We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Get started

error 500 - Questions | Forum

« Back to plugin

« Back to forum topic list

dudi Apr 17 '15

i have this problem. (new version from oxwall 1.7.3)

Message: Undefined variable: userId File: /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/components/feed_item.php Line: 178

OW Debug - Exception

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 'AND `questionId` = '10' LIMIT 0, 1' at line 1 File: /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php Line: 707 Trace: #0 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php(707): PDOStatement->execute() #1 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array) #2 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'QUESTIONS_BOL_F...', Array, 0, Array) #3 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/bol/follow_dao.php(100): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/bol/service.php(519): QUESTIONS_BOL_FollowDao->findFollow(NULL, '10') #5 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/components/feed_item.php(178): QUESTIONS_BOL_Service->isFollow(NULL, '10') #6 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/renderable.php(233): QUESTIONS_CMP_FeedItem->onBeforeRender() #7 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/component.php(80): OW_Renderable->render() #8 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/components/feed_list.php(73): OW_Component->render() #9 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/renderable.php(233): QUESTIONS_CMP_FeedList->onBeforeRender() #10 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/component.php(80): OW_Renderable->render() #11 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/components/feed.php(131): OW_Component->render() #12 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/questions/components/feed.php(138): QUESTIONS_CMP_Feed->renderList() #13 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/renderable.php(233): QUESTIONS_CMP_Feed->onBeforeRender() #14 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/component.php(80): OW_Renderable->render() #15 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/renderable.php(258): OW_Component->render() #16 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/request_handler.php(274): OW_Renderable->render() #17 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/application.php(329): OW_RequestHandler->dispatch() #18 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/index.php(73): OW_Application->handleRequest() #19 {main} Type: PDOException

Sergey Kambalin Apr 19 '15

Hello,

Thank you for the bug report. I fixed the error and the fix will be included in the next update. If you do not want the update, you can apply the fix by yourself. Follow the link to GIT commit:

https://github.com/greyexpert/questions/commit/326ccceef0a4db1f5e791172422a92a565445a96

The Forum post is edited by Sergey Kambalin Apr 19 '15

W.C Jun 9 '16

hello,

i have the same issue!

at what time the new Version, with fix, will be released?

with best regards

John Nov 23 '16

I'm getting this 500 error message if I click on Questions -> My friends' questions

Type: Exception
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 'AND `questionId` = '24' LIMIT 0, 1' at line 1
File:[not reproduced]/public_html/ow_core/database.php
Line: 723
Trace: #0 [not reproduced]/public_html/ow_core/database.php(723): PDOStatement->execute() #1 [not reproduced]/public_html/ow_core/database.php(308): OW_Database->execute('SELECT * FROM o...', Array) #2 [not reproduced]/public_html/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'QUESTIONS_BOL_F...', Array, 0, Array) #3 [not reproduced]/public_html/ow_plugins/questions/bol/follow_dao.php(100): OW_BaseDao->findObjectByExample(Object(OW_Example)) #4 [not reproduced]/public_html/ow_plugins/questions/bol/service.php(519): QUESTIONS_BOL_FollowDao->findFollow(NULL, '24') #5 [not reproduced]/public_html/ow_plugins/questions/components/feed_item.php(178): QUESTIONS_BOL_Service->isFollow(NULL, '24') #6 [not reproduced]/public_html/ow_core/view.php(165): QUESTIONS_CMP_FeedItem->onBeforeRender() #7 [not reproduced]/public_html/ow_core/component.php(80): OW_View->render() #8 [not reproduced]/public_html/ow_plugins/questions/components/feed_list.php(73): OW_Component->render() #9 [not reproduced]/public_html/ow_core/view.php(165): QUESTIONS_CMP_FeedList->onBeforeRender() #10 [not reproduced]/public_html/ow_core/component.php(80): OW_View->render() #11 [not reproduced]/public_html/ow_plugins/questions/components/feed.php(131): OW_Component->render() #12 [not reproduced]/public_html/ow_plugins/questions/components/feed.php(138): QUESTIONS_CMP_Feed->renderList() #13 [not reproduced]/public_html/ow_core/view.php(165): QUESTIONS_CMP_Feed->onBeforeRender() #14 [not reproduced]/public_html/ow_core/component.php(80): OW_View->render() #15 [not reproduced]/public_html/ow_core/renderable.php(124): OW_Component->render() #16 [not reproduced]/public_html/ow_core/view.php(183): OW_Renderable->onRender() #17 [not reproduced]/public_html/ow_core/request_handler.php(258): OW_View->render() #18 [not reproduced]/public_html/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(QUESTIONS_CTRL_List)) #19 [not reproduced]/public_html/ow_core/application.php(346): OW_RequestHandler->dispatch() #20 [not reproduced]/public_html/index.php(76): OW_Application->handleRequest() #21 {main}

Can you help?
Thanks

Pascal Feb 8 '17

Hey John. I get the same error here.

Christopher Matchmaker Nov 2 '17

Thanks for Posting the fix, working well after applying the code to feed_item

You do not have permission to reply this topic

Oxwall Software

Please sign in

We build. You grow.

Start a social network, a fan-site, an education project with oxwall - free opensource community software

error 500 - Questions | Forum