MyBB Community Forums

MySQL error: 1054
Unknown column 'u.nameformat' in 'field list'
Query: SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup, u.nameformat FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1218074677' ORDER BY u.username ASC, s.time DESC

I guess that happened after I updated MyPlaza plugin

---

portal works fine and all links to all posts, but when I click on index.php I get this error

board is here: http://www.vitz-omsk.com

---

board version - 1.2.10

Upgrade to 1.4. I think you upgraded your plugin to 1.4 format.

http://dev.mysql.com/doc/refman/5.0/en/c...tates.html

Look on that list it shows all mysql errors. It looks like you need to fix your tables.

If your running on cpanel go

Cpanel > Mysql Databases > Fix Tables
Cpanel > Mysql Databases > Repair Tables

do that and the error should go and try optimising your tables in the Admin CP

there's no CPanel on my hosting there's different custom panel made by hoster & no fix table function

---

looks like the only way is to restore backup

Hmmm normally a custom one had the function. Look in your database info bit

You can repair and optimize tables in phpMyAdmin. If your host doesn't supply it , you can download it yourself from www.phpmyadmin.net

My host supplys phpMyAdmin but I couldn't find there somthing like "fix tables"

Try this: http://paulstamatiou.com/2006/05/31/how-...phpmyadmin

The problem was in Myplaza plugin, deactivating that plugin caused error, I just erased all tables that has records about plaza, that's it