Unable to access Admin Dashboard after installation

Discussion in 'Installation & Upgrades' started by chankingston, Feb 27, 2019.

  1. chankingston

    chankingston New Member

    Hi,

    I found no problem installing Subrion v4.2.1 on CentOS 7 machine. However, after installation, following mysql error reported as I attempted to go to the ADMIN DASHBOARD page.


    ===========================================================

    Fatal error: Uncaught mysqli_sql_exception: Illegal argument to a regular expression. in /var/www/html/subrion/includes/classes/ia.core.mysqli.php:159 Stack trace: #0 /var/www/html/subrion/includes/classes/ia.core.mysqli.php(159): mysqli_query(Object(mysqli), 'SELECT `attribu...') #1 /var/www/html/subrion/includes/classes/ia.core.mysqli.php(276): iaDb->query('SELECT `attribu...') #2 /var/www/html/subrion/includes/classes/ia.core.mysqli.php(242): iaDb->getAll('SELECT `attribu...') #3 /var/www/html/subrion/includes/classes/ia.core.mysqli.php(547): iaDb->_get('all', Array, ' WHERE `pages` ...', NULL, NULL) #4 /var/www/html/subrion/includes/classes/ia.core.view.php(1368): iaDb->all(Array, '`pages` REGEXP(...', NULL, NULL, 'admin_actions') #5 /var/www/html/subrion/includes/classes/ia.core.view.php(926): iaView->_getAdminToolbarActions() #6 /var/www/html/subrion/includes/classes/ia.core.php(161): iaView->output() #7 /var/www/html/subrion/index.php(123): iaCore->init() #8 {main} thrown in /var/www/html/subrion/includes/classes/ia.core.mysqli.php on line 159

    ===========================================================


    It seems that the subrion-cms attempted to execute a SQL query but somehow failed. I checked the mysql database and all database tables should be created properly by the subrion installation process:


    ===========================================================

    mysql> show tables;
    +-------------------------------------+
    | Tables_in_subrion |
    +-------------------------------------+
    | sbr421_acl_objects |
    | sbr421_acl_privileges |
    | sbr421_admin_actions |
    | sbr421_admin_pages |
    | sbr421_admin_pages_groups |
    | sbr421_api_tokens |
    | sbr421_blocks |
    | sbr421_blog_entries |
    | sbr421_blog_entries_tags |
    | sbr421_blog_tags |
    | sbr421_config |
    | sbr421_config_custom |
    | sbr421_config_groups |
    | sbr421_cron |
    | sbr421_currencies |
    | sbr421_email_templates |
    | sbr421_favorites |
    | sbr421_fields |
    | sbr421_fields_groups |
    | sbr421_fields_image_types |
    | sbr421_fields_pages |
    | sbr421_fields_relations |
    | sbr421_fields_tree_nodes |
    | sbr421_file_types |
    | sbr421_hooks |
    | sbr421_image_types |
    | sbr421_image_types_filetypes |
    | sbr421_invoices |
    | sbr421_invoices_items |
    | sbr421_items |
    | sbr421_items_pages |
    | sbr421_language |
    | sbr421_languages |
    | sbr421_logs |
    | sbr421_members |
    | sbr421_members_auth_providers |
    | sbr421_menus |
    | sbr421_migrations |
    | sbr421_modules |
    | sbr421_objects_pages |
    | sbr421_online |
    | sbr421_pages |
    | sbr421_payment_gateways |
    | sbr421_payment_gateways_ipn_log |
    | sbr421_payment_plans |
    | sbr421_payment_plans_options |
    | sbr421_payment_plans_options_values |
    | sbr421_payment_subscriptions |
    | sbr421_payment_transactions |
    | sbr421_positions |
    | sbr421_search |
    | sbr421_usergroups |
    | sbr421_views_log |
    +-------------------------------------+
    53 rows in set (0.00 sec)



    ===========================================================

    Here is the subrion server information:yum info

    [[email protected] ~]# cat /etc/redhat-release
    CentOS Linux release 7.4.1708 (Core)

    [[email protected] ~]# php --version
    PHP 7.3.2 (cli) (built: Feb 5 2019 13:10:03) ( NTS )
    Copyright (c) 1997-2018 The PHP Group
    Zend Engine v3.3.2, Copyright (c) 1998-2018 Zend Technologies

    MySQL: Server version: 8.0.11 MySQL Community Server - GPL

    Attached Files:

  2. Vasily_B.

    Vasily_B. Project Manager

    Hi,

    I believe it might be related to PHP 7.3 / MySQL 8 version. We've got some reports with the same issues, and we have not released patch. At the moment the only way would be to downgrade PHP/MySQL version to 7.2 / MySQL 5.7

    Let us know if this is an option.

    Thanks

Share This Page