Bug add new employee in version 9.0

[sbahjaoui]

Hi,
I have error “ref doesn’t have a default value” when I want to add new employees in new version 9.0
Note: new installation v9.0

[fedoo]

Hello @sbahjaoui did you solve this problem?
Greetings from Chile,

Freddy

[sbahjaoui]

Not yet, I’m using version 8

[fedoo]

Hello @sbahjaoui, something I did yesterday that generates the payment.

In the following file add the following:

compta/salaries/class/paymentsalary.class.php

Add after line 323

$sql.= ", ref";

And after line 391

$sql.= ", '".$this->ref."'";

You tell me,

Regards

Freddy

[kamkaran]

I really like what you have shared.

[sbahjaoui]

Hi @fedoo,
First of all thank you for your help, where can i add $sql.= ", ref"; ? which function?
Thank you.

[Kundrats]

Had the same issue, solved with:

[code]
ALTER TABLE llx_payment_various CHANGE ref ref VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;[/code

[nazeer]

try to upgrade to 9.0.2 stable version…

I just tried no more issues after update.

[sbahjaoui]

I will do that thank you.

[OmanGhost]

I have the same issue on version 10.0.0

How I can solve this?

[ksar]

Hello ?

Try to return to the migration process from 9 to 10 by calling page /install

[deborahuribe]

Did you still have this problem or you resolve this issue. facing same issue. Didn’t find any solution yet!

[OmanGhost]

Still no solution