sql_mode = ''

Hi

I've been using Affiliatefeeds for a while and love it!

Im just trying to setup a new site on a different server, which all works well until I try to Import Data when I get the following message...


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 'sql_mode = ''' at line 1
SET @@SESSION sql_mode = ''



Everything else look as though it works ok it's just the Import that goes wrong. Any thoughts?

typo, not many are using php-mysql any more so it remained unnoticed

please check the file administrator/components/com_datafeeds/cron/mysql.php

there is a line with SET @@SESSION sql_mode:
either remove that line or remove the @@
or add a dot between SESSION and sql

corrected file svn.brambring.nl/svn/xmlstuff/datafeeds/...admin/cron/mysql.php

Great - Thanks for the quick and perfect reply.

It's working great.