Database error 1146 with Codeigniter SELECT query

Question

I have created a website using CodeIgniter. When I move my site from local server to live server and making changes to the db file accordingly, it still shows database error 1146. Here is the error:

A Database Error Occurred

Error Number: 1146

Table 'cinodext_webcm.DATA' doesn't exist

SELECT * FROM DATA WHERE TYPE = 'MOVIE' ORDER BY ID DESC

Filename: /home/cinodext/public_html/models/site_upload.php

Line Number: 70

@NULL I have checked my database and this table exists inside the database — Top Gun
– Top Gun, Commented Oct 23, 2013 at 5:16
If you move your website from Window to Linux server the table name becomes case sensitive. Please check it. — Nish
– Nish, Commented Oct 23, 2013 at 5:55

Kuf · Accepted Answer · 2013-10-23 05:33:06Z

2

Firs, check your DB setting in /applications/config/dababases.php.

Then, try to connect manually from the web server, and run the query:

mysql -h <hostname> -u <username> -p<password>
USE cinodext_webcm;
SELECT * FROM `data` WHERE `type` = 'MOVIE' ORDER BY ID DESC

This should help you understand where the error is generated from.

edited Oct 23, 2013 at 5:33

answered Oct 23, 2013 at 5:26

Kuf

17.9k7 gold badges69 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kuf Over a year ago

the space in not obligatory

Phil Over a year ago

TIL - the space is optional for usernames ;)

jmadsen · Accepted Answer · 2013-10-23 05:19:37Z

0

Check your connection user's permissions.

answered Oct 23, 2013 at 5:19

jmadsen

3,6552 gold badges37 silver badges49 bronze badges

Collectives™ on Stack Overflow

Database error 1146 with Codeigniter SELECT query

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related