Database Error after posting content

[tezgno]

Hello:

I am running Beta 2 of the software. After I post a news article and attempt to view it, I get the following:

Error message :
A database related error has occured

I can see the subject matter of the message and can even edit it, but if I try to view it, it gives me this error. Where can I check to determine what is causing it? Thanks.

[mayorbrain]

I am not able to replicate this issue.
Please can I have the complete error message. You can do this by following this steps:

- First try reproducing the error
- Immediately you see the error, go to your database
- select precurio database
- select logs table
- go to the last record in the logs table
- copy the contents of the message field (this is the complete error message).

[tezgno]

Here is the entry from the last log entry in the DB:

Code:

exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION precurio.concat does not exist' in /var/www/clients/client1/web3/web/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/clients/client1/web3/web/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/clients/client1/web3/web/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#3 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#4 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select), Array)
#5 /var/www/clients/client1/web3/web/application/cms/models/vo/Content.php(249): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#6 /var/www/clients/client1/web3/web/application/cms/controllers/ViewController.php(80): Content->getSharedUsers()
#7 /var/www/clients/client1/web3/web/library/Zend/Controller/Action.php(513): Cms_ViewController->detailsAction()
#8 /var/www/clients/client1/web3/web/library/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('detailsAction')
#9 /var/www/clients/client1/web3/web/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /var/www/clients/client1/web3/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#11 /var/www/clients/client1/web3/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#12 /var/www/clients/client1/web3/web/public/index.php(42): Zend_Application->run()
#13 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION precurio.concat does not exist' in /var/www/clients/client1/web3/web/library/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /var/www/clients/client1/web3/web/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)
#3 /var/www/clients/client1/web3/web/library/Zend/Db/Adapter/Abstract.php(706): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select), Array)
#4 /var/www/clients/client1/web3/web/application/cms/models/vo/Content.php(249): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#5 /var/www/clients/client1/web3/web/application/cms/controllers/ViewController.php(80): Content->getSharedUsers()
#6 /var/www/clients/client1/web3/web/library/Zend/Controller/Action.php(513): Cms_ViewController->detailsAction()
#7 /var/www/clients/client1/web3/web/library/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('detailsAction')
#8 /var/www/clients/client1/web3/web/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#9 /var/www/clients/client1/web3/web/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#10 /var/www/clients/client1/web3/web/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#11 /var/www/clients/client1/web3/web/public/index.php(42): Zend_Application->run()
#12 {main}

[mayorbrain]

That error indicates that you do your mysql server does not support CONCAT function. This means you are using an older version of the mysql server.
Precurio requires mysql server 5.1 at minimum to run properly, please upgrade.

[tezgno]

I will do that in the morning when I get in.

On another note, if the software requires mySQL 5.1, which is perfectly fine, then you should specify that on the requirements page. On the requirements page, it specifies that you need 5.X, to which mySQL 5.0 is in that category.

[mayorbrain]

Sorry about that. will update in future versions.
Thank you.

[tezgno]

Just as an update, I upgraded to mySQL 5.1 and that seems to have fixed the problem. Thanks again for the help.