CMS Made Simple Forums
https://forum.cmsmadesimple.org/

[closed] Creating tables failed in installer
https://forum.cmsmadesimple.org/viewtopic.php?f=80&t=61661
Page 1 of 1

Author:  Rolf [ Sat Jun 23, 2012 8:36 pm ]
Post subject:  [closed] Creating tables failed in installer

SVN Rev. 8099
Installer step 6:
\$1:
Creating module_smarty_plugins table... [failed]
Creating routes table... [failed]

Author:  arnoud [ Sun Jun 24, 2012 10:01 am ]
Post subject:  Re: Creating tables failed in installer

Rev: 8100

Saw the [failed] message in installer step 6 but the tables are created fine:

\$1:
mysql> desc cms_routes;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| term    | varchar(255) | NO   | PRI | NULL    |       |
| key1    | varchar(50)  | NO   | PRI | NULL    |       |
| key2    | varchar(50)  | YES  |     | NULL    |       |
| key3    | varchar(50)  | YES  |     | NULL    |       |
| data    | text         | YES  |     | NULL    |       |
| created | datetime     | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> desc cms_module_smarty_plugins;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| sig       | varchar(80)  | NO   | PRI | NULL    |       |
| name      | varchar(80)  | YES  |     | NULL    |       |
| module    | varchar(160) | YES  |     | NULL    |       |
| type      | varchar(40)  | YES  |     | NULL    |       |
| callback  | varchar(255) | YES  |     | NULL    |       |
| available | int(11)      | YES  |     | NULL    |       |
| cachable  | tinyint(4)   | YES  |     | NULL    |       |
+-----------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

Author:  Rolf [ Sun Jun 24, 2012 7:15 pm ]
Post subject:  Re: [fixed?] Creating tables failed in installer

Should be fixed.

Author:  Rolf [ Tue Jun 26, 2012 7:08 pm ]
Post subject:  Re: [not fixed] Creating tables failed in installer

In SVN rev. 8118 no [failed] messages, but there are several index lines:
\$1:
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating content_props table... [done]
Creating index in content table... [done]
Creating crossref table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating css table... [done]
Creating index in content table... [done]
Creating css_assoc table... [done]
Creating index in content table... [done]
Creating index in content table... [done]

Author:  Rolf [ Sat Jul 07, 2012 9:46 am ]
Post subject:  Re: [not fixed] Creating tables failed in installer

Not fixed in rev. 8162

\$1:
Creating additional_users table... [done]
Creating admin_bookmarks table... [done]
Creating index in admin_bookmarks table... [done]
Creating adminlog table... [done]
Creating admin_recent_pages table... [done]
Creating content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating content_props table... [done]
Creating index in content table... [done]
Creating crossref table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating css table... [done]
Creating index in content table... [done]
Creating css_assoc table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating event_handlers table... [done]
Creating events table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating index in content table... [done]
Creating group_perms table... [done]
Creating index in content table... [done]
Creating groups table... [done]
Creating htmlblobs table... [done]
Creating index in content table... [done]
Creating additional_htmlblob_users table... [done]
Creating modules table... [done]
Creating index in content table... [done]
Creating module_deps table... [done]
Creating module_templates table... [done]
Creating index in content table... [done]
Creating permissions table... [done]
Creating siteprefs table... [done]
Creating templates table... [done]
Creating index in content table... [done]
Creating user_groups table... [done]
Creating userprefs table... [done]
Creating index in content table... [done]
Creating users table... [done]
Creating userplugins table... [done]
Creating version table... [done]
Creating module_smarty_plugins table... [done]
Creating routes table... [done]
Importing sample data... [done]
Setting admin account information... [done]
Setting sitename... [done]
Creating additional_users table sequence... [done]
Creating admin_bookmarks table sequence... [done]
Creating admin_recent_pages table sequence... [done]
Creating content table sequence... [done]
Creating content_props table sequence... [done]
Creating css table sequence... [done]
Creating events table sequence... [done]
Creating event_handlers table sequence... [done]
Creating group_perms table sequence... [done]
Creating groups table sequence... [done]
Creating htmlblobs table sequence... [done]
Creating additional_htmlblob_users table sequence... [done]
Creating permissions table sequence... [done]
Creating templates table sequence... [done]
Creating users table sequence... [done]
Creating userplugins table sequence... [done]

Author:  calguy1000 [ Sat Jul 07, 2012 2:08 pm ]
Post subject:  Re: [not fixed] Creating tables failed in installer

This is the same string being used to describe creating different indexes on the cms_content table. though it is vague, there is no error. and this is old stuff (not new in 1.11 afaik)... so not gonna fix it.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/