TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

Members
  • Total Members: 3,963
  • Latest: BiZaJe
Stats
  • Total Posts: 195,911
  • Total Topics: 21,307
  • Online today: 871
  • Online ever: 8,223 (February 19, 2025, 04:35:35 AM)
Users Online
  • Users: 0
  • Guests: 518
  • Total: 518

Database error after upgrade.

Started by Teebags, May 29, 2010, 04:28:04 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Teebags

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.


IchBin

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

This website is proudly hosted on Crocweb Cloud Website Hosting.