Quote:
Logician - I've recreated the webqueries as you suggested (even though they all looked like they were there anyway) and I still have the problem.
When visiting the test page I get the following error:
|
Thx for trying..
I'm not sure why this problem occurs in your server. I thought it was related to wrong entries in the webquery table but considering the fact that you created them manually now and still problem is there, this does not look like the culprit now.
I installed this hack in different servers with different configurations and vb versions, but never run into such a problem.
The weird thing is, you are having "SQL syntax error" in your webqueries however the query in the error log seems just fine.
For instance your error logs indicates an SQL syntax error in query:
[sql]
SELECT threadid, title, postusername,postuserid,dateline FROM thread WHERE sticky=0 AND visible=1 AND forumid=2 ORDER BY
dateline DESC LIMIT 10
[/sql]
But this is a perfectly ok query and you'll see that it will run ok, if for instance you run it in your phpmyadmin.
Since I can not confirm the problem in my localhost, I'm not sure how I can help you.
If you want to give it a secondshot, I'd say, delete (drop) all hack tables (wt2_templates,wt2_queries,wt2_themes,wt2_visitlog s) and recreate them (you don't need to redo other installation steps).
If this does not help, I would need admin CP/FTP/phpmyadmin access to server that is producing the error to track the problem, if you want it fixed.