Table doesn't exist

[clarkdocs]

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.

[David_Powers]

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.

[clarkdocs]

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.

[clarkdocs]

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

[David_Powers]

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.

[clarkdocs]

thank you david for your guidance.  i solved this problem just a few minutes ago.  i was taking data from an excel spreadsheet, copying the csv data and pasting it into a text document and then changing the extension from .txt to .csv.  this was a necessary workaround because of a problem with the original database.  i found a way to generate the csv data directly from the original database and that solved it.

i now have a problem and i've started another thread... i have 104 records in my table and view data in DW only shows 100. 

thanks for your time.

kevin

[David_Powers]

Marking this thread as assumed answered.