CMS Made Simple Forums

When installing CMSMS 1.4 beta 2 I encountered a problem.

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?

Klassiekerrally wrote: 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?

Have you permission for create index/alter table with your account in mysql?

Alby

Yes, that should be possible, at least I can delete them...

Could you try what happens when installing the 1.4 version, which is just released..

Ronny

Just did... Exactly the same problem 

Are you sure that all files are overwritten?

Did you try transferring all in Binary mode?

I only had this issue once, and there was a invalid character in the sql-file, but that was solved during the 1.4beta testing.

Ronny

Klassiekerrally wrote: Just did... Exactly the same problem 

Check your DB if index's are not created
If are not created:

Rename install folder to install_1.4
Download 1.3.1
Upload install folder only of 1.3.1
Install
Check again your DB if index's are not created

Alby

Do I have to re-install 1.4 after doing that?

Using the install-folder of 1.3.1 results (again) in the last message:
Importing sample data...Invalid query: INSERT INTO wmwh_additional_htmlblob_users ( ADDITIONAL_HTMLBLOB_USERS_ID, USER_ID, HTMLBLOB_ID ) VALUES ( 6, 1, 5 );

Klassiekerrally wrote: Do I have to re-install 1.4 after doing that?

No, upgrade only install/upgrade.php (after replace install folder of 1.4)

Klassiekerrally wrote: Using the install-folder of 1.3.1 results (again) in the last message:
Importing sample data...Invalid query: INSERT INTO wmwh_additional_htmlblob_users ( ADDITIONAL_HTMLBLOB_USERS_ID, USER_ID, HTMLBLOB_ID ) VALUES ( 6, 1, 5 );

Can you check with SQL tool if index are created with 1.3.1 install?
For last query if wmwh_ is the correct prefix you should have problem with mysql case sensitive

Alby

I can't find any table with 'index' in the name of it...

I think wmwh_ is the right prefix. You're saying that it possibly should be WMWH_ ?

Klassiekerrally wrote: I can't find any table with 'index' in the name of it...

No, index are index of field/column in table, check property of table (example prefix_content table)

Klassiekerrally wrote: I think wmwh_ is the right prefix. You're saying that it possibly should be WMWH_ ?

or maybe:
INSERT INTO wmwh_additional_htmlblob_users ( additional_htmlblob_users_id, users_id, htmlblob_id ) VALUES ( 6, 1, 5 );

Try with a SQL tool

Alby

alby wrote: INSERT INTO wmwh_additional_htmlblob_users ( additional_htmlblob_users_id, users_id, htmlblob_id ) VALUES ( 6, 1, 5 );

Try with a SQL tool

Thanks for your patience!

I've tried to create a new row in wmwh_additional_htmlblob_users and after that giving additional_htmlblob_users_id the value 6, users_id the value 1 and htmlblob_id the value 5. (hope this is what should have been done).

This results in the following error:
Couldn't write row.
MySQL said: INSERT command denied to user 'wim_midwinter'@'a80-100-69-129.adsl.xs4all.nl' for table 'wmwh_additional_htmlblob_users'

Klassiekerrally wrote:

alby wrote: INSERT INTO wmwh_additional_htmlblob_users ( additional_htmlblob_users_id, users_id, htmlblob_id ) VALUES ( 6, 1, 5 );

Try with a SQL tool

Thanks for your patience!

I've tried to create a new row in wmwh_additional_htmlblob_users and after that giving additional_htmlblob_users_id the value 6, users_id the value 1 and htmlblob_id the value 5. (hope this is what should have been done).

This results in the following error:
Couldn't write row.
MySQL said: INSERT command denied to user 'wim_midwinter'@'a80-100-69-129.adsl.xs4all.nl' for table 'wmwh_additional_htmlblob_users'

Very strange that you have CREATE permission and not INSERT.
Ask your provider

Alby