View Full Version : Errors
kylewood
01-20-2008, 10:35 AM
When i click on someones profile i get this;
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 1200834016 at 1200834016 ---------------
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 1200839598 at 1200839598 ---------------
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 1200849265 at 1200849265 ---------------
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 1200939179 at 1200939179 ---------------
I fixed everything else, i only have one problem now, the one when viewing member profiles.
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
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.