The pages table does have auto increment... but auto increment should still work if you insert a record with a fixed ID...
I.e. when the SQL executed in 20.sql it should have tried to put in ID 29 - not ID 28.
Very odd...
As it happens the 9.sql is the wrong way to do it... the reason it puts in a fixed ID is so that it knows the pageID for the menuitem insert just below... there is a better way do to it, but I didn't think this way would cause any problems either.
I'll fix 9.sql for 1.0.6 to insert that record in another manner.
The pages table does have auto increment... but auto increment should still work if you insert a record with a fixed ID...
I.e. when the SQL executed in 20.sql it should have tried to put in ID 29 - not ID 28.
Very odd...
As it happens the 9.sql is the wrong way to do it... the reason it puts in a fixed ID is so that it knows the pageID for the menuitem insert just below... there is a better way do to it, but I didn't think this way would cause any problems either.
I'll fix 9.sql for 1.0.6 to insert that record in another manner.