CODEWITHSUNDEEP
phpcakephp
ahsan-ali
ahsan-ali

Reputation: 133

SQLSTATE[42S02]: Base table or view not found in cakephp

I am using CakePHP 2.3.6. Everything works fine on localhost, but when I upload to the server, the custom query in the controller's function throws an error saying "table not found". However, the table does exist.

The database is created in such a manner that I don't have any other way than using a custom query. Any help appreciated.

Database Error

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kidzo_v3.Children' doesn't exist

Query:

Insert into Children(Birthdate,Gender,User_id) 
values('1997-11-16','male','14121');

Upvotes: 1

Views: 3644

Answers (1)

ahsan-ali
ahsan-ali

Reputation: 133

Turns out the problem was I used an upper case name in the custom query :(

Upvotes: 1

Related Questions