Forgot your password?
Forgot your username?
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?
Please Log in to join the conversation.
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
Great - Thanks for the quick and perfect reply.
It's working great.