Issue: Database error

Issue Tools
- View Changes

October 10, 2009 5:16 PM

Hostboard

Junior Member

Database error

Database error in vBulletin 3.8.3:

Code:

Invalid SQL:

            SELECT thread.threadid, thread.title
                
            FROM thread AS thread
            
            WHERE thread.forumid IN (1530)
                AND visible = 1
                AND open <> 10
                
            AND lastpost < 
            ORDER BY lastpost 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 lastpost DESC' at line 10
Error Number  : 1064
Request Date  : Saturday, October 10th 2009 @ 02:44:04 AM
Error Date    : Saturday, October 10th 2009 @ 02:44:05 AM
Script        : http://www.MyDomain.com/forums/showwiki.php?title=:187775&goto=nextoldest
Referrer      : 
IP Address    : 77.88.28.247
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version :

Issue Details

Issue Number 874

Issue Type Bug

Project VaultWiki 3.x Series

Category Wiki Pages

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 2.5.4

Fixed Version 2.5.5

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 10, 2009 5:45 PM
pegasus

VaultWiki Team
I believe this happens when you try to view the next newest/oldest from an article that hasn't been created yet.

In showwiki.php, find (2 places):

Code:

$thread = $threadinfo;

Add after:

Code:

if ($thread['threadid'] == 'error') { eval(standard_error(fetch_error('invalidid', $vbphrase['ces_article'], $vbulletin->options['contactuslink']))); }
Reply
October 10, 2009 6:22 PM

Hostboard

Junior Member

Edited and added. Now If i cut and past that URL I get a 404 error.

Reply
October 10, 2009 8:11 PM

pegasus

VaultWiki Team

This is expected behavior if you have your forum configured to return 404 when it throws an invalid ID error.

You will see if you try: /forums/showthread.php?t=

Reply
October 12, 2009 12:14 PM

Hostboard

Junior Member

I use VBSEO 404 pages retrun back to the home page.

Reply

+ Reply

All times are GMT -4. The time now is 10:59 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Database error

Issue Tools