Issue: Error in attachment database (again)

Issue Tools
- View Changes

June 19, 2011 4:49 PM

TundraSoul TundraSoul is offline

New Member

Error in attachment database (again)

And the fun continues....

Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

                       SELECT fd.filedataid
                       FROM attachment AS acu
                       INNER JOIN filedata AS fd ON (acu.filedataid = fd.filedataid)
                       LEFT JOIN thread AS thread ON (thread.firstpostid = acu.contentid AND thread.title LIKE acu.filename)
                       WHERE acu.filedataid = 16959
                               AND acu.userid = 8965
                               AND thread.forumid IN ()
                       LIMIT 1;

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 ')
                       LIMIT 1' at line 7
Error Number  : 1064
Request Date  : Sunday, June 19th 2011 @ 12:03:51 PM
Error Date    : Sunday, June 19th 2011 @ 12:03:51 PM
Script        : http://www.mysite.com/asset.php?fid=16959&uid=8965&d=1306305626
- Show quoted text -

Issue Details

Issue Number 2363

Issue Type Bug

Project VaultWiki 3.x Series

Category Attachments

Status Duplicate

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 3.0.12

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)

June 19, 2011 7:01 PM

pegasus

VaultWiki Team

You might need to rebuild the namespace cache. Because it is saying that the image namespace exists but it contains no forums. This is impossible, if it didn't contain forums, it wouldn't exist.

AdminCP > Namespace Manager > Rebuild All Namespaces.

Reply
June 19, 2011 7:07 PM

TundraSoul

New Member

I rebuilt the cache. I'll let you know how it goes.

Reply

This petition for a change to Unconfirmed was rejected

June 20, 2011 1:09 AM

TundraSoul TundraSoul is offline

New Member

Code:

Database error in vBulletin 4.1.4:

Invalid SQL:

                       SELECT fd.filedataid
                       FROM attachment AS acu
                       INNER JOIN filedata AS fd ON (acu.filedataid = fd.filedataid)
                       LEFT JOIN thread AS thread ON (thread.firstpostid = acu.contentid AND thread.title LIKE acu.filename)
                       WHERE acu.filedataid = 15921
                               AND acu.userid = 7029
                               AND thread.forumid IN ()
                       LIMIT 1;

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 ')
                       LIMIT 1' at line 7
Error Number  : 1064
Request Date  : Sunday, June 19th 2011 @ 09:48:10 PM
Error Date    : Sunday, June 19th 2011 @ 09:48:10 PM
Script        : http://www.mysite.com/asset.php?fid=15921&uid=7029&d=1306256266

Sorry to say, the error remains.

June 20, 2011 2:28 AM

pegasus

VaultWiki Team

Can you PM me FTP access to your site, and a vB login that can see this error? I need to see why the code thinks your site has no wiki forums.

Reply
June 21, 2011 1:43 AM

pegasus

VaultWiki Team

This error didn't make the Asset Manager unusable, it just broke some thumbnails.

As I suspected this is a result of having created an image space but not having permission to view any forums that make up that space or the forums that are part of the space are not in the vBulletin forum cache, as discussed in the previous report. I applied the same fix I suggested in the other report (which you said didn't work on 3.0.11) and it's working now on 3.0.12. Marking as a duplicate.

You also have some issues with the attachment javascript. Try redownloading the VaultWiki ZIP and replacing the /clientscript folder.

Reply
June 21, 2011 1:46 AM

TundraSoul

New Member

So then I don't have to patch anything?

Reply

+ Reply

All times are GMT -4. The time now is 9:49 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: Error in attachment database (again)

Issue Tools