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