Text only | Text with Images

TinyPortal

Development => Support => Installation => Topic started by: mkabwilliams on September 14, 2006, 11:52:08 PM

Title: getting error on clean install when going to settings
Post by: mkabwilliams on September 14, 2006, 11:52:08 PM
I get this error when i try to go to tiny portal settings under the admin.

You have an error in your SQL syntax near '(smf_themes AS tb) ON th.ID_THEME = tb.ID_THEME
WHERE th' at line 4
File: /var/www/vhosts/atomicninjamonkey.com/httpdocs/Sources/TPortalAdmin.php
Line: 1229
Title: Re: getting error on clean install when going to settings
Post by: G6Cad on September 15, 2006, 12:18:07 AM
Did you do the install from the Default SMF theme and no other NON TP valid themes installed?

Usually that error comes when you have another NON tp enabled theme installed to your forum and didnt have the SMF Default theme set as forum Default
Title: Re: getting error on clean install when going to settings
Post by: mkabwilliams on September 18, 2006, 01:52:09 AM
I have not installed any other themes and this is the error I'm getting when trying to uninstall TP
3.     Execute Modification     ./Themes/default/index.template.php     Test failed
Title: Re: getting error on clean install when going to settings
Post by: IchBin on September 18, 2006, 03:00:18 AM
And that would probably be because you have other mods installed that have altered the code that TP is looking for, or you have altered the code yourself.
Title: Re: getting error on clean install when going to settings
Post by: G6Cad on September 18, 2006, 08:24:26 AM
This errors is DB related, and some changes in the code are needed.
eeek have found a solution for it, and read this thread and follow what he say and you will have a working forum :)
http://www.tinyportal.net/smf/index.php?topic=8411.msg68942#msg68942
Title: Re: getting error on clean install when going to settings
Post by: mkabwilliams on September 18, 2006, 09:30:24 PM
I'm not understanding the fix there. I've done a clean install of everything with just SMF and TP no other mods. and when I try to edit the front page posting I get

You have an error in your SQL syntax near '(smf_themes AS tb) ON th.ID_THEME = tb.ID_THEME
WHERE th' at line 4
File: /var/www/vhosts/tribalthieves.com/httpdocs/Sources/TPortalAdmin.php
Line: 1229
Title: Re: getting error on clean install when going to settings
Post by: G6Cad on September 18, 2006, 09:33:37 PM
Yes, and the link i gave to you are the solution for that error posted by eeek.

Follow the thread and you know what to fix and where, and if you still dont know what to do, i suggest you post there and wait for eeek or some one to help you out with a better explanation :)
Title: Re: getting error on clean install when going to settings
Post by: feline on September 18, 2006, 09:52:02 PM
no other explain .. there is a typos, that not work with mysql 3.xx.
remove the parenthesis at the FROM and LEFT JOIN statement and it's work ...

Fel
Title: Re: getting error on clean install when going to settings
Post by: mkabwilliams on September 19, 2006, 06:10:38 AM
Thanks for the help got it working. Now is there a doc or something that would point out what to do when I get other mods installed to make sure they show up on all my themes?
Title: Re: getting error on clean install when going to settings
Post by: IchBin on September 19, 2006, 05:14:53 PM
Theres is no doc but what is given in the mods themselves. You have to open the mod and look for the .xml or .mod file that tells you what needs to be added to your theme.
Text only | Text with Images