Errors from Wizard.php

Errors from Wizard.php

Postby nerak99 on Wed Oct 12, 2011 4:26 am

Doing a test install on my laptop,

edit: BTW, the database solved stuff below does not seem to have a solution in it but does seem to be the same problem)

uname -r
Linux <mydomaininfo> 2.6.40.6-0.fc15.x86_64 #1 SMP Tue Oct 4 00:39:50 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux
php 5.3.8
mysql 5.5.14

the wizard successfully creates a table and a couple of other things in the mysql database (v 5.5.14)
These are

lt_tmp_user_permissions, blog_id and user_id_permission_id.

This suggests that the database user and permissions are fine.
(I selected utf8 although if I use back and go to latin1 it still happens and to be honest this does not look like a collation issue.)

The next page has this stuff in it. Suggesting a load of SQL problems in wizard.php.

Any ideas?

Error creating table articles: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, modification_date TIMESTAMP(14) NOT NULL, user_id ' at line 3
Error creating table articles_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, in_main_page TINYINT(1) NOT NULL DEFAULT 1, parent_id' at line 6
Error creating table articles_comments: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, user_id INTEGER(10) DEFAULT 0, user_email ' at line 7
Error creating table articles_notifications: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Error creating table blogs: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, last_update_date TIMESTAMP(14) NOT NULL, num_posts ' at line 11
Error creating table mylinks: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, PRIMARY ' at line 9
Error creating table mylinks_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, num_links ' at line 5
Error creating table permissions: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8
Error creating table referers: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) TYPE=MyISAM' at line 7
Error creating table users: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (id) ) TYPE=MyISAM' at line 12
Error creating table users_permissions: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Table tmp_users_permissions created successfully.
Error creating table config: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6
Error creating table filtered_content: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM' at line 6
Error creating table host_blocking_rules: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, blog_id INTEGER(10) NOT NULL DEFAULT 0, block_ty' at line 4
Error creating table gallery_resources: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, flags INTEGER(10) DEFAULT 0, resource_type ' at line 6
Error creating table gallery_albums: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, properties TEXT NOT NULL, show_album ' at line 8
Error creating table bayesian_filter_info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 7
Error creating table bayesian_tokens: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Error creating table article_categories_link: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 5
Error creating table custom_fields_definition: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), searchable TINYINT(1) DEFAULT 1, hidden TI' at line 8
Error creating table custom_fields_values: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 9
Error creating table articles_text: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table phpbb2_users: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table blog_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error creating table global_articles_categories: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
nerak99
 
Posts: 12
Joined: Wed Oct 12, 2011 3:55 am
LifeType Version: 2.1.11

Re: Errors from Wizard.php

Postby nerak99 on Wed Oct 12, 2011 5:57 am

Well as a start I think it may be a 5.5 Mysql issue.
Perhaps the correct syntax for each table needs to be sorted out.
The first table issue seems to be with "articles" where an SQL issue occurs
whereas this SQL does work although the INTEGERS may need to be BIGINTS

CREATE TABLE articles (id INTEGER AUTO_INCREMENT PRIMARY KEY NOT NULL, date TIMESTAMP, modification_date TIMESTAMP NOT NULL, user_id INTEGER NOT NULL, blog_id INTEGER NOT NULL, status INTEGER NOT NULL DEFAULT 1, num_reads INTEGER DEFAULT 0, properties TEXT NOT NULL DEFAULT '', slug CHAR(255) NOT NULL DEFAULT '', num_comments INTEGER NOT NULL DEFAULT 0, num_nonspam_comments INTEGER NOT NULL DEFAULT 0, num_trackbacks INTEGER NOT NULL DEFAULT 0, num_nonspam_trackbacks INTEGER NOT NULL DEFAULT 0, global_category_id INTEGER NOT NULL DEFAULT 0, in_summary_page INTEGER NOT NULL DEFAULT 1, INDEX num_reads (num_reads), INDEX user_id (user_id), INDEX slug (slug), INDEX blog_id_status_date (blog_id, status, date), INDEX global_category_status (global_category_id, status), INDEX date(date) )
nerak99
 
Posts: 12
Joined: Wed Oct 12, 2011 3:55 am
LifeType Version: 2.1.11

Re: Errors from Wizard.php

Postby nerak99 on Wed Oct 12, 2011 6:26 am

Well having captured the sql that the database engine receives from the php, the first problem seems to be TIMESTAMP(14). See this rather tetchy bug comment from mysql bug reports
http://bugs.mysql.com/bug.php?id=41510

Specifically

[16 Dec 2008 16:27] Valeriy Kravchuk
This is not a bug. We have warnings about timestamp(N) deprecation for years already:
nerak99
 
Posts: 12
Joined: Wed Oct 12, 2011 3:55 am
LifeType Version: 2.1.11

Re: Errors from Wizard.php [SOLVED]

Postby nerak99 on Wed Oct 12, 2011 8:39 am

Well fixed, helped by the wonders of rpl. (Also achievable using sed)

By doing a recursive change rather carefully and exchanging

T(14) with T (to deal with the Timeastamp issue)
TYPE=MyISAM with ENGINE=MyISAM
and
NOTNULL with NOT NULL (I do not think that last is necessarily needed)

wizard.php ran successfully.

The file mainly effected (and I think the only file effected) is

/install/dbschemas.properties.php

Thank you for listening
nerak99
 
Posts: 12
Joined: Wed Oct 12, 2011 3:55 am
LifeType Version: 2.1.11

Re: Errors from Wizard.php

Postby jondaley on Wed Oct 12, 2011 10:18 pm

Ah - I saw your other post first, before this one.

Can you upload your changes to bugs.lifetype.net, that way it will get logged in the release process, and it is easier for me to check that your changes look good to me?

Thanks.
jondaley
Lifetype Expert
 
Posts: 6169
Joined: Thu May 20, 2004 6:19 pm
Location: Pittsburgh, PA, USA
LifeType Version: 1.2.11 devel branch

Re: Errors from Wizard.php

Postby nerak99 on Thu Oct 13, 2011 5:00 pm

There you go, posted as major bug 1658 and attached edited dbschema file.

Brian
nerak99
 
Posts: 12
Joined: Wed Oct 12, 2011 3:55 am
LifeType Version: 2.1.11

Re: Errors from Wizard.php

Postby jondaley on Tue Oct 18, 2011 12:41 pm

thanks.
jondaley
Lifetype Expert
 
Posts: 6169
Joined: Thu May 20, 2004 6:19 pm
Location: Pittsburgh, PA, USA
LifeType Version: 1.2.11 devel branch


Return to Configuration and Installation

cron