Database Conversion Errors
Posted 2024-03-20 오후 6:48:18 · 관리자
Dear Customer.
We have just build new patch for fixing database converting error.
I attach download link for patch file.
PowerScene Lite for Py3 https://www.anygate.com/powerscene/patch/PowerSceneLite_2.0.5.3_x64_py3.zip
PowerScene Network for Py3 : https://www.anygate.com/powerscene/patch/PowerScene_2.0.5.3_x64_py3.zip
Those are based on powerscene 2.0.5.3.
If have no problems, we will apply next up coming release ( 2.0.6)
If have any problems, please net us know
Thanks
-------------------------------------------------------------
Dear Anygate,
It appears that the database converter assumes the length of data when creating the new tables in the exported database. This causes "Data too long for column '{col}' at row 1" errors during export. This is a common problem with calculation formulas (8000 char) and descriptions (50 char). It is not hard to exceed 50 characters for a point description. Our database in PowerScene has a 256 character limit for descriptions, but when we export/convert the database, the new database shows a limit of 50 characters, resulting in many export errors.
We also encounter this error for some tables: "No data supplied for parameters in prepared statement."
We have a MariaDB license.
Thank you,
RPE