Problem with software table [closed]

Question

Hi,

I contact you because I have a problem with the software tab on OCS.

The software's list is empty on OCS for lot of computers.

After diagnostic, the MAX(ID) from software table is 2147483647 and it is the max value of INT type.

The software table can't register anything new.

The MIN(ID) is 430426245

Total entries (select count) in the software table is : 28485014.

We can see that 28 485 014 < 2 147 483 647 and I don't understand why the auto increment didn't begin at 1.

Can someone help me to find a solution please ? Do you have already met this problem ?

My OCS version is 2.8.1 and the OS is Debian Buster (10).

Thanks in advance,

Kind Regards

Answer 1

The table 'software' start from OCS 2.8 (before the table is 'softwares' cf 7037.sql script).

If you start a NEW server with OCS 2.10, the field 'ID' of table 'software' is a 'bigint' field (not an 'int' field !).

BUT, if you upgrade you OCS server, the field 'ID' of table 'software' could be a 'int' field.

There is a problem between '7035.sql' and 'ocsbase_new.sql' : in '7035.sql' the type is 'int', and in 'ocsbase_new.sql' the type is 'bigint' ...

I suggest an sql cmd as 'alter table software modify ID bigint not null auto_increment;' ? (I strongly recommand to stop Apache before launching the sql !!)

EDIT : the script 7053.sql do the job :

ALTER TABLE software MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE software_link MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE software_categories_link MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;

Answer 2

Hi Jacques,

Thanks for your answer, it's ok for me now.

After an inventory, the softwares appears correctly.

Kind Regards