PDA

View Full Version : Photopost Classified Upgrade problem #2


fdwilk1
April 10th, 2008, 11:24 AM
I removed the suggested statement.

I now get a series of messages stating:

Error performing MySQL command: ALTER TABLE ppads_invites CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
Error: 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 'CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci' at line

Should I remove all of the:

$query[] = "ALTER TABLE {$Globals['pp_db_prefix']}admingroups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";

statements?

Thanks

Doug

Chuck S
April 10th, 2008, 11:28 AM
You do not need to worry about those errors for some reason your mysql version does not like setting collation although every mysql 4 and 5 that I know should support this.

fdwilk1
April 10th, 2008, 11:32 AM
sorry I posted this second thread. All future comments wil be on the original.

Doug

Chuck S
April 10th, 2008, 11:39 AM
yes i posted in your other thread