AddHandler x-httpd-php5 .php
AddHandler x-httpd-php  .php4

Options +FollowSymLinks +ExecCGI

<IfModule mod_rewrite.c>
  RewriteEngine On

  # we skip all files with .something
  RewriteCond %{REQUEST_URI} \..+$
  RewriteCond %{REQUEST_URI} !\.html$
  RewriteRule .* - [L]

  # we check if the .html version is here (caching)
  RewriteRule ^$ index.html [QSA]
  RewriteRule ^([^.]+)$ $1.html [QSA]
  RewriteCond %{REQUEST_FILENAME} !-f

  # no, so we redirect to our front web controller
  RewriteRule ^(.*)$ web/index.php [QSA,L] 
</IfModule>

# big crash from our front web controller
ErrorDocument 500 "<h2>Application error</h2>symfony project failed to start properly"

RewriteRule ^(.*)$ web/index.php [QSA,L]

ini_set{'magic_quotes_gpc', 'Off') in index.php

php_flag magic_quotes_gpc off in .htaccess

magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
register_globals = Off

prod:
  .settings:
    no_relative_url:        on

AddHandler x-httpd-php5 .php
AddHandler x-httpd-php .php4

Options +FollowSymLinks +ExecCGI

<IfModule mod_rewrite.c>
  RewriteEngine On

  RewriteCond %{REQUEST_URI} /stats
  RewriteRule .* - [L]

  RewriteCond %{REQUEST_URI} !/web/
  RewriteRule ^(.*)$ web/$1

  # we skip all files with .something
  RewriteCond %{REQUEST_URI} \..+$
  RewriteCond %{REQUEST_URI} !\.html$
  RewriteRule .* - [L]

  # we check if the .html version is here (caching)
  RewriteRule ^$ index.html [QSA]
  RewriteRule ^([^.]+)$ $1.html [QSA]
  RewriteCond %{REQUEST_FILENAME} !-f

  # no, so we redirect to our front web controller
  RewriteRule ^(.*)$ index.php [QSA,L]
</IfModule>

# big crash from our front web controller
ErrorDocument 500 "<h2>Application error</h2>symfony application failed to start properly"

Symfony Project Created Congratulations! You have  uccessfully created your symfony project.

[PropelException]
[wrapped: Could not execute update [Native Error: Unknown system variable 'NAMES'] [User Info: SET NAMES utf8] [User Info: Array]]
stack trace

    * at ()
      in SF_ROOT_DIR/lib/symfony/vendor/propel/Propel.php line 484 ...
             481.             try {
             482.                 $con = Creole::getConnection($dsn);
             483.             } catch (SQLException $e) {
             484.                 throw new PropelException($e);
             485.             }
             486.             self::$connectionMap[$name] = $con;
             487.         }
    * at Propel::getConnection('propel')
      in SF_ROOT_DIR/lib/model/om/BaseProjectPeer.php line 157 ...

#      encoding:           utf8     # Default charset for table creation

define('SF_DEBUG',       true);

[PropelException]
[wrapped: connect failed [Native Error: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)] [User Info: Array]]
stack trace

    * at ()
      in SF_ROOT_DIR/lib/symfony/vendor/propel/Propel.php line 484 ...
             481.             try {
             482.                 $con = Creole::getConnection($dsn);
             483.             } catch (SQLException $e) {
             484.                 throw new PropelException($e);
             485.             }
             486.             self::$connectionMap[$name] = $con;
             487.         }
    * at Propel::getConnection('propel')
      in SF_ROOT_DIR/lib/model/om/BaseProjectPeer.php line 157 ...

prod:
  propel:
    param:
      host:               xxx.secureserver.net  # SQL server
      username:           sqlDatabaseUserName
      password:           sqlDatabaseUserPassword

all:
  propel:
    class:                sfPropelDatabase
    param:
      phptype:            mysql     # Database vendor
      hostspec:           xxx.secureserver.net  # SQL server
      database:           sqlDatabaseName  # in my case = sqlDatabaseUserName
      username:           sqlDatabaseUserName
      password:           sqlDatabaseUserPassword
      port:               3306
#      encoding:           utf8     # I had to comment this line 
      persistent:         true      # Use persistent connections

propel.targetPackage       = lib.model
propel.packageObjectModel  = true
; Next line is probably does not matter
propel.project             = sym_00 
propel.database            = mysql
propel.database.createUrl  = mysql://xxx.secureserver.net/
propel.database.url        = mysql://xxx.secureserver.net/

propel.addGenericAccessors = true
propel.addGenericMutators  = true
propel.addTimeStamp        = false

propel.schema.validate     = false

; directories
propel.home                    = .
; Next line depends on the web site name, see config.php
propel.output.dir              = /home/content/o/p/e/opencoreadmin/html

$sf_symfony_lib_dir  = '/home/content/o/p/e/opencoreadmin/html/lib/symfony';
$sf_symfony_data_dir = '/home/content/o/p/e/opencoreadmin/html/data/symfony';

Error

SQL query:

SET NAMES utf8

MySQL said: Documentation
#1193 - Unknown system variable 'NAMES' 

Options +FollowSymLinks +ExecCGI


AddHandler x-httpd-php5 .php
AddHandler x-httpd-php .php4

<IfModule mod_rewrite.c>
  RewriteEngine On

  # uncomment the following line, if you are having trouble
  # getting no_script_name to work
  #RewriteBase /

  # we skip all files with .something
  RewriteCond %{REQUEST_URI} \..+$
  RewriteCond %{REQUEST_URI} !\.html$
  RewriteRule .* - [L]

  # we check if the .html version is here (caching)
  RewriteRule ^$ index.html [QSA]
  RewriteRule ^([^.]+)$ $1.html [QSA]
  RewriteCond %{REQUEST_FILENAME} !-f

  # no, so we redirect to our front web controller
  RewriteRule ^(.*)$ /web/index.php [QSA,L]
#tried with RewriteRule ^(.*)$ web/index.php [QSA,L]
#too
</IfModule>

# big crash from our front web controller
ErrorDocument 500 "<h2>Application error</h2>symfony application failed to start properly"