Issue: Incompatibility with another module?

Issue Tools
- View Changes

August 29, 2008 6:38 AM

vimto

Regular Member

Incompatibility with another module?

YAAS

I have another mod on my site called Yet Another Award System which has been working pretty good, but when I tried running part of it today I noticed an error coming up that mentioned namespaces, this is the error:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

     SELECT postid, threadid, namespaceid, forumid
     FROM post AS post, thread AS thread
     WHERE post.threadid = thread.threadid AND
      postid >=  AND
      thread.lastpost >= 1219400598
     ORDER BY postid
     LIMIT;

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 'AND
      thread.lastpost >= 1219400598
     ORDER BY postid
     LIMIT' at line 4
Error Number  : 1064
Request Date  : Friday, August 29th 2008 @ 11:23:18 AM
Error Date    : Friday, August 29th 2008 @ 11:23:18 AM
Script        : http://www.bluedragons.co.uk/forums/admin/award.php?do=manage
Referrer      : http://www.bluedragons.co.uk/forums/admin/index.php?do=nav

This is from clicking on the Award System/Give award to user part of my Admin page.
Is there anything I can do to get this working again?

There is no mention of the sql code in the award.php page so I can only assume it is being hooked in somehow....Any ideas?

Issue Details

Issue Number 211

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 2.0.3

Fixed Version 2.0.4

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 29, 2008 12:20 PM

pegasus

VaultWiki Team

In vault/special_plugins_bbcode.php, find:

PHP Code:

if (empty($threadinfo['namespaceid']) AND VB_AREA == 'AdminCP')

Replace with:

PHP Code:

if (empty($threadinfo['namespaceid']) AND VB_AREA == 'AdminCP' AND $_REQUEST['do'] == 'buildpostcache')

Reply
August 29, 2008 5:26 PM

vimto

Regular Member

Many thanks, works great. excellent work

Reply

+ Reply

All times are GMT -4. The time now is 12:35 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: Incompatibility with another module?

Issue Tools