Current time: 07-25-2014, 11:18 AM Hello There, Guest! (LoginRegister)


SQL Error: 1146 - Table 'this' doesn't exist
06-19-2009, 05:45 PM
Post: #1
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago SQL Error: 1146 - Table 'this' doesn't exist
I moved the forum to new host but it shows this error while accessing admin page -
SQL Error:
1146 - Table 'techma_techmafiasru544.mybb_users' doesn't exist
Query:
SELECT uid,username,password,salt,loginkey,remember,coppauser,usergroup FROM mybb_users WHERE username='admin' LIMIT 1


And while accessing main forum following error is showed-
SQL Error:
1146 - Table 'techma_techmafiasru544.mybb_sessions' doesn't exist
Query:
DELETE FROM mybb_sessions WHERE ip='67.222.144.44'
Find all posts by this user
06-19-2009, 05:50 PM
Post: #2
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago RE: SQL Error: 1146 - Table 'this' doesn't exist
Make sure your database details in ./inc/config.php are right, and check that the tables to actually exist in your database.

Can you still feel the butterflies?

Free never tasted like pudding.
Visit this user's website Find all posts by this user
06-19-2009, 05:58 PM
Post: #3
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago RE: SQL Error: 1146 - Table 'this' doesn't exist
The database details are correct in config.php file and I imported db backup from existing site but it don't have mybb_users table.
Find all posts by this user
06-19-2009, 06:00 PM
Post: #4
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago RE: SQL Error: 1146 - Table 'this' doesn't exist
Then it looks like your backup was incomplete, are you able to make another backup??

Can you still feel the butterflies?

Free never tasted like pudding.
Visit this user's website Find all posts by this user
06-19-2009, 06:04 PM
Post: #5
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago RE: SQL Error: 1146 - Table 'this' doesn't exist
If you still have the backup from your old host, extract from there the missing tables and import it at the db of the new host.

[Image: sig.gif]

Contact me in private only if you need paid help with mybb-related issues. Otherwise, please don''t, unless I invite you to. Thanks Smile
Find all posts by this user
06-19-2009, 07:08 PM
Post: #6
Solved: 3 Years, 9 Months, 3 Weeks, 1 Day, 21 Hours, 13 Minutes, 46 Seconds ago RE: SQL Error: 1146 - Table 'this' doesn't exist
I used a new db backup & it solved the problem.
Find all posts by this user


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | MyBB | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication