Page 1 of 1

mysql errors on page and admin panel

Posted: Wed Dec 09, 2015 3:09 am
by geemuni
Help please ???

I am getting the following errors on my website:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/#####/public_html/system/database/mysql.php on line 6
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/index.php on line 181Warning: Cannot modify header information - headers already sent by (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/system/library/currency.php on line 45

In the admin panel, I cannot get it to load after logging in and receive these errors:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/#####/public_html/system/database/mysql.php on line 6
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/system/library/session.php on line 11Warning: Cannot modify header information - headers already sent by (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/system/library/currency.php on line 45Warning: Cannot modify header information - headers already sent by (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 28Warning: Cannot modify header information - headers already sent by (output started at /home/#####/public_html/system/database/mysql.php:6) in /home/#####/public_html/vqmod/vqcache/vq2-system_engine_controller.php on line 29

I have tried:

To solve this, open the following file:
system > library > session.php

Find:
session_start();

Replace with:
session_save_path(“/tmp”); session_start();

Which fixes nothing.

I have also attempted updating to the new mysqli.php file which causes more errors.

Any ideas on how to fix?

Thanks

Re: mysql errors on page and admin panel

Posted: Wed Dec 09, 2015 4:20 am
by IP_CAM
this basically answers your question, you ONLY have to switch to MYSQLI, in your BOTH config.php
Files, if you already have an OC Version, (believed 1.5.5.1up) already including/containing the
mysqli.php file by default.
http://forum.opencart.com/viewtopic.php?f=19&t=155393

Ernie
hitline.info/shop/

Re: mysql errors on page and admin panel

Posted: Wed Dec 09, 2015 9:23 pm
by geemuni
IP_CAM, you are a lifessaver.

After trying all of the mysqli files I started on the mmsqli. The file in the main folder works like a charm.