Page 1 of 1

Install Problem to 1.9 - Production Site Down

Posted: Wed May 18, 2011 9:12 pm
by 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

Re: Install Problem to 1.9 - Production Site Down

Posted: Wed May 18, 2011 9:16 pm
by Jos
Why not try to install latest version 1.9.4.1?

Re: Install Problem to 1.9 - Production Site Down

Posted: Wed May 18, 2011 9:26 pm
by 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.

Re: Install Problem to 1.9 - Production Site Down

Posted: Wed May 18, 2011 9:36 pm
by Jos
paulag wrote: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 :D

Hope your site gets up and running now

Re: Install Problem to 1.9 - Production Site Down

Posted: Wed May 18, 2011 9:39 pm
by 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!

Re: Install Problem to 1.9 - Production Site Down

Posted: Thu May 26, 2011 2:54 am
by replytomk3
paulag wrote: 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.

Re: Install Problem to 1.9 - Production Site Down

Posted: Thu May 26, 2011 2:13 pm
by 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).