PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   General Discussion (http://www.photopost.com/forum/general-discussion/)
-   -   Photopost Classified Upgrade problem #2 (http://www.photopost.com/forum/general-discussion/136190-photopost-classified-upgrade-problem-2-a.html)

fdwilk1 April 10th, 2008 10:24 AM

Photopost Classified Upgrade problem #2
 
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 10: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 10:32 AM

sorry I posted this second thread. All future comments wil be on the original.

Doug

Chuck S April 10th, 2008 10:39 AM

yes i posted in your other thread


All times are GMT -5. The time now is 04:30 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97