Magento Forum

   
admin page in my magento is error, why? 
 
wasis
Member
 
Total Posts:  44
Joined:  2012-04-16
 

hi guys, 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!

 
Magento Community Magento Community
Magento Community
Magento Community
 
connor2k
Jr. Member
 
Total Posts:  14
Joined:  2008-08-06
 

I am having the exact same problem. Any solutions yet?

 
Magento Community Magento Community
Magento Community
Magento Community
 
furnitureforyoultd
Enthusiast
 
Total Posts:  833
Joined:  2009-03-09
 

CREATE TABLE `captcha_log` (
    `
typeVARCHAR(32NOT NULL COMMENT 'Type',
    `
valueVARCHAR(32NOT NULL COMMENT 'Value',
    `
countINT(10UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Count',
    `
updated_atTIMESTAMP NULL DEFAULT NULL COMMENT 'Update Time',
    
PRIMARY KEY (`type`, `value`)
)
COMMENT='Count Login Attempts'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

 
Magento Community Magento Community
Magento Community
Magento Community
 
Quaeso
Guru
 
Avatar
Total Posts:  334
Joined:  2010-04-03
 
furnitureforyoultd - 29 May 2012 08:25 AM

CREATE TABLE `captcha_log` (
    `
typeVARCHAR(32NOT NULL COMMENT 'Type',
    `
valueVARCHAR(32NOT NULL COMMENT 'Value',
    `
countINT(10UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Count',
    `
updated_atTIMESTAMP NULL DEFAULT NULL COMMENT 'Update Time',
    
PRIMARY KEY (`type`, `value`)
)
COMMENT='Count Login Attempts'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

Hi furnitureforyoultd,

where must I insert this Code? in phpMy admin?

Is that the solution for 1.7.0.2 too??

 
Magento Community Magento Community
Magento Community
Magento Community
 
joeymad
Jr. Member
 
Total Posts:  10
Joined:  2011-06-24
 
Quaeso - 09 July 2012 10:25 AM

furnitureforyoultd - 29 May 2012 08:25 AM
CREATE TABLE `captcha_log` (
    `
typeVARCHAR(32NOT NULL COMMENT 'Type',
    `
valueVARCHAR(32NOT NULL COMMENT 'Value',
    `
countINT(10UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Count',
    `
updated_atTIMESTAMP NULL DEFAULT NULL COMMENT 'Update Time',
    
PRIMARY KEY (`type`, `value`)
)
COMMENT='Count Login Attempts'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

Hi furnitureforyoultd,

where must I insert this Code? in phpMy admin?

Is that the solution for 1.7.0.2 too??

This code goes into phpMyAdmin
As far as I know, not much has changed between 1.7.0 and 1.7.0.2 except for security patches.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Quaeso
Guru
 
Avatar
Total Posts:  334
Joined:  2010-04-03
 

It works

many thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
iondale
Jr. Member
 
Total Posts:  2
Joined:  2011-02-28
 

Hey I’m having the same issue. Can you guys please be more specific? Where in phpmyadmin are you talking about? Is there place I can insert those codes there? Please help.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top