Watchdog LOCK error when saving "Separate form to configure this Hierarchical Select widget's settings."
| Project: | Hierarchical Select |
| Version: | 5.x-3.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Wim Leers |
| Status: | closed |
Jump to:
When I press the save button in: "Separate form to configure this Hierarchical Select widget's settings." I get the following Watchdog error message, which prevents the changes from beeing saved:
"Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (9, 'php', 'Duplicate entry 'hs_config_content-taxonomy-field_taxonomy_field_' for key 1\nquery: INSERT INTO variable (name, value) VALUES ('hs_config_content-taxonomy-field_taxonomy_field_hierarch_0', 'a:7:{s:9:\\"config_id\\";s:48:\\"content-taxonomy-field_taxonomy_field_hierarch_0\\";s:12:\\"save_lineage\\";s:1:\\"1\\";s:15:\\"enforce_deepest\\";s:1:\\"0\\";s:10:\\"node_count\\";s:1:\\"0\\";s:12:\\"level_labels\\";a:2:{s:6:\\"status\\";i:0;s:6:\\"labels\\";a:2:{i:0;s:0: in /home/username/public_html/drupalsite/includes/database.mysqli.inc on line 151"
#1
Can you reproduce this consistently? I think it's a random glitch, because those configs are actually saved using
variable_set().#2
Closing due to lack of response.
#3
Sorry for the time it took to respond, but I wanted to get the module tested for some weeks to see if the error appear every time I press the save button on that config-page. I need still more days/weeks of testing in order to conlude if these errors appear often or not.
The changes are saved when I press the save button and this error appears.
Since it is a watchdog error I don't worry to much about it, but it isn't user friendly having those white-screens of death. And non-techies would get shocked. So if anyone else experience the same please report.