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

Error 500, if user insert "tag" with the word that contain character " ' " - Advanced Blogs | Forum

Peter Nov 13 '15
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.
iDragon Solution Co., Ltd
We will check it then fix it soon.
Peter Nov 13 '15

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

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.
  oxwall_demo_blog_edit_bug.png (1075Kb)
You do not have permission to reply this topic