Text only | Text with Images

TinyPortal

Development => Support => Installation => Topic started by: theauctionboard on April 02, 2010, 01:21:26 AM

Title: Issue with B5
Post by: theauctionboard on April 02, 2010, 01:21:26 AM
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

:'(
Title: Re: Issue with B5
Post by: Xarcell on April 02, 2010, 03:39:03 AM
Can we get some more information. What version of SMF, was it a TP upgrade, or a fresh install?
Title: Re: Issue with B5
Post by: theauctionboard on April 02, 2010, 11:28:29 AM
Hi,

     Beta 5 and SMF 1.1

     This is an upgrade
Title: Re: Issue with B5
Post by: ZarPrime on April 02, 2010, 02:09:15 PM
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 (http://www.tinyportal.net/index.php/topic,581), 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
Title: Re: Issue with B5
Post by: theauctionboard on April 02, 2010, 03:19:53 PM
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
Title: Re: Issue with B5
Post by: Xarcell on April 02, 2010, 04:46:33 PM
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?
Title: Re: Issue with B5
Post by: theauctionboard on April 02, 2010, 09:34:27 PM
Yes,

    Beta 4 is all I have ever installed before Beta 5
Title: Re: Issue with B5
Post by: Xarcell on April 03, 2010, 12:56:20 AM
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.
Title: Re: Issue with B5
Post by: theauctionboard on April 03, 2010, 01:01:18 AM
Hello,

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

Thanks for your help
Title: Re: Issue with B5
Post by: Cykasm on May 12, 2010, 10:17:52 AM
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
Text only | Text with Images