Post by REW » Tue Jan 26, 2016 3:52 am

Hi!

My host, (Dreamhost) is planning a manditory upgrade to PHP 5.6 soon. Thus far we have been on 5.3. Today I manually set the server to PHP 5.6 for testing, and got the following error at the top of the site:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/cmargo5/shop.pacherbs.com/system/database/mysql.php on line 6

Can anyone clue me in on what this is related to, and what I might do to remedy the error?

My system/database/mysql.php file line #6 reads:

if (!$this->link = mysql_connect($hostname, $username, $password)) {

My skills stop here, as I don't really know what I'm looking at.

Thanks in advance for any assistance! :)

Opencart 1.5.6.4 (an upgrade done by qphoria)
Theme: Journal http://themeforest.net/item/journal-adv ... me/4260361

EDIT, ADDITIONAL ERROR LOGS:
2016-01-25 11:52:55 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/index.php on line 179
2016-01-25 11:52:55 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/system/library/currency.php on line 45
2016-01-25 11:55:10 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:12 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:13 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:14 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:14 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/system/library/captcha.php on line 40
2016-01-25 11:55:15 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:15 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:36 - PHP Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:36 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:55:36 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/index.php on line 179
2016-01-25 11:55:36 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/system/library/currency.php on line 45
2016-01-25 11:57:12 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:12 - PHP Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:12 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/index.php on line 179
2016-01-25 11:57:12 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/system/library/currency.php on line 45
2016-01-25 11:57:14 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:14 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:15 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:15 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/system/library/captcha.php on line 40
2016-01-25 11:57:15 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
2016-01-25 11:57:16 - PHP Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cmargo5/shop.pacherbs.com/system/database/mysql.php:6) in /home/cmargo5/shop.pacherbs.com/vqmod/vqcache/vq2-system_library_session.php on line 12
Last edited by REW on Thu Feb 18, 2016 6:25 am, edited 1 time in total.

REW
New member

Posts

Joined
Wed Feb 25, 2015 4:00 am

Post by IP_CAM » Tue Jan 26, 2016 5:51 am

change in BOTH config.php files:
define('DB_DRIVER', 'mysql');
to:
define('DB_DRIVER', 'mysqli');
and check again !

AND DELETE your second Posting, as long as nobody else replies to, it makes very little sense, to double post around here...

Ernie
openshop.li

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by REW » Wed Feb 17, 2016 1:06 pm

Thanks, that worked! I don't see how to delete a post though...

REW
New member

Posts

Joined
Wed Feb 25, 2015 4:00 am

Post by kirkhall » Thu Feb 18, 2016 5:39 am

REW wrote:Thanks, that worked! I don't see how to delete a post though...
Just edit the title of your original post and put (Solved) at the beginning.

No one wants the post deleted as it might help others.

Active Member

Posts

Joined
Thu May 22, 2014 11:31 am

Post by IP_CAM » Thu Feb 18, 2016 5:54 am

he/she created two different Posts, on the same matter, But as long as no-one else replies to, one can always later remove such an 'empty' post again. That's what I meant. :D

Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kirkhall » Thu Feb 18, 2016 6:04 am

Sorry Ernie, I didn't even notice you mentioned a 2nd post.

Active Member

Posts

Joined
Thu May 22, 2014 11:31 am

Post by REW » Thu Feb 18, 2016 6:28 am

Well, either way, I don't see the delete post link.

I marked both threads as solved, and included the fix in the other thread as well.

REW
New member

Posts

Joined
Wed Feb 25, 2015 4:00 am
Who is online

Users browsing this forum: Amazon [Bot] and 12 guests