When I copied the files from v157 test site to my current site, I got the following error on the admin page (it does not appear on the admin page for the test site):
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
A check of the error log gives:
[24-Sep-2020 13:18:43 America/Boise] Request URI: /admin/, IP address: 50.49.199.232
#1 trigger_error() called at [/home1/pazdarwi/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home1/pazdarwi/public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home1/pazdarwi/public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home1/pazdarwi/public_html/admin/includes/classes/WhosOnline.php:132]
#5 WhosOnline->retrieve() called at [/home1/pazdarwi/public_html/admin/includes/classes/WhosOnline.php:213]
#6 WhosOnline->getStats() called at [/home1/pazdarwi/public_html/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php:15]
#7 include(/home1/pazdarwi/public_html/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php) called at [/home1/pazdarwi/public_html/admin/index_dashboard.php:62]
#8 require(/home1/pazdarwi/public_html/admin/index_dashboard.php) called at [/home1/pazdarwi/public_html/admin/home.php:25]
#9 require(/home1/pazdarwi/public_html/admin/home.php) called at [/home1/pazdarwi/public_html/admin/index.php:11]
--> PHP Fatal error: 1267:Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' :: SELECT customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id, host_address, user_agent, s.value as session_data
FROM zen_whos_online w
LEFT OUTER JOIN zen_sessions s ON (s.sesskey = w.session_id)
WHERE ip_address != '' AND ip_address NOT IN ('your','IP','(ADMIN)','184.9.94.48','184.12.51.9','50.49.199.232','50.49.199.23 2')
ORDER BY time_entry, LPAD(ip_address,11,'0') ==> (as called by) /home1/pazdarwi/public_html/kkdt/includes/classes/WhosOnline.php on line 132 <== in /home1/pazdarwi/public_html/includes/classes/db/mysql/query_factory.php on line 170.
Please note my admin site has a different name, I just changed in the error message for security.
It is currently being run with: PHP Version: 5.6.40 (Zend: 2.6.0). This will be changed sometime in the next week or two.
Bookmarks