Re: Unknown column 'subtest_id' in 'NEW'

[Prashant Tekriwal]

We can't use AUTO_INCREMENT in tables where we are using 'id' from 'seq' because we use one single incrementing sequence across multiple tables if that what you mean.

Also we don't want to use AUTO_INCREMENT for 'id' in seq table because that would insert as many rows in seq table as many times we want a new id.

In our case we have just one row in seq table.

I know this whole logic is very tedious but this is how it is currently and we need to change a lot of logic to change this behavior.

If I can get to know what is actually causing the issue that will be really helpful.

I am totally stuck because of this issue.

Any help will be highly appreciated.