[sllik]

wierd.. what mysql version do you have?

Originally Posted by hollosch

Hi,
I get the following database-errors when mapping the data. I turned on the "Import User Data From Facebook" option:

Datenbankfehler in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:

                                INSERT INTO vb3_fbdatamap
                                (vbfield, fbfield) VALUES ('avatarurl', 'pic')
                                ON DUPLICATE KEY UPDATE fbfield = 'pic';

MySQL-Fehler  : 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 'ON DUPLICATE KEY UPDATE fbfield = 'pic'' at line 3
Fehler-Nr.    : 1064

Datenbankfehler in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:

                                INSERT INTO vb3_fbdatamap
                                (vbfield, fbfield) VALUES ('field2', 'affiliations')
                                ON DUPLICATE KEY UPDATE fbfield = 'affiliations';

MySQL-Fehler  : 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 'ON DUPLICATE KEY UPDATE fbfield = 'affiliations'' at line 3
Fehler-Nr.    : 1064

What is the problem?