qwcrm icon indicating copy to clipboard operation
qwcrm copied to clipboard

[URGENT!!! HELP ]after logged in its redirect back to login page unable to log in and see dashboard, v3.1.3

Open anik4good opened this issue 1 year ago • 13 comments

image

i have uploaded the image after log in its redirect back to this page, I tested with PHP 7.2 and 7.4 still same issue

anik4good avatar Oct 18 '24 04:10 anik4good

let me have a think an ge back to you

shoulders avatar Oct 18 '24 06:10 shoulders

thanks do you need any information from me ? i am using windows 11 and laragon I tested with MySQL 5.7 and MySQL 8.0 still the same whenever I try to login it redirect me but if I use wrong password it gives me error that password is wrong , also in my db there is info for users image

anik4good avatar Oct 18 '24 06:10 anik4good

  • Most of my testing was done on Xampp (php/MariaDB).
  • I have never used laragon but I will try over the week end to get that installed and see what is happing.
  • There might be an issue with the hashing algorithm

I want to get my next version out soon which has a massive amount of fixes.

shoulders avatar Oct 18 '24 07:10 shoulders

I'm using the MD5 hashing algorithm for passwords, and I've noticed that Laragon and XAMPP are pretty similar since both come with PHP, Apache, and MySQL. I've followed all the steps and made the necessary modifications to the database, and everything went smoothly during the installation—no errors at all! However, when I tried to log in, I ran into an issue. I'm hoping to figure it out soon!

anik4good avatar Oct 18 '24 07:10 anik4good

I don't have the code open but it might be the session handling is not working and it needs swapping to database.

I think in the qwcrm config there is a variable called session handler, make sure this is set to "database"

shoulders avatar Oct 18 '24 07:10 shoulders

this is the config

<?php
class QConfig
{
    public $db_host = 'localhost';
    public $db_name = 'test_db';
    public $db_user = 'root';
    public $db_pass = '';
    public $db_prefix = 'vykl_';
    public $sef = '0';
    public $gzip = '0';
    public $maintenance = '0';
    public $theme_name = 'default';
    public $default_language = 'en_GB';
    public $autodetect_language = '1';
    public $google_server = 'https://www.google.com/';
    public $email_online = '1';
    public $email_mailer = 'phpmail';
    public $email_mailfrom = '[email protected]';
    public $email_fromname = 'From QWcrm';
    public $email_replyto = '';
    public $email_replytoname = 'Reply to QWcrm';
    public $email_sendmail_path = '/usr/sbin/sendmail';
    public $email_smtp_host = 'localhost';
    public $email_smtp_port = '25';
    public $email_smtp_security = '';
    public $email_smtp_auth = '0';
    public $email_smtp_username = '';
    public $email_smtp_password = '';
    public $secret_key = 'WkF5pnvbsgWUIFs5YrkWq2DSKYxzkDSP';
    public $force_ssl = '0';
    public $recaptcha = '0';
    public $recaptcha_site_key = '';
    public $recaptcha_secret_key = '';
    public $session_handler = 'database';
    public $session_lifetime = '1440';
    public $shared_session = '0';
    public $remember_me = '1';
    public $cookie_lifetime = '60';
    public $cookie_token_length = '16';
    public $cookie_domain = '';
    public $cookie_path = '';
    public $workorder_history_notes = '0';
    public $qwcrm_access_log = '0';
    public $qwcrm_activity_log = '0';
    public $qwcrm_error_log = '0';
    public $qwcrm_sql_logging = '0';
    public $qwcrm_email_error_log = '0';
    public $qwcrm_email_transport_log = '0';
    public $error_reporting = 'default';
    public $error_page_raw_output = '0';
    public $error_handler_whoops = '1';
    public $qwcrm_debug = '0';
    public $qwcrm_advanced_debug = '0';
    public $qwcrm_smarty_debugging = '0';
    public $smarty_debugging = '0';
    public $smarty_debugging_ctrl = 'NONE';
    public $smarty_force_compile = '0';
    public $smarty_force_cache = '0';
    public $smarty_caching = '0';
    public $smarty_cache_lifetime = '3600';
    public $smarty_cache_modified_check = '0';
    public $smarty_cache_locking = '0';
}

yes it sets to database

this is my db config image

image

anik4good avatar Oct 18 '24 08:10 anik4good

you should be using php 7.4

shoulders avatar Oct 18 '24 08:10 shoulders

i changed to php 7.4

image

image

anik4good avatar Oct 18 '24 08:10 anik4good

thanks for the heads up., leave it with me.

shoulders avatar Oct 18 '24 09:10 shoulders

Thank you for your prompt response and support on this matter. I appreciate getting good news from you soon.

anik4good avatar Oct 18 '24 09:10 anik4good

is STRICT_TRANS_TABLES enables on you DB server?

This will not be an issue in the new version.

Try turning debug on and see if it gives you any errors when logging.

  • enable php errors

tar

shoulders avatar Oct 19 '24 12:10 shoulders

also my version I have running seems to be on php 7.3 which is not ideal but with no errors. I think 7.4 works but with exceptions and some minor issues.

shoulders avatar Oct 19 '24 12:10 shoulders

does this do the same thing on Xampp. I am just putting together my dev setup.

shoulders avatar Nov 07 '24 10:11 shoulders