Question: Installation Have Database Issue

Installation Have Database Issue

when i installing the system its show after i fill complete fields and its show database problem

TM

Tiago Maia

Asked

when i installing the system its show after i fill complete fields and its show database problem

  • MS

    Mian Saleem

    Answered

    when i installing the system its show after i fill complete fileds and its show database problem

    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (grupowb_tsms.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 (Fahad Bangash, fahadbangash, [email protected], $2y$10$itEDZej.bu1Ye3tzDkVZLuFOWioZ00LTB9qlTLfYXr35wCDKxAt8O, 1, 0123456789, 1, 2024-10-20 16:03:42, 2024-10-20 16:03:42))

    kindly solve the issue and provide complete active version this is my sub domain where i want to install

    https://gestao.grupowb.pt/install#/

    database name: grupowb_tsms database username: grupowb_tsms Password: Programmer1199@

  • MS

    Mian Saleem

    Answered

    Hello,

    Please let me know the server (files & database) access details in private reply.

    You can add private reply by enabling the PRIVATE for Staff only at top right of reply section.

    Thank you

  • TM

    Tiago Maia

    Answered

    Ok, but what about the reported problem, how can we solve this bug?

  • MS

    Mian Saleem

    Answered

    Hello,

    I have not sure why are you getting the error. That’s why I asked the server details so that I can check.

    What is your php and mysql versions?

  • TM

    Tiago Maia

    Answered

    10.6.20-MariaDB PHP 8.1

  • MS

    Mian Saleem

    Answered

    Hello,

    The latest version required php8.2+ Please make sure you are install with new/empty database.

    If still the same, I will need your server (files & database) access to check and suggest solution.

    Thank you

  • TM

    Tiago Maia

    Answered

    I did the test and it keeps giving me an error:

    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (grupowb_gestaocontas.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 (Miguel Oliva, migueloliva, [email protected], $2y$10$CC/lvNBvwaZNQC/MeJoh/er.SCFqA553FAyXN4rOMEf4VlGK5r8fa, 1, 0123456789, 1, 2024-11-29 11:56:29, 2024-11-29 11:56:29))

    I hired someone who said they knew your system well to do the installation and even though she is having difficulties, I’ve been waiting all this time and nothing has been resolved, I’m going to ask to cancel the purchase on Envato since I can’t get clear support from you.

    Attachments
  • MS

    Mian Saleem

    Answered

    Hello,

    Please let me know the server (files & database) access details in private reply so that I can check for you.

    You can add private reply by enabling the PRIVATE for Staff only at top right of reply section.

    Thank you

  • TM

    Tiago Maia

    Answered

    Just a test to see if the privacy button is working, ignore this message the content is following

  • TM

    Tiago Maia

    Answered

    Hello dear, I have placed all the server access information in a single document to make things easier, the document is attached.

    CPANEL ACCESS: » https://sistema.grupowb.br/cpanel » User: adminsystem » Pass: websyst-Gruop!2024

    With my best regards

  • Login to Reply