Asset page doesnt work

4 replies [Last post]
Offline
Joined: 2009-06-15
Posts: 7

Hardware: Virtual Host provide by Vmware ESXi
Operating System: Linux CentOS 5.3 64
AMP Stack: Apache 2.2.8, MySQL 5.0.45, Php 5.2.6
OpenFISMA version: The last, 2.3

Hi, I´ve just install OpenFisma and when I access Assets menu this error occurs

"An unexpected error has occurred. This error has been logged for administrator review.

You may want to try again in a few minutes. If the problem persists, please contact your administrator.
"

There isn´t log in error or access file. Is there another step that I can take to fix this.

Tks

Offline
Joined: 2009-04-16
Posts: 89
RE: Asset page doesnt work

"'lferla' pid='32' dateline='1247845059'" wrote:

Hardware: Virtual Host provide by Vmware ESXi
Operating System: Linux CentOS 5.3 64
AMP Stack: Apache 2.2.8, MySQL 5.0.45, Php 5.2.6
OpenFISMA version: The last, 2.3

Hi, I´ve just install OpenFisma and when I access Assets menu this error occurs

"An unexpected error has occurred. This error has been logged for administrator review.

You may want to try again in a few minutes. If the problem persists, please contact your administrator.
"

There isn´t log in error or access file. Is there another step that I can take to fix this.

Tks

Can you post the log file? It is stored in //data/logs/error.log

If I can see the error log I can probably tell you what went wrong.

Offline
Joined: 2009-06-15
Posts: 7
RE: Asset page doesnt work

Tks about help, follow the log.

2009-07-17T12:51:10-03:00 ERR (3): Mysqli prepare error: 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 3
#0 /var/www/html/openfisma/library/Zend/Db/Statement.php(109): Zend_Db_Statement_Mysqli->_prepare('SELECT `a`.`nam...')
#1 /var/www/html/openfisma/library/Zend/Db/Adapter/Mysqli.php(343): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `a`.`nam...')
#2 /var/www/html/openfisma/library/Zend/Db/Adapter/Abstract.php(429): Zend_Db_Adapter_Mysqli->prepare('SELECT `a`.`nam...')
#3 /var/www/html/openfisma/library/Zend/Db/Adapter/Abstract.php(700): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#4 /var/www/html/openfisma/application/controllers/AssetController.php(278): Zend_Db_Adapter_Abstract->fetchCol(Object(Zend_Db_Select))
#5 /var/www/html/openfisma/library/Zend/Controller/Action.php(494): AssetController->searchboxAction()
#6 /var/www/html/openfisma/library/Zend/Controller/Dispatcher/Standard.php(285): Zend_Controller_Action->dispatch('searchboxAction')
#7 /var/www/html/openfisma/library/Zend/Controller/Front.php(934): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#8 /var/www/html/openfisma/public/index.php(54): Zend_Controller_Front->dispatch()
#9 {main}
by root(1) from 192.168.80.61

Offline
Joined: 2009-07-14
Posts:
RE: Asset page doesnt work

Your problem maybe the "Systems" is null, you should add some systems under the Administrator menu.

Offline
Joined: 2009-06-15
Posts: 7
RE: Asset page doesnt work

Perfect!!!! It works now. Tks so much