problem with similar error: Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message '

[tadas andriuska]

hello, i ran this:

[root@srv01 scripts]# ./doctrine build-all-rebuild

The task "build-all-rebuild" has not been registered

Doctrine Command Line Interface

./doctrine build-all-reload

./doctrine compile

./doctrine create-tables

./doctrine dump-data

./doctrine rebuild-db

./doctrine load-data

./doctrine generate-yaml-db

./doctrine build-all

./doctrine generate-migrations-models

./doctrine drop-db

./doctrine generate-migrations-diff

./doctrine generate-sql

./doctrine generate-migrations-db

./doctrine generate-migration

./doctrine build-all-load

./doctrine generate-models-db

./doctrine migrate

./doctrine create-db

./doctrine dql

./doctrine generate-yaml-models

./doctrine generate-models-yaml

But database i set in config.xml is empty. and when i visit my web page i get this error:
Fatal error: Uncaught exception 'Doctrine_Connection_Mysql_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zadmin_bb.admin_roles' doesn't exist. Failing Query: "SELECT a.role_id AS a__role_id, a.name AS a__name FROM admin_roles a ORDER BY a.role_id desc"' in /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/library/Doctrine/Connection.php:1082 Stack trace: #0 /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/library/Doctrine/Connection.php(1025): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Mysql), 'SELECT a.role_i...') #1 /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/library/Doctrine/Query/Abstract.php(976): Doctrine_Connection->execute('SELECT a.role_i...', Array) #2 /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/library/Doctrine/Query/Abstract.php(1026): Doctrine_Query_Abstract->_execute(Array) #3 /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/application/models/AdminRoles.php(195): Doctrine_Q in /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/library/Doctrine/Connection.php on line 1082

[shine software]

Hi,

the procedure has been deprecated. You have to use the setup wizard look at http://www.shineisp.com/setup-installation-released/

Best Regards

[tadas andriuska]

so the problem was that i was using not root user for mysql but user for database i set up in config.xml. somehow install didint wanted to work with that user. after i changed the config.xml to root user database was filled with info, but now i have another error: 

string(161) "Error on saving the xml file in /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/application/configs/config.xml <br/>Please check the folder permissions". application/config and public dir, but still same thing. i dont want to chmod all var dir.

i have chmod 777

im using zpanel as my hosting control panel to manage dns , ftp and other stuff.

Thanks,   

  Tadas

[shine software]

You have to set /application/configs/ as writtable.
Check which is the user that runs apache and set the right permission.

In order to execute ShineISP you have to set these following folders as writable:

• /application/configs
• /public

Regards

[tadas andriuska]

they are set as writable. does it makes difference if i have uploaded to my server using git clone and not downloaded zip to my computer and uploaded extracted content to server ?

[Shine Software Staff]

No, there is not any difference. which is the error?

Il 09/05/13 21:32, tadas andriuska ha scritto:

--
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.
 
 

[tadas andriuska]

error is the same:

string(161) "Error on saving the xml file in /var/zpanel/hostdata/zadmin/public_html/hostingas_abit_lt/application/configs/config.xml <br/>Please check the folder permissions"

you can see it by visiting my test page: http://hostingas.abit.lt/ .

[Shine Software Staff]

So the solution is the same. You have to check if the apache has been started with a specific user.
The error is clear. Have you tried to set the /application/configs directory as 775?
Have you a shell access? I can see it for you.

Regard

Il 09/05/13 21:40, tadas andriuska ha scritto:

[tadas andriuska]

my problem was, that when i ran git clone it had created all files and folders with wit root owner, so what i have to do was run "chown -R apache:apache directory/" and now i can see instalation window.

[Shine Software Staff]

Good I have updated the documentation. Thanks!
http://www.shineisp.com/setup-installation-released/

Il 10/05/13 09:08, tadas andriuska ha scritto:

--