mysql error

[Osterling]

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:

PHP Code:

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 10:58:40 PM
Script: http://www.
Referer: http://www.
Username: exasko
IP Address: 


Anyone have any idea to fix this?

[Davey]

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.

[Osterling]

CREATE TABLE journal (
journalid int(11) NOT NULL auto_increment,
title text NOT NULL,
description text NOT NULL,
imagename text NOT NULL,
entries int(11) NOT NULL default '0',
views int(11) NOT NULL default '0',
enabled smallint(6) default '0',
timestamp int(11) NOT NULL default '0',
userid int(11) NOT NULL default '0',
mood text NOT NULL,
np text NOT NULL,
PRIMARY KEY (journalid)
) TYPE=MyISAM ;

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

[Davey]

Your SQL-query has been executed successfully
 
SQL-query :
CREATE TABLE journal ( journalid int(11) NOT NULL auto_increment, title text NOT NULL, description text NOT NULL, imagename text NOT NULL, entries int(11) NOT NULL default '0', views int(11) NOT NULL default '0', enabled smallint(6) default '0', timestamp int(11) NOT NULL default '0', userid int(11) NOT NULL default '0', mood text NOT NULL, np text NOT NULL, PRIMARY KEY (journalid) ) TYPE=MyISAM

Nothing wrong with that.

[Osterling]

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

[Davey]

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.

[Osterling]

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

[Davey]

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

[Osterling]

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

[Davey]

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?