i am updating my module (in this case the latest version of smartsection), it worked fine previously but then strange thing happened. i always got error in:

Adding module config data...
Config itemtype added to the database.
Config option added. Name: Articles Value: article
Config option added. Name: Items Value: item
Config option added. Name: Turorials Value: tutorial
Config option added. Name: Stories Value: story
ERROR: Could not insert config allowsubmit to the database.
ERROR: Could not insert config anonpost to the database.
ERROR: Could not insert config allowupload to the database.
ERROR: Could not insert config dateformat to the database.
ERROR: Could not insert config displaytype to the database.
ERROR: Could not insert config show_subcats to the database.
ERROR: Could not insert config displaylastitems to the database.
ERROR: Could not insert config use_wysiwyg to the database.
ERROR: Could not insert config displaylastitem to the database.
ERROR: Could not insert config lastitemsize to the database.
ERROR: Could not insert config titlesize to the database.
ERROR: Could not insert config displaysubcatdsc to the database.
ERROR: Could not insert config display_date_col to the database.
ERROR: Could not insert config display_hits_col to the database.
etc.

this now happens to all my modules, everytime i try to update the module i experience the same issue, for example (on the AMS):
Adding module config data...
ERROR: Could not insert config storyhome to the database.
ERROR: Could not insert config displaynav to the database.
ERROR: Could not insert config max_items to the database.
ERROR: Could not insert config autoapprove to the database.
ERROR: Could not insert config newsdisplay to the database.
ERROR: Could not insert config displayname to the database.
ERROR: Could not insert config columnmode to the database.
ERROR: Could not insert config storycountadmin to the database.
ERROR: Could not insert config uploadgroups to the database.
ERROR: Could not insert config maxuploadsize to the database.
ERROR: Could not insert config restrictindex to the database.
ERROR: Could not insert config anonymous_vote to the database.
ERROR: Could not insert config com_rule to the database.
ERROR: Could not insert config com_anonpost to the database.
ERROR: Could not insert config notification_enabled to the database.
ERROR: Could not insert config notification_events to the database.

for all the issue, the MySQL debug mode show this message:
INSERT INTO xoops_config (conf_id, conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES (0, 30, 0, 'storyhome', '_AMS_MI_STORYHOME', '5', '_AMS_MI_STORYHOMEDSC', 'select', 'int', 0)
Error number: 1062
Error message: Duplicate entry '65535' for key 1
INSERT INTO xoops_config (conf_id, conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES (0, 30, 0, 'displaynav', '_AMS_MI_DISPLAYNAV', '1', '_AMS_MI_DISPLAYNAVDSC', 'yesno', 'int', 1)
Error number: 1062
Error message: Duplicate entry '65535' for key 1
INSERT INTO xoops_config (conf_id, conf_modid, conf_catid, conf_name, conf_title, conf_value, conf_desc, conf_formtype, conf_valuetype, conf_order) VALUES (0, 30, 0, 'max_items', '_AMS_MI_MAXITEMS', '30', '_AMS_MI_MAXITEMDESC', 'text', 'int', 2)
Error number: 1062
Error message: Duplicate entry '65535' for key 1

all the error message refer to that:
Error number: 1062
Error message: Duplicate entry '65535' for key 1

please help. thanks.

seems that the "conf_id" field (smallint(5)) in the xoops_config file has reached its maximum (65535)?! i changed the conf_id field to mediumint and now all works fine (can i do that)?

i did a browse to the xoops_config file, the conf_id (which is set to be auto incremental?) initially increment properly but then suddenly did a jump in the middle, resulting it reaches its maximum.

is it a XOOPS core program issue?

note: i am using XOOPS 2.0.7.

apparently i can't change the conf_id field to mediumint, as now all the latest update module admin start to behave strangely.

appreciate your assistance on this. [how can i fix this mess]

* bump *

Ok This is what looks like it happening and a potential fix.

What happened:
the xoops_config table auto_increment field looks like it is messed so that you are getting to the max.

The Fix:
There is no way to fix that except to drop the column and recreate it with the same attributes it had. WARNING: there is a linked table, hence the id in the first place. This is the xoops_configoption table and THERE MAY BE MORE but that is the only on that has the same field name so in theory that should be the only dependancy existing. If you look at this document, in the comments, you will see how to "reset" the auto_increment field in mysql.

I hope this helps please let me know..