HELP!!! Bizarre unexpected error messages re. INSERT INTO search_dataset
ss_drupal - August 24, 2009 - 19:53
I have gotten several error messages as follows.
I'm baffled as to the cause or what to do about it.
Has anyone had any experience along these lines?
Anybody have a clue?
Please advise.
* user warning: Duplicate entry '1-help' for key 1 query: INSERT INTO search_dataset (sid, type, data, reindex) VALUES (1, 'help', ' readme id readmetxt v 1123 20090815 081723 davyvandenbremt exp description drupal allows you to define a different theme for administration pages administer site configuration administration theme by default this only applies to pages with a path starting with admin and content editing pages the administration theme module adds a few more option to the default configuration page like use administration theme for batch processing use administration theme for code reviews some of these pages will only appear if they apply to your installation ie you have the module installed which generates these pages you also have the option to define a custom set of drupal paths or aliases to apply the administration theme for requirements this module requires drupal 6 a drupal 5 version is available installation 1 copy upload the admintheme module folder to the sites all modules directory of your drupal installation 2 enable the administration theme module in drupal administer modules configuration you can enable disable the administration theme on the administration theme configuration page administration theme can be configured at administer site configuration administration theme developers you can add define extra pages where the administration theme should be applied to by implementing the hookadminthemeoptions hook in your modules this hook uses an op variable to specify two operation that can be done getting all options and checking if an option should be applied to a path check out adminthemeadmintheme for an example implementation author davy van den bremt http wwwdavyvandenbremtbe ', 0) in C:\s\http\project_name\site_name\000\modules\search\search.module on line 571.
* user warning: Duplicate entry '2-help' for key 1 query: INSERT INTO search_dataset (sid, type, data, reindex) VALUES (2, 'help', ' using advanced help the advanced help system is a pluggable system that provides advanced help facilities for drupal and its modules although the advanced help does not provide general help by itself it provides a powerful and easy framework that modules may use to provide their own help modules utilizing advanced help should create a help subdirectory inside their module s directory place the file modulenamehelpini in this subdirectory formatted similar to the following example buses title how buses are tied into the system file buses topicid title title of topic file filename of topic without the html extension weight how important the topic is on the index page parent the optional topic parent to use in the breadcrumb either topic or module topic all topics are addressed by the module providing the topic and by the topic id to embed links use the following format output theme advancedhelptopic module topic inside your help file link to other topics using the format a href topic module topic this format will ensure the popup status remains consistent when switching between links use a href path examplejpg to reference items within the help directory such as images you wish to embed within the help text use a href baseurl admin settings siteconfiguration to reference any normal path in the site if the search module is enabled the contents of help system will be indexed on cron if you enable new modules and wish to immediately index its help text visit the administration reports status report and click the run cron manually link example don t click this see ini file format note in previous versions advanced help did not require the s wrapped around the topic path and baseurl links this is currently still supported but may be removed in a future version by adding the s these tokens are now not limited to href and src paramaters ', 0) in C:\s\http\project_name\site_name\000\modules\search\search.module on line 571.
* user warning: Duplicate entry '4-help' for key 1 query: INSERT INTO search_dataset (sid, type, data, reindex) VALUES (4, 'help', ' help ini file format the advanced help configuration file is in simple ini file format divided into sections for each help file plus an optional section for global settings that might be inherited for each help file the first line of an advanced help ini file should be id which will be a comment providing the cvs identifier for the file the indicates a comment character anything after the will be ignored global settings may be put into a section named advanced help settings this means that this name is reserved and it cannot be a help file in any module the following settings may be set in this section line break if set to any value the line break filter will be applied to all help files defined by this module unless that help file specifically is set otherwise by default the line break filter is not applied however help files can be much easier to write with the line break filter on navigation if set to true the navigation will be displayed at the end of the help topic previous topic next topic and child topics css specify a css file that will be used for all help files unless overridden including the css extension this css file must reside in the help directory along with the html files and will not be affected by translation name may be set to override the module name as displayed in both the module index as well as the navigation and breadcrumb trail in general this does not need to be set but a few modules may want to use a more friendly name than appears in the info file index name this may be set to change the name of the module in the module index it overrides the name setting above as well as the module name in its info file hide this may be used to hide a module in the module index this is particularly useful for modules who insert their help files into the hierarchy of another module as might be done by modules that extend views or cck by setting hide true the module will not appear as its own entry each section after that will correspond to a single help file and each one may have the following settings title the title of the topic presented to the user and used in links if you have special characters in your title be sure to enclose it in quotes file the filename without the html extension used for the topic this is optional if not specified the topic name wil be the file name weight the weight used for sorting topics on the administration page defaults to 0 of unspecified items with the same weight are sorted alphabetically parent the topic id to use in a hierarchy children will be listed beneath parents in the topic list and will have the parent in their breadcrumb trail you may parent this topic to another module s topic by using module topic as the identifier for example views display will make this a child of the display topic in the views module line break if set to true linebreaks will be converted into br and p tags automatically if unspecified will default to off set to 0 to disable the filter if this has been turned on in the global settings css specify a css file that will be used for this file this css file must reside in the help directory along with the html files this will override any css file added by the global system popup width the width in pixels of the popup window defaults to 500 if unspecified popup height the height in pixels of the popup window defaults to 500 if unspecified for example here is a version of the advancedhelphelpini file usingadvancedhelp title using advanced help weight 10 translation title translating advanced help inifile title help ini file format line break true ', 0) in C:\s\http\project_name\site_name\000\modules\search\search.module on line 571.Followed by:
Type php
Date Monday, August 24, 2009 - 15:38
User ssroot
Location http://localhost:3000/themes/ad_blueprint/images/bullet2.gif
Referrer
Message Duplicate entry '4-help' for key 1 query: INSERT INTO search_dataset (sid, type, data, reindex) VALUES (4, 'help', ' help ini file format the advanced help configuration file is in simple ini file format divided into sections for each help file plus an optional section for global settings that might be inherited for each help file the first line of an advanced help ini file should be id which will be a comment providing the cvs identifier for the file the indicates a comment character anything after the will be ignored global settings may be put into a section named advanced help settings this means that this name is reserved and it cannot be a help file in any module the following settings may be set in this section line break if set to any value the line break filter will be applied to all help files defined by this module unless that help file specifically is set otherwise by default the line break filter is not applied however help files can be much easier to write with the line break filter on navigation if set to true the navigation will be displayed at the end of the help topic previous topic next topic and child topics css specify a css file that will be used for all help files unless overridden including the css extension this css file must reside in the help directory along with the html files and will not be affected by translation name may be set to override the module name as displayed in both the module index as well as the navigation and breadcrumb trail in general this does not need to be set but a few modules may want to use a more friendly name than appears in the info file index name this may be set to change the name of the module in the module index it overrides the name setting above as well as the module name in its info file hide this may be used to hide a module in the module index this is particularly useful for modules who insert their help files into the hierarchy of another module as might be done by modules that extend views or cck by setting hide true the module will not appear as its own entry each section after that will correspond to a single help file and each one may have the following settings title the title of the topic presented to the user and used in links if you have special characters in your title be sure to enclose it in quotes file the filename without the html extension used for the topic this is optional if not specified the topic name wil be the file name weight the weight used for sorting topics on the administration page defaults to 0 of unspecified items with the same weight are sorted alphabetically parent the topic id to use in a hierarchy children will be listed beneath parents in the topic list and will have the parent in their breadcrumb trail you may parent this topic to another module s topic by using module topic as the identifier for example views display will make this a child of the display topic in the views module line break if set to true linebreaks will be converted into br and p tags automatically if unspecified will default to off set to 0 to disable the filter if this has been turned on in the global settings css specify a css file that will be used for this file this css file must reside in the help directory along with the html files this will override any css file added by the global system popup width the width in pixels of the popup window defaults to 500 if unspecified popup height the height in pixels of the popup window defaults to 500 if unspecified for example here is a version of the advancedhelphelpini file usingadvancedhelp title using advanced help weight 10 translation title translating advanced help inifile title help ini file format line break true ', 0) in C:\s\http\project_name\site_name\000\modules\search\search.module on line 571.
Severity error
Hostname 127.0.0.1
Operations 
need to try
First you need to isolate if the problem is due to a module that has been added or a theme you've added. The best thing is to to go back to stock themes first, and turn off the modules you've to isolate the problem. Once finding which ones then isolating the problem should be easier.
My $0.02
/t
Brute force fix ...
Since development on the site was still in the early stages, I simply rebuilt the whole site.
I did leave out a couple of modules which testing demonstrated unnecessary.
My suspicion is that the problem was brought on by an update to two modules --
admin_theme-6.x-1.1 --> admin_theme-6.x-1.3 and
finder-6.x-1.2 --> finder-6.x-1.3
No definitive data.