Status
Not open for further replies.

viper357

Customer
I was running 1.0.11, upgraded to 1.0.14 and received a database error when clicking on any thread, I had to go back to 1.0.11 for my forum to work again.

Database error in vBulletin 3.8.5:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,threadread.readtime AS threadread, forumread.readtime AS forumread,
thread.*

, post.pagetext AS description
FROM thread AS thread

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND subscribethread.canview = 1)


LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = thread.forumid AND forumread.userid = 1)


LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid = 52637;

MySQL Error : Column 'visible' in field list is ambiguous
Error Number : 1052
Request Date : Monday, May 5th 2014 @ 01:53:42 AM
Error Date : Monday, May 5th 2014 @ 01:53:42 AM
Script : http://www.marineaquariumsa.com/showthread.php?t=52637
Referrer : Marine Aquariums South Africa
IP Address : ******
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.73-cll
 
So I am installing the new release this morning and that should take care of the thrown database errors, but what do I do about my photopost problems? 404 Not Found which returns The requested URL /dbseo.php was not found on this server.
 
You should exclude photopost from DBSEO via the .htaccess file :)

Unfortunately I can't tell you exactly how that's done since I have no experience running photopost, but if you contact their support department they should be able to help you out :)
 
My photopost directory is not under my forum directory so I don't understand why DB seo would re-write it as it stands now. Also all my vbadvanced pages are broken as well such as 404 Not Found

I see the DB SEO .htaccess entry excludes folders in the forum directory to be excluded such as mobiquo and admincp which makes sense,

RewriteCond %{REQUEST_URI} !(admincp/|dbseocp/|modcp/|cron|mobiquo|forumrunner|api\.php)

but I don't understand why it operates on folders which do not fall under forum forum directory.
 
Last edited:
Fixed most of the stuff with this entry to my .htaccess file

PHP:
RewriteCond %{REQUEST_URI} !(reviewpost/|classifieds/|photopost/|admincp/|dbseocp/|modcp/|cron|mobiquo|forumrunner|api\.php)

Still have the problem with the base vbadvanced not working. Could use some help on that one.....
 
I don't understand why it operates on folders which do not fall under forum forum directory.
Rewrite rules cascade, i.e. any rewrites that apply to /directory1 also applies to /directory1/directory2 etc.

Still have the problem with the base vbadvanced not working. Could use some help on that one.....
Can you please explain what you mean by "not working"? Is it the same issue as the Photopost?
 
I get the same error message as in the first post, when I installed the lite version on the Advanced Tagging System on my 3.8.x board. Does the problem still exist then? I had to disable the product in order to fix the database error:

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,
 
Status
Not open for further replies.

Legacy DragonByte SEO

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
7,169
Customer rating
5.00 star(s) 1 ratings
Back
Top