Need help!!!

[Guest]

I cannot figure this out. This is my first time dealing with MYSQL so bare with me plz....

 

 

I am trying to install the Anti Robot Registration module, and one of the first things it says to do is create a DB and to use Anti Robot Registration.sql file. Well I upload it to a database I create using mysql, but it gives me an error message:

 

Error

 

SQL-query :

 

INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES (

 

'', 'Anti Robot Reg', 'Anti Robot Registration', 300, 1

)

 

MySQL said:

 

 

Table 'ffsgra46_Anti.configuration_group' doesn't exist

 

 

what could I be doing wrong?

[1quicksi]

How are you uploading this? You need to use phpMyAdmin to alter your database. There are numerous threads outlining how to do this but if you want a hand PM me and I will walk you through it :)

[Guest]

I never used the Anti Robot Registration module but usually on a .sql file all of the statements to create the table are already specified. All you have to do is run this via phpmyadmin or manually if you have shell access with the following command:

 

mysql -u user_name -p database_name < Registration.sql

 

This will run the sql commands that are inside of the .sql file and create all of the correct tables on your specified database.

[Guest]

maybe there is something wrong with the sql file?

 

 

 

 

 

 

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('', 'Anti Robot Reg', 'Anti Robot Registration', 300, 1);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate Anti Robot Registration ?', 'ACCOUNT_VALIDATION', 'true', 'Put a special code into create account & edit account to verify the user is human :)', 300, 10, '2003-05-10 19:38:18', '2003-05-10 19:38:18', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for Create Account ? ', 'ACCOUNT_CREATE_VALIDATION', 'true', 'This will put the Validation Code Check in the Create Account when activated (DEFAULT)', 300, 20, '2003-05-10 21:23:10', '2003-05-10 20:39:46', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Activate for Editing Account ? ', 'ACCOUNT_EDIT_VALIDATION', 'true', 'This will put the Validation Code Check also in the Account Edit when activated (OPTIONAL)', 300, 30, '2003-05-10 21:23:10', '2003-05-10 20:39:46', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Length for the Validation Code', 'ENTRY_VALIDATION_LENGTH', '5', 'The DEFAULT Length = 5', 300, 50, '2003-05-10 21:23:10', '2003-05-10 20:39:46', NULL, NULL);

 

 

CREATE TABLE anti_robotreg (

session_id char(32) DEFAULT '' NOT NULL,

reg_key char(5) NOT NULL,

timestamp int(11) unsigned NOT NULL,

PRIMARY KEY (session_id))