PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old April 10th, 2008, 10:24 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: May 2006
Posts: 33
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
fdwilk1 is offline   Reply With Quote
Old April 10th, 2008, 10:28 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,704
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.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old April 10th, 2008, 10:32 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: May 2006
Posts: 33
sorry I posted this second thread. All future comments wil be on the original.

Doug
fdwilk1 is offline   Reply With Quote
Old April 10th, 2008, 10:39 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,704
yes i posted in your other thread
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PhotoPost Classifieds upgrade problem fdwilk1 General Discussion 5 April 10th, 2008 10:38 AM
I just did an upgrade to Classified 2.6 tcroft2683 Classifieds How do I...? 1 April 25th, 2007 08:02 PM
PhotoPost Upgrade Problem - Need Help Restoring DB! mkdevo Photopost Pro Installation & Upgrades 13 January 15th, 2006 09:01 AM
Photopost upgrade problem dimopoulos Photopost Pro Installation & Upgrades 17 October 1st, 2005 09:15 PM
Upgrade Problem PhotoPost CMS > PhotoPost Pro 5.02 flumpydog Photopost Pro Installation & Upgrades 4 April 1st, 2005 09:01 PM


All times are GMT -5. The time now is 06:46 PM.

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