[SOLVED] Another Revo b5 upgrade error

PHP: v 5.2.9
MySQL: 5.0.67-community

I am trying to upgrade from b4 to b5. I overwrote all of the files properly and when I hit /manager, got a nasty error that was fixed by getting rid of session_name, session_cookie_path, session_cookie_domain and clearing the modx_session table.

However, when I go to /manager now, it presents the login screen, but when I type in my credentials, I get:

That account could not be located. Check the username and re-type the password to try again

I am absolutely certain I am typing the proper credentials. I thought I might have to go through /setup again, which presents a whole new set of problems.

When I hit the database step in /setup, Testing the database and Checking the database gets a big green "Success!", but then when I hit next I get this:

Warning: PDO::exec() [pdo.exec]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ’latin1_swedish_ci’ is not valid for CHARACTER SET ’utf8’ in /home/cbdweb54/public_html/colmanbrohandavis.com/core/xpdo/om/mysql/connect.inc.php on line 12

Warning: Cannot modify header information - headers already sent by (output started at /home/cbdweb54/public_html/colmanbrohandavis.com/core/xpdo/om/mysql/connect.inc.php:12) in /home/cbdweb54/public_html/colmanbrohandavis.com/setup/includes/modinstallrequest.class.php on line 98

So at this point, I can’t login and can’t run setup. Any suggestions?

Quote from: mr.johnny at Dec 16, 2009, 04:55 PM

I am absolutely certain I am typing the proper credentials. I thought I might have to go through /setup again, which presents a whole new set of problems.
When I hit the database step in /setup, Testing the database and Checking the database gets a big green "Success!", but then when I hit next I get this:

Warning: PDO::exec() [pdo.exec]: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ’latin1_swedish_ci’ is not valid for CHARACTER SET ’utf8’ in /home/cbdweb54/public_html/colmanbrohandavis.com/core/xpdo/om/mysql/connect.inc.php on line 12

Warning: Cannot modify header information - headers already sent by (output started at /home/cbdweb54/public_html/colmanbrohandavis.com/core/xpdo/om/mysql/connect.inc.php:12) in /home/cbdweb54/public_html/colmanbrohandavis.com/setup/includes/modinstallrequest.class.php on line 98

So at this point, I can’t login and can’t run setup. Any suggestions?

Whats the database collation of your database? It seems that it’s latin1_swedish_ci, and you’re trying to specify a charset_connection of utf8. You’ll need to set the charset to latin1 (in setup, the upgrade has the option to) to fix that.

Ty sir, that worked like a charm

I’ve seen that error a few times. Setup doesn’t always detect the charset correctly (in fact, I have one Latin1 install the comes up in setup as Big5, which I’ve never seen or used).

For obtuse manipulations which can be performed on MySql injections due to char set changes -- I usually use the same thing on every site and match that charset with the head of each template used for the pages. As I exclusively build sites for Americanized English (but sometimes link to other languages -- I don’t speak) I stay with the utf8_unicode_ci both as the entire MySql backend default connection set and the individual database and table settings.

Now, if "they" only considered my 9 programming languages as acceptable forms of communication....