
Originally Posted by
muah
According to the directions given by Zen Cart, i uploaded the new files to the old store allowing overwrite...then adjusted the permissions...then ran zc_install. After that, removed zc install and everything seemingly works then i found those errors. Looking at the logs folder I see the following and i removed personal info so i don't worry about it:
[27-May-2021 17:02:05 America/Boise] Request URI: /shop/admin/, IP address: i remove this info
#1 trigger_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:132]
#5 WhosOnline->retrieve() called at [/home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php:218]
#6 WhosOnline->getStats() called at [/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php:15]
#7 include(/home2/myprivatename/public_html/shop/admin/includes/modules/dashboard_widgets/WhosOnlineDashboardWidget.php) called at [/home2/myprivatename/public_html/shop/admin/index_dashboard.php:62]
#8 require(/home2/myprivatename/public_html/shop/admin/index_dashboard.php) called at [/home2/myprivatename/public_html/shop/admin/home.php:25]
#9 require(/home2/myprivatename/public_html/shop/admin/home.php) called at [/home2/myprivatename/public_html/shop/admin/index.php:11]
--> PHP Fatal error: 1267:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_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 whos_online w
LEFT OUTER JOIN sessions s ON (s.sesskey = w.session_id)
WHERE ip_address != '' AND ip_address NOT IN (' i remove this as it may be sensitive')
ORDER BY time_entry, LPAD(ip_address,11,'0') ==> (as called by) /home2/myprivatename/public_html/shop/admin/includes/classes/WhosOnline.php on line 132 <== in /home2/myprivatename/public_html/shop/includes/classes/db/mysql/query_factory.php on line 170.
Bookmarks