Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 01-20-2008, 10:35 AM
kylewood kylewood is offline
 
Join Date: Aug 2006
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Errors

When i click on someones profile i get this;

Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : Table 'ubeboo_vbulletin.profilefieldcategory' doesn't exist
Error Number : 1146
Date : Sunday, January 20th 2008 @ 12:34:43 PM
Script : http://football101.co.uk/forums/member.php?u=14
Referrer : http://football101.co.uk/forums/index.php
IP Address : 78.145.162.134
Username : El Nino
Classname : vb_database


Help?

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

I think the whole of my search is screwed, i cant look at todays post, find all post users? Please help me :P
Reply With Quote
  #2  
Old 01-20-2008, 11:33 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://www.vbulletin.com/forum/showthread.php?t=231816" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=231816</a>

Your not running upgrade.php according to threads here at vb.org. Make sure you run upgrade.php when you load updated files on to the server.
Reply With Quote
  #3  
Old 01-20-2008, 11:34 AM
kylewood kylewood is offline
 
Join Date: Aug 2006
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What does PL1 mean?
Reply With Quote
  #4  
Old 01-20-2008, 11:35 AM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable you plugins and see if the error still occurs.

(Some more information: http://www.vbulletin.com/forum/showthread.php?t=229747)
Reply With Quote
  #5  
Old 01-20-2008, 11:46 AM
kylewood kylewood is offline
 
Join Date: Aug 2006
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I disabled all and the error still occurs, i recently tried installing hide hack and this is when this all happened. I edited lots of files but i re-uploaded them instead of deleting the stuff out.

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

All the other errors have gone but the profile one is still there.
Reply With Quote
  #6  
Old 01-20-2008, 01:51 PM
Opserty Opserty is offline
 
Join Date: Apr 2007
Posts: 4,103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

  1. Take a backup of your edited files.
  2. Download an fresh copy of vBulletin from vBulletin.com. Ensure it is the same version as you have on your site (3.6.1 according to your DB error)
  3. Upload these unedited files (except install.php) making sure you overwrite existing files on the server
  4. See if you can reproduce the errors.
Reply With Quote
  #7  
Old 01-20-2008, 03:05 PM
kylewood kylewood is offline
 
Join Date: Aug 2006
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Won work, is there a way to make it not look for that table?

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

Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = '53675ea9f1c981873f5c97ae7d1911af' AND orderedids = '24,28,17,82,52,47,6,44,55,23,77,56,81,5,72,42,67, 74,71,78,20,80,79,13' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Sunday, January 20th 2008 @ 05:13:58 PM
Script : http://football101.co.uk/forums/search.php?do=getnew
Referrer : http://football101.co.uk/forums/index.php
IP Address : 78.145.162.134
Username : El Nino
Classname : vb_database

I also get this when looking for new posts.
Reply With Quote
  #8  
Old 01-21-2008, 06:38 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

did you do any recent maintenance on your forums, like upgrading?
Reply With Quote
  #9  
Old 01-21-2008, 01:26 PM
kylewood kylewood is offline
 
Join Date: Aug 2006
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nope i have not upgraded, only thing i can think of is using Hide Hack Ressurection.

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

I fixed everything else, i only have one problem now, the one when viewing member profiles.

Quote:
Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT pf.profilefieldid, pf.profilefieldcategoryid, pf.required, pf.type, pf.data, pf.def, pf.height
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;

MySQL Error : Unknown column 'pf.profilefieldcategoryid' in 'field list'
Error Number : 1054
Date : Monday, January 21st 2008 @ 06:12:35 PM
Script : http://football101.co.uk/forums/member.php?u=1
Referrer : http://football101.co.uk/forums/showthread.php?t=124
IP Address : 78.145.162.134
Username : El Nino
Classname : vb_database
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 04:06 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02037 seconds
  • Memory Usage 2,226KB
  • 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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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