Print Page - [bugtracker] Database Error when adding Category Bloc

Title: [bugtracker] Database Error when adding Category Bloc
Post by: Greyhound on April 12, 2010, 04:36:01 PM

New install of SMF and just added TP 1.0 Beta 5-1. I added a category block for the front page and got this error:

Database 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 '(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT JOIN s' at line 2
File: /mywebsite.com/Sources/TPortal.php
Line: 2153

Now I'm totally locked out of my site. The only mod installed other than TP is who's online today.

Title: Re: [bugtracker] Database Error when adding Category Bloc
Post by: IchBin on April 12, 2010, 05:10:20 PM

We'd appreciate it if you wouldn't post support in the bug tracker. Generally you post what you think is a bug in the board, then if it's a bug then we'll have you put something in the bug tracker. If you're site is buggered up, then you should restore to the backup you made before making changes to your site. Assuming you can't hit your admin center directly. index.php?action=admin

Title: Re: [bugtracker] Database Error when adding Category Bloc
Post by: IchBin on April 13, 2010, 05:11:28 PM

Indeed a bug. Fix posted at the end of this topic.
http://www.tinyportal.net/index.php?topic=32376.10

Title: Re: [bugtracker] Database Error when adding Category Bloc
Post by: IchBin on April 15, 2010, 08:09:23 PM

Additionally, the same problem exists on line 1841 of TPortal.php.

Title: Re: [bugtracker] Database Error when adding Category Bloc
Post by: bloc on April 21, 2010, 06:51:08 PM

Fixed on both places for TP v1.0 beta5.2

TinyPortal

Development => Feedback => Bugs/Errors => Topic started by: Greyhound on April 12, 2010, 04:36:01 PM