mysqli_real_escape_string error and no idea how to fix

[The7thguest]

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."

[tgely]

@@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)

[The7thguest]

wow that was a kind of easy hm? :lol:

 

It works perfectly. Thank you so much Gergely :thumbsup:

[Flinspach]

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

[Flinspach]

Hi Gergely,

 

I localized the problem : addon # 7704, Ultimate_Seo_Urls_5_PRO_r205, is installed.

With this addon disabled the error disappears, with this addon enabled the error occurs.

 

Any ideas ?

 

Martin

[Flinspach]

Hi Gergely,

 

try to fix the problem in the forum topic for addon # 7704:

http://www.oscommerce.com/forums/topic/336702-ultimate-seo-urls-5-by-fwr-media/page__st__3920

 

Martin