SOS - i have an error 1060 when upgrating to 1.0.1...

[Classico]

Hi,

When i try the update it from 1.0.0 ( http://yoursite.com/forum/admincp/vbadyna_install.php ) i have this database error...

Database error in vBulletin 3.6.9:

Invalid SQL:
ALTER TABLE adv_dyna_search ADD ipaddress CHAR(15) NOT NULL AFTER userid;

MySQL Error : Duplicate column name 'ipaddress'
Error Number : 1060
Date : Saturday, April 19th 2008 @ 06:55:36 PM
Script : http://www.mysite/forum/admincp/vbadyna_install.php
Referrer : http://mysite/forum/admincp/vbadyna_install.php
IP Address : 89.155.103.111
Username : Classico
Classname : vB_Database

Can you please help me? I haveo no idea how to solve it... :o

Thanks!

[Brian]

Sounds like you may have somehow hit the 'Continue' button twice while doing the upgrade. If you look in the admincp/vbadyna_install.php file for this line and remove it, you should be able to continue the upgrade if you try running it again.

$db->query_write("ALTER TABLE " . TABLE_PREFIX . ADV_DYNA_PREFIX . "_search ADD ipaddress CHAR(15) NOT NULL AFTER userid");

[Our Sponsors]

[Classico]

Thanks Brian!

Now i have this error:

ALTER TABLE adv_dyna_attachments
ADD file_data MEDIUMBLOB NULL DEFAULT NULL,
ADD thumb_data MEDIUMBLOB NULL DEFAULT NULL;

MySQL Error : Duplicate column name 'file_data'
Error Number : 1060

I think it was my fault... As i had some error in the begining with the 1.0.1, i returned it to 1.0.0. And now it´s giving me this errors when i try to update ir again to 1.0.1....:o

Perhaps i shoud wait to 1.0.2... What is the best?

Thanks!

[Brian]

Hrmm... Would you mind just submitting a support ticket via the Members' Area here? Might be easier for both of us if I could take a look and make sure the upgrade is fully completed for you.

[Our Sponsors]

[Classico]

Just did it.

Sorry for the work.... :o

[Classico]

Solved!!! :)

Thanks for all, Brian!!! :)

Regards