Ajax Register

1 year 9 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';

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

1 year 9 months ago #8009 by Saka
Try replacing this code:
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';
with this:
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';
in admin/sql/install.mysql.utf8.sql
and then try to install again.

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.

We also recommend

Twitter

sakicnet: Register into multiple groups with AJAX Register 3.8 https://t.co/oAt6IJJxQA 722 days ago from Twitter Web Client

Stay in touch