I'm assuming this is because I'm running a MySQL 4 database but I have not seen anywhere in here anything about MySQL 4 giving any issues (Only saw a post about running PHP 5 which I am indeed running.)
Here's my issue, clicking on the "Connect with Facebook" button does nothing.
In Data Mapping, if I try to associate any vBulletin Field with any facebook Field I receive a database error. Here is one of the errors for example:
Code:
Database error in vBulletin 3.8.2:
Invalid SQL:
INSERT INTO fbdatamap
(vbfield, fbfield) VALUES ('field1', 'uid')
ON DUPLICATE KEY UPDATE fbfield = 'uid';
MySQL Error : 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 = 'uid'' at line 3
Error Number : 1064
Request Date : Thursday, June 4th 2009 @ 06:03:41 PM
Error Date : Thursday, June 4th 2009 @ 06:03:41 PM
Script : http://www.brain-spew.com/forums/admincp/fbconnect_datamap.php?do=save
Referrer : http://www.brain-spew.com/forums/admincp/fbconnect_datamap.php
IP Address : xxx.xxx.xxx.xxx
Username : 350Chevy
Classname : vB_Database
MySQL Version : 4.0.27-max-log
Sorry, I've been out of the loop for a while and used to code a bit but now I'm old and forgetful.
Does this mean I need to convert my DB to MySQL 5? Or is this something simple. TIA