Print Page - Database error after upgrade.

Title: Database error after upgrade.
Post by: Teebags on May 29, 2010, 04:28:04 PM

Just upgraded from 0.9.8 to 1.0 B5-1 and I'm now getting the following:

QuoteDatabase 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/xim/public_html/Sources/TPortal.php
Line: 2153

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.4. The above error might possibly go away if you execute the latest version of upgrade.php.

Any ideas? I'm a bit stumped.

Tried repairing the table in phpMyAdmin but it didn't find any errors.

Title: Re: Database error after upgrade.
Post by: Teebags on May 29, 2010, 04:36:09 PM

Found this, it worked...

http://www.tinyportal.net/index.php?topic=32376.msg260521#msg260521

Title: Re: Database error after upgrade.
Post by: IchBin on May 29, 2010, 08:02:56 PM

Sweet. I love it when people use the search! :)

TinyPortal

Development => Support => Topic started by: Teebags on May 29, 2010, 04:28:04 PM