When I go to do a full buddylist migration, I get a page full of "watchdog not locked" mysql errors. Here is one example:

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '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 'LIKE user_relationships' at line 1\nquery: CREATE TEMPORARY TABLE user_relationship_migration LIKE user_relationships in /home/www/mysite.com/includes/database.mysql.inc on line 174.', 2, '', 'http://mysite.com/admin/user/relationships/migrate', 'http://mysite.com/admin/user/relationships/migrate', '73.12.87.2', 1242259791) in /home/www/mysite.com/includes/database.mysql.inc on line 174

--
MySQL 4.0.26
PHP 4.3.8

Comments

alex.k’s picture

alex.k commented
Priority: Critical » Normal

Doesn't sound related to UR. You should, however, investigate the error watchdog was trying to report, i.e. error in 'create temporary table' SQL.

AppleBag’s picture

AppleBag commented

Ya think it might be due to my MYSQL version being a bit old? What is the minimum MYSQL version required by the module?

alex.k’s picture

alex.k commented

Not sure as this was written before I became maintainer. Please check the query and which parts may be unsupported. But yeah I'd upgrade to 5.x definitely.

stella’s picture

stella commented
Version: 5.x-2.x-dev » 6.x-1.0-rc3

I get a similar error:

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:230:\"Duplicate entry '2-74-1' for key 1\nquery: INSERT INTO user_relationships (requester_id, requestee_id, rtid, approved, created_at)\n SELECT requester_uid, requestee_uid, 1, 0, 1262530101 FROM buddylist_pending_requests\";s:5:\"%file\";s:167:\"/Applications/MAMP/htdocs/d6_dev_sites/sites/heystaks.localhost/modules/contrib-stable/user_relationships/user_relationship_migrate/user_relationship_migrate.mysql.inc\";s:5:\"%line\";i:16;}', 3, '', 'http://heystaks.localhost/admin/user/relationships/migrate', 'http://heystaks.localhost/admin/user/relationships/migrate in /Applications/MAMP/htdocs/d6_dev_sites/includes/database.mysqli.inc on line 128

It seems to be triggered by a duplicate insert into the user_relationships table. I'm using mysql 5.0.x

plan9’s picture

plan9 commented

I have the same issue - it stops the migration taking place.

plan9’s picture

plan9 commented
Version: 6.x-1.0-rc3 » 5.x-2.x-dev

I found that un-installing user relationships and installing the previous 5.x-1.0 release allowed me to successfully migrate from buddylist. After this I upgraded to the current user relations release.

You can get the old version here: http://ftp.drupal.org/files/projects/user_relationships-5.x-1.0.tar.gz

Hope this helps

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Closed (won't fix)

Sorry for pinging the participants.

Now that Drupal 7 is out, there is no support for Drupal 5 and the corresponding modules anymore. Therefore, I'm closing all old issues which are still open.

I suggest you upgrade to Drupal 6 or 7 and figure out if you're feature is still needed or the bug still exists and open a new issue in that case.