Problem with TP settings

[warhonowicz]

I have just created a blank SMF install (1.1RC3) and then installed TP 0.95 on top. The installation went okay, but when from the Admin menu I click on TP - Settings I get the following error message:

Code Select Expand


You have an error in your SQL syntax near '(testsite_themes AS tb) ON th.ID_THEME = tb.ID_THEME
WHE' at line 4
File: /home/m/m/mmc/public_html/testsite/Sources/TPortalAdmin.php
Line: 1229


[G6Cad]

How did you install TP ?  Manuall or through the package manager?

[warhonowicz]

through the package manager

I have also tested this with the default or the Babylon theme, same result

[G6Cad]

Can you try upload the manual install files through FTP and then run the manual_tp_install.php and see if that will fix the DB issue there
You fint the manuall install package in the download section
Extract the files, and upload and overwrite the file you have, then point your browser to manual_tp_install.php

[warhonowicz]

no error message during the install, but the same when I try to get to the settings

[IchBin]

Try uploading a new TPortalAdmin.php file and see if that fixes it.

[warhonowicz]

Nope, doesn't make any difference

[warhonowicz]

I get the same error when I try to add a new article, however adding categories works fine.

[eeek]

I got the same error but not decided what it is yet...

Something to do with adding your installed themes in to the tp theme changer, I just commented out the complete bit till I have time to look. 

It worked fine on my test server but not on my main one. The obvious difference is test server = mysql 5.new, main server = mysql 3.ancient and I did wonder if it was something to do with the JOIN

[warhonowicz]

It worked fine on my test server but not on my main one. The obvious difference is test server = mysql 5.new, main server = mysql 3.ancient and I did wonder if it was something to do with the JOIN

I actually use the same server, just a different directory, but I'll try playing around with the theme changer.