During the upgrade to MySQL 8.0, I encountered one different warnings related to CiviCRM tables and I want to take the correct steps in this regard. These warnings are listed below:
Usage of db objects with names conflicting with new reserved keywords Warning: The following objects have names that conflict with new reserved keywords. Ensure queries sent by your applications use quotes when referring to them or they will result in errors. Do I need to fix the mentioned 4 tables (sample tables listed below)? Are the commands I provided for fixing these tables correct and valid?
xxx_xx.civicrm_mapping_field.grouping - Column name
xxx_xx.civicrm_option_value.grouping - Column name
xxx_xx.log_civicrm_mapping_field.grouping - Column name
xxx_xx.log_civicrm_option_value.grouping - Column name
SELECT "grouping" FROM xxx_cagri.civicrm_mapping_field;
I am encountering an issue with my Joomla 4.4.0 and CiviCRM 5.64.2 installation.
The solution you provided for the "Undefined variable $store in Joomla.php on line 56" issue worked previously. However, I am currently experiencing the following errors in the error.log file in a rather extensive manner.
[02-Nov-2023 16:12:58 Europe/Istanbul] PHP Warning: Undefined array key "group" in /home/alodesk/public_html/administrator/components/com_civicrm/civicrm/CRM/Contact/Form/Contact.php on line 880
[02-Nov-2023 16:13:00 Europe/Istanbul] PHP Warning: Trying to access array offset on value of type null in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%ED/ED0/ED0373F0%%blocks.tpl.php on line 8
[02-Nov-2023 16:13:00 Europe/Istanbul] PHP Warning: Trying to access array offset on value of type null in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%ED/ED0/ED0373F0%%blocks.tpl.php on line 9
[02-Nov-2023 16:13:00 Europe/Istanbul] PHP Warning: Trying to access array offset on value of type null in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%ED/ED0/ED0373F0%%blocks.tpl.php on line 11
[02-Nov-2023 16:13:00 Europe/Istanbul] PHP Warning: Trying to access array offset on value of type null in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%ED/ED0/ED0373F0%%blocks.tpl.php on line 14
[02-Nov-2023 16:13:01 Europe/Istanbul] PHP Warning: Undefined array key "localTasks" in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%EA/EAA/EAA96A89%%joomla.tpl.php on line 56
[02-Nov-2023 16:13:01 Europe/Istanbul] PHP Warning: Undefined array key "showWebsite" in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%1A/1A8/1A8F6B69%%Summary-tab.tpl.php on line 67
[02-Nov-2023 16:13:01 Europe/Istanbul] PHP Warning: Undefined array key "showIM" in /home/alodesk/public_html/media/civicrm/templates_c/tr_TR/%%1A/1A8/1A8F6B69%%Summary-tab.tpl.php on line 92
I suspect these new warnings might be related to the previous issue. I would appreciate your assistance in understanding the root cause and finding a solution for these PHP warnings. Please let me know if you need any further information or logs to diagnose the problem.
Thank you in advance for your help.
Correction: Please do not consider the question I asked before. There is already exchange rate information within the plugins. I am testing it now. Thank you very much again.
Hi @nicol
I'm currently using this CSS, and I think it's sufficient. However, I'm considering making some changes to buttons and similar elements to slightly move away from CiviCRM's Stone Age look. Is it possible to use the same CSS file to apply the button and similar styles used in Joomla 4?
I am experiencing an issue with Joomla integration while using CiviCRM. I am getting the following error on line 56 of the "Joomla.php" file:
PHP Warning: Undefined variable $store in /home/userxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php on line 56
This error indicates that the variable $store is not defined when trying to set the $api_key variable. However, I have noticed that I haven't previously defined the $store variable.
Relevant code snippet:
$api_key = CRM_Utils_Request::retrieve('api_key', 'String', $store, FALSE, NULL, 'REQUEST');
I am seeking assistance with resolving this issue. How should I properly define the $store variable?
Any help with this would be greatly appreciated. Thank you in advance.
Best regards,
I am experiencing an issue with Joomla integration while using CiviCRM. I am getting the following error on line 56 of the "Joomla.php" file:
PHP Warning: Undefined variable $store in /home/userxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php on line 56
This error indicates that the variable $store is not defined when trying to set the $api_key variable. However, I have noticed that I haven't previously defined the $store variable.
Relevant code snippet:
$api_key = CRM_Utils_Request::retrieve('api_key', 'String', $store, FALSE, NULL, 'REQUEST');
I am seeking assistance with resolving this issue. How should I properly define the $store variable?
Any help with this would be greatly appreciated. Thank you in advance.
Best regards,
I am experiencing an issue with Joomla integration while using CiviCRM. I am getting the following error on line 56 of the "Joomla.php" file:
PHP Warning: Undefined variable $store in /home/userxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php on line 56
This error indicates that the variable $store is not defined when trying to set the $api_key variable. However, I have noticed that I haven't previously defined the $store variable.
Relevant code snippet:
$api_key = CRM_Utils_Request::retrieve('api_key', 'String', $store, FALSE, NULL, 'REQUEST');
I am seeking assistance with resolving this issue. How should I properly define the $store variable?
Any help with this would be greatly appreciated. Thank you in advance.
Best regards,
With the support of @larssg, the problem was solved.
I'm really happy with the solution you provided. However, I don't have the knowledge and ability to create a pull request on GitHub. Thank you for your assistance.
I wanted to provide an update regarding the suggested solution for the "Undefined variable $store
" error in Joomla.php. After making the suggested change to the code by updating the line to $api_key = CRM_Utils_Request::retrieve('api_key', 'String');
, I have observed that the error no longer occurs, and no new error is logged in the error_log file.
However, I am concerned about the long-term implications of this change, particularly with future updates of CiviCRM. If there is a possibility of encountering the same issue with each CiviCRM update, I would like to understand the root cause and explore a more sustainable solution.
Could you please provide further insight into why this change was suggested as a resolution for the error? Additionally, if there are any known considerations or potential drawbacks associated with this modification, I would greatly appreciate any information you can provide.
I am experiencing an issue with Joomla integration while using CiviCRM. I am getting the following error on line 56 of the "Joomla.php" file:
PHP Warning: Undefined variable $store in /home/userxxx/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php on line 56
This error indicates that the variable $store is not defined when trying to set the $api_key variable. However, I have noticed that I haven't previously defined the $store variable.
Relevant code snippet:
$api_key = CRM_Utils_Request::retrieve('api_key', 'String', $store, FALSE, NULL, 'REQUEST');
I am seeking assistance with resolving this issue. How should I properly define the $store variable?
Any help with this would be greatly appreciated. Thank you in advance.
Best regards,