user warning: Duplicate entry 'relativity_casetracker_basic_case_ancestor_weigh' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_case_ancestor_weight', 's:1:\"0\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_case_children_weigh' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_case_children_weight', 's:2:\"11\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_case_operations_wei' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_case_operations_weight', 's:2:\"12\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_discovery_casetracker_basic_ca' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_discovery_casetracker_basic_case', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_organisation_casetracker_basic' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_organisation_casetracker_basic_project', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_package_dev_cycle_packaging_re' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_package_dev_cycle_packaging_rec', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_packaging_rec_casetracker_basi' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_packaging_rec_casetracker_basic_case', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_project_ancestor_we' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_project_ancestor_weight', 's:2:\"10\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_project_parents_wei' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_project_parents_weight', 's:1:\"0\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_project_children_we' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_project_children_weight', 's:2:\"11\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_casetracker_basic_project_operations_' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_casetracker_basic_project_operations_weight', 's:1:\"0\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_casetracker_basic_project_case' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_casetracker_basic_project_casetracker_basic_case', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_casetracker_basic_project_disc' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_casetracker_basic_project_discovery', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_casetracker_basic_project_pack' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_casetracker_basic_project_package_dev_cycle', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_casetracker_basic_project_case' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_casetracker_basic_project_casetracker_basic_project', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172.
user warning: Duplicate entry 'relativity_render_package_uat_casetracker_basic_' for key 1 query: INSERT INTO variable (name, value) VALUES ('relativity_render_package_uat_casetracker_basic_case', 's:5:\"title\";') in /var/www/html/projects/public_html/includes/database.mysql.inc on line 172. I beleive this is because Node Relativity uses the Drupal "variable" table instead of using a table of it's own. Due to the finite length of record names by the time prefixes such as "relativity_child_ord_" and suffixes such as "_weight" are added to long node type names you can have a series of truncated names that are no longer unique therefore preventing changes to settings and causing warnings.
This is happening to "Case Tracker" node relationships as case tracker has very long node type names. But that said "Node Relativity" should be able to cope with valid Drupal node-type string lengths.
Alternative to creating a seperate table the relativity settings could be merged into fewer variables so that both the node-type names and the relavant settings are both stored within the variable data as arrays (where it wont suffer from truncation) e.g.:-
relativity = [ [type-1, -10, 0, 9, [type-2, 1, any], [type-3, 1, 1]], [type-2, 0, 8, 9, [type-1, 1, 1], [type-3, 1, any]],... etc.
But if the data structure is re-written then it might as well be in a seperate table:-
node-relativity {table}
{record} type-1, -10, 0, 9, [type-2, 1, any], [type-3, 1, 1]]
{record} type-2, 0, 8, 9, [type-1, 1, 1], [type3, 1, any]]
{record} ...
etc.Due to time preasures and the learning curve involved in fixing this all I can do is point out the problem, possible cause and suggest how to fix it.
Comments
Comment #1
darius commentedDuplicate of http://drupal.org/node/76828?