Hi, I recetly moved my website and forum from one hosting service to a new one, and I imported my old database. I was forced to change DB username (from xxxx_frm to xx_frm), and now i get this king of error:
now, i understand the problem is the name of the table he keeps looking for, he tries to load the old database table, but what should I do to solve the problem?
Thanks a lot
Code:
Invalid SQL: SELECT ap.*,p.caption FROM vb3_albumpicture ap LEFT JOIN vb3_picture p on p.pictureid=ap.pictureid WHERE state = 'visible' AND albumid = '13'; MySQL Error : Table 'xxxx_frm.vb3_albumpicture' doesn't exist
Thanks a lot
Comment