Settings for auto numbering give database error

[partnerwerk]

Hello there,

I wanted to change a few records for aut numbering due to the beginning of the year. Whenever I try to change an entry I receive this error message:

Input array has 1 params, does not match query: SELECT vtiger_field.tablename,vtiger_field.columnname,vtiger_field.uitype,vtiger_field.fieldname,vtiger_field.fieldid,vtiger_field.fieldlabel,vtiger_field.maximumlength,vtiger_field.block,vtiger_field.generatedtype,vtiger_field.tabid,vtiger_field.defaultvalue,vtiger_field.typeofdata,vtiger_field.sequence,vtiger_field.displaytype, vtiger_field.readonly FROM vtiger_field WHERE vtiger_field.tabid=? AND vtiger_field.block IN () AND vtiger_field.displaytype = 1 AND info_type = ? and vtiger_field.presence in (0,2) ORDER BY block,sequence'

As far as I cann see all updates have been run but something seems to be missing. I would very much appreciate advice to fix this.

Henning

[joebordes]

it has to be something with the blocks. I see in the code that query, it looks ok.
the autonumber records look ok in detail view?
two blocks?

[joebordes]

Hi

did you find any explanation for this?

[partnerwerk]

Hi Joe, I apologize. I wasn't aware of your answer.
No, so far I don't know what this means.
I am attaching a screenshot with the detail view.

The second screenshot shows the screen when I click on ”Edit”.

Clicking on ”FIX_MISSING_NUMBERING” gives feedback that 0 updates have been made.

[joebordes]

The module has not been installed correctly. Very hard to say why and difficult to fix. We have to look in the database to see what steps of the installation are missing and launch them again separately in order to finish the installation and proceed.

Can you please look for me on Gitter (joebordes) and we can discuss it? I will try to help.