Fatal mysql error after install

[Martin Šinský]

Hello,
after install  i have this error:
"Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?)' at line 1. Failing Query: "SELECT l.language_id AS l__language_id, l.language AS l__language, l.locale AS l__locale, l.base AS l__base, l.active AS l__active FROM languages l WHERE (l.locale = ?)"' in /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Connection.php:1082 Stack trace: #0 /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'SELECT l.langua...') #1 /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(976): Doctrine_Connection->execute('SELECT l.langua...', Array) #2 /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(1026): Doctrine_Query_Abstract->_execute(Array) #3 /data/vhost in /data/vhosts/shine.izona.net/htdocs/library/Zend/Controller/Plugin/Broker.php on line 312"

can you help me, please?

[Shine Software]

Hi Martin,

thanks for testing ShineISP project. The error seems to me referred to the language var that it has not found . Try to add a querystring at the end of the shineisp url: http://shine.izona.net/?lang=en_EN

keep us updated!

Best regards

--
Free Code is really better than payed project code
---
Hai ricevuto questo messaggio perché sei iscritto al gruppo "ShineISP" di Google Gruppi.
Per annullare l'iscrizione a questo gruppo e non ricevere più i suoi messaggi, invia un'email a shineisp+u...@googlegroups.com.
Per postare messaggi in questo gruppo, invia un'email a shin...@googlegroups.com.
Visita questo gruppo all'indirizzo http://groups.google.com/group/shineisp?hl=it.
Per ulteriori opzioni, visita https://groups.google.com/groups/opt_out.
 
 

[Martin Šinský]

Hi, i have tried it and still the same.
When I try it with non existent csv file (for example with ?lang=cs_CZ), i got:
"Error opening translation file '/data/vhosts/shine.izona.net/htdocs/public/languages/cs_CZ.csv'"

Regards,
Martin


Dne středa, 30. ledna 2013 17:14:46 UTC+1 shinesoftware napsal(a):

[Martin Šinský]

Hi, i have tried it and still the same.
When I try it with non existent csv file (for example with ?
lang=cs_CZ), i got:
"Error opening translation file '/data/vhosts/shine.izona.net/htdocs/
public/languages/cs_CZ.csv'"

Regards,
Martin

On 30 led, 17:14, Shine Software <shinesoftw...@gmail.com> wrote:
> Hi Martin,
>
> thanks for testing ShineISP project. The error seems to me referred to
> the language var that it has not found . Try to add a querystring at the
> end of the shineisp url:http://shine.izona.net/?lang=en_EN
>
> keep us updated!
>
> Best regards
>

