Forgot?

SQL Error in Watches

Reply Topic
Link to this post 30 Mar 11

First of all, I want to say a big thank you for NinjaBoard, loving it! :)

I get a SQL 1064 error on the Watches item. This happens when filtering the watches and I get the following:

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 `tbl`.`created_by` = '20' ORDER BY `created_on` DESC LIMIT 0 , 20' at line 1 of the following query : SELECT `tbl`.* FROM `njsc_ninjaboard_subscriptions` AS `tbl` WHERE `tbl`.`subscription_type` = AND `tbl`.`created_by` = '20' ORDER BY `created_on` DESC LIMIT 0 , 20

I had this on the 1.06 Stable and then found the 1.07 build 1651 linked in the forum when I was searching for email notifications (that's working fine btw)

I'll disable my menu item to watches for now and hopefully see this looked at in a future update.

Once again, thanks for the fine work!

Link to this post 30 Mar 11

Hi Sentinet,

Pretty sure this is now fixed, Stian is busily working on the next update, but i will jsut mention to him in passing (just in case)

thanks for letting us know

Richie

Forums Joomla Extension Support NinjaBoard SQL Error in Watches