# error in salary module

**URL:** <https://www.dolibarr.org/forum/t/error-in-salary-module/18005>\
**Category:** Using my Dolibarr\
**Created:** [October 10, 2019, 6:12am UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005 "2019-10-10T06:12:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kiranpce](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/kiranpce/32/577_2.png) [@kiranpce](https://www.dolibarr.org/forum/u/kiranpce)\
**Post date:** [October 10, 2019, 6:12am UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005/1 "2019-10-10T06:12:40Z")

</div>

Dear Sir

I am using salary module in 10.0.2 linux version. Have posted all data fields in salary. but it is giving error as “Field ‘ref’ doesn’t have a default value”

can somebody guide please.

best regards

 ![salary.jpg](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/b/bf61a4e30457f1d42c41c73a1d467de07ec8f942.jpeg)

---

<div class="post-metadata">

**Author:** ![kiranpce](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/kiranpce/32/577_2.png) [@kiranpce](https://www.dolibarr.org/forum/u/kiranpce)\
**Post date:** [October 10, 2019, 1:24pm UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005/2 "2019-10-10T13:24:35Z")

</div>

It appears it is a bug since I have checked all the probabilities.

can moderator please resolve best regards Kiran

---

<div class="post-metadata">

**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\
**Post date:** [October 10, 2019, 1:34pm UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005/3 "2019-10-10T13:34:10Z")

</div>

Hello,

Can you share the dolibarr logs ?

---

<div class="post-metadata">

**Author:** ![quid](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/q/da6949/32.png) [@quid](https://www.dolibarr.org/forum/u/quid)\
**Post date:** [October 10, 2019, 2:00pm UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005/4 "2019-10-10T14:00:45Z")

</div>

can you check table structure llx\_payment\_salary and see ref field has Null set to Yes and Default value is set to NULL

---

<div class="post-metadata">

**Author:** ![kiranpce](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/kiranpce/32/577_2.png) [@kiranpce](https://www.dolibarr.org/forum/u/kiranpce)\
**Post date:** [October 23, 2019, 8:32am UTC](https://www.dolibarr.org/forum/t/error-in-salary-module/18005/5 "2019-10-23T08:32:44Z")

</div>

It could be sorted out by by modifying the DB . Thank you so much Quid and Ksar . Great help by you people.