vb.org Archive

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

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

- - Errors (https://vborg.vbsupport.ru/showthread.php?t=168270)

kylewood

01-20-2008 10:35 AM

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

Opserty

01-20-2008 11:33 AM

<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.

kylewood

01-20-2008 11:34 AM

What does PL1 mean?

Opserty

01-20-2008 11:35 AM

Disable you plugins and see if the error still occurs.

(Some more information: http://www.vbulletin.com/forum/showthread.php?t=229747)

kylewood

01-20-2008 11:46 AM

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.

Opserty

01-20-2008 01:51 PM

Take a backup of your edited files.
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)
Upload these unedited files (except install.php) making sure you overwrite existing files on the server
See if you can reproduce the errors.

kylewood

01-20-2008 03:05 PM

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.

Marco van Herwaarden

01-21-2008 06:38 AM

did you do any recent maintenance on your forums, like upgrading?

kylewood

01-21-2008 01:26 PM

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

All times are GMT. The time now is 07:27 PM.

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