magento管理员错误：SQLSTATE [42S02]：找不到基表或视图：1146表'sinergi_luki.captcha_log'不存在

Question

i have a problem with my admin page. after i login to admin, suddenly it show an error message..

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sinergi_luki.captcha_log' doesn't exist

is it because i migrate my magento 1.5.0.1 to a new server but in a new server i install magento 1.7.0.0..? or why? give me a solution guys. Thanks!

Answer 1

Sadly, there's no magic answer for you other than: Next time migrate Magento correctly.

The system on your new server has code that references a custom database table, sinergi_luki. This table did not make the trip over to your new server from the old. It's also not a part of the base magento installation. The word sinergi is, according to Google translate, Indonesian for synergies, and Luki appears to be an Indonesian name, so my guess is the previous developer built some custom functionality without including database migrations.

You should find the old database, export this table, and pull it back into your new system. Outside of that you're SOL.

Good luck.