John H wrote:
I'm running 0.7.3 and I've setup the facebook application. The problem
I'm having is that it throws a DB error. I click on the FB app in FB
and it goes to my site and says you must login and then it says do you
want to update FB: okay, skip. No matter which one I select it takes
me back to my web site login page and then throws a 500 error code. I
then look in my log files and it gives me a DB error. Looks like it's
trying to write the same info to the database twice.

2009-06-08 04:48:08 LOG_ERR: PEAR error: DB Error: already exists :
INSERT INTO foreign_link (user_id , foreign_id , service , noticesync
, friendsync , profilesync , created ) VALUES ( 1 ,  100000012650219 ,
 2 ,  1 ,  0 ,  0 , '2009-06-08 04:48:08' )  [nativecode=1062 **
Duplicate entry '1-2147483647-2' for key 1]

John,

I think this might be because Facebook started using 64-bit user IDs for new users (e.g.: 100000012650219) and Laconica isn't able to handle them yet. I'll try to get a patch for that into the 0.7.4 release. The fix is to make the foreign_id column use MySQL's BIGINT data type.

Zach




_______________________________________________
Laconica-dev mailing list
[email protected]
http://mail.laconi.ca/mailman/listinfo/laconica-dev

Reply via email to