Install Problem to 1.9 - Production Site Down

[paulag]

Based on suggestions to earlier request I installed 1.9 and am now dead in the water with the following errors:


Warning: mysqli_real_escape_string() [function.mysqli-real-escape-string]: invalid object or resource mysqli in /usr/www/users/artweiss/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc on line 187

Warning: mysqli_real_escape_string() [function.mysqli-real-escape-string]: invalid object or resource mysqli in /usr/www/users/artweiss/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc on line 187

Warning: mysqli_real_escape_string() [function.mysqli-real-escape-string]: invalid object or resource mysqli in /usr/www/users/artweiss/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc on line 187

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/artweiss/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc:187) in /usr/www/users/artweiss/lib/misc.functions.php on line 224

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/artweiss/lib/adodb_lite/adodbSQL_drivers/mysqli/mysqli_driver.inc:187) in /usr/www/users/artweiss/lib/misc.functions.php on line 225

I am running MySQL 5.0.9
Php 5.3

This is a production website that is now down, so all replies welcome.

Thanks
-Paula

[Jos]

Why not try to install latest version 1.9.4.1?

[paulag]

That IS what I am installing. Latest version.

I believe I found an answer deep in an OLD post many versions ago.

It throws errors if you choose other than mySQL(compatibility) from the install screen which makes no sense.

I hope this is the end of the errors. I hate upgrading this site because everytime I do it is like a small mystery why something does not work or names of things change to customizations, etc.

[Jos]

I believe I found an answer deep in an OLD post many versions ago.

It throws errors if you choose other than mySQL(compatibility) from the install screen which makes no sense.

I guess that could be it. Why choose something else when you are running MySQL

Hope your site gets up and running now

[paulag]

I chose the MySQL 4.1 option because the host suggested it. Otherwise I would not have chosen differently.

Have you ever encountered weird characters showing up in the content post-upgrade? For example:

.
 


? Is that a problem that was there before but not appearing (based on how user inputted content) or something related to upgrade?

Thanks again for your response. Appreciate it!

[replytomk3]

Have you ever encountered weird characters showing up in the content post-upgrade? For example:

.
 


? Is that a problem that was there before but not appearing (based on how user inputted content) or something related to upgrade?

Database character encoding is specified incorrectly in config.php.

[paulag]

Yes I did experience some of that. Most I could just manually change on the page content (it was minimal, thankfully). Not sure if it is related to the CMS upgrade or the host SQL upgrade though. I"ve experienced it before on Wordpress and had to literally do search and replace throughout all the content in the DB (no fun).