[closed] Creating tables failed in installer

Post Reply
User avatar
Rolf
Dev Team Member
Dev Team Member
Posts: 7740
Joined: Wed Apr 23, 2008 7:53 am
Location: The Netherlands

[closed] Creating tables failed in installer

Post by Rolf »

SVN Rev. 8099
Installer step 6:
Creating module_smarty_plugins table... [failed]
Creating routes table... [failed]
Image
- + - + - + - + - + -
Latest CMSMS tutorial: FormBuilder WatchGuard
- + - + - + - + - + -
Did my post help you solving a problem at your (customers) website and it saved you many hours of work?
Great!! Buy me a cup of coffee in return as a small token of appreciation!
arnoud
Power Poster
Power Poster
Posts: 1399
Joined: Sun Apr 19, 2009 9:33 am

Re: Creating tables failed in installer

Post by arnoud »

Rev: 8100

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

Code: Select all

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)
User avatar
Rolf
Dev Team Member
Dev Team Member
Posts: 7740
Joined: Wed Apr 23, 2008 7:53 am
Location: The Netherlands

Re: [fixed?] Creating tables failed in installer

Post by Rolf »

Should be fixed.
Image
- + - + - + - + - + -
Latest CMSMS tutorial: FormBuilder WatchGuard
- + - + - + - + - + -
Did my post help you solving a problem at your (customers) website and it saved you many hours of work?
Great!! Buy me a cup of coffee in return as a small token of appreciation!
User avatar
Rolf
Dev Team Member
Dev Team Member
Posts: 7740
Joined: Wed Apr 23, 2008 7:53 am
Location: The Netherlands

Re: [not fixed] Creating tables failed in installer

Post by Rolf »

In SVN rev. 8118 no [failed] messages, but there are several index lines:
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]
Image
- + - + - + - + - + -
Latest CMSMS tutorial: FormBuilder WatchGuard
- + - + - + - + - + -
Did my post help you solving a problem at your (customers) website and it saved you many hours of work?
Great!! Buy me a cup of coffee in return as a small token of appreciation!
User avatar
Rolf
Dev Team Member
Dev Team Member
Posts: 7740
Joined: Wed Apr 23, 2008 7:53 am
Location: The Netherlands

Re: [not fixed] Creating tables failed in installer

Post by Rolf »

Not fixed in rev. 8162
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]
Image
- + - + - + - + - + -
Latest CMSMS tutorial: FormBuilder WatchGuard
- + - + - + - + - + -
Did my post help you solving a problem at your (customers) website and it saved you many hours of work?
Great!! Buy me a cup of coffee in return as a small token of appreciation!
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm
Location: Fernie British Columbia, Canada

Re: [not fixed] Creating tables failed in installer

Post by calguy1000 »

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.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Post Reply

Return to “Closed Issues”