I just started using this module and everything is fine until I uncheck any item, then I get something similar to the following: -

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_QnVzaW5lc3MgT3duZXIgR29hbHM=_pro' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_QnVzaW5lc3MgT3duZXIgR29hbHM=_profile', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_QmlvZ3JhcGhpY2FsIEluZm9ybWF0aW9u' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_QmlvZ3JhcGhpY2FsIEluZm9ybWF0aW9u_profile', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_U2VydmljZSBQcm92aWRlciBHb2Fscw==' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_U2VydmljZSBQcm92aWRlciBHb2Fscw==_profile', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_Q29udGFjdCBJbmZv_contactinformat' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_Q29udGFjdCBJbmZv_contactinformation', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_Q29tcGFueSBQcm9maWxl_companyprof' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_Q29tcGFueSBQcm9maWxl_companyprofile', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_U3Vic2NyaXB0aW9uIFN0YXR1cw==_sub' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_U3Vic2NyaXB0aW9uIFN0YXR1cw==_subsciptions', 'i:1;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

Warning: Table 'eb1_watchdog' was not locked with LOCK TABLES query: INSERT INTO eb1_watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Duplicate entry 'myaccount_alter_UHJpdmF0ZSBtZXNzYWdlcw==_private' for key 1\nquery: INSERT INTO eb1_variable (name, value) VALUES ('myaccount_alter_UHJpdmF0ZSBtZXNzYWdlcw==_privatemsg', 'i:0;') in /var/www/entrebah/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/entrebah/admin/user/myaccount-alter', 'http://localhost/entrebah/admin/user/myaccount-alter', '127.0.0.1', 1226524004) in /var/www/entrebah/includes/database.mysql.inc on line 172

It appears by using backtrace in Devel that the Variables are being set multiple times on each form submit, which is causing the mysql error. Any thoughts or ideas for work arounds?

Gary

Comments

jody lynn’s picture

jody lynn
she/her
Primary language English
commented
Status: Active » Postponed (maintainer needs more info)

It's hard for me to imagine how that could be occurring and we haven't heard that error from anyone else.

Can you try disabling other contrib modules to try to determine if one of your other modules is causing a conflict?

dsel’s picture

dsel commented

I'm getting the same thing. Will try to turn some things off and see if that helps.

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_lname&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_fname&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_email&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_bio&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_office&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1214, 'php', '<em>Duplicate entry &amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_pro&amp;#039; for key 1\nquery: INSERT INTO variable (name, value) VALUES (&amp;#039;myaccount_alter_UGVyc29uYWwgSW5mb3JtYXRpb24=_profile_phone&amp;#039;, &amp;#039;i:1;&amp;#039;)</em> in <em>/afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', 'https://www.stanford.edu/dept/humbio/cgi-bin/?q=admin/user/myaccount-alter', '10.32.26.186', 1236388004) in /afs/ir.stanford.edu/dept/humbio/cgi-bin/includes/database.mysql.inc on line 172
ramriot’s picture

ramriot commented
Assigned: Unassigned » ramriot
Status: Postponed (maintainer needs more info) » Closed (fixed)

Work moved on and issue did not re-occur, closing now to clear decks.