Problem with 3.6.8 to 3.7.4 update

[yeku]

I uploaded the files of the update and I try to update this error:

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE userlist ADD friend ENUM('yes', 'no', 'pending', 'denied') NOT NULL DEFAULT 'no';

MySQL Error : Table 'forolechuzo.userlist' doesn't exist
Error Number : 1146
Request Date : Saturday, January 24th 2009 @ 03:03:53 AM
Error Date : Saturday, January 24th 2009 @ 03:03:53 AM
Script : http://www.lechuzo.com/install/upgrade_370b2.php?step=3
Referrer :
IP Address : xxxxxxxxxxxx
Username :
Classname : vB_Database
MySQL Version : 5.0.45

I can not go to my admincp, any idea?

thanks

[Dismounted]

Please open a support ticket at vBulletin.com.

[Marco van Herwaarden]

No need to open a ticket yet.

"Database error in vBulletin 3.6.8"

This means that you have not ran the upgrade script yet. Please run the upgrade script.

[Zate]

neither of my 3.6.10 installs have a "userlist" table either. I am trying to track down when that table is supposed to be created because so far in the upgrade script it was not created.

[yeku]

Hello Marco

The bug is caused precisely because running the script, this error occurs in Step 3.

Anyway, I did a test. I downloaded the original version 3.6.8, I uploaded the forum in another folder, and upload my bd run the upgrade script and I have not had any error.

This test confirms that I have a grave error in my original forum.

I ask: You can dump the original version 3.6.8 on my forum to avoid the error when trying to run the upgrade?

Thanks Marco

[Marco van Herwaarden]

Actually 3.6.8 should already have that table. for some reason you are missing default table(s). Best would be to open a support ticket so someone can check your database.

[yeku]

Hi Marco, one of the conditions required to send a ticket is:

Whether or not you have edited any files (if you have installed hacks or modified any of the vBulletin PHP files, we cannot offer any support until the original files are restored.)

I have some hack installed. I give support?

I have to uninstall all hack before sending the ticket?

thanks again

[Dismounted]

define('DISABLE_HOOKS', true);
Add this to the end of your config.php. This will disable all your modifications. If you have made any file edits to vBulletin's files, overwrite those files with the originals. Then open your ticket (although this should not be needed in this case).

[yeku]

ok Dismounted, thank you very much

I will try and send the ticket

[yeku]

hello, is already solved.

Updated to 3.7.4

Thank you all for your help