search

tsolucio / corebos

core Business Operating System. An OPEN SOURCE business application that helps small and medium business handle all the day to day tasks.
https://corebos.com
151 stars 141 forks source link

Settings for auto numbering give database error #1469

Open partnerwerk opened 1 year ago

partnerwerk commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

Hi

did you find any explanation for this?

partnerwerk commented 1 year ago

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.

Bildschirmfoto 2023-01-24 um 18 25 07

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

Bildschirmfoto 2023-01-24 um 18 26 41

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

joebordes commented 1 year ago

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.