Cant install Ajax registration
- hopsms
-
Topic Author
- Offline
- New Member
-
Less
More
- Thank you received: 0
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 ?
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.
- Saka
-
- Offline
- Administrator
-
11 years 5 months ago #7191
by Saka
Emir Sakic
www.sakic.net
What's your mySQL version?
Emir Sakic
www.sakic.net
Please Log in or Create an account to join the conversation.