
Re: Error Upgrading To RC2
you can continue instalation..
i got same errors , but affter upgrade all is ok
ALTER TABLE `ip_cms_blocks` ADD `border` TINYINT(1) SET DEFAULT '1' AFTER `border_explain`
+++ 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 'SET DEFAULT '1' AFTER `border_explain`' at line 1
ALTER TABLE `ip_cms_blocks` ADD `titlebar` TINYINT(1) SET DEFAULT '1' AFTER `border`
+++ 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 'SET DEFAULT '1' AFTER `border`' at line 1
UPDATE `ip_cms_blocks` SET border= '0' WHERE border_explain= '0,0,0,0'
+++ Error: Unknown column 'border_explain' in 'where clause'
UPDATE `ip_cms_blocks` SET border= '1' WHERE border_explain= '1,1,1,1'
+++ Error: Unknown column 'border_explain' in 'where clause'
UPDATE `ip_cms_blocks` SET titlebar= '0' WHERE titlebar_explain= '0,0'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
UPDATE `ip_cms_blocks` SET titlebar= '1' WHERE titlebar_explain= '1,1'
+++ Error: Unknown column 'titlebar_explain' in 'where clause'
ALTER TABLE ip_registration_desc DROP `reg_option1`
+++ Error: Can't DROP 'reg_option1'; check that column/key exists
ALTER TABLE ip_registration_desc DROP `reg_option2`
+++ Error: Can't DROP 'reg_option2'; check that column/key exists
ALTER TABLE ip_registration_desc DROP `reg_option3`
+++ Error: Can't DROP 'reg_option3'; check that column/key exists
INSERT INTO ip_config VALUES ('ip_version', '1.2.24.51')
+++ Error: Duplicate entry 'ip_version' for key 1
this error ip_registration_desc DROP is a new mod Event registration RC1 doesnt have this table thats why error appaer
BTW in any case backup ur files and database before you upgrade to rc2
____________
We are the
phpBBorg. Lower your Crackers. Your phpological and forumological distinctivness will be added to our own. Resistance if futile!