[SOLVED] not auto incrementing in DB

[dennismonsewicz]

I have a joomla component i have custom built but for some reason when it installs the main menu for the admin the main menu link does not auto increment in the DB (row id). Everything else does though.

 

I understand that this is a third party script question but the auto incrementing is where my problem lies.. any help?

[revraz]

There really is nothing to it.

 

Set it in your DB and when you do a insert, make sure you don't add to that field.  Many people will add it to their insert statement as a NULL or ' ', but just exclude it altogether.

 

Also, can't help you much without seeing the code that pertains to your issue.

[dennismonsewicz]

well the way the Joomla backend loads the menu structure into the DB is by an XML file here is the bit of code containing the XML code:

 

<menu>Tmo Deductible</menu>
		<submenu>
			<menu link="option=com_tmodeductible&section=phoneplan">Phone Deductibles</menu> 
			<menu link="option=com_tmodeductible&section=plan_by_state">Deductibles By State</menu>
		</submenu>

 

The submenu's rowid auto increments in the DB bu the main menu does not

[revraz]

That code has nothing to do for writing to the DB.

[dennismonsewicz]

well like i said its Joomla's way of doing things. It somehow inserts that bit of information in one of the SQL tables

[revraz]

That code doesn't.

[dennismonsewicz]

i figured out my problem

 

This line was in the install SQL file:

 

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

 

i commented it out and everything works like a charm!