http://www.icyphoenix.com/viewtopic.php?f=35&t=5875
-----------------------------------
ankur0412
Sat 23 May, 2009 13:40

Error Upgrading To RC2
-----------------------------------
Hello I get the following errors while updating database from RC1 to RC2


The following SQL have not been executed:
# ALTER TABLE phpbb_registration_desc DROP `reg_option1`
+++ Error: Table 'xxxx_mcforums2.phpbb_registration_desc' doesn't exist

# ALTER TABLE phpbb_registration_desc DROP `reg_option2`
+++ Error: Table 'xxxx_mcforums2.phpbb_registration_desc' doesn't exist

# ALTER TABLE phpbb_registration_desc DROP `reg_option3`
+++ Error: Table 'xxxx_mcforums2.phpbb_registration_desc' doesn't exist

# INSERT INTO phpbb_config VALUES ('ip_version', '1.2.24.51')
+++ Error: Duplicate entry 'ip_version' for key 'PRIMARY'


Is there anything I need to do?


-----------------------------------
Limun
Sat 23 May, 2009 13:59

Re: Error Upgrading To RC2
-----------------------------------
you can continue instalation..  :wink: 
i got same errors , but affter upgrade all is ok 
[spoiler]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[/spoiler]

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


-----------------------------------
ankur0412
Sat 23 May, 2009 15:59

Re: Error Upgrading To RC2
-----------------------------------
oh, I hope it doesn't post any problem with the event registration mod.


-----------------------------------
TheSteffen
Thu 28 May, 2009 09:03

Re: Error Upgrading To RC2
-----------------------------------
[quote user="ankur0412" post="39675"]oh, I hope it doesn't post any problem with the event registration mod.[/quote]

No, you wouldn't have any problems with this.

EDIT: Can you please check you do not have this `reg_option3` in you table ip_registration_desc