vb.org Archive - Error in PM Message

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Error in PM Message (https://vborg.vbsupport.ru/showthread.php?t=92668)

Skyline_GT

07-22-2005 08:41 AM

Error in PM Message

I don't know why when I am trying to view the pm messages I got the following errors.

Quote:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM thread WHERE threadid =
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: Friday 22nd of July 2005 02:39:14 AM
Script: http://www.gamerzplanet.net/forums/p...pm&pmid=208744
Referer: http://www.gamerzplanet.net/forums/private.php?

The only two file that I recently edit are showthread.php and fuctions_showthread.php I don't know why it will affect private.php...
anyone have any thoughts??
thanks..

Marco van Herwaarden

07-22-2005 11:57 AM

Well that query is selecting from the thread table, not the pm table. So a bit strange.

Princeton

07-22-2005 01:17 PM

check your modifications ... I believe fuctions_showthread.php is 'required' in private.php

Skyline_GT

07-23-2005 12:18 AM

any wrong with this code?

Code:

$iscredits = false;

        if(!in_array($forum['forumid'], explode(',', $vboptions['credit_sysapplied'])))

        {

                $iscredits = true;

        }

^ from fuctions_showthread

and

Code:

// Begin thread Credits

$iscredits = false;

if(!in_array($forum['forumid'], explode(',', $vboptions['credit_sysapplied'])))

{

        $iscredits = true;

}

$creditthread = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX ."thread WHERE threadid = $thread[threadid]");

$creditvote = ceil($creditthread['creditsvote']/$creditthread['totalcreditsvote']);

^ from showthreads.php

these are the codes that I added to the two files. No other changes..

Marco van Herwaarden

07-23-2005 05:31 AM

The code itself don't look wrong, it only seems it gets executed on a moment that it should not be.

Skyline_GT

07-23-2005 06:23 AM

Quote:

Originally Posted by MarcoH64

The code itself don't look wrong, it only seems it gets executed on a moment that it should not be.

I don't know where is the problem.. can you give me a hand?

All times are GMT. The time now is 05:11 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01199 seconds Memory Usage 1,720KB 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 (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: