The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
08-18-2008, 11:25 PM
|
||||
|
||||
Major Help With VB database needed
My database tables have somehow split into the original tables eg starting vb..... but somehow there has also appeared the same tables but without the vb at the start.
The forum now appears to be running off both these, can these be merged or at least members posts and actual members merged into the original tables so i can then remove the tables that it shouldnt be using? 
|
|
#2
08-18-2008, 11:28 PM
|
|||
|
|||
|
You can't be running off both sets of tables it is either one or the other. Check your config.php file to see which table prefix is defined there. Then look into the tables that don't have this prefix (or have the other prefix).
|
|
#3
08-18-2008, 11:32 PM
|
||||
|
||||
|
config file (as it always has been) is running off the prefix 'vb'
But if i remove the non vb starting tables, database errors occur and the forums cant run
|
|
#5
08-18-2008, 11:39 PM
|
||||
|
||||
|
access
adminhelp administrator adminlog adminmessage adminutil announcement announcementread attachment attachmentpermission attachmenttype attachmentviews avatar bbcode calendar calendarcustomfield calendarmoderator calendarpermission casino_bet_stats casino_blackjack_dealt casino_donatelog casino_games casino_letitride_dealt casino_lotto_draw casino_lotto_tickets casino_sb_bets casino_sb_events casino_sb_groups casino_sb_outcomes casino_settings casino_texasholdem_chatlog casino_texasholdem_dealt casino_texasholdem_whoisin casino_vidpok_dealt cpsession cron cronlog customavatar customprofilepic datastore deletionlog editlog event externalcache faq forum forumpermission forumread holiday icon imagecategory imagecategorypermission impexerror infraction infractionban infractiongroup infractionlevel language mailqueue moderation moderator moderatorlog passwordhistory paymentapi paymentinfo paymenttransaction phrase phrasetype plugin pm pmreceipt pmtext podcast podcastitem poll pollvote post posthash postindex postparsed product productcode productdependency profilefield ranks regimage reminder reputation reputationlevel rssfeed rsslog search session setting settinggroup sigparsed sigpic smilie stats strikes style subscribeevent subscribeforum subscribethread subscription subscriptionlog subscriptionpermission tachyforumpost tachythreadpost template templatehistory thread threadrate threadread threadredirect threadviews upgradelog user useractivation userban userfield usergroup usergroupleader usergrouprequest usernote userpromotion usertextfield usertitle word have reloaded them back for now as the site doesnt work without them
|
|
#6
08-18-2008, 11:44 PM
|
|||
|
|||
|
What was the full error message, you received before? (Right click a select "View Source" and paste it here).
You may be able to recreate it by just removing a single table.
|
|
#7
08-18-2008, 11:48 PM
|
||||
|
||||
|
<!--
Database error in vBulletin 3.7.2: Invalid SQL: SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1219106829; MySQL Error : Table 'blythblu_vbull.casino_texasholdem_whoisin' doesn't exist Error Number : 1146 Request Date : Monday, August 18th 2008 @ 08:47:39 PM Error Date : Monday, August 18th 2008 @ 08:47:39 PM Script : http://livefootballonline.com/ Referrer : IP Address : 86.11.172.65 Username : Unregistered Classname : vB_Database MySQL Version : --> Thanks
|
:up:
|
#10
08-19-2008, 12:10 AM
|
|||
|
|||
|
No problem, those "casino" tables are related to a modification I presume. (Which doesn't use table prefixes defined in config.php, but its own prefix).
Just make sure you compare the tables you've removed to make sure they don't contain any data you need e.t.c.
|
 |
«
Previous Thread
|
Next Thread
»
Linear Mode
|
|
All times are GMT. The time now is 09:53 PM.