PDA

View Full Version : database error

badawidollah
10-09-2009, 02:30 PM
Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT title
FROM usertitle
WHERE minposts <= 0
ORDER BY minposts DESC
LIMIT 1;

MySQL Error : Table 'tonop_forum5.usertitle' doesn't exist
Error Number : 1146
Request Date : Friday, October 9th 2009 @ 06:53:00 AM
Error Date : Friday, October 9th 2009 @ 06:53:01 AM
Script : http://www.nusantaraku.org/admincp/user.php?do=update
Referrer : http://www.nusantaraku.org/admincp/user.php?do=edit&u=140
IP Address : 203.82.92.157
Username : administrator
Classname : vB_Database
MySQL Version : 5.0.81-community
Lynne
10-09-2009, 02:40 PM
You already posted this over on vb.com and I replied over there.
badawidollah
10-09-2009, 02:42 PM
You already posted this over on vb.com and I replied over there.

i found usertitle
but why my mysql told me that i dont have it.
i dont know how to fix it
what to do

--------------- Added 1255103123 at 1255103123 ---------------

usertitle char(250) latin1_swedish_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
Lynne
10-09-2009, 02:59 PM
As I'm telling you over on vb.com, we are talking about a table named usertitle, not the usertitle field in the user table.