Question Any way to accept legacy URLs?

[furnival]

I have installed the lite version of this on a test forum and it seems to work well. The only thing stopping me from instaling this on my live site (and buying the pro version and a branding free license) is this issue, which might be outside the realm of support but it is a setup which worked for me before with VBSEO installed....

I need to refer people directly to new posts in my forum from outside VBulletin. For reasons I won't bore you with I don't think the URL structure of the links can be changed. They are like this: http://mydomain.com/test/forum/showthread.php?p=573122#post573122

These links worked OK with VBSEO, which redirected them to the SEO-friendly URLs, but with DBSEO they give this database error:

Database error in vBulletin 4.2.2:
Invalid SQL:

        SELECT DISTINCT(post.userid), user.userid, user.username
        FROM `prefix_post` as post
        LEFT JOIN prefix_user AS user ON (user.userid = post.userid)
        WHERE post.threadid = 
        ORDER BY user.username ASC;

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 'ORDER BY user.username ASC' at line 5
Error Number  : 1064
Request Date  : Wednesday, June 4th 2014 @ 01:51:09 PM
Error Date    : Wednesday, June 4th 2014 @ 01:51:09 PM
Script        : http://mydomain.com/test/forum/showthread.php?p=573122

Is there any way to make these URLs work please?

 

[Fillip H.]

That query is not from DBSEO and not from vBulletin, so I have no idea where it's from. Can you please try disabling all other modifications and re-enable them one-by-one until you find the culprit? Once we've figured out which mod is doing this, I may be able to assist

 

[furnival]

Oh right, I see, I actually get this SQL error even with DBSEO switched off. I'm sorry for wasting your time, I just assumed it was a DBSEO issue. From what you say I presume that DBSEO can handle URLs of this type of format: http://mydomain.com/test/forum/showthread.php?p=573122#post573122

On edit: OK i see that DBSEO has functions in a file called showthread.php to get the thread ID from a GET string but for some reason in my case it's not working.

I found a plugin with a conflict, now that's disabled I don't get SQL errors any more, just "invalid thread specified" errors whether DBSEO is turned on or off.

 

[furnival]

I have fixed this now. It was not DBSEO's fault!

 

[Fillip H.]

Glad you got it working