Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2008, 11:28 PM
DanTHEGREAT's Avatar
DanTHEGREAT DanTHEGREAT is offline
 
Join Date: Oct 2008
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default database error.

On my forum, I get a database error of this:

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:
SELECT field0 FROM VFKK_userfield WHERE userid='101';;

MySQL Error : Unknown column 'field0' in 'field list'
Error Number : 1054
Request Date : Sunday, December 21st 2008 @ 08:27:52 PM
Error Date : Sunday, December 21st 2008 @ 08:27:52 PM
Script : http://freerealmsforums.com/private....owpm&pmid=5983
Referrer : http://freerealmsforums.com/private.php
IP Address : ###.88.239.151
Username : #####
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

anyone know the problem

NOTE: Happens on every function on the forums.
Reply With Quote
  #2  
Old 12-21-2008, 11:31 PM
ExTincTi0N ExTincTi0N is offline
 
Join Date: Mar 2008
Location: Texas
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Where are you getting this database error? when you try to send a pm?
Reply With Quote
  #3  
Old 12-21-2008, 11:32 PM
Medtech's Avatar
Medtech Medtech is offline
 
Join Date: Oct 2007
Posts: 310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

sounds like an issue with a profile field. anyone been doing any editing?
Reply With Quote
  #4  
Old 12-21-2008, 11:33 PM
DanTHEGREAT's Avatar
DanTHEGREAT DanTHEGREAT is offline
 
Join Date: Oct 2008
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually, It happens to every forum I try to click, most functions on the forum..@_@
Reply With Quote
  #5  
Old 12-21-2008, 11:36 PM
ExTincTi0N ExTincTi0N is offline
 
Join Date: Mar 2008
Location: Texas
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have any modifications on your site that are enabled?
Reply With Quote
  #6  
Old 12-21-2008, 11:37 PM
Medtech's Avatar
Medtech Medtech is offline
 
Join Date: Oct 2007
Posts: 310
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

also did you remove any mods? sometimes a file may be left behind. go to admincp/ maintinance/ diagnostics/ suspect file versions. look for any files belonging to any modifications you may have removed and delete them. i had a similar issue a few hrs ago.
Reply With Quote
  #7  
Old 12-21-2008, 11:37 PM
DanTHEGREAT's Avatar
DanTHEGREAT DanTHEGREAT is offline
 
Join Date: Oct 2008
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes I have over 10...@_@
Reply With Quote
  #8  
Old 12-21-2008, 11:37 PM
ExTincTi0N ExTincTi0N is offline
 
Join Date: Mar 2008
Location: Texas
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try disabling all of your mods to see if that is the problem.
Reply With Quote
  #9  
Old 12-22-2008, 12:04 AM
DanTHEGREAT's Avatar
DanTHEGREAT DanTHEGREAT is offline
 
Join Date: Oct 2008
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well in the DB, under fieldlist is there a "field" or "field0" or both in the database because I see a column called field but no user accounts have anything filled inside of it, I am thinking that it got renamed in the structure.
Reply With Quote
  #10  
Old 12-22-2008, 03:13 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In the userfield table, there are field columns starting with field1, field2, etc up to however many User Profile Fields you have. vB comes with field1, field2, field3, and field4 already, so when you add a Profile Field, the next one is field5, then field6, etc. The only way there can be a field0 is if someone did something in the database. The field names are all listed in the User Profile Field Manager.
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 01:25 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.04725 seconds
  • Memory Usage 2,238KB
  • Queries Executed 11 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete