Installation problem
- hakana
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
9 years 7 months ago #7486
by hakana
Hi Emir,
When I try to install the laterst version of Ajax register on Joomla 3.4.1 I get this error:
Warning
Can't write; duplicate key in table 'j33_ajaxregister_field_values' SQL=CREATE TABLE j33_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 `j33_ajaxregister_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';
There is no existing ajax register table on the database. I checked it.
Please advise
When I try to install the laterst version of Ajax register on Joomla 3.4.1 I get this error:
Warning
Can't write; duplicate key in table 'j33_ajaxregister_field_values' SQL=CREATE TABLE j33_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 `j33_ajaxregister_fields` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AJAX Register fields value storage table';
There is no existing ajax register table on the database. I checked it.
Please advise
Please Log in or Create an account to join the conversation.
- Saka
- Offline
- Administrator
9 years 6 months ago #7488
by Saka
Emir Sakic
www.sakic.net
Can't say why you get it. Send the access info on mail and I will have a look.
Emir Sakic
www.sakic.net
Please Log in or Create an account to join the conversation.
- hakana
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
9 years 6 months ago #7491
by hakana
Have you ever tried to install the latest Ajax register to the latest version of Joomla? I tried it many times and I always get this error.
Please Log in or Create an account to join the conversation.
- Saka
- Offline
- Administrator
9 years 6 months ago #7492
by Saka
Emir Sakic
www.sakic.net
Of course. Works without problems for me. Will catch you on Skype to have a look on your configuration.
Emir Sakic
www.sakic.net
Please Log in or Create an account to join the conversation.
- Saka
- Offline
- Administrator
9 years 6 months ago #7496
by Saka
Emir Sakic
www.sakic.net
Turns out this was because you had another instance of Joomla and AJAX Register installed in the same database (with different prefix).
If anybody gets this issue here is how you can solve it:
1) Unzip AJAX_Register.zip
2) Locate mySQL installation file:
2.5-3/admin/sql/install.mysql.utf8.sql
3) Open the file with a text editor and find this code:4) Rename the constraint name to:5) Zip the directory again and you should be able to install it.
If anybody gets this issue here is how you can solve it:
1) Unzip AJAX_Register.zip
2) Locate mySQL installation file:
2.5-3/admin/sql/install.mysql.utf8.sql
3) Open the file with a text editor and find this code:
CONSTRAINT `values_ibfk_1`
CONSTRAINT `values_ibfk_2`
Emir Sakic
www.sakic.net
Please Log in or Create an account to join the conversation.