When I go to the Administer>>Node relativity page & try to enable a node type, I get the following errors:

Warning: Table 'system' was not locked with LOCK TABLES query: SELECT * FROM system WHERE type = 'theme' in /usr/www/users/ceo3141/includes/database.mysql.inc on line 167

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 'relativity_parent_ord_princetonbeagle_business_i' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('relativity_parent_ord_princetonbeagle_business_info', 's:3:\\"any\\";') in /usr/www/users/ceo3141/includes/database.mysql.inc on line 167.', 2, '', 'http://www.princetonbeagle.com/admin/settings/relativity', 'http://www.princetonbeagle.com/admin/build/modules', '141.162.101.50', 1213798674) in /usr/www/users/ceo3141/includes/database.mysql.inc on line 167

Can anyone help?? Thank you.

Comments

darius’s picture

darius commented
Status: Active » Closed (won't fix)

Unfortunately, it's an issue with Drupal 5 in general - your variable names exceed 48 characters. See http://drupal.org/node/62673

If you know how to work with a database (would be easy with PHPMyAdmin, for example), something like this would fix it:

ALTER TABLE {variable} CHANGE `name` `name` VARCHAR(128) NOT NULL'

ceo3141’s picture

ceo3141 commented

Excellent -- thank you vm for your quick reply, that was easy to fix!