# Strange problem when creating Contacts

**URL:** <https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299>\
**Category:** Maintaining my Dolibarr\
**Tags:** Question, Help, Database, Issue\
**Created:** [May 12, 2022, 8:59am UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299 "2022-05-12T08:59:59Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![balev](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/6bbea6/32.png) [@balev](https://www.dolibarr.org/forum/u/balev)\
**Post date:** [May 12, 2022, 8:59am UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/1 "2022-05-12T08:59:59Z")

</div>

Hello to everyone.  
My company stared using Dolibarr i have transfered all our data in the dabase and everything is working fine. But i cannot create new contacts. Im getting this strange error from the debug mode:  
Dolibarr version - 15.0.1.

- 

```auto

```

2022-05-12 11:47:27 ERR DoliDBMysqli::query SQL Error message: DB\_ERROR\_167 Out of range value for column ‘rowid’ at row 1

```auto
* error

```

2022-05-12 11:47:27 ERR Contact::create Out of range value for column ‘rowid’ at row 1

```auto
This is the SQL error:
INSERT INTO llxcg_socpeople ( datec, fk_soc, lastname, firstname, fk_user_creat, priv, fk_stcommcontact, statut, canvas, entity, ref_ext, import_key) VALUES ('2022-05-12 12:05:13', 24812,'Georgiev','Petar', 1, 0, 0, 1, null, 1,'', null)
[DB_ERROR_167] Out of range value for column 'rowid' at row 1

I have checked the database : [llxcg_socpeople] - rowid - and its set to INT, but i keep getting that error and i cannot create new contacts.

System :
Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.3.34-MariaDB-log - MariaDB Server
Protocol version: 10
If anyone has ever had that problem and found solution would be perfect. We are using (Bulgarian as default lang - havnt tryed if i switch to English)
```

---

<div class="post-metadata">

**Author:** ![ariffidaali](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ariffidaali/32/462_2.png) [@ariffidaali](https://www.dolibarr.org/forum/u/ariffidaali)\
**Post date:** [May 12, 2022, 3:07pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/2 "2022-05-12T15:07:28Z")

</div>

Hi,  
Values might not be unique as rowid is a primary key.

---

<div class="post-metadata">

**Author:** ![balev](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/6bbea6/32.png) [@balev](https://www.dolibarr.org/forum/u/balev)\
**Post date:** [May 25, 2022, 2:04pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/3 "2022-05-25T14:04:19Z")

</div>

Im just trying to add a new contact. Im attaching an image everything is filled but i keep getting the same error.

 ![Problem](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/7/7c41dfb798901febe643146d220772348bc65030.jpeg)

---

<div class="post-metadata">

**Author:** ![balev](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/6bbea6/32.png) [@balev](https://www.dolibarr.org/forum/u/balev)\
**Post date:** [May 25, 2022, 2:07pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/4 "2022-05-25T14:07:03Z")

</div>

Here is the database problem in debug mode.

 ![DBS error](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/8/88506f5b2052e4f5ebc344583810ca71743f0eb0.jpeg)

---

<div class="post-metadata">

**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\
**Post date:** [June 20, 2022, 8:17pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/5 "2022-06-20T20:17:34Z")

</div>

The value used for rowid when creating a new contact is a value auto incremented.  
You should have a look in database to know what is the property autoincrement of field rowid in table socpeople.

---

<div class="post-metadata">

**Author:** ![balev](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/b/6bbea6/32.png) [@balev](https://www.dolibarr.org/forum/u/balev)\
**Post date:** [June 21, 2022, 1:07pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/6 "2022-06-21T13:07:53Z")

</div>

Everything looks normal to me here are some screenshots from the database

 ![rowID1](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/b/bae9d2dc42dd9efae4eece9bedded0d387a1ccd7.jpeg)  
 ![rowid2](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/b/bac86b30d18d9faf5d54b65cec639142ecf59dee.jpeg)

---

<div class="post-metadata">

**Author:** ![eldy](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/eldy/32/12_2.png) [@eldy](https://www.dolibarr.org/forum/u/eldy)\
**Post date:** [October 18, 2022, 3:31pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/7 "2022-10-18T15:31:19Z")

</div>

Can you copy the full sql string that fails (the screenshot shows only the begin of sql)

---

<div class="post-metadata">

**Author:** ![milenmk](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/milenmk/32/4128_2.png) [@milenmk](https://www.dolibarr.org/forum/u/milenmk)\
**Post date:** [October 20, 2022, 4:34pm UTC](https://www.dolibarr.org/forum/t/strange-problem-when-creating-contacts/22299/8 "2022-10-20T16:34:51Z")

</div>

We’ve sorted out this already. Because of a couple of imports/deletes the autoincrement value for rowid had gotten very big and over the limit.