It seems, that plugin have a bug when inserting tags. If user insert "tag" with the word, that contain character " ' ", for example doll'z. It show server error 500, after publishing.
Post will remain published, but it can not be openned. (internal server error)
You can reproduce that bug, on your demo site too.
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Error 500, if user insert "tag" with the word that contain character " ' " - Advanced Blogs | Forum
Peter
Nov 13 '15
UPDATE:
error log output related to this issue, maybe it helps you to find the problem.
[Fri Nov 13 7:59:52 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 'z', 'on point')
AND `p`.`id` != 2955
ORDER BY `t`.`id`
LIMIT 0, 9' at line 7 File: /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php Line:720 Trace: [#0 /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php(720): PDOStatement->execute() | #1 /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php(341): OW_Database->execute('????SELECT DIST...', Array) | #2 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/bol/post_dao.php(185): OW_Database->queryForObjectList('????SELECT DIST...', 'ADVANCEDBLOGS_B...', Array) | #3 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/bol/post_service.php(127): ADVANCEDBLOGS_BOL_PostDao->findListByTags(''slink', 'maitr...', 0, 9, ' AND `p`.`id` !...') | #4 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/controllers/view.php(179): ADVANCEDBLOGS_BOL_PostService->findListByTags(''slink', 'maitr...', 0, 9, ' AND `p`.`id` !...') | #5 [internal function]: ADVANCEDBLOGS_CTRL_View->index(Array) | #6 /home/admin/web/mydomain.XYZ/public_html/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /home/admin/web/mydomain.XYZ/public_html/ow_core/application.php(342): OW_RequestHandler->dispatch() | #8 /home/admin/web/mydomain.XYZ/public_html/index.php(76): OW_Application->handleRequest() | #9 {main}]
error log output related to this issue, maybe it helps you to find the problem.
[Fri Nov 13 7:59:52 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 'z', 'on point')
AND `p`.`id` != 2955
ORDER BY `t`.`id`
LIMIT 0, 9' at line 7 File: /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php Line:720 Trace: [#0 /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php(720): PDOStatement->execute() | #1 /home/admin/web/mydomain.XYZ/public_html/ow_core/database.php(341): OW_Database->execute('????SELECT DIST...', Array) | #2 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/bol/post_dao.php(185): OW_Database->queryForObjectList('????SELECT DIST...', 'ADVANCEDBLOGS_B...', Array) | #3 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/bol/post_service.php(127): ADVANCEDBLOGS_BOL_PostDao->findListByTags(''slink', 'maitr...', 0, 9, ' AND `p`.`id` !...') | #4 /home/admin/web/mydomain.XYZ/public_html/ow_plugins/advancedblogs/controllers/view.php(179): ADVANCEDBLOGS_BOL_PostService->findListByTags(''slink', 'maitr...', 0, 9, ' AND `p`.`id` !...') | #5 [internal function]: ADVANCEDBLOGS_CTRL_View->index(Array) | #6 /home/admin/web/mydomain.XYZ/public_html/ow_core/request_handler.php(266): call_user_func_array(Array, Array) | #7 /home/admin/web/mydomain.XYZ/public_html/ow_core/application.php(342): OW_RequestHandler->dispatch() | #8 /home/admin/web/mydomain.XYZ/public_html/index.php(76): OW_Application->handleRequest() | #9 {main}]
Peter
Nov 13 '15
UPDATE:
It seems that is Oxwall core problem too.
If user insert "tag" with the word that contain character " ' ", for example doll'z. It publish the post correctly, post is openable BUT.... After editing the post again, text area and tag area is broken.
Look at the screenshot from Oxwall demo site - editing the blog post, after publishing. With the word doll'z as tag. Html editor gone, tag line doesnt work.
It seems that is Oxwall core problem too.
If user insert "tag" with the word that contain character " ' ", for example doll'z. It publish the post correctly, post is openable BUT.... After editing the post again, text area and tag area is broken.
Look at the screenshot from Oxwall demo site - editing the blog post, after publishing. With the word doll'z as tag. Html editor gone, tag line doesnt work.
You do not have permission to reply this topic
