Ajax Register
- andlil
-
Topic Author
- Offline
- New Member
-
Less
More
- Posts: 1
- Thank you received: 0
5 years 7 months ago #8008
by andlil
What the heck is this message after installation ?
JInstaller: :Installera: SQL-fel REFERENCES command denied to user 'joomla1@t183286'@'172.22.223.26' for table '#__ajaxregister_fields'
Tillägg Installera: SQL-fel vid frågebehandling: DB-funktion misslyckades med felnummer 1142
REFERENCES command denied to user 'joomla1@t183286'@'172.22.223.26' for table '#__ajaxregister_fields'
SQL =
CREATE TABLE #__ajaxregister_field_values (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`field_id` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
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';
JInstaller: :Installera: SQL-fel REFERENCES command denied to user 'joomla1@t183286'@'172.22.223.26' for table '#__ajaxregister_fields'
Tillägg Installera: SQL-fel vid frågebehandling: DB-funktion misslyckades med felnummer 1142
REFERENCES command denied to user 'joomla1@t183286'@'172.22.223.26' for table '#__ajaxregister_fields'
SQL =
CREATE TABLE #__ajaxregister_field_values (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`field_id` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
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';
Please Log in or Create an account to join the conversation.
- Saka
-
- Offline
- Administrator
-
5 years 7 months ago #8009
by Saka
Emir Sakic
www.sakic.net
Try replacing this code:with this:in admin/sql/install.mysql.utf8.sql
and then try to install again.
CREATE TABLE #__ajaxregister_field_values (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`field_id` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
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';CREATE TABLE #__ajaxregister_field_values (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`field_id` int(11) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';and then try to install again.
Emir Sakic
www.sakic.net
Please Log in or Create an account to join the conversation.