Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 8 Months, 3 Weeks ago New Host - MyBB SQL Error
#1
Solved: 8 Years, 8 Months, 3 Weeks ago Exclamation 
Hey guys,

Not sure what is causing the error because I uploaded my database via phpmyadmin and changed these settings from config.php:

$config['hostname'] = ' ';
$config['username'] = ' ';
$config['password'] = ' ';
$config['database'] = ' ';
$config['table_prefix'] = 'mybb_';


Getting this error:

SQL Error:
1146 - Table 'computer_mybb.datacache' doesn't exist
Query:
SELECT title,cache FROM datacache


Though I'm not sure if the table prefix is causing it or something else...

Cheers
#2
Solved: 8 Years, 8 Months, 3 Weeks ago
Quote:I uploaded my database via phpmyadmin and changed these settings from config.php:
[...]
$config['table_prefix'] = 'mybb_';

Do you mean you changed the table prefix or that you assigned the same prefix as in your database backup?
[retired]
#3
Solved: 8 Years, 8 Months, 3 Weeks ago
Well I tried removing the prefix line, and tried using these:

$config['table_prefix'] = 'mybb_';
$config['table_prefix'] = 'computer_';

I'm sure the database name, user and pass is correct, 100%.
#4
Solved: 8 Years, 8 Months, 3 Weeks ago
Either the table prefix is incorrect or the table doesn't exist in the database.
No longer involved in the MyBB project.
#5
Solved: 8 Years, 8 Months, 3 Weeks ago
Table mybb_datacache does excist, just checked in phpmyadmin.
#6
Solved: 8 Years, 8 Months, 3 Weeks ago
Quote:SQL Error:
1146 - Table 'computer_mybb.datacache' doesn't exist
Query:
SELECT title,cache FROM datacache

Looks like to me you have the prefix appended to the database name rather than prepended to the table name. So 'computer_mybb.datacache' should actually be, '{databasename}.mybb_{tablename}'
[retired]
#7
Solved: 8 Years, 8 Months, 3 Weeks ago
Soo how do I fix it? No idea what u mean o.0
#8
Solved: 8 Years, 8 Months, 3 Weeks ago
(2014-03-10, 03:17 PM)MikeInToshx Wrote: Soo how do I fix it? No idea what u mean o.0

this:

(2014-03-10, 03:00 PM)Nathan Malcolm Wrote: Either the table prefix is incorrect or the table doesn't exist in the database.

Make sure both are correct and your problems should go away.
[retired]
#9
Solved: 8 Years, 8 Months, 3 Weeks ago
Yeah well If only I knew WHAT to fix.. lol. Doesn't realy answer my question Sad

I have to remove the "mybb_" prefix off my database that I downloaded from my forum??
#10
Solved: 8 Years, 8 Months, 3 Weeks ago
(2014-03-10, 03:27 PM)MikeInToshx Wrote: Yeah well If only I knew WHAT to fix.. lol. Doesn't realy answer my question Sad

I have to remove the "mybb_" prefix off my database that I downloaded from my forum??

Okay let me be more plain:
  • Look at the database and see what it is named
  • Go to your configuration file and check the the name is exactly right (the prefix has nothing to do with the database name, copy it exactly)
  • Check the prefix of all the tables in your database.
  • In your configuration file, check that the prefix is exactly the same as what is prepended to your table names
[retired]
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)