new section generates error

[xmanhattan]

Hello all,

For some reason after I enter a new section or category, I am receiving errors after the save on the creation and the updating.  Oddly enough, it does not do this for an existing data.  2008.1

The error code is mysql error 1064 execute.

[datahell]

You should see a red area with white coloured letters saying about this mysql error. Click on it and you will see a detailed description of this error. If you see this error only for a few miliseconds before you get re-directed back click the "stop" button in your browser as fast as you can to see the error message. Copy-paste the error details here.

[attachment deleted by admin]

[xmanhattan]

Just tried it again but sorry to say that it did not give any errors this time.   

Very strange, I'll keep looking for it if it happens again.

[datahell]

Most probably a bad index (already existed), it passed as mysql increment indexes by 1 each time. Do a database repair/optimize from within Elxis administration or via phpmyadmin. Don't worry, nothing serious.

More explanation about this error (possible reason)
Lets say you have sections with indexes 1, 2, 3, 4 and 5.
You delete sections 4 and 5.
Normally when you are going to add a new section this will get index 6 (index next value information is being stored inside mysql).
If for some reason adodb give you wrong index (4 instead of 6) this will cause an error. You should try again (5 instead of 6), and again (6, this time you get the right value) to get it working properly.
You could also solve this problem if you set index next value to 4 instead of 6.