Issue with B5

[theauctionboard]

Hi,

    This is not an April fools joke.  I used the new package and now I receive this 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 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/theaucti/public_html/Sources/TPortal.php
Line: 2115

[Xarcell]

Can we get some more information. What version of SMF, was it a TP upgrade, or a fresh install?

[theauctionboard]

Hi,

     Beta 5 and SMF 1.1

     This is an upgrade

[ZarPrime]

Hello theauctionboard,

Welcome to TinyPortal.

In the future, when posting for Support here, could you please get into the habit of including the information in the posting template at the bottom of our Posting Guidelines, so that it will be easier for us to provide the information that you need.

For now, let me ask you this.  Assuming you are staying with SMF 1.1.11 and upgrading to TinyPortal 1.0 beta 5, I must ask you this question.  What version of TinyPortal are you upgrading "from"?  If the answer to this is "TinyPortal version 0.98", then you must first uninstall TP before performing the upgrade.

ZarPrime

[theauctionboard]

Link to my site: http://www.theauctionboard.com
SMF version: SMF ver. 1.1.11
TP version: TP ver. BETA 4 just installed less than a month ago/no other verions ever installed/new site
Theme name and version: SM Stock Themes
Browser Name and Version: IE 8
Mods installed: Lost list with site issue
Related Error messages: 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 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/theaucti/public_html/Sources/TPortal.php
Line: 2115

[Xarcell]

I hoped you back-up your site.

Looks like you may have had some issues upgrading.

Did you uninstalled TP Beta 4 before installed TP Beta 5?

[theauctionboard]

Yes,

    Beta 4 is all I have ever installed before Beta 5

[Xarcell]

I don't what to tell you. Obviously it's an issue from upgrading. But usually i only see that error if a person didn't UNINSTALL the previous version of TP first, before in installing the new version.

[theauctionboard]

Hello,

    The issue is fixed for now, we used our daily backup from the server and lost minimal data.

Thanks for your help

[Cykasm]

I'm getting the same issue, didn't upgrade as it was a fresh install

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 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2

Only happens when I set show articles from a categorie, I can show one article but not all.

TinyPortal 1.0 beta 5-1 - SMF 1.1.11