CODEWITHSUNDEEP
phpmysqlcodeigniter
Top Gun
Top Gun

Reputation: 688

Database Error with Codeigniter Project

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 a 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

Any Help???

Upvotes: 0

Views: 1166

Answers (2)

Kuf
Kuf

Reputation: 17846

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.

Upvotes: 2

jmadsen
jmadsen

Reputation: 3675

Check your connection user's permissions.

Upvotes: 0

Related Questions