mysql error
 

I'm not sure if I can get support here since I downloaded this hack from another forum but it's a mysql problem and I was just hopeing some one here could provide me the answer:

Anyone have any idea to fix this?

At a first glance, it looks like you are missing parameters for the LIMIT part.
LIMIT, as its name implies, limits your results to the set amount.
Ex:

|------table: vb3_bankbalance-------|
// not even remotely my real bank records, i wouldn't be that stupid.
id, in, out, balance
1, 0.00, 10.00, 560.00
2, 300.00, 0.00, 860.00
3, 0.00, 50.00, 810.00
4, 0.00, 20.00, 790.00
5, 100.00, 0.00, 890.00
6, 0.00, 500.00, 390.00
7, 100.00, 0.00, 490.00
|------end--------|

$DB_site->query("
SELECT balance
FROM " . TABLE_PREFIX . "mybankrecords
LIMIT 2,7
");

Should grab rows 2 -> 7 and leave row 1 in the database.
A 'LIMIT' can't have no parameters. That's probably why you are getting that error, anyway.

thats the sql i ran, could you fix it to make it right because to be honest your post didn't make much sense to me :confused:

Nothing wrong with that.

then i hate to sound stupid, but what should i do to fix this? i am really new to mysql..

is there something i could run to fix it, or do something? god i hate sounding stupid..

Well I straight off ran that query copy + paste, and it executed it fine. Not sure why it isn't working in your case. What exactly is it saying? Have you tried running the query from phpMyAdmin? That is where I ran it from.

No it runs prefectly.. its when I try to view it.. see,


http://www.exasko.info/forum/journal.php

that is the problem i am getting..

I just see "there has been a technical problem with the database" :p

Database error in vBulletin 3.0.0:

Invalid SQL:
SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views
FROM journal j
LEFT JOIN user u ON u.userid = j.userid
WHERE j.enabled = 1
ORDER BY j.views DESC
LIMIT

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 '' at line 6

mysql error number: 1064

Date: Friday 20th of August 2004 11:55:56 PM
Script: http://www.exasko.info/forum/journal.php
Referer:


that is the error i get on that page..

Open up 'journal.php' in your favourite editor.
Find the line with the text:
"SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views"
Paste all of the query including $DB_site->query bit.
Maybe put it inside [code] braces? :p