What have I done:
- removed all files from the server
- uploaded all new CMSMS files to the server
- uploaded an empty config.php file to the server
- emptied the db, erased all tables (using CocoaMySQL on my iMac)
- started the installation
At point 5 I got the following overview:
Creating additional_users table... [done]
Creating admin_bookmarks table... [done]
Creating index in admin_bookmarks table... [failed]
Creating adminlog table... [done]
Creating admin_recent_pages table... [done]
Creating content table... [done]
Creating index in content table... [failed]
Creating index in content table... [failed]
Creating index in content table... [failed]
Creating content_props table... [done]
Creating index in content table... [failed]
Creating crossref table... [done]
Creating index in content table... [failed]
Creating index in content table... [failed]
Creating css table... [done]
Creating index in content table... [failed]
Creating css_assoc table... [done]
Creating index in content table... [failed]
Creating index in content table... [failed]
Creating event_handlers table... [done]
Creating events table... [done]
Creating index in content table... [failed]
Creating index in content table... [failed]
Creating group_perms table... [done]
Creating index in content table... [failed]
Creating groups table... [done]
Creating htmlblobs table... [done]
Creating index in content table... [failed]
Creating additional_htmlblob_users table... [done]
Creating modules table... [done]
Creating index in content table... [failed]
Creating module_deps table... [done]
Creating module_templates table... [done]
Creating index in content table... [failed]
Creating permissions table... [done]
Creating siteprefs table... [done]
Creating templates table... [done]
Creating index in content table... [failed]
Creating user_groups table... [done]
Creating userprefs table... [done]
Creating index in content table... [failed]
Creating users table... [done]
Creating userplugins table... [done]
Creating version table... [done]
Importing sample data...Invalid query: INSERT INTO wmwh_additional_htmlblob_users ( ADDITIONAL_HTMLBLOB_USERS_ID, USER_ID, HTMLBLOB_ID ) VALUES ( 6, 1, 5 );
So obviously the creating of indexes goes wrong, as does the importing of sample data.
I can't figure out what goes wrong, and what's worse: neither can my webhosting company...
Can anyone shed any light on what needs to be adjusted?
