Log in

View Full Version : I got problem with mysql .. please help me ??


OmaniMan
10-03-2004, 09:51 AM
Hello there ...

The problem is when I want to read old threads I got error on DATABASE and exactly :
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT dateline FROM post where userid= order by dateline asc limit 0, 18446744073709551615

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by dateline asc limit 0, 18446744073709551615' at line 1

mysql error number: 1064

Date: Sunday 03rd of October 2004 02:28:00 PM
Script: http://www.mydomain.com/vb/showthread.php?t=1030
Referer:
Username: myname
IP Address: xxx.xx.xx.xxx

What is the problem ?? :(

My Mysql Version is : 4.0.20
PHP : 4.3.8 :disappointed:

Dean C
10-03-2004, 09:55 AM
SELECT dateline FROM post where userid= order by dateline asc limit 0, 18446744073709551615


You're missing the userid, but why the hell is that your upper limit :o!? You might want to reinstall whatever modification you installed :)

OmaniMan
10-03-2004, 09:57 AM
Thanks Dear Dean C for your replaying ...

Do you mean I have to reinstall hack ??

Or can you help me to tell what spcific file ??

OmaniMan
10-03-2004, 10:07 AM
Dear ...

I Found the problem ... (( Level Hack Made Problem )) .. I removed the hack and now it works ...

Thanks again