EE 2.9.3 on PHP 7.3 "Fatal error: Uncaught Error:"
Development and Programming
I’ve running the website locally properly on my MAMP devsite. Now my provider did upgrade the PHP Version from 5.6 to 7.3 and i get the following error code:
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/drivers/mysql/mysql_driver.php:73 Stack trace: #0 /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/DB_driver.php(115): CI_DB_mysql_driver->db_connect() #1 /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/DB_driver.php(450): CI_DB_driver->initialize() #2 /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/DB_driver.php(299): CI_DB_driver->simple_query(‘SELECT *\nFROM (…’) #3 /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/DB_active_rec.php(1066): CI_DB_driver->query(‘SELECT *\nFROM (…’) #4 /home/chrsei48/www/pixelmania.ch/system/expressionengine/core/EE_Config.php(211): CI_DB_active_record->get_where(‘sites’, Array) #5 /home/chrsei48/www/pixelmania.ch/system/expressionengine/libraries/Core.php(134): EE_Config->site_prefs(”) #6 /home/chrsei48/www/pixelmania.ch/system/expressionengine/libraries/Core.php(37) in /home/chrsei48/www/pixelmania.ch/system/codeigniter/system/database/drivers/mysql/mysql_driver.php on line 73
Ok, I did the upgrade to EE 2.11.9. Changed in config.php the $db[‘expressionengine’][‘dbdriver’] = “mysqli”;. Now i run in new issues:
Error Number: 1054 Unknown column ‘t.dst_enabled’ in ‘field list’ SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id, w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio, md.*, wd.* FROM exp_channel_titles AS t LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (6,86) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc Filename: modules/channel/mod.channel.php Line Number: 288
Are you planning on upgrading to v5? If they’re running PHP 7.3, I’d recommend it. I’m fairly certain there are a few issues in even the very latest 2.11 under 7.3. Plus it’s just a good idea.
Getting current will definitely solve that issue.
If you have to stay on 2.11 for a bit and it’s otherwise working, make certain you’ve got the latest version and delete and re-upload your mod.channel.php file- or really the whole folder. I believe that code was updated and shouldn’t be throwing the error- here’s the commit:
https://github.com/ExpressionEngine/ExpressionEngine/commit/3d48031c564e20a7641bbaf503356e466ce8ccd6
But like I say, if you can push on and get current, it will be moot.