Issue: Database error on edit / redirect

Issue Tools
- View Changes

May 10, 2009 1:37 PM

tommythejoat tommythejoat is offline

Regular Member

Database error on edit / redirect

Editing an article title containing a semicolon generates database error.

One of my users created an article with a semicolon in the title (which may not be relevant) and when attempting to rename the article and another similar one to generate a more standard title format, got the following database errors:

Code:

Database error in vBulletin 3.8.2: 

Invalid SQL: 

                        SELECT thread.threadid 
                        FROM thread AS thread 
                        LEFT JOIN vault_link AS link ON (thread.firstpostid = link.postid) 
                        WHERE thread.threadid IN (50236) 
                                AND link.redirect = 1 
                                AND link.targetid IN () 
                        GROUP BY thread.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 ')

                        GROUP BY thread.threadid' at line 6 
Error Number  : 1064 
Request Date  : Sunday, May 10th 2009 @ 11:06:57 AM 
Error Date    : Sunday, May 10th 2009 @ 11:06:58 AM 
Script        : hxxp://mb.nawcc.org/showwiki.php?title=Kern+und+Sohne+KuS101&do=edit 
Referrer      : hxxp://mb.nawcc.org/showwiki.php?title=Kern+und+Sohne+KuS101 
IP Address    : 72.161.185.130 
Username      : kirxklox 
Classname     : vB_Database 
MySQL Version :

Same error, different article:

Code:

Database error in vBulletin 3.8.2: 

Invalid SQL: 

                        SELECT thread.threadid 
                        FROM thread AS thread 
                        LEFT JOIN vault_link AS link ON (thread.firstpostid = link.postid) 
                        WHERE thread.threadid IN (50231) 
                                AND link.redirect = 1 
                                AND link.targetid IN () 
                        GROUP BY thread.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 ')

                        GROUP BY thread.threadid' at line 6 
Error Number  : 1064 
Request Date  : Sunday, May 10th 2009 @ 11:07:57 AM 
Error Date    : Sunday, May 10th 2009 @ 11:07:57 AM 
Script        : hxxp://mb.nawcc.org/showwiki.php?title=Gustav+Becker+GB101&do=edit 
Referrer      : hxxp://mb.nawcc.org/showwiki.php?title=Gustav+Becker+GB101 
IP Address    : 72.161.185.130 
Username      : kirxklox 
Classname     : vB_Database 
MySQL Version :

Issue Details

Issue Number 584

Issue Type Bug

Project VaultWiki 3.x Series

Category Redirects

Status Duplicate

Priority 3 - Loss of Functionality

Affected Version 2.2.3 Patch Level 1

Fixed Version (none)

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

May 10, 2009 2:56 PM

pegasus

VaultWiki Team

Duplicate of: http://www.crackedeggstudios.com/pro...hp?issueid=519
See the third post on.

Reply
May 10, 2009 4:06 PM

tommythejoat

Regular Member

Still just a little confused. The reference says that bug is fixed in 2.2.3 pl1.

Do I still need to install the patches referred to in that thread?

I am not sure I know how to read the project status information properly.

Will 2.3.0 be available soon?

Reply
May 10, 2009 4:26 PM

pegasus

VaultWiki Team

Two bugs were reported in that thread. Only one made it into PL1, while the one you mentioned had to be retained until 2.3.0.

2.3.0 was released moments ago, but the upgrade instructions have not yet been updated. Please wait for an announcement to be created.

Reply

+ Reply

All times are GMT -4. The time now is 6:53 PM.

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 on edit / redirect

Issue Tools