1 reply to this topic

[turnerbp]

I have installed Autologon into my Store but can't seem to get it to work. I think my problem is in the Mysql file. Here is what I entered below and it also gives the error message. Can someone help and explain. thanks, Brian





Error

SQL-query :

CREATE TABLE `AutoLogin` (

`configuration_title` VARCHAR( Allow AutoLogon ) NOT NULL ,
`configuration_key` VARCHAR( ALLOW_AUTOLOGON ) NOT NULL ,
`configuration_value` VARCHAR( false ) NOT NULL ,
`configuration_description` VARCHAR( Allow registered users to save their login - info into a cookie so they are automatically logged in upon return to the shop. ) NOT NULL ,
`configuration_group_id` VARCHAR( 1 ) NOT NULL ,
`sort_order` VARCHAR( 999 ) NOT NULL ,
`last_modified` VARCHAR( now( ) ) NOT NULL ,
`date_added` VARCHAR( now( ) ) NOT NULL ,
`use_function` VARCHAR( NULL ) NOT NULL ,
`set_function` VARCHAR( 'tep_cfg_select_option(array('true', 'false'),' )
) NOT NULL
)

MySQL said:


You have an error in your SQL syntax near 'Allow AutoLogon) NOT NULL, `configuration_key` VARCHAR(ALLOW_AUTOLOGON) NOT NULL' at line 1
Back

[Wizzud]

I'm not sure where you're SQL came from but I think it should look more like this

insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values ('Allow AutoLogon', 'ALLOW_AUTOLOGON', 'false', 'Allow registered users to save their login-info into a cookie so they are automatically logged in upon return to the shop.<br><br>Best used on SSL-protected shops.', '1', '999', now(), now(), NULL, 'tep_cfg_select_option(array('true', 'false'),');