MyBB Community Forums
MyBB SQL Error after importing - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: MyBB SQL Error after importing (/thread-83964.html)



MyBB SQL Error after importing - sh4nks. - 12-11-2010

Hey Wink

i have a problem after importing these tables:
board_forumpermissions
board_forums
board_forumsread
board_forumsubscriptions
board_posts
board_threads
board_threadsread
board_threadsubscriptions
board_threadviews
board_users
board_usertitles


If i want to change something in Settings (User CP)
i get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'commentnotify' in 'field list'
Query:
    UPDATE board_users SET `commentnotify`='', `commentsfilter`='0' WHERE uid = 1 LIMIT 1 

i reloaded the cache...

thanks for help Smile

cheers Wink


RE: MyBB SQL Error after importing - Matt - 12-11-2010

A plugin is trying to use that column but it doesn't exist.


RE: MyBB SQL Error after importing - sh4nks. - 12-11-2010

i re-installed Profile-Comments and now it works Smile

thanks so much Wink

cheers