TinyPortal

Development => Support => Topic started by: Misaki21 on May 06, 2011, 03:25:48 AM

Title: problem with my frontpage
Post by: Misaki21 on May 06, 2011, 03:25:48 AM
Hello, today I was editing the appearance of blocks from the menu of tiny portal and suddenly start to tighten, I appeared the following 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 date DESC
LIMIT 200 'at line 5
File: / data/multiserv/users/569086/projects/1403702/www/Sources/TPortal.php
Line: 1520

Please help >. <

I have a forum with SMF 2.0 RC5
TinyPortal 1.0 RC1, I have installed the theme x-mas of DzinerStudio
My Website: http://raijuu-no-phoenix.com.nu/index.php
Language: spanish
Title: Re: problem with my frontpage
Post by: IchBin on May 06, 2011, 02:47:02 PM
Can you attach your TPortal.php file please?
Title: Re: problem with my frontpage
Post by: Misaki21 on May 06, 2011, 05:24:29 PM
tell me how to do that, please I'm really newbie in this  :( , I would greatly appreciate
Title: Re: problem with my frontpage
Post by: IchBin on May 06, 2011, 05:42:18 PM
You download the file from your server, then when you post your next reply here you click the "Additional Options" link on the reply page and click the button to attach the file.
Title: Re: problem with my frontpage
Post by: Misaki21 on May 06, 2011, 09:54:39 PM
Here is the file you asked me
Title: Re: problem with my frontpage
Post by: IchBin on May 07, 2011, 12:05:46 AM
Hmm.. I don't see a problem with the code. What are your frontpage settings in Admin > TinyPortal > Settings?
Title: Re: problem with my frontpage
Post by: Misaki21 on May 07, 2011, 04:07:45 AM
This is a snapshot of the data you asked me
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg804.imageshack.us%2Fimg804%2F365%2Fnombrez.jpg&hash=a4490f891a8039a0941470ed78d462490c4c2209)
Title: Re: problem with my frontpage
Post by: IchBin on May 07, 2011, 04:33:57 AM
Those are the general settings which I'm glad you posted :)  but you need to click the link for frontpage in the left menu and show a screen shot of that page.
Title: Re: problem with my frontpage
Post by: Misaki21 on May 07, 2011, 04:46:18 AM
I did not know which of the two was, so you take a snapshot at two

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg31.imageshack.us%2Fimg31%2F4793%2Fdasi.jpg&hash=f431b72c09e4ec291bd9a4c83b97d349093654dd)

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg718.imageshack.us%2Fimg718%2F9782%2F35615463.jpg&hash=16aabaf515980c3f6196b274f234a3f182ee8eda)

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg576.imageshack.us%2Fimg576%2F2738%2Fasct.jpg&hash=190216cdfe2bd371c36db83c9c31c6f75acfd7dd)

(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg804.imageshack.us%2Fimg804%2F6926%2Faddx.jpg&hash=9b676bd081f1df01cd158b186f09c741305aad42)

Title: Re: problem with my frontpage
Post by: IchBin on May 07, 2011, 09:55:14 PM
Thank you. I am not seeing the problem.

Do you still get an error if you change from "Articles and Forum Posts" to "Only Articles"?

How about if you set it to "Only forum posts" ?
Title: Re: problem with my frontpage
Post by: Misaki21 on May 08, 2011, 10:29:08 PM
Thank you very much, choosing the option "Only Articles" is under  :)