Hi,
I'm moving siwapp to a nginx server and I'm having troubles. I install and when I access through the web throws an 500 error. Looking in the logs, it seems is a primary key violation but this doesn't happens in the original copy running in apache... I don't understand why this error occurs. Somebody knows this problem ?
The log is
2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'" while reading response header from upstream, client: II.PPP.II.PPP, server:
xxxxxxx.xxxxxx.com, request: "GET / HTTP/1.1", upstream: "fastcgi://
127.0.0.1:9000", host: "
xxxxxxx.xxxxxx.com"
2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082Stack trace:
#0 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/
xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server:
xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/css/screen.css HTTP/1.1", upstream: "fastcgi://
127.0.0.1:9000", host: "
xxxxxxx.xxxxxx.com", referrer: "
https://xxxxxxx.xxxxxx.com/"
2015/01/04 22:15:42 [error] 428#0: *90136 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082Stack trace:
#0 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/
xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server:
xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/images/sfTLogo.png HTTP/1.1", upstream: "fastcgi://
127.0.0.1:9000", host: "
xxxxxxx.xxxxxx.com", referrer: "
https://xxxxxxx.xxxxxx.com/"
2015/01/04 22:15:42 [error] 428#0: *90140 FastCGI sent in stderr: "PHP message: Action "sf/sf_default" does not exist.
PHP message: PHP Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxxxxx de xxxxxx xxxxxx' for key 'cstm_idx'' in /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php:1082Stack trace:
#0 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement))
#1 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(1042): Doctrine_Connection_Statement->execute(Array)
#2 /var/www/
xxxxxx.com/xxxxxxx/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php(687): Doctrine_Connection->exec('INSERT INTO cus...', Array)
#3 /var/www/
xxxxxx.com/xxxxxxx/lib/ven" while reading response header from upstream, client: II.PPP.II.PPP, server:
xxxxxxx.xxxxxx.com, request: "GET /sf/sf_default/images/icons/tools48.png HTTP/1.1", upstream: "fastcgi://
127.0.0.1:9000", host: "
xxxxxxx.xxxxxx.com", referrer: "
https://xxxxxxx.xxxxxx.com/"
And the NGINX config:
upstream dddddd_fffffffffff {
server
dddddd.fffffffffff.com;
}
server {
listen 80;
server_name
dddddd.fffffffffff.com;
rewrite ^(.*) https://$server_name$request_uri? permanent;
}
server {
listen 443 ssl;
server_name
dddddd.fffffffffff.com;
root /var/www/
fffffffffff.com/dddddd/web; ## <-- Your only path reference.
ssl_certificate /etc/nginx/ssl/server.crt;
ssl_certificate_key /etc/nginx/ssl/server.key;
gzip_static on;
location ~ ^/(index|frontend|frontend_dev|backend|backend_dev)\.php$ {
include fastcgi_params;
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_param PATH_TRANSLATED $document_root$fastcgi_path_info;
fastcgi_param HTTPS on;
fastcgi_pass
127.0.0.1:9000;
}
location / {
index index.php;
try_files $uri /index.php?$args;
}
access_log /var/log/nginx/dddddd.fffffffffff.com_access.log gzip buffer=32k;
error_log /var/log/nginx/dddddd.fffffffffff.com_error.log warn;
}
Thanks in advance !