Question: I Cant Login To Invoice Manager

I Cant Login To Invoice Manager

Cette page ne fonctionne pasImpossible de traiter cette demande via facturation.bsjc.fr à l'heure actuelle. HTTP ERROR 500 The install is ok The htaccess is ok What can i do ? Thank

JD

Jean Claude DAUDY

Asked
Cette page ne fonctionne pasImpossible de traiter cette demande via facturation.bsjc.fr à l'heure actuelle.
HTTP ERROR 500
The install is ok
The htaccess is ok

What can i do ?

Thanks
  • MS

    Mian Saleem

    Answered
    Hello,

    Please check your server's php error logs and let me know the error details so that I can suggest.

    If you are not sure about server logs, you can try to enable app log by changing the `log_threshold` to 1 in the `app/config/config.php` and then try to access the page again. Lastly check the latest log file in the `app/logs/` folder.

    Thank you
  • JD

    Jean Claude DAUDY

    Answered
    Hello,
    Sorry for the delay due to the holidays. Here is the content of the log-2022-12-28.php file in the app/log directory
    Thanks


    <?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

    ERROR - 2022-12-28 10:32:10 --> Query error: SELECT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_sessions` - Invalid query: SELECT `data`
    FROM `sim_sessions`
    WHERE `id` = 'c9241c71ac41049d97d7f199efcae1dbb83f79fc'
    ERROR - 2022-12-28 10:32:10 --> Query error: SELECT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_settings` - Invalid query: SELECT *
    FROM `sim_settings`
    ERROR - 2022-12-28 10:32:10 --> Severity: error --> Exception: Call to a member function num_rows() on bool /home/fwpm0572/facturation.bsjc.fr/app/models/Site.php 15
    ERROR - 2022-12-28 10:32:10 --> Query error: INSERT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_sessions` - Invalid query: INSERT INTO `sim_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c9241c71ac41049d97d7f199efcae1dbb83f79fc', '86.202.59.69', 1672219930, '__ci_last_regenerate|i:1672219930;')
    ERROR - 2022-12-28 10:32:10 --> Severity: Warning --> ini_set(): A session is active. You cannot change the session module's ini settings at this time /home/fwpm0572/facturation.bsjc.fr/system/libraries/Session/Session_driver.php 205
    ERROR - 2022-12-28 10:32:10 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /opt/alt/php74/var/lib/php/session) Unknown 0
    ERROR - 2022-12-28 10:32:13 --> Query error: SELECT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_sessions` - Invalid query: SELECT `data`
    FROM `sim_sessions`
    WHERE `id` = '1cbd419935f3254eb537c99cbd1dacd08a26f3ab'
    ERROR - 2022-12-28 10:32:13 --> Query error: SELECT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_settings` - Invalid query: SELECT *
    FROM `sim_settings`
    ERROR - 2022-12-28 10:32:13 --> Severity: error --> Exception: Call to a member function num_rows() on bool /home/fwpm0572/facturation.bsjc.fr/app/models/Site.php 15
    ERROR - 2022-12-28 10:32:13 --> Query error: INSERT command denied to user 'fwpm0572_Facturebsjc'@'localhost' for table `fwpm0572_factbsjc2`.`sim_sessions` - Invalid query: INSERT INTO `sim_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1cbd419935f3254eb537c99cbd1dacd08a26f3ab', '86.202.59.69', 1672219933, '__ci_last_regenerate|i:1672219933;')
    ERROR - 2022-12-28 10:32:13 --> Severity: Warning --> ini_set(): A session is active. You cannot change the session module's ini settings at this time /home/fwpm0572/facturation.bsjc.fr/system/libraries/Session/Session_driver.php 205
    ERROR - 2022-12-28 10:32:13 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /opt/alt/php74/var/lib/php/session) Unknown 0
  • JD

    Jean Claude DAUDY

    Answered
    And the server web error log say :

    [Wed Dec 28 09:01:01.678857 2022] [cgid:error] [pid 22505:tid 47112748697344] [client 54.36.148.5:0] AH01265: attempt to invoke directory as script: /home/fwpm0572/bsjc.fr/cgi-bin/

    thanks
  • MS

    Mian Saleem

    Answered
    Hello,

    Please update database user privileges and allow all including `insert` on the database.

    Thank you
  • JD

    Jean Claude DAUDY

    Answered
    Hello,
    I did what you asked, but I still get the same http 500 error. However I have put all the privileges on the database. I checked, there is no table in the database and yet the installation went well. Now I can't do any reinstallation because the file /install/index.php is locked.
    Here is the last log file

    <?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

    ERROR - 2023-01-01 14:22:26 --> Query error: Table 'fwpm0572_factbsjc2.sim_sessions' doesn't exist - Invalid query: SELECT `data`
    FROM `sim_sessions`
    WHERE `id` = 'f99a94ea7148810461e2212ef5d14f7e0e4304b6'
    ERROR - 2023-01-01 14:22:26 --> Query error: Table 'fwpm0572_factbsjc2.sim_settings' doesn't exist - Invalid query: SELECT *
    FROM `sim_settings`
    ERROR - 2023-01-01 14:22:26 --> Severity: error --> Exception: Call to a member function num_rows() on bool /home/fwpm0572/facturation.bsjc.fr/app/models/Site.php 15
    ERROR - 2023-01-01 14:22:26 --> Query error: Table 'fwpm0572_factbsjc2.sim_sessions' doesn't exist - Invalid query: INSERT INTO `sim_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f99a94ea7148810461e2212ef5d14f7e0e4304b6', '86.202.59.69', 1672579346, '__ci_last_regenerate|i:1672579346;')
    ERROR - 2023-01-01 14:22:26 --> Severity: Warning --> ini_set(): A session is active. You cannot change the session module's ini settings at this time /home/fwpm0572/facturation.bsjc.fr/system/libraries/Session/Session_driver.php 205
    ERROR - 2023-01-01 14:22:26 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /opt/alt/php74/var/lib/php/session) Unknown 0
    ERROR - 2023-01-01 14:22:31 --> Query error: Table 'fwpm0572_factbsjc2.sim_sessions' doesn't exist - Invalid query: SELECT `data`
    FROM `sim_sessions`
    WHERE `id` = '59aa2fa44c029a6605c0a9486ffc6fc1a8ff28fd'
    ERROR - 2023-01-01 14:22:31 --> Query error: Table 'fwpm0572_factbsjc2.sim_settings' doesn't exist - Invalid query: SELECT *
    FROM `sim_settings`
    ERROR - 2023-01-01 14:22:31 --> Severity: error --> Exception: Call to a member function num_rows() on bool /home/fwpm0572/facturation.bsjc.fr/app/models/Site.php 15
    ERROR - 2023-01-01 14:22:31 --> Query error: Table 'fwpm0572_factbsjc2.sim_sessions' doesn't exist - Invalid query: INSERT INTO `sim_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('59aa2fa44c029a6605c0a9486ffc6fc1a8ff28fd', '86.202.59.69', 1672579351, '__ci_last_regenerate|i:1672579351;')
    ERROR - 2023-01-01 14:22:31 --> Severity: Warning --> ini_set(): A session is active. You cannot change the session module's ini settings at this time /home/fwpm0572/facturation.bsjc.fr/system/libraries/Session/Session_driver.php 205
    ERROR - 2023-01-01 14:22:31 --> Severity: Warning --> session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /opt/alt/php74/var/lib/php/session) Unknown 0
  • JD

    Jean Claude DAUDY

    Answered
    Your software does not correspond to the regulations of my country and therefore I cannot use it. Can you please refund me (I know that the license will be deactivated) Thanking you in advance
  • MS

    Mian Saleem

    Answered
    Hello,

    Please let me know the regulation that you are talking about so that I can check them in v4

    For a refund, please open a request at the marketplace.

    Thank you
  • Login to Reply