I was using the send.module for a while without any problem, but today all of sudden, I started receiving the following error when I tried to save my cck content type named "digital_promotion_kit", after I changed the send setting specific to the content type.

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', 'Duplicate entry 'send_digital_promotion_kit_fulltext_digital_prom' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_fulltext_digital_promotion_kit', 'i:1;') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/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 (1, 'php', 'Duplicate entry 'send_digital_promotion_kit_linktext_digital_prom' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_linktext_digital_promotion_kit', 's:4:\\"send\\";') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/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 (1, 'php', 'Duplicate entry 'send_digital_promotion_kit_subject_digital_promo' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_subject_digital_promotion_kit', 's:26:\\"Send to Friend from Drupal\\";') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/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 (1, 'php', 'Duplicate entry 'send_digital_promotion_kit_message_digital_promo' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_message_digital_promotion_kit', 's:0:\\"\\";') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/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 (1, 'php', 'Duplicate entry 'send_digital_promotion_kit_template_digital_prom' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_template_digital_promotion_kit', 's:15:\\"%message\\r\\n%body\\";') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/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 (1, 'php', 'Duplicate entry 'send_digital_promotion_kit_pernode_digital_promo' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_pernode_digital_promotion_kit', 'i:0;') in /var/www/includes/database.mysql.inc on line 172.', 2, '', 'http://localhost/admin/content/types/digital-promotion-kit', 'http://localhost/admin/content/types/digital-promotion-kit', '127.0.0.1', 1213007714) in /var/www/includes/database.mysql.inc on line 172

Then if I tried to navigate to any other page on my website, I get the following error,

* user warning: Duplicate entry 'send_digital_promotion_kit_fulltext_digital_prom' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_fulltext_digital_promotion_kit', 'i:1;') in /var/www/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry 'send_digital_promotion_kit_linktext_digital_prom' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_linktext_digital_promotion_kit', 's:4:\"send\";') in /var/www/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry 'send_digital_promotion_kit_subject_digital_promo' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_subject_digital_promotion_kit', 's:26:\"Send to Friend from Drupal\";') in /var/www/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry 'send_digital_promotion_kit_message_digital_promo' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_message_digital_promotion_kit', 's:0:\"\";') in /var/www/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry 'send_digital_promotion_kit_template_digital_prom' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_template_digital_promotion_kit', 's:15:\"%message\r\n%body\";') in /var/www/includes/database.mysql.inc on line 172.
* user warning: Duplicate entry 'send_digital_promotion_kit_pernode_digital_promo' for key 1 query: INSERT INTO variable (name, value) VALUES ('send_digital_promotion_kit_pernode_digital_promotion_kit', 'i:0;') in /var/www/includes/database.mysql.inc on line 172.

and I also get the following message at the same time.

"The content type digital_promotion_kit has been updated."

I found the discussion related to the watchdog error at http://drupal.org/node/243927 but my problem didn't disappear after I increased the mysql memory limit from 16M to 32M. So it appears the watchdog error was caused by the double entry error. Then I looked for double entry solution and found http://drupal.org/node/69722 , but I couldn't solve the problem since I couldn't find any relationship between the variable table and sequences table in the database (there is send_sid entry in the sequences table but I doubt that is the issue).

I also found that after receiving the both watchdog and double entry errors, the value column for my node type in the send_setting table gets updated, but the value column of the variable table does not get updated.

Could anybody help me solve this issue?

Comments

jajathejazzcat’s picture

jajathejazzcat commented

OK I did more research with this issue and was able to find a solution eventually at http://drupal.org/node/68941. The name column in the variable table is set to varchar (48), and my cck content type name was too long for the column when concatenated with other strings automatically created by the send module. I changed my content type name from 23 characters to 3 and all the error messages disappeared. The only minor remaining issue is that database rows (fulltext, linktext, etc) in the variable table under the old content type name didn't get erased when I changed the content type name. Is there a way to erase them or should I just manually delete them?
Thanks.

allie micka’s picture

allie micka
she/her
commented
Status: Active » Closed (fixed)

I think you can just manually delete them. The next time the cache is cleared they'll be gone.

Thanks for following up on your issue!

Allie

wintervanilla’s picture

wintervanilla commented

Thanks! I was having the same problem and this solved it for me.