overlordofevil Posted April 3, 2008 Share Posted April 3, 2008 I am writing a php interface for a mysql db. I added some tables to the db and for some reason when i try to access them i get the Table 'tablename' doesn't exist message. I am not sure what to check but i know the table is loaded and it shows up in the console and when i use phpmyadmin. I am able to run any query for other tables I originally put in the db with but the new tables i just added i get the error. any suggestions on what to check. Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/ Share on other sites More sharing options...
overlordofevil Posted April 3, 2008 Author Share Posted April 3, 2008 Server version: 5.0.45 Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/#findComment-508656 Share on other sites More sharing options...
fenway Posted April 3, 2008 Share Posted April 3, 2008 Are you sure you've selected the right DB? Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/#findComment-508671 Share on other sites More sharing options...
overlordofevil Posted April 3, 2008 Author Share Posted April 3, 2008 yep I made sure it is going to the correct DB. that was the first thing I checked in my code. The exact errors I am getting are Table 'nerodb2.skill_info' doesn't exist Table 'nerodb2.classinfo' doesn't exist Table 'nerodb2.race_info' doesn't exist now if I avoid trying to connect to this tables everything works fine so I think it may have something to do with PHP scripts but i wanted to check with the mysql group to see if you guys have come across this issue. thanks Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/#findComment-508692 Share on other sites More sharing options...
fenway Posted April 3, 2008 Share Posted April 3, 2008 Have you issued a CHECK TABLES? Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/#findComment-508729 Share on other sites More sharing options...
overlordofevil Posted April 3, 2008 Author Share Posted April 3, 2008 yeah i did that... I found the problem... you were right I had it pointed to the wrong db... I had it trying to pull the info from the live server not the test server... This issue is solved. thanks for the help. Link to comment https://forums.phpfreaks.com/topic/99403-solved-table-tablename-doesnt-exist/#findComment-508738 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.