> Il 30/01/2013 17:09, Martin S(insk� ha scritto:
>
>
>
>
>
>
>
> > Hello,
> > after install  i have this error:

> > *"Fatal error*: Uncaught exception

> > 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[42000]:
> > Syntax error or access violation: 1064 You have an error in your SQL
> > syntax; check the manual that corresponds to your MySQL server version
> > for the right syntax to use near '?)' at line 1. Failing Query:
> > "SELECT l.language_id AS l__language_id, l.language AS l__language,
> > l.locale AS l__locale, l.base AS l__base, l.active AS l__active FROM
> > languages l WHERE (l.locale = ?)"' in
> > /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Connection.php:1082
> > Stack trace: #0
> > /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Connection.php(1025):
> > Doctrine_Connection->rethrowException(Object(PDOException),
> > Object(Doctrine_Connection_Mysql), 'SELECT l.langua...') #1
> > /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(976):
> > Doctrine_Connection->execute('SELECT l.langua...', Array) #2
> > /data/vhosts/shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(1026):
> > Doctrine_Query_Abstract->_execute(Array) #3 /data/vhost in

> > */data/vhosts/shine.izona.net/htdocs/library/Zend/Controller/Plugin/Broker.php*
> > on line *312*"

>
> > can you help me, please?
>
> > --
> > Free Code is really better than payed project code
> > ---

> > Hai ricevuto questo messaggio perch� sei iscritto al gruppo "ShineISP"
> > di Google Gruppi.
> > Per annullare l'iscrizione a questo gruppo e non ricevere pi� i suoi

[shinesoftware]

Hi Martin,

this message: "'Role 'guest' not found'" means that you have not executed the doctrine command by a linux shell:

Type this command: /var/www/shineisp/application/scripts/doctrine build-all-reload

Read this: http://www.shineisp.com/installing-shineisp/

Best regards

[Martin Šinský]

Hi,
I run it.
But i don't know why, at the end there is Segmentation fault:


./doctrine build-all-reload
PHP Warning: Module 'pam_auth' already loaded in Unknown on line 0
build-all-reload - Are you sure you wish to drop your databases? (y/n)
y
build-all-reload - Successfully dropped database for connection named
'doctrine'
build-all-reload - Successfully created database for connection named
'doctrine'
build-all-reload - Created tables successfully
Segmentation fault

Regards,
Martin

On 31 led, 10:41, shinesoftware <shinesoftw...@gmail.com> wrote:
> Hi Martin,
>
> this message: "'Role 'guest' not found'" means that you have not executed
> the doctrine command by a linux shell:
>

> Type this command: */var/www/shineisp/application/scripts/doctrine
> build-all-reload*

>
> Read this:http://www.shineisp.com/installing-shineisp/
>
> Best regards
>
> Il giorno mercoledì 30 gennaio 2013 17:14:46 UTC+1, shinesoftware ha
> scritto:
>
>
>
>
>
>
>
>
>
> >  Hi Martin,
>
> > thanks for testing ShineISP project. The error seems to me referred to the
> > language var that it has not found . Try to add a querystring at the end of
> > the shineisp url:http://shine.izona.net/?lang=en_EN
>
> > keep us updated!
>
> > Best regards
>
> > Il 30/01/2013 17:09, Martin Šinský ha scritto:
>
> > Hello,
> > after install  i have this error:

> > *"Fatal error*: Uncaught exception 'Doctrine_Connection_Mysql_Exception'

> > with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You
> > have an error in your SQL syntax; check the manual that corresponds to your
> > MySQL server version for the right syntax to use near '?)' at line 1.
> > Failing Query: "SELECT l.language_id AS l__language_id, l.language AS
> > l__language, l.locale AS l__locale, l.base AS l__base, l.active AS
> > l__active FROM languages l WHERE (l.locale = ?)"' in /data/vhosts/
> > shine.izona.net/htdocs/library/Doctrine/Connection.php:1082 Stack trace:
> > #0 /data/vhosts/
> > shine.izona.net/htdocs/library/Doctrine/Connection.php(1025):
> > Doctrine_Connection->rethrowException(Object(PDOException),
> > Object(Doctrine_Connection_Mysql), 'SELECT l.langua...') #1 /data/vhosts/
> > shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(976):
> > Doctrine_Connection->execute('SELECT l.langua...', Array) #2 /data/vhosts/
> > shine.izona.net/htdocs/library/Doctrine/Query/Abstract.php(1026):

> > Doctrine_Query_Abstract->_execute(Array) #3 /data/vhost in */data/vhosts/
> > shine.izona.net/htdocs/library/Zend/Controller/Plugin/Broker.php* on line
> > *312*"

[Shine Software]

Hi again,

Are you using caches? What kind of caches? What version of PHP?

thanks

[Martin Šinský]

Hi,
php 5.2.6,
in php is only loaded memcache, not any other.

Regards,
Martin

[Shine Software]

Try to disable the Memcache.

[Martin Šinský]

Didn't help, but i'm now testing shineisp on another server without
any trouble, so it looks that on the first server is some bad
configuration.

Regards,
Martin

[shine software]

Have you solved the problem?
If yes, please share your solution.

thanks