New Item ID set to 0 (zero)
Posted: Wed Jun 13, 2007 11:23 pm
Aroha folks...this is my first post and contribution back to this aweshum forum...enjoy! 
I recently migrated my Joomla 1.0.12 installation from one server to another, and ran into some problems with the Item ID being set to 0 for each new story, user, menu item, etc. This causes all sorts of problems, namely, you are unable to continue adding new stuff to your site...rendering you stuck in the mud.
Essentially, you need to make sure specific database tables are set to 'auto_increment' the Item IDs. This can easily be done using something like phpMyAdmin to modify your tables.
Do this for each table in your database, unless noted in the DO NOT EDIT list below.
1) login to your database using phpMyAdmin
2) select the first table in the database, i.e. jos_acajoom_lists
3) look for the 'id' field. click on the 'change' icon next to that (looks like a pencil).
4) in the edit window, erase the '0' from the 'Default' field.
5) next, select 'auto_increment' from the 'Extra' field.
6) click the Save button to exit
Repeat as necessary until you have done this for all tables, except these below. Just leave them as-is, as they do not need to auto-increment:
----------DO NOT EDIT THESE TABLES -----------
jos_acajoom_stats_global
jos_acajoom_xonfig
jos_content_frontpage
jos_core_log_items
jos_core_log_searches
jos_groups
jos_modules_menu
jos_poll_menu
jos_session
jos_stats_agents
jos_templates_menu
jos_usertypes
----------DO NOT EDIT THESE TABLES -----------
When you're done, all the necessary 'Default' fields should be blank, and all their respective 'Extra' fields should be set to auto-increment.
cheers,
rediray
I recently migrated my Joomla 1.0.12 installation from one server to another, and ran into some problems with the Item ID being set to 0 for each new story, user, menu item, etc. This causes all sorts of problems, namely, you are unable to continue adding new stuff to your site...rendering you stuck in the mud.
Essentially, you need to make sure specific database tables are set to 'auto_increment' the Item IDs. This can easily be done using something like phpMyAdmin to modify your tables.
Do this for each table in your database, unless noted in the DO NOT EDIT list below.
1) login to your database using phpMyAdmin
2) select the first table in the database, i.e. jos_acajoom_lists
3) look for the 'id' field. click on the 'change' icon next to that (looks like a pencil).
4) in the edit window, erase the '0' from the 'Default' field.
5) next, select 'auto_increment' from the 'Extra' field.
6) click the Save button to exit
Repeat as necessary until you have done this for all tables, except these below. Just leave them as-is, as they do not need to auto-increment:
----------DO NOT EDIT THESE TABLES -----------
jos_acajoom_stats_global
jos_acajoom_xonfig
jos_content_frontpage
jos_core_log_items
jos_core_log_searches
jos_groups
jos_modules_menu
jos_poll_menu
jos_session
jos_stats_agents
jos_templates_menu
jos_usertypes
----------DO NOT EDIT THESE TABLES -----------
When you're done, all the necessary 'Default' fields should be blank, and all their respective 'Extra' fields should be set to auto-increment.
cheers,
rediray