Skip to main content
C
clarkdocs
Participant
December 14, 2009
Question

Table doesn't exist

  • December 14, 2009
  • 2 replies
  • 928 views

CS3 on a Macbook Pro

MAMP

SQL database with 15 fields and 124 records that was imported from a csv

I have connected my database to dreamweaver successfully, but when i right click on the table of the database to view data, it produces an error stating the the table doesn't exist.  It does.  I can view the table through phpmyadmin and there are 124 records.

I created a test table within the same data base and filled it with data, and I was able to see the data in Dreamweaver.  I don't know why one table will 'exist' and the other one 'doesn't exist.'

thank you.

This topic has been closed for replies.

2 replies

David_Powers
David_Powers
Inspiring
December 16, 2009

Marking this thread as assumed answered.

David_Powers
David_Powers
Inspiring
December 15, 2009

Thread moved to the Dreamweaver Application Development forum, which deals with PHP/MySQL and other server-side issues.

It's difficult to say why a table is not recognized. One possibility is that you have used an illegal character in the table name. Hyphens and spaces, for example, are not valid in database identifiers (such as table and column names). phpMyAdmin and Dreamweaver normally get around this by enclosing MySQL identfiers in backticks. However, it's better not to use invalid characters in the first place.

C
clarkdocsAuthor
Participant
December 15, 2009

New information...

I removed some spaces and the figure # from my table and column names, and now my error has advanced from "Table doesn't exist' to "An unidentified error occured"  The table and the column names appear in the DW database window, but when I right click to view data, the unidentified error pops up.  Love the vagueness of that one.

David_Powers
David_Powers
Inspiring
December 16, 2009

Newer information.

If i empty the table of its original information (which was imported as a csv) and put in dummy information using the phpmyadmin interface, that data shows up.  so the problem has to be in the way MAMP is treating my csv upon import.  right?  so this is not a dreamweaver problem.  still need help though...

thanks


clarkdocs wrote:

so the problem has to be in the way MAMP is treating my csv upon import.  right?

Not necessarily. It could be a problem with the way the csv is formatted, or with the options you have chosen when importing it through phpMyAdmin. Without knowing what your CSV looks like, it's purely guesswork.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices