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:
Is there any way to make these URLs work please?
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:
Code:
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=573122Is there any way to make these URLs work please?
