Forum

Database setup

Posted in CategoryInstallation & Update
  • Karol
    Karol Kovalik   ( User ) 11 months ago

    Hi, hope you can guide me to a solution.

    I downloaded the lastest stable 1.0.8. Unpacked into the root and launched the installer. Got only as far as step 2/3 where its simply not taking my:

    • - server (localhost)
    • - username (root)
    • - password (my password)
    • - database (aka)

     

    Also I am quite confused by what I should put into the field Database field? Is this the DB prefix that will be created? I also tried to create the DB manualy using mysql CREATE DATABASE aka; but still no luck.

    Thanks.

  • Denis
    Denis Duliçi   ( Admin ) 11 months ago

    Hi Karol.

    You should first create a database on your server. If you use MySQL then you can create it through phpMyAdmin tool.

    Regards

  • Karol
    Karol Kovalik   ( User ) 11 months ago

    Thank you Denis. I did create the Database. But just the database, no table structure. In case table structure is required, where do I find it?

  • Karol
    Karol Kovalik   ( User ) 11 months ago

    SOLVED: I did not have php-mysqli installed.

    apt-get install php-mysql

    did the trick.

  • Naveed
    Naveed Qamar   ( User ) 11 months ago

    Hi Denies, 

    I have tried to install through Softaculous installer and it gives error while login. then I have download latest version (just today) and upload through ftp, created mysql database (user is automatically created) Now I am install Akaunting, it stucks on step 2. I am filling out the 

    • - server (live host server)
    • - username (as infinity server provided)
    • - password (my cPanel password is same database password)
    • - database (database name)

    but it is not accepting the entries and gives error " Error: Could not connect to the database! Please, make sure the details are correct. "

    Please help

  • Tukaram
    Tukaram Khandgave   ( User ) 7 months ago

    Hi Denies,

    I have tried install akaunting 1.0.15 but in second step i got following db error

    Please help.

    SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting_db`.`#sql-1118_ce` (errno: 121 "Duplicate key on write or update") (SQL: alter table `apm_user_roles` add constraint `user_roles_role_id_foreign` foreign key (`role_id`) references `apm_roles` (`id`) on delete cascade on update cascade)

  • Half
    Half Bit   ( User ) 6 months ago

    Hi Tukaram Khandgave

    The database needs to be empty.

Please login or register to leave a response.