+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: [solved]database error after loaded to shared server (/showthread.php?tid=48210)
[solved]database error after loaded to shared server - El Forum - 01-08-2012
[eluser]tuckee[/eluser]
Hi,
To load my front page, I have to go through the database retrieve information and load it to front page.
I got the following error as below:
A Database Error Occurred
Error Number: 1146
Table 'picknsha_sponsorsys.Advertisement' doesn't exist
SELECT * FROM Advertisement WHERE ads_status=1 ORDER BY ads_name limit 3
is quite obvious why the error occur, is because table 'picknsha_sponsorsys.advertisement' doesn't exist. The proper table should just be table 'advertisement'.
'picknsha_sponsorsys' is the name of my database.
my question is why would the system put the database name before the table name 'advertisement'
if i were to run on local machine, i do not have this problem.
do u have any idea how can i solve this problem?