Text only | Text with Images

TinyPortal

Development => Support => Installation => Topic started by: clothahump on April 02, 2010, 11:26:20 AM

Title: Upgrade failed.
Post by: clothahump on April 02, 2010, 11:26:20 AM
Just tried to install latest package and it has thrown an error.

QuoteYou 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 irxj_tp_articles AS art
LEFT' at line 2
File: /home2/ciderpress/public_html/Sources/TPortal.php
Line: 2115

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.
Title: Re: Upgrade failed.
Post by: Skhilled on April 02, 2010, 11:47:23 AM
To upgrade your database, upload the upgrade.php and .sql files from the smf 1.1.11 zip to the root forum directory. Then run hxxxp://www.yoursite.com/upgrade.php.

This will upgrade the database but not the files, since they are already upgraded. This may or may not fix the db issue you are having but should help your site anyways. :)
Title: Re: Upgrade failed.
Post by: clothahump on April 02, 2010, 11:52:23 AM
I would if I could find it in the package, still searching.

No upgrade for 1.1.11 in the package.
Title: Re: Upgrade failed.
Post by: Skhilled on April 02, 2010, 11:53:45 AM
Download SMF 1.1.11. Open the zip and you'll find the upgrade files in there...in the root directory of the zip. ;)
Title: Re: Upgrade failed.
Post by: clothahump on April 02, 2010, 11:57:33 AM
Not in the copy I downloaded yesterday, no upgrade and no sql.
Title: Re: Upgrade failed.
Post by: Skhilled on April 02, 2010, 11:58:41 AM
Sorry, should have said download the large upgrade package:

http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-11_upgrade.zip
Title: Re: Upgrade failed.
Post by: clothahump on April 02, 2010, 12:07:42 PM
That would explain why I was unable to find it, downloading now.
Title: Re: Upgrade failed.
Post by: Skhilled on April 02, 2010, 12:11:16 PM
Sorry about that. Just got in from work awhile ago and getting settled. :P
Title: Re: Upgrade failed.
Post by: clothahump on April 02, 2010, 12:21:35 PM
Updating and creating indexes... Unsuccessful!
This query:

    ALTER TABLE irxj_smileys
    ORDER BY LENGTH(code) DESC;

Caused the 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 'LENGTH(code) DESC' at line 2
Title: Re: Upgrade failed.
Post by: Skhilled on April 02, 2010, 12:34:06 PM
That is a common upgrade issue when upgrading from previous versions of SMF. I wish they'd fix it... Please read this:

http://docs.simplemachines.org/index.php?topic=1079.0
Title: Re: Upgrade failed.
Post by: clothahump on April 09, 2010, 09:14:33 AM
Fatal error: Call to undefined function tp_loadtheme() in /home2/ciderpress/public_html/Sources/Load.php  on line 1165
Title: Re: Upgrade failed.
Post by: G6Cad on April 09, 2010, 09:26:41 AM
do you have the same error in the default curve theme ?
Title: Re: Upgrade failed.
Post by: clothahump on April 09, 2010, 11:22:01 AM
Unable to login let alone change the theme?
Title: Re: Upgrade failed.
Post by: IchBin on April 09, 2010, 02:42:48 PM
Sounds like you need to go through the install manually if that is the case. Upload all files, edit the SMF files that TP requires, and then run the tpinstall.php file.
Text only | Text with Images