Cant install Ajax registration

11 years 5 months ago #7189 by hopsms
I get this error:



        JInstaller: :Install: Error SQL DB function failed with error number 1005
        Can't create table '48_hopsms.o38y2_ajaxregister_field_values' (errno: 121) SQL=CREATE TABLE o38y2_ajaxregister_field_values ( `user_id` int(11) NOT NULL, `field_id` int(11) NOT NULL, `value` varchar(255) NOT NULL, KEY `idx_user_id` (`user_id`), CONSTRAINT `values_ibfk_1` FOREIGN KEY (`field_id`) REFERENCES `o38y2_ajaxregister_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';
        SQL =

        CREATE TABLE #__ajaxregister_field_values (
          `user_id` int(11) NOT NULL,
          `field_id` int(11) NOT NULL,
          `value` varchar(255) NOT NULL,
          KEY `idx_user_id` (`user_id`),
          CONSTRAINT `values_ibfk_1` FOREIGN KEY (`field_id`) REFERENCES `#__ajaxregister_fields` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';

        Component Install: SQL error file DB function failed with error number 1005
        Can't create table '48_hopsms.o38y2_ajaxregister_field_values' (errno: 121) SQL=CREATE TABLE o38y2_ajaxregister_field_values ( `user_id` int(11) NOT NULL, `field_id` int(11) NOT NULL, `value` varchar(255) NOT NULL, KEY `idx_user_id` (`user_id`), CONSTRAINT `values_ibfk_1` FOREIGN KEY (`field_id`) REFERENCES `o38y2_ajaxregister_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';
        SQL =

        CREATE TABLE #__ajaxregister_field_values (
          `user_id` int(11) NOT NULL,
          `field_id` int(11) NOT NULL,
          `value` varchar(255) NOT NULL,
          KEY `idx_user_id` (`user_id`),
          CONSTRAINT `values_ibfk_1` FOREIGN KEY (`field_id`) REFERENCES `#__ajaxregister_fields` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';

Using Joomla 2.5.14 - domain: hopsms.is

What can be wrong ?

Please Log in or Create an account to join the conversation.

11 years 5 months ago #7191 by Saka
What's your mySQL version?

Emir Sakic
www.sakic.net

Please Log in or Create an account to join the conversation.

About us

We provide high quality Joomla components created by a co-founder and original core developer of Joomla. For over a decade, our products have been used by more than 20.000 webmasters around the world.

Stay in touch