SQLSTATE[42S02]: Base table or view not found: 1146 Table

1

Trying to build a customer query. Went to API. Created new. Went to Steps. Right clicked for Database Actions. Selected Database Custom Query. Tried to create a query and I got the message SQLSTATE[42S02]: Base table or view not found: 1146 Table xxx (my table name). Also tried it with a Database Query step. Same thing. Even a simple SELECT * FROM which selects a table from the list showing on the left. Tested the connection and that works. Panel on left shows all the tables with their various columns.

I already have another custom query that works fine to the same db.

Any idea where this is going wrong?

2

Do you by chance have any special characters or spaces in your table name?

3

No. The step is called qryAllCustomers, the table is called customers, and even the query SELECT * FROM customers brings back the error.

4

Do you have any connected relation tables to your customer table? A quick google search for the error (although it’s all greek to me) seems to be a problem with a related table.

5

Well, there are foreign keys to other tables, but even when I do a join to them it doesn't work. What other kinds of "related tables" could there be? Plus, everything works fine in dbForge Studio.

6

Thanks for your help brad. Figured it out. Connection issue.

7

That’s great, Rod! Glad you got it solved. Good luck with your project!