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

synatx error when posting - Articles | Forum

Bob Brown
Bob Brown Sep 1 '15
Hello,


I'm getting this error when a news poster posted to our site. Is there a reasonable fix to this issue?


[Tue Sep 1 8:31:54 2015] [ow_core_log] [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 'em like bacon"', 'barack obama', 'black lives matter', 'deputy darren h. go' at line 7 File: /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php Line:707 Trace: [#0 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(707): PDOStatement->execute() | #1 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(341): OW_Database->execute('\n\t\t\tSELECT DIST...', Array) | #2 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_dao.php(404): OW_Database->queryForObjectList('\n\t\t\tSELECT DIST...', 'ARTICLES_BOL_Ar...', Array) | #3 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_service.php(170): ARTICLES_BOL_ArticleDao->findListByTags(''"pigs-in-...', 0, 10) | #4 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/controllers/view.php(175): ARTICLES_BOL_ArticleService->findListByTags(''"pigs-in-...', 0, 10) | #5 [internal function]: ARTICLES_CTRL_View->index(Array) | #6 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/application.php(329): OW_RequestHandler->dispatch() | #8 /var/www/vhosts/cprworldwidemedia.com/cprradio/index.php(73): OW_Application->handleRequest() | #9 {main}][Tue Sep 1 8:31:55 2015] [ow_core_log] [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 'em like bacon"', 'barack obama', 'black lives matter', 'deputy darren h. go' at line 7 File: /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php Line:707 Trace: [#0 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(707): PDOStatement->execute() | #1 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(341): OW_Database->execute('\n\t\t\tSELECT DIST...', Array) | #2 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_dao.php(404): OW_Database->queryForObjectList('\n\t\t\tSELECT DIST...', 'ARTICLES_BOL_Ar...', Array) | #3 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_service.php(170): ARTICLES_BOL_ArticleDao->findListByTags(''"pigs-in-...', 0, 10) | #4 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/controllers/view.php(175): ARTICLES_BOL_ArticleService->findListByTags(''"pigs-in-...', 0, 10) | #5 [internal function]: ARTICLES_CTRL_View->index(Array) | #6 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/application.php(329): OW_RequestHandler->dispatch() | #8 /var/www/vhosts/cprworldwidemedia.com/cprradio/index.php(73): OW_Application->handleRequest() | #9 {main}][Tue Sep 1 8:31:57 2015] [ow_core_log] [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 'em like bacon"', 'barack obama', 'black lives matter', 'deputy darren h. go' at line 7 File: /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php Line:707 Trace: [#0 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(707): PDOStatement->execute() | #1 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(341): OW_Database->execute('\n\t\t\tSELECT DIST...', Array) | #2 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_dao.php(404): OW_Database->queryForObjectList('\n\t\t\tSELECT DIST...', 'ARTICLES_BOL_Ar...', Array) | #3 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_service.php(170): ARTICLES_BOL_ArticleDao->findListByTags(''"pigs-in-...', 0, 10) | #4 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/controllers/view.php(175): ARTICLES_BOL_ArticleService->findListByTags(''"pigs-in-...', 0, 10) | #5 [internal function]: ARTICLES_CTRL_View->index(Array) | #6 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/application.php(329): OW_RequestHandler->dispatch() | #8 /var/www/vhosts/cprworldwidemedia.com/cprradio/index.php(73): OW_Application->handleRequest() | #9 {main}][Tue Sep 1 8:31:58 2015] [ow_core_log] [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 'em like bacon"', 'barack obama', 'black lives matter', 'deputy darren h. go' at line 7 File: /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php Line:707 Trace: [#0 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(707): PDOStatement->execute() | #1 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/database.php(341): OW_Database->execute('\n\t\t\tSELECT DIST...', Array) | #2 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_dao.php(404): OW_Database->queryForObjectList('\n\t\t\tSELECT DIST...', 'ARTICLES_BOL_Ar...', Array) | #3 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/bol/article_service.php(170): ARTICLES_BOL_ArticleDao->findListByTags(''"pigs-in-...', 0, 10) | #4 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_plugins/articles/controllers/view.php(175): ARTICLES_BOL_ArticleService->findListByTags(''"pigs-in-...', 0, 10) | #5 [internal function]: ARTICLES_CTRL_View->index(Array) | #6 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /var/www/vhosts/cprworldwidemedia.com/cprradio/ow_core/application.php(329): OW_RequestHandler->dispatch() | #8 /var/www/vhosts/cprworldwidemedia.com/cprradio/index.php(73): OW_Application->handleRequest() | #9 {main}]



Regards,


Bobby,.


What could also be causing this issue?


iDragon Solution Co., Ltd
we will fix it soon.

To be worked properly, please go to each article detaile, edit it, then clean the tag without quote like "" or ''
Bob Brown
Bob Brown Sep 1 '15
Hello,


Thanks and can't edit it from the front end like that, would it be possible to do this from the database end? 


Regards,


Bobby

iDragon Solution Co., Ltd
it's now fixed. Please download the new update on store then overwrite on your host.
Bob Brown
Bob Brown Sep 2 '15
Hello,


Sweet, also is it possible to implement something that will align photos and text right? Or a way to make the header image smaller with it being so big?


Regards,


Bobby

You do not have permission to reply this topic