cancel
Showing results for 
Search instead for 
Did you mean: 

[table] was created with a different version of MySQL and cannot be read

sofaville
Newbie
Posts: 8
Registered: ‎08-02-2014

[table] was created with a different version of MySQL and cannot be read

Hi there,
Can anyone help?
I thought the migration of my site had gone fairly smoothly - my existing code worked fine once I updated it with the new SQL database host / name / passwords etc
However I'm trying to read / insert data into a new table I've created since the migration  - I can see it in phpMyAdmin and I can successfully run the queries / inserts directly in that tool - but when I try to run exactly the same queries in my code they fail and I get the following mysqli_error:
was created with a different version of MySQL and cannot be read
All my previous tables are reading fine.
Any ideas of what I can do to fix this? I did a quick search on Google but the advice all seemed fairly technical (downgrading the database, re-instally the upgrade on the server...)
I'm an amateur coder, so any advice will have to be fairly basic!
4 REPLIES 4
Gabe
Community Veteran
Posts: 767
Registered: ‎29-10-2008

Re: [table] was created with a different version of MySQL and cannot be read

How did you create the table? phpMyAdmin?
I have to admit, for the moment I'm ignoring that tool and just using Adminer.
Gabe
sofaville
Newbie
Posts: 8
Registered: ‎08-02-2014

Re: [table] was created with a different version of MySQL and cannot be read

yes I created it in phpMyAdmin.
just tried dropping the table and rebuilding it using MySqlManager in the Control Panel - that hasn't worked either.
Maybe I'll try Adminer as you suggest.
sofaville
Newbie
Posts: 8
Registered: ‎08-02-2014

Re: [table] was created with a different version of MySQL and cannot be read

fixed it.
double-checked my host name and it was subtly different to the one in the control panel. Odd that the rest of the site was working - either way its fixed now.
bobpullen
Community Gaffer
Community Gaffer
Posts: 15,047
Thanks: 2,699
Fixes: 171
Registered: ‎04-04-2007

Re: [table] was created with a different version of MySQL and cannot be read

I've seen a few of these now.
There were a number of customers who were originally provisioned on MySQL4 database instances. This was later corrected after it was found to cause problems with the phpMyAdmin application install. In some cases it looks like the database instances were upgraded to 5 in the MySQL Manager/Control Panel however some customers' sites were left pointing at the MySQL4 instance Undecided

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