vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   New Post Error (https://vborg.vbsupport.ru/showthread.php?t=74474)

JD210 01-16-2005 08:31 PM
New Post Error
 
On both the vbadvanced portal, and on the welcome panel, where it lists the link for New Posts, I get the following error whenever I click on the link to show new posts. This doesn't happen if there are no new posts, but if there are new posts, then the below error shows up. Any ideas as to how to fix this. The link to my boards is: Vast Frontier
Quote:
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
thread.pollid, thread.open, thread.lastpost AS postdateline,
thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid, thread.threaddesc
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM vb3thread AS thread
LEFT JOIN vb3user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vb3subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)
LEFT JOIN vb3post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(19, 18)
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 '.userid AS postuserid
, NOT ISNULL(subscribethread.subscrib

mysql error number: 1064

Marco van Herwaarden 01-17-2005 03:19 AM
add a "," before user.userid:
[sql], user.userid AS postuserid
[/sql]

JD210 01-17-2005 06:23 PM
Where do I put it? Where do I find that phrase to add the "," to, and if it is MySQL, how do I edit it to add that?

Marco van Herwaarden 01-17-2005 08:28 PM
Well i don't know which script generates this error, you should be able to tell us. I think you just installed some hack, best is to ask in the support thread of that hack, and not in the general php/sql section.


All times are GMT. The time now is 01:10 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.01001 seconds
  • Memory Usage 1,719KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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