Forum

Database setup

Posted in CategoryInstallation & Update
  • Karol Kovalik    ( User ) 3 years 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 Duliçi    ( Admin ) 3 years 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 Kovalik    ( User ) 3 years 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 Kovalik    ( User ) 3 years ago

    SOLVED: I did not have php-mysqli installed.


    apt-get install php-mysql


    did the trick.

  • Naveed Qamar    ( User ) 3 years 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 Khandgave    ( User ) 3 years 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 Bit    ( User ) 3 years ago

    Hi Tukaram Khandgave


    The database needs to be empty.

  • Amto    ( User ) 7 months ago
    Hello,
    I created database and filled all fields like database name, user and password correctly but after click next button, next admin section not open. Please suggest.

Please login or register to leave a response.