* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ON" at character 88 in /home/forum/drupal-6.9/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO fbconnect_users (uid, fbuid, timestamp) VALUES (3, 1205229234, 1234960723) ON DUPLICATE KEY UPDATE uid = 3 in /home/forum/drupal-6.9/sites/all/modules/fbconnect/fbconnect.module on line 375.
* Association failed

CommentFileSizeAuthor
#4 fbconnect.376239.patch2.41 KBjaydub
#3 fbconnect.376239.patch1.9 KBjaydub

Comments

LaNets’s picture

LaNets commented
Status: Active » Patch (to be ported)

The lastest Dev version include à fix for this bug.
Thanks for reporting.

wa2nlinux’s picture

wa2nlinux commented

Same error is still show up

jaydub’s picture

jaydub commented
Title: postgres error » PostgreSQL error (MySQL specific statements used)
Status: Patch (to be ported) » Needs review
StatusFileSize
new fbconnect.376239.patch1.9 KB

The example reported above failed on PostgreSQL because the SQL used is MySQL specific (ON DUPLICATE UPDATE). However it's been replaced in the current -dev with another MYSQL specific statement REPLACE (and in another place REPLACE INTO). The attached patch addresses these two queries by simply using a DELETE and INSERT statement pair.

jaydub’s picture

jaydub commented
StatusFileSize
new fbconnect.376239.patch2.41 KB

Re-rolled with another query modified for compatibility

wa2nlinux’s picture

wa2nlinux commented

Patch aplied ...seem working well

budda’s picture

budda
Primary language English
Location Cheshire
commented
Assigned: Unassigned » budda
Status: Needs review » Reviewed & tested by the community

Tested against MySQL to ensure nothing has been broken.
Seems fine.

Ready for commit.

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Reviewed & tested by the community » Fixed

Committed to CVS.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.