IS
Reported
Hello,
When I try to install script, I have error:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sviscolv_suits`.`users`, CONSTRAINT `users_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`)) (SQL: insert into `users` (`name`, `username`, `email`, `password`, `owner`, `phone`, `account_id`, `updated_at`, `created_at`) values
How can I resolve this issue.
Best regards,
Ivo Svisco
evanto username: iviss
When I try to install script, I have error:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sviscolv_suits`.`users`, CONSTRAINT `users_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`)) (SQL: insert into `users` (`name`, `username`, `email`, `password`, `owner`, `phone`, `account_id`, `updated_at`, `created_at`) values
How can I resolve this issue.
Best regards,
Ivo Svisco
evanto username: iviss
Attachments
- MSAnsweredHello,
May I know your MySQL version?
Please help me check your database if the tables are created and accounts table has a default account.
Thank you - ISAnsweredhere will be php info:
https://suits.svisco.lv/info.php - MSAnsweredHello,
I have no idea who to check mysql version from phpinfo :(
You can check the MySQL version from phpmyinfo or by the following query
```sql
SHOW VARIABLES LIKE 'version';
```
Please ask question so that you have the option to add private reply. Bugs and request don't have any option to reply privately. I will need some private data to help you so please [ask question](/support/tailor-shop-management-system-tsms-web/ask_question).
Thank you - ISAnsweredHello,
I installed on another hosted server and on localhost. Now error is 419. On localhost migrations made correctly, but on hosting migrated only 3 tables.Attachments - MSAnsweredI am still didn't know the mysql version. Are localhost and liver server has same mysql versions?
- ISAnsweredCan You install TSMS for me? I can pay for it.
- MSAnsweredHello,
Yes, please **[open installation request ticket](/support/tickets/new)**. It will cost you $20.
As I suggested before, if you ask question, I can help you check too.
Thank you - Login to Reply