# Error in database with upload in runtime

**URL:** <https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785>\
**Category:** Ignition\
**Created:** [November 12, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785 "2018-11-12T20:36:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![alemancordero](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@alemancordero](https://forum.inductiveautomation.com/u/alemancordero)\
**Post date:** [November 12, 2018, 8:36pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/1 "2018-11-12T20:36:54Z")

</div>

Una disculpa antes que nada por escribir la duda en español.  
Estoy trabajando con base de datos, y al actualizar el proyecto mi base de datos se sobreescribe automaticamente. este error solo pasa si guardo el el avance del proyecto y hago upload en el runtime.  
espero me puedan ayudar.

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [November 13, 2018, 5:39am UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/2 "2018-11-13T05:39:37Z")

</div>

I was curious enough to try Google translate--not sure if this is exactly what you meant, but maybe Google's version will aid in getting answers:

> An apology first of all for writing the doubt in Spanish.  
> I am working with database, and when updating the project my database is automatically overwritten. this error only happens if I save the progress of the project and upload in the runtime.  
> I hope you can help me.

Hopefully your English is better than my Spanish (don't ask)!

If I understand right, you have a database connected to Ignition and when you save (and publish?) your Ignition project in Ignition Designer, something gets overwritten in the database. Is it possible you have a script or something that writes to the database that would be triggered on a client restart after update from Designer?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 13, 2018, 4:37pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/3 "2018-11-13T16:37:07Z")

</div>

Also, I would definitely suggest sending in an email to [support@inductiveautomation.com](mailto:support@inductiveautomation.com) - we have a few Spanish speakers on staff who can definitely help troubleshoot if you’re more comfortable in Spanish.

---

<div class="post-metadata">

**Author:** ![alemancordero](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@alemancordero](https://forum.inductiveautomation.com/u/alemancordero)\
**Post date:** [November 14, 2018, 5:54pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/4 "2018-11-14T17:54:08Z")

</div>

Thanks for answering my question. I do not publish the project, I have a window that updates the data of the database when I activate a button; the window is for updating recipe parameters and another for the names of the recipes and their sequence. it only makes the update when activating a button but when saving the project and updating it in the runtime the values ​​of the database are modified alone and this hurts me a lot.

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [November 14, 2018, 6:04pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/5 "2018-11-14T18:04:58Z")

</div>

By “database”, are you referring to SQL or something like it connected to Ignition? If so, code samples may aid people in understanding what may be happening. Or contact support as @paul-griffith suggested.

Or perchance is the information that is getting changed stored in a dataset property (rather than a database)? If so, it will be overwritten with values in Designer anytime you save and publish (publish is the step that makes the update available to runtime clients). If you are storing in a dataset property, you can avoid overwriting by storing in a dataset memory tag and binding the dataset property to it.

---

<div class="post-metadata">

**Author:** ![alemancordero](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@alemancordero](https://forum.inductiveautomation.com/u/alemancordero)\
**Post date:** [November 14, 2018, 6:31pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/6 "2018-11-14T18:31:16Z")

</div>

I’ll do that, thank you very much

---

<div class="post-metadata">

**Author:** ![alemancordero](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@alemancordero](https://forum.inductiveautomation.com/u/alemancordero)\
**Post date:** [November 14, 2018, 6:37pm UTC](https://forum.inductiveautomation.com/t/error-in-database-with-upload-in-runtime/20785/7 "2018-11-14T18:37:11Z")

</div>

I’ll do that, thank you very much.
