vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   What Am I Doing Wrong? (https://vborg.vbsupport.ru/showthread.php?t=92572)

ManagerJosh 07-20-2005 09:13 PM
What Am I Doing Wrong?
 
Tried executing this query, but keep getting a database error, 1064



PHP Code:
$pms = $db->query_read("
  SELECT pm.*, pmtext.*
   " . iif($vbulletin->options['privallowicons'], ", icon.title AS icontitle, icon.iconpath") . "
  FROM " . TABLE_PREFIX . "pm AS pm
  LEFT JOIN " . TABLE_PREFIX . "pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
  " . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = pmtext.iconid)") . "
  WHERE pm.userid=$userid AND pm.folderid=$folderid
  ORDER BY pmtext.dateline DESC
 "); 


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 pmtext.dateline DESC' at line 7

Error Number : 1064

Brad 07-20-2005 10:57 PM
Unless it changed in a later beta, iif is no longer a vaild function AFAIK.

Link14716 07-20-2005 10:59 PM
iif sucked anyways.

iif($condition, $true, $false) should be ($condition ? $true : $false).

Marco van Herwaarden 07-21-2005 03:39 AM
Check if $folderid is not empty.

ManagerJosh 07-23-2005 10:10 AM
I'm using:

PHP Code:
$messagecounters = array();
$pmcounts = $db->query_read("
    SELECT COUNT(*) AS total, folderid
    FROM " . TABLE_PREFIX . "pm AS pm
    LEFT JOIN " . TABLE_PREFIX . "pmtext AS pmtext USING(pmtextid)
    WHERE userid = $userid
    GROUP BY folderid
");
while ($pmcount = $db->fetch_array($pmcounts))
{
    $messagecounters["$pmcount[folderid]"] = intval($pmcount['total']);
}

$links = array();
foreach ($folders AS $key => $value)
{
    $links[] = '<a href="' . THIS_SCRIPT . "?userid=$userid&amp;folderid=$key\">$value (" . intval($messagecounters["$key"]) . ")</a>";
} 
What did I do wrong?

Marco van Herwaarden 07-23-2005 10:31 AM
PHP Code:
while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
    $messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 

$links = array(); 
foreach ($folders AS $key => $value) 
Shouldn't that be:
PHP Code:
while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
    $messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 

$links = array(); 
foreach ($messagecountersAS $key => $value) 

Logikos 07-23-2005 10:52 AM
Acually you made a type-o Marco.
PHP Code:
 while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
    $messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 

$links = array(); 
foreach ($messagecountersAS $key => $value) 
Should be:
PHP Code:
 while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
    $messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 

$links = array(); 
foreach ($messagecounters AS $key => $value) 
You forgot the space before AS :)

ManagerJosh 07-23-2005 11:26 AM
Quote:
Originally Posted by Live Wire
Acually you made a type-o Marco.
PHP Code:
while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
$messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 
 
$links = array(); 
foreach ($messagecountersAS $key => $value) 
Should be:
PHP Code:
while ($pmcount = $db->fetch_array($pmcounts)) 
{ 
$messagecounters["$pmcount[folderid]"] = intval($pmcount['total']); 
} 
 
$links = array(); 
foreach ($messagecounters AS $key => $value) 
You forgot the space before AS :)
Database error in vBulletin 3.5.0 Beta 4:

Invalid SQL:

Code:
SELECT pm.*, pmtext.*
                        , icon.title AS icontitle, icon.iconpath
                FROM pm AS pm
                LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
                LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
                WHERE pm.userid=1 AND pm.folderid=
                ORDER BY pmtext.dateline DESC;
 
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 pmtext.dateline DESC' at line 7
Error Number : 1064

Appears to be:

PHP Code:
if (empty($_REQUEST['pmid']))
{
$vbulletin->input->clean_array_gpc($_REQUEST, array('folderid' => INT));
$pms = $db->query_read("
SELECT pm.*, pmtext.*
" . iif($vbulletin->options['privallowicons'], ", icon.title AS icontitle, icon.iconpath") . "
FROM " . TABLE_PREFIX . "pm AS pm
LEFT JOIN " . TABLE_PREFIX . "pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
" . iif($vbulletin->options['privallowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = pmtext.iconid)") . "
WHERE pm.userid=$userid AND pm.folderid=$folderid
ORDER BY pmtext.dateline DESC
"); 
Okay, looking at that SQL query....ARGH :| No idea what's wrong :|

Marco van Herwaarden 07-23-2005 11:28 AM
Yeah i saw after i submitted (double click not only select the word, but also the space after), but i thought he would figure that out.

Logikos 07-23-2005 11:50 AM
That error is due to one of two possiablities.
1) pm.userid is showing up as empty.
Or
2) pm.folderid is showing up as empty


All times are GMT. The time now is 07:26 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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.01252 seconds
  • Memory Usage 1,781KB
  • 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
  • (1)bbcode_code_printable
  • (9)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete