Bug Report: Installation Problems

Installation Problems

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`.

IS

Ivo Svisco

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

Attachments
  • MS

    Mian Saleem

    Answered

    Hello,

    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

  • IS

    Ivo Svisco

    Answered

    here will be php info:

    https://suits.svisco.lv/info.php

  • MS

    Mian Saleem

    Answered

    Hello,

    I have no idea who to check mysql version from phpinfo 😦

    You can check the MySQL version from phpmyinfo or by the following query

    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.

    Thank you

  • IS

    Ivo Svisco

    Answered

    Hello,

    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.

  • MS

    Mian Saleem

    Answered

    I am still didn’t know the mysql version. Are localhost and liver server has same mysql versions?

  • IS

    Ivo Svisco

    Answered

    Can You install TSMS for me? I can pay for it.

  • MS

    Mian Saleem

    Answered

    Hello,

    Yes, please open installation request ticket. It will cost you $20.

    As I suggested before, if you ask question, I can help you check too.

    Thank you

  • Login to Reply