Jump to content


Issue information

  • #032408

  • Fixed

  • 2.4.0

  • 2.4.1

  • 0 - None Assigned


Issue Confirmations

  • Yes (1)No (0)
Photo

Can't delete blog entry

Posted by bfarber on 04 August 2011 - 12:34 PM

 Date: Thu, 04 Aug 2011 17:31:51 +0000

 Error: 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 comment_approved=1 ORDER BY comment_id DESC LIMIT 0,20' at line 1

 IP Address: xxxxx - /index.php?app=blog&module=post&section=mod&do=dodelentry&entryid=6414&blogid=3774&auth_key=efefe219b44ba0e7e4e024c56d594cde

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 mySQL query error: SELECT comment_id, entry_id, comment_date, member_name, member_id FROM ibf_blog_comments c WHERE entry_id IN () AND comment_approved=1 ORDER BY comment_id DESC LIMIT 0,20

 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

 | File																   	| Function																  	| Line No.	  	|

 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

 | admin/applications_addon/ips/blog/sources/classes/blogFunctions.php		| [blogFunctions].fetchBlogComments										 	| 860		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/sources/classes/blogFunctions.php		| [blogFunctions].rebuildBlog											   	| 2573		  	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/post/mod.php		  	| [blogFunctions].deleteEntries											 	| 333		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/post/mod.php		  	| [public_blog_post_mod].deleteEntry											| 95				|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/sources/base/ipsController.php								   	| [public_blog_post_mod].doExecute										  	| 302		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


Also see these in the logs


Date: Thu, 04 Aug 2011 03:10:28 +0000

 Error: 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 ') ORDER BY comment_id DESC LIMIT 0,5' at line 1

 IP Address: xxxxx - /index.php?app=blog&module=manage&act=create

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 mySQL query error: SELECT * FROM ibf_blog_comments c WHERE entry_id IN () ORDER BY comment_id DESC LIMIT 0,5

 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

 | File																   	| Function																  	| Line No.	  	|

 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [blogFunctions].fetchBlogComments										 	| 71				|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [public_blog_manage_dashboard]._actDashboard							  	| 161		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [public_blog_manage_dashboard]._actCreate								 	| 51				|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/sources/base/ipsController.php								   	| [public_blog_manage_dashboard].doExecute								  	| 302		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date: Thu, 04 Aug 2011 03:10:16 +0000

 Error: 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 ') ORDER BY comment_id DESC LIMIT 0,5' at line 1

 IP Address: xxxxx - /index.php?app=blog&module=manage&act=create

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 mySQL query error: SELECT * FROM ibf_blog_comments c WHERE entry_id IN () ORDER BY comment_id DESC LIMIT 0,5

 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

 | File																   	| Function																  	| Line No.	  	|

 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [blogFunctions].fetchBlogComments										 	| 71				|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [public_blog_manage_dashboard]._actDashboard							  	| 161		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/applications_addon/ips/blog/modules_public/manage/dashboard.php  	| [public_blog_manage_dashboard]._actCreate								 	| 51				|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 | admin/sources/base/ipsController.php								   	| [public_blog_manage_dashboard].doExecute								  	| 302		   	|

 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

changed status to: Fixed
changed fixed-in version to: 2.4.1

The same problem happens to me when using IP.Board 3.1.4 with latest version of IP.Blog with it. Please is there a fix you can share?


That's quite an old bug and a lot has changed, your best option would be to upgrade but submit a ticket and we will try to take a look.






1 user(s) are reading this issue

0 members, 1 guests, 0 anonymous users