vb.org Archive - Problem with 3.6.8 to 3.7.4 update

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Problem with 3.6.8 to 3.7.4 update (https://vborg.vbsupport.ru/showthread.php?t=202873)

yeku	01-24-2009 12:05 AM

Problem with 3.6.8 to 3.7.4 update

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

Quote:

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

01-24-2009 03:01 AM

Please open a support ticket at vBulletin.com.

Marco van Herwaarden

01-24-2009 03:19 PM

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	01-24-2009 03:44 PM

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	01-25-2009 01:28 PM

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

01-25-2009 02:22 PM

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	01-25-2009 03:08 PM

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

Quote:

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

01-26-2009 03:29 AM

PHP Code:


		
			
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	01-26-2009 11:24 AM

ok Dismounted, thank you very much

I will try and send the ticket

yeku	01-28-2009 11:19 AM

hello, is already solved.

Updated to 3.7.4

Thank you all for your help

All times are GMT. The time now is 03:17 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01487 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: