| Member Verified Customer
Join Date: Feb 2002 Location: Northern California
Posts: 222
| sql errors on upgrade
from 2.6 to 3.01.
running MySQL - 4.0.17
Preparing to update database...
Error performing MySQL command: CREATE TABLE pp_messages ( msgid int( 12 ) NOT NULL AUTO_INCREMENT , userid int( 12 ) NOT NULL default '0', datestamp int( 15 ) NOT NULL default '0', message mediumtext, status smallint( 1 ) NOT NULL default '0', type enum( 'c', 'f', 'i', 'm', 'r' ) default NULL , product int( 12 ) NOT NULL default '0', PRIMARY KEY ( msgid ) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 9
Error performing MySQL command: CREATE TABLE pp_captcha ( id int( 12 ) NOT NULL auto_increment , code varchar( 12 ) default NULL , PRIMARY KEY ( id ) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 4
Error performing MySQL command: CREATE TABLE pp_buddies ( id int( 12 ) NOT NULL auto_increment , userid int( 12 ) NOT NULL default '0', buddy int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , KEY userid ( userid ) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 6
Error performing MySQL command: CREATE TABLE pp_board ( msgid int(12) NOT NULL auto_increment, replyto int(12) NOT NULL default '0', userid int(12) NOT NULL default '0', category int(4) NOT NULL default '0', date int(15) NOT NULL default '0', subject varchar(250) default NULL, message mediumtext, replies int(6) NOT NULL default '0', views int(7) NOT NULL default '0', lastmsg int(12) NOT NULL default '0', lastdate int(15) NOT NULL default '0', lastuser int(12) NOT NULL default '0', lastusername varchar(32) default NULL, ipaddr varchar(15) default NULL, updated int(16) NOT NULL default '0', updateuser int(12) NOT NULL default '0', PRIMARY KEY (msgid), KEY date (date) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 19
Error performing MySQL command: CREATE TABLE pp_invites ( id int( 12 ) NOT NULL AUTO_INCREMENT , code varchar( 32 ) default NULL , email varchar( 32 ) default NULL , name varchar( 64 ) default NULL , message mediumtext, datestamp int( 16 ) NOT NULL default '0', referer int( 10 ) NOT NULL default '0', status smallint( 1 ) NOT NULL default '0', uid int( 12 ) NOT NULL default '0', PRIMARY KEY ( id ) , UNIQUE KEY code ( code ) ) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 12
Error performing MySQL command: CREATE TABLE IF NOT EXISTS pp_subscriptions (id int(10) NOT NULL auto_increment, name VARCHAR(75) NOT NULL default '', description TEXT NULL DEFAULT NULL, gid INT(4) NOT NULL default '0', duration VARCHAR(75) NOT NULL default '', days INT(4) NOT NULL default '0', price float(12,2) NOT NULL default '0.00', isactive varchar(3) NOT NULL default 'yes', PRIMARY KEY (id)) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 9
Error performing MySQL command: CREATE TABLE IF NOT EXISTS pp_paid_subscriptions (id int(10) NOT NULL auto_increment, userid VARCHAR(75) NOT NULL default '', start VARCHAR(250) NOT NULL default '', end VARCHAR(75) NOT NULL default '', days INT(4) NOT NULL default '0', subid INT(5) NOT NULL default '0', gid INT(4) NOT NULL default '0', oldid INT(4) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 9
Error performing MySQL command: ALTER TABLE pp_admingroups 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
Error performing MySQL command: ALTER TABLE pp_admlog 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
Error performing MySQL command: ALTER TABLE pp_adtypes 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
Error performing MySQL command: ALTER TABLE pp_bidding 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
Error performing MySQL command: ALTER TABLE pp_bids 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
Error performing MySQL command: ALTER TABLE pp_cache 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
Error performing MySQL command: ALTER TABLE pp_categories 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
Error performing MySQL command: ALTER TABLE pp_comments 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
Error performing MySQL command: ALTER TABLE pp_currency 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
Error performing MySQL command: ALTER TABLE pp_extrafields 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
Error performing MySQL command: ALTER TABLE pp_favorites 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
Error performing MySQL command: ALTER TABLE pp_feedback 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
Error performing MySQL command: ALTER TABLE pp_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
Error performing MySQL command: ALTER TABLE pp_ipcache 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
Error performing MySQL command: ALTER TABLE pp_iponline 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
Error performing MySQL command: ALTER TABLE pp_laston 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
Error performing MySQL command: ALTER TABLE pp_notify 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
Error performing MySQL command: ALTER TABLE pp_productextras 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
Error performing MySQL command: ALTER TABLE pp_products 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
Error performing MySQL command: ALTER TABLE pp_settings 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
Error performing MySQL command: ALTER TABLE pp_sort 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
Error performing MySQL command: ALTER TABLE pp_stats 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
Error performing MySQL command: ALTER TABLE pp_usergroups 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
Error performing MySQL command: ALTER TABLE pp_users 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
updating product tags...done.
Upgrade complete! To prevent users from modifying your PhotoPost database settings, please be sure to delete the upgrade.php file from your PhotoPost directory before continuing.
|
Linear Mode
