[Intex]

Logician

OK, I've installed the hack. Templates created and the SQL queries had run successfully:

>>

Your SQL-query has been executed successfully :
The content of your file has been inserted. (23 Instructions)

<<


After installation I run the http://mysite/forum/admin/webtemplate.php and this works fine and displays the admin panel. Then I run into some different problems:


Your Custom Pages

Selecting 'Visit' for the 'Test' page produces the following error which is duplicated what looks like hundreds of times down the page:

SELECT count(*) as count FROM user mysql error: You have an error in your SQL syntax near ' SELECT count(*) as count FROM user

Default WebTemplates

1. Selecting 'visit' for the 'invalid_pg' page displays but all the images do not relate to the right style, despite all the correct templates being in the correct style. The colours however for the style are correct (background etc.).
   
2. Selecting 'visit' for the 'phptest [Private]' page produces the following error
   
   

   Warning: Wrong datatype for second argument in call to in_array in c:\program files\apache group\apache\htdocs\forum\view.php on line 93

3. Selecting 'visit' for the 'priv_privatemessages [Private] [Draft]' page produces the following error:
   
   

   SELECT dateline,privatemessageid, fromuserid, touserid, title, message, touser.username 
   AS tousername, fromuser.username AS fromusername FROM privatemessage LEFT JOIN user AS touser ON
   (touser.userid=privatemessage.touserid) LEFT JOIN user AS fromuser ON (fromuser.userid=privatemessage.fromuserid) 
   WHERE folderid='0' ORDER BY privatemessageid DESC LIMIT 30 mysql error: You have an error in your SQL syntax near ' SELECT 
   dateline,privatemessagei' at line 1 mysql error number: 1064 Date: Monday 30th of June 2003 10:19:29 PM Script: http://<br />
   <a href="http://test..../test.com/</a>forum/forum/view.php?pg=priv_privatemessages Referer: http://<br />
   <a href="http://test....plate.php?</a> -->

   Note the double 'forum' path as highlighted in yellow above.
   
4. Selecting 'visit' for the 'webqueryhelp [Draft]' page displays everything perfectly including my style header and footer.
   
5. Selecting 'visit' for the 'webtemplateshelp [Draft]' page displays everything perfectly including my style header and footer.
   
6. Selecting 'visit' for the 'webtemplates_variables [Draft]' page displays everything perfectly including my style header and footer.

It looks likes there is a problem with whenever it wants to access database information as the other pages are just general pages and don't have any queries.

The double forum/forum path is weird for starters and the one issue with display the incorrect footer / header for one of the pages (could this be using the footer and header in your templates that I see on the Admin page?).

Anyway, any ideas .