vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   mysql error (https://vborg.vbsupport.ru/showthread.php?t=68581)

Osterling 08-21-2004 02:14 AM
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:

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 08-21-2004 02:36 AM
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 08-21-2004 02:40 AM
Quote:
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 :confused:

Davey 08-21-2004 02:45 AM
Code:
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 08-21-2004 02:47 AM
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 08-21-2004 02:50 AM
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 08-21-2004 02:52 AM
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 08-21-2004 02:55 AM
I just see "there has been a technical problem with the database" :p

Osterling 08-21-2004 02:57 AM
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 08-21-2004 03:00 AM
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

Osterling 08-21-2004 03:04 AM
Code:
$journal_views = $DB_site->query("
                                                        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 " . "$vboptions[journals_viewdisplaylimit]
                                                        ");
that' it... thank you so much :)

Davey 08-21-2004 03:07 AM
Could you try replacing it with this, and telling me what happens then?

Code:
$journal_views = $DB_site->query("
                                                        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 $vboptions['journals_viewdisplaylimit']
                                                        ");
Thanks.

Osterling 08-21-2004 03:08 AM
i get this error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/exas77ko/public_html/forum/journal.php on line 1211

Brad 08-21-2004 03:09 AM
Try this instead:

PHP Code:
$limit_views = intval($vboptions['journals_viewdisplaylimit']);
$journal_views = $DB_site->query("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" . $limit_views); 

Davey 08-21-2004 03:11 AM
Ah, brad.loo to save the day. :p

edit. hey brad.loo, maybe you could help with my problem :devious: :p look about 10 threads down lol.

Osterling 08-21-2004 03:12 AM
Quote:
Originally Posted by Brad.loo
Try this instead:

PHP Code:
$limit_views = intval($vboptions['journals_viewdisplaylimit']);
$journal_views = $DB_site->query("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" . $limit_views); 
when i did that, i got this error

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 LIMIT0
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 'LIMIT0' at line 1

mysql error number: 1064

Brad 08-21-2004 03:13 AM
Argh...damn array, use this:

PHP Code:
$journal_views = $DB_site->query("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"  . $vboptions['journals_viewdisplaylimit']); 

Osterling 08-21-2004 03:20 AM
Quote:
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 1

mysql error number: 1064

Date: Saturday 21st of August 2004 12:19:31 AM
Script: http://www.exasko.info/forum/journal.php
thats the error i get when made the other change

Brad 08-21-2004 03:25 AM
Wait, is the the journal script posted on evB? Last I heard that has alot more errors then just then one, just so you know.

You can try throwing this at it, are you sure you set up all the vBoptions for that script correctly?

PHP Code:
$journal_views = $DB_site->query("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".$vboptions[journals_viewdisplaylimit]); 
Altho im not sure why the single quotes in the array would throw it off any.

Osterling 08-21-2004 04:21 AM
no.. didn't fixc the problem :(


All times are GMT. The time now is 04:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01116 seconds
  • Memory Usage 1,786KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (5)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (20)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete