Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 04-19-2008, 03:12 PM
tillcat5 tillcat5 is offline
 
Join Date: May 2007
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default userdatabase problem

my server had to do soem fixes and reloaded my site and now my database will not recognize any of my memmbers. this is the error i get

Quote:
Restored with a small error

[root@server1 sitename]# mysql -u sitename_hostecon -p sitename_vbulletinsqlkey < sitename_vbulletinsqlkey.sql
Enter password:
ERROR 1054 (42S22) at line 5158: Unknown column 'vbp_immunity' in 'field list'
anyone know what we can do to fix tihs without losing everything
Reply With Quote
  #2  
Old 04-19-2008, 03:24 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable your modifications and see if the error still occurs.
Reply With Quote
  #3  
Old 04-19-2008, 03:28 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please post line 5158 of the backup file and the 10 lines above/under.
Reply With Quote
  #4  
Old 04-19-2008, 03:37 PM
tillcat5 tillcat5 is offline
 
Join Date: May 2007
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i cant even get into the admincp. it doesnt accept any passwords from mebers so no members can log in. i am getting those lines for you

--------------- Added [DATE]1208623480[/DATE] at [TIME]1208623480[/TIME] ---------------

INSERT INTO vbadminlog VALUES('36156', '760', '1190733953', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36157', '760', '1190733954', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36158', '760', '1190734002', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36159', '760', '1190734003', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36160', '760', '1190734447', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36161', '760', '1190734448', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36162', '760', '1190734557', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36163', '760', '1190734558', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36164', '760', '1190734588', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36165', '760', '1190734589', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36166', '760', '1190734758', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36167', '760', '1190734759', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36168', '760', '1190734784', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36169', '760', '1190734785', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36170', '760', '1190734851', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36171', '760', '1190734852', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36172', '760', '1190734903', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36173', '760', '1190734904', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36174', '760', '1190734927', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36175', '760', '1190734928', 'template.php', 'edit', 'style id = 0', '72.65.109.209');
INSERT INTO vbadminlog VALUES('36176', '760', '1190734971', 'template.php', 'updatetemplate', 'style id = 10', '72.65.109.209');

--------------- Added [DATE]1208666808[/DATE] at [TIME]1208666808[/TIME] ---------------

i seem to have gotten past this problem .. thanks for input...
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:39 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09411 seconds
  • Memory Usage 2,187KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete