shocker-z Posted April 12, 2007 Share Posted April 12, 2007 I keep getting this error in MYSQLcc.. i had it before on my database called pronet so i created a new one called pronet2 and now that has the same issue and wont let me insert, modify or delete rows using MYSQLcc. Any ideas on what causes this? Regards Liam Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/ Share on other sites More sharing options...
fenway Posted April 12, 2007 Share Posted April 12, 2007 Not sure what you mean by a "new one", you mean new connection? Also, this software has been and still is very buggy, and very old. Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/#findComment-227969 Share on other sites More sharing options...
AndyB Posted April 13, 2007 Share Posted April 13, 2007 http://dev.mysql.com/doc/refman/5.0/en/identifiers.html Identifiers may begin with a digit but unless quoted may not consist solely of digits. I'd suggest avoiding giving a table a name that's a single digit. Name it table_1 if you really want to (but why not call it something meaningful?). Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/#findComment-228089 Share on other sites More sharing options...
bubblegum.anarchy Posted April 13, 2007 Share Posted April 13, 2007 Get the community version of SQLyog. Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/#findComment-228127 Share on other sites More sharing options...
bubblegum.anarchy Posted April 13, 2007 Share Posted April 13, 2007 You have an ERROR 1146: Table 'pronet2.1' doesn't exist and a table named pronet2 - update your query so that the table you reference is pronet2 rather than pronet2.1 Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/#findComment-228129 Share on other sites More sharing options...
shocker-z Posted April 13, 2007 Author Share Posted April 13, 2007 Sorry i should have explained.. My database is called Pronet2 and tables users and signatures. I found the problem and that is what fenway said it is issue with mysqlcc Link to comment https://forums.phpfreaks.com/topic/46747-localhost-error-1146-table-pronet21-doesnt-exist/#findComment-228312 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.