vb.org Archive - upgrading from 3.0.6

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

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

- - upgrading from 3.0.6 - 3.5.4 (https://vborg.vbsupport.ru/showthread.php?t=116869)

zyad	05-27-2006 09:50 PM

upgrading from 3.0.6 - 3.5.4

Hello, i'm not completely positive if this fits into this topic, but it's the most relevant, other than asking support on .com.

I'm sure this is a dumb question, but I tried upgrading from 3.0.6 - 3.5.4 using /install/upgrade.php ... however i get an error.

Quote:

Database error in vBulletin :

Invalid SQL:

SELECT title, data
FROM _datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');

MySQL Error : Table 'frforum._datastore' doesn't exist
Error Number : 1146
Date : Saturday, May 27th 2006 @ 03:46:06 PM
Script : http://*************/install/upgrade.php
Referrer :
IP Address : 65.92.172.244
Username :
Classname : vb_database

i put in the database login info into the config file from the 3.0.6 to 3.5.4

am i missing something?

Mark.B

05-27-2006 09:55 PM

The first thing that stands out for me is this:

'frforum._datastore'

There appears to be a dot after your table prefix....are you sure that's supposed to be there?

Check your new config.php and make sure the table prefix is set correctly without a dot. Since I'm assuming your forum worked ok previously, I would say that's where the problem could lie.

zyad	05-27-2006 10:00 PM

hmmm no period

Quote:

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '_';

however i just removed the underscore and now it's like this...

Quote:

Database error in vBulletin :

Invalid SQL:

SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');

MySQL Error : Table 'frforum.datastore' doesn't exist
Error Number : 1146
Date : Saturday, May 27th 2006 @ 04:01:23 PM
Script : http://www.*************/install/upgrade.php
Referrer :
IP Address : 65.92.172.244
Username :
Classname : vb_database

Mark.B

05-27-2006 10:06 PM

Hmmm....

It's late at night, it's the underscore that's wrong, not the dot. I'm half asleep.....

Have you a copy of your OLD config.php? If so, what was the table prefix entry on that?

It's worth double checking that the database details on the new config file exactly match those on the old one.

zyad	05-27-2006 10:07 PM

table prefix in the old config file says vb3_ .... however in phpmyadmin, it doesn't show a prefix on any table

Mark.B

05-27-2006 11:40 PM

Quote:

Originally Posted by zyad

table prefix in the old config file says vb3_ .... however in phpmyadmin, it doesn't show a prefix on any table

Well it's worth trying putting that in and seeing what happens....

If that was the setting in the old config file, and the forum was running ok, then it's got to be worth chaging it back to that.

Not having run a board with prefixes I am never 100% sure how they're set up, but I'd try that for certain.

zyad	05-28-2006 03:57 AM

thanks for your help mark. i actually removed the prefixes and i noticed that i forgot to change the db name :( lol i'm such a dummy

All times are GMT. The time now is 01:34 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00989 seconds Memory Usage 1,725KB 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 (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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: