Issue: Special:Imagelist database error

Issue Tools
- View Changes

June 24, 2009 2:14 PM

Jella

Regular Member

Special:Imagelist database error

click letter with no image related to letter

When on the file list page where images are, Special:Imagelist seen here http://tvlampforum.com/showwiki.php?...cial:Imagelist
and you click on a letter with no image starting with that letter: ... you get a database error page
example I have no images listed starting with the letter C
you then get a database error page stating

Code:

Database error in vBulletin 3.7.3:
Invalid SQL:
		SELECT COUNT(thread.threadid) AS rowcount
		FROM thread AS thread
		WHERE thread.forumid IN (60)
			 AND thread.threadid IN ();
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 ')' at line 4
Error Number  : 1064
Request Date  : Wednesday, June 24th 2009 @ 02:10:35 PM
Error Date    : Wednesday, June 24th 2009 @ 02:10:36 PM
Script        : http://tvlampforum.com/showwiki.php?lampwiki=Special:Imagelist
Referrer      : http://tvlampforum.com/showwiki.php?lampwiki=Special:Imagelist
IP Address    : 98.229.125.21
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.77-community

Issue Details

Issue Number 648

Issue Type Bug

Project VaultWiki 3.x Series

Category Images

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.3.2

Fixed Version 2.5.0

Milestone VaultWiki 2.5.x

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

June 24, 2009 2:34 PM

pegasus

VaultWiki Team

In vault/extensions/image/special/special_imagelist.php, find:

PHP Code:

$threadids = array();

Replace with:

PHP Code:

$threadids = array(-1);

Reply
June 29, 2009 2:22 PM

Jella

Regular Member

That worked great, I fixed both sites, thank you Ted.

Reply

+ Reply

All times are GMT -4. The time now is 10:27 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: Special:Imagelist database error

Issue Tools