Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mysqli_real_escape_string error and no idea how to fix


The7thguest

Recommended Posts

Hello.

 

First of all, sorry for my bad english im from Germany ;-)

 

Yesterday i installed OsCommerce v2.3.3 on my new webspace.

 

Install goes with no errors but after that my site have some errors like:

 

Deprecated: mysql_connect() [function.mysql-connect]: The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /users/name/www/admin/includes/functions/database.php on line 19
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /users/name/www/admin/includes/functions/database.php:19) in /users/name/www/admin/includes/functions/sessions.php on line 102
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /users/name/www/admin/includes/functions/database.php:19) in /users/name/www/admin/includes/functions/sessions.php on line 102
Warning: Cannot modify header information - headers already sent by (output started at /users/name/www/admin/includes/functions/database.php:19) in /users/name/www/admin/includes/functions/general.php on line 34

 

OK!

I think i need Google now. :P Well i found that https://github.com/haraldpdl/oscommerce2/commit/040a409568adce149dc4b5067ed261149f74a0fe

 

After that my Site is working and i klick on a category and boom:

 

Warning: require(includes/languages/.php) [function.require]: failed to open stream: No such file or directory in /users/name/www/includes/application_top.php on line 299
Fatal error: require() [function.require]: Failed opening required 'includes/languages/.php' (include_path='.') in /users/name/www/includes/application_top.php on line 299
Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 129
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42
Warning: mysqli_errno() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42
-
select count(*) as total from sessions where sesskey = ''
[TEP STOP]

 

OK! Lets Google again :D

 

But i cannot find anything about that ... I have written this text at the support forum of my provider but i got no answer for a few days now...

 

Hope some expert can help me here :(

 

greetings!

 

EDIT:

Oh and i want to say: my host uses "MySQL 5.5, and PostgreSQL 9.1."

Link to comment
Share on other sites

@@The7thguest

 

 

Warning: require(includes/languages/.php) [function.require]: failed to open stream: No such file or directory in /users/name/www/includes/application_top.php on line 299 Fatal error: require() [function.require]: Failed opening required 'includes/languages/.php' (include_path='.') in /users/name/www/includes/application_top.php on line 299

 

This is language error. Your shop has no language. There would be several problem probably bad session.

 

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 129

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42

Warning: mysqli_errno() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /users/name/www/includes/functions/database.php on line 42

-

select count(*) as total from sessions where sesskey = ''

[TEP STOP]

 

Install the latest github package. https://github.com/osCommerce/oscommerce2 (at bottom of right side is download button)

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Link to comment
Share on other sites

  • 1 month later...

Hi Gergely,

 

i get the same problem

 

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in /homepages/14/d249473523/htdocs/osc_2-3-3/catalog/includes/functions/database.php on line 129

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /homepages/14/d249473523/htdocs/osc_2-3-3/catalog/includes/functions/database.php on line 42

 

after updating from 2-3-3-1 to 2-3-3-2.

I checked the update manual twice and found no hint.

Any ideas ?

 

Martin

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...