• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[solved]database error after loaded to shared server


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?

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.