Can't install 2.1.2. Get no collation option

Hi

When I try to install Revo 2.1.2 on my ISP i can’t get it to even install.

Database type: mysql sqlsrv
Database host: mydomain.se.mysql (yes one.com has this structure)
Database login name: mydomain_se
Database password: xxxxxxx
Database name: mydomain_se
Table prefix: modx_
→ Test database server connection and view collations.

Connecting to database server: Success!

- Checking MySQL server version: OK! Running: 5.0.51a-24+lenny5-log
- Checking MySQL client version: OK! Running: 5.0.51a


But it does not populate any data below:
Connection character set: (This is empty and can not choose another value)
Collation: (This is empty and can not choose another value)


→ Create or test selection of your database.

Checking database: MODX could not create your database. Please manually create your database and then try again.

Anyone seen this?
/M

mysql 5.0.51 is not supported by Revolution bad PDO driver

Hope that helps

Checkout REVO requirements http://rtfm.modx.com/display/revolution20/MySQL+5.0.51+Issues

Ohh alright, I have missed that.

I take evolution then

Thanks for the quick answer

/M

With Evo, you’ll get unexpected results from Ditto and other snippets with that version of MySQL; the version of MySQL has known grouping and ordering bugs.

Ohh thats no good, I have to get a upgraded server then och switch company

/Martin

Hi there. I've tried installing 2.2.9-PL for the last 3 hours and getting no where fast.

I'm running SQLServer2005 and PHP5 is set up correctly and running. The spot I'm stuck on is the "Connection Information" page where you select your database type etc. I've already created an empty database called "modx" and login name "modx", plus granted it every permission possible. I have tried the following settings:

Database host: "local", "localhost", "SIMON-PC\Simon" (ie. SQL Server instance Name), "SIMON\PC", "127.0.0.1,1433"

And Database Login Name: "SIMON-PC\Simon_modx", "modx", "SIMON-PC_modx", "Simon-PC_modx", "Simon_modx"

And unfortunately all I am getting is "Connecting to database server:"

There doesn't appear to be a folder called "corec\cache\logs" so I can not find any issues.

Your help would be much appreciated

Cheers,
Simon

The only things I can think of to suggest are using a username other than 'modx' and making sure there is no punctuation in your passwords -- just alphanumeric characters and not starting with a number.

Another possibility is a missing or corrupted file in the install. This is fairly common if you transfer the files individually with FTP.

Quote from: BobRay at Sep 30, 2013, 04:28 AM

The only things I can think of to suggest are using a username other than 'modx' and making sure there is no punctuation in your passwords -- just alphanumeric characters and not starting with a number.

Another possibility is a missing or corrupted file in the install. This is fairly common if you transfer the files individually with FTP.

Thanks BobRay.
Ok so I renamed the database and username and tried using the installmodx.php option. This then created an install log under "C:\Inetpub\wwwroot\ModXRevolution3\core\cache\logs" with the following:

[2013-09-30 19:17:37] (ERROR in xPDOConnection::connect @ C:\Inetpub\wwwroot\ModXRevolution3\core\xpdo\xpdo.class.php : 3031) SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

[2013-09-30 19:17:38] (ERROR) Could not connect to database server: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

How can I make SQL Server accept the connection? I've set every permission on the database to "Grant" and for the database user I've also granted every permission under Server Roles as well as User Mapping.

Thanks again for your continued assistance.
Simon

Try a simple PHP connection. There may be something wrong with the database configuration. use a dbtest.php file in your web root for testing.
http://www.php.net/manual/en/function.mysqli-connect.php

Thanks sotwell.

Tried that and I'm still getting an error of "No connection could be made because the target machine actively refused it."

I can't for the life of me figure out how to make SQL Server accept the connection. I run ColdFusion on this same development server and connections work to the server every time, including even creating a test connection to this database to test it.