Issue: MySQL Error

Issue Tools
- View Changes

February 1, 2011 8:31 AM

rcforum

New Member

MySQL Error

MySQL Error after performing a search

At the VB search page i performed a search:

-search in wiki content pages
-search for keyword and Search entire Pages

Code:

Datenbankfehler in vBulletin 4.1.1:

Invalid SQL:

                        SELECT thread.*,article.languageid,post.pagetext AS preview,subscribethread.subscribethreadid,threadread.readtime
                        FROM VB3_thread AS thread
                                LEFT JOIN VB3_vault_article AS article ON (article.threadid = thread.threadid)
LEFT JOIN VB3_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN VB3_subscribethread AS subscribethread ON
                                        subscribethread.threadid = thread.threadid AND
                                        subscribethread.userid =  22556
LEFT JOIN VB3_threadread AS threadread ON
                                        threadread.threadid = thread.threadid AND
                                        threadread.userid =  22556
                        WHERE thread.threadid IN (2000287,2000285,2000825,2000699,2000696,2000270,2007603,2000694,2008199,2012033,2011666,2007515,2007365,2007366,2011378,2007369,2007460,2000735,2010671,2009856) AND;

MySQL-Fehler  : 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 11
Fehler-Nr.    : 1064
Fehler-Zeit   : Tuesday, 01.02.2011 @ 14:20:25
Datum         : Tuesday, 01.02.2011 @ 14:20:25
Skript        : http://vb3.rc-forum.de/search.php?searchid=8
Referrer      : http://vb3.rc-forum.de/search.php?search_type=1
IP-Adresse    : 194.138.39.54
Benutzername  : mred
Klassenname   : vB_Database
MySQL-Version : 5.0.67-1~ui40+2-log

Issue Details

Issue Number 2217

Issue Type Bug

Project VaultWiki 3.x Series

Category Core

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.9

Fixed Version 3.0.10

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 1, 2011 12:24 PM
pegasus

VaultWiki Team
Fixed in the current ZIP. In packages/vaultwiki/legacy/vaultarticle.php, find:

Code:

$where[] = $hook_query_where;

Replace with:

Code:

if ($hook_query_where) { $where[] = $hook_query_where; }
Reply

+ Reply

All times are GMT -4. The time now is 11:11 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: MySQL Error

Issue Tools