MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1146 - Table 'craizer_mybb.mybb_datacache' doesn't exist
Query:
SELECT title,cache FROM mybb_datacache
Please contact the MyBB Group for support.
please can someone tell me how to fix this?
i cant access anything on my forum.
this happened after i dropped the old database and uploaded a backup sql file.
Looks like you're backup is not ok, or you made a mistake while restoring it.
What tables do you find now in you're "new" database ?
well, there are quite a few tables:
mybb_db1adminlog
mybb_db1adminoptions
mybb_db1adminsessions
mybb_db1adminviews
mybb_db1announcements
mybb_db1attachments
mybb_db1attachtypes
mybb_db1awaitingactivation
mybb_db1badwords
mybb_db1banfilters
mybb_db1banned
mybb_db1calendarpermissions
mybb_db1calendars
mybb_db1captcha
mybb_db1datacache
mybb_db1events
mybb_db1forumpermissions
mybb_db1forums
mybb_db1forumsread
mybb_db1forumsubscriptions
mybb_db1games
mybb_db1games_categories
mybb_db1games_champions
mybb_db1games_favourites
mybb_db1games_rating
mybb_db1games_scores
mybb_db1games_sessions
mybb_db1games_settings
mybb_db1games_settings_groups
mybb_db1games_templates
mybb_db1games_themes
mybb_db1games_tournaments
mybb_db1groupleaders
mybb_db1helpdocs
mybb_db1helpsections
mybb_db1icons
mybb_db1ipn
mybb_db1joinrequests
mybb_db1mailerrors
mybb_db1maillogs
mybb_db1mailqueue
mybb_db1massemails
mybb_db1moderatorlog
mybb_db1moderators
mybb_db1modtools
mybb_db1myawards
mybb_db1myawards_users
mybb_db1mycode
mybb_db1pages
mybb_db1polls
mybb_db1pollvotes
mybb_db1posts
mybb_db1privatemessages
mybb_db1profilefields
mybb_db1promotionlogs
mybb_db1promotions
mybb_db1reportedposts
mybb_db1reputation
mybb_db1searchlog
mybb_db1sessions
mybb_db1settinggroups
mybb_db1settings
mybb_db1smilies
mybb_db1spiders
mybb_db1stats
mybb_db1tasklog
mybb_db1tasks
mybb_db1templategroups
mybb_db1templates
mybb_db1templatesets
mybb_db1themes
mybb_db1themestylesheets
mybb_db1threadratings
mybb_db1threads
mybb_db1threadsread
mybb_db1threadsubscriptions
mybb_db1threadviews
mybb_db1upgrade_data
mybb_db1userfields
mybb_db1usergroups
mybb_db1users
mybb_db1usertitles
mybb_db1warninglevels
mybb_db1warnings
mybb_db1warningtypes
i havent uploaded any of the plugins yet though.
does this matter?
i think i know what the error is, but i dont know how to fix it.
on my new site, the database is craizer_mybb or whatever, but my old site, the sql database is a3594811_craizer
All your tables are misnamed. The db1 stuff isn't supposed to be there.
Looks like the database itself is fine then, open ./inc/config.php and make sure all the details are correct, change them to match whatever they need to be.
ok then, i will try that, thanks again Matt
I also have this problem.How can I fix the problem?
I checked config.php and all off details are correct.
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1146 - Table 'mybbaz_belayiz.mybb_datacache' doesn't exist
Query:
SELECT title,cache FROM mybb_datacache
And does it actually exist in the database?? If it does, double check your database settings in config.php, if it's in the actual database there must be something wrong there.