corbetto

Members
  • Posts

    7
  • Joined

  • Last visited

Posts posted by corbetto

  1. On 6/21/2022 at 6:19 PM, Chiacomo said:

    Hi,

     

    i have the same problem. I didn't use akaunting for 2 weeks. Yesterday i wanted to use it. I tried to login and but the login site didn't load.

    This was in the log files and the container stopped:

     

     Some options are missing and --no-interaction is present. Please run the following command for more information :
     php artisan help install
     Missing options are : db-port

     

    After editing the settings of the container and set setup to false, i restartet the container. I entered my credentials at the login screen but nothing

    happens.

     

    Now i have a big problem to get it work again. I only have backups fom the database. I don*t no what happend. I think the problem comes from an

    update because i see the login screen in a new design.

     

    Please help me because i am in big trouble.

     

    When i use this line in the container:

    php artisan install --db-host "ip_of_dbhost" --db-port "port_number_of_db" --db-name "db_name_here" --db-username "db_username_here" --db-password "db_password_here" --company-name "company_name" --company-email "company@mail" --admin-email "email@mail" --admin-password "password_here" --locale "en-US"

     

    with my values, it connects to the database and after a few seconds this error came:


    In Connection.php line 742:
                                                                                                       
      SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2gl_media` (errno: 121 "Du  
      plicate key on write or update") (SQL: alter table `2gl_media` add constraint `original_media_i  
      d` foreign key (`original_media_id`) references `2gl_media` (`id`) on delete set null)           
                                                                                                       

    In Connection.php line 527:
                                                                                                       
      SQLSTATE[HY000]: General error: 1005 Can't create table `akaunting`.`2gl_media` (errno: 121 "Du  
      plicate key on write or update")   

     

     

    Best Regards

    Im in the exact same boat, if you find out anything please share!

  2. I did make some further progress by adding the SeverName line to my local server ip with port for akaunting in the apache.conf file within the console - this stopped the fully qual'd domain name error. But i still cannot get pass the login, allthough the logs say that its POST ing 

  3. 1 minute ago, Danuel said:

     

     

    if you open akaunting console and type  "service apache2 restart" still not working ?

     

    Yup still not working, it shuts down container then this appears in log:

    Module rewrite already enabled
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    [Sun Jun 19 19:31:27.215839 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.53 (Debian) PHP/8.1.7 configured -- resuming normal operations
    [Sun Jun 19 19:31:27.215879 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

  4. Still having issues not been able to login now getting this error output any help please!!!

    Enabling module rewrite.
    To activate the new configuration, you need to run:
    service apache2 restart
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.6. Set the 'ServerName' directive globally to suppress this message
    [Sun Jun 19 19:13:43.286237 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.53 (Debian) PHP/8.1.7 configured -- resuming normal operations
    [Sun Jun 19 19:13:43.286280 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
    172.18.0.1 - - [19/Jun/2022:19:13:51 +1200] "GET / HTTP/1.1" 302 1624 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.123.123.115 Safari/537.36"

  5. Just updated to the latest version and get constantly stuck on login - just hangs when i press login. Only thing that looks out of order in the log is this:

    [2022-06-09 09:25:31] production.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'accounting.ak_users' doesn't exist (SQL: select * from `ak_users` where `email` = email@gmail.com and `ak_users`.`deleted_at` is null limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'accounting.ak_users' doesn't exist (SQL: select * from `ak_users` where `email` = email@gmail.com and `ak_users`.`deleted_at` is null limit 1) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:742)