End of life for on-premise instances
At the end of March 2023, we cease on-premise hosting for Xentral instances. We encourage you to migrate your Xentral instance to our cloud - please do not hesitate to contact account@xentral.com for discussing and scheduling your cloud migration, or refer to our website or to our Community for more information.
Be aware that at the end of March 2023 we will stop any support services for on-premise hosted instances. There will be no further bug fixing or updates available. Likewise, we will not issue any further open source versions.
In version 22.1, the database table firmendaten will be removed completely. Therefore, all code that is accessing this table using a direct SQL query MUST be updated.
Additionally, it is recommended to also stop using direct SQL queries with the firmendaten_werte table, as this will allow for performance improvements.
Old code that is using a direct SQL query won't work anymore:
$this->app->DB->Query("UPDATE firmendaten SET freifeld13='Duft' where id='1'");
How to update: Use the SystemSettings service instead:
app(\App\Core\Settings\SystemSettings::class)->set('freifeld13', 'Duft');
Old code is fetching value of briefpapier2 using a direct SQL query:
$briefpapier2 = $this->app->DB->Select("SELECT briefpapier2 FROM firmendaten WHERE id={$firmendatenid}");
How to update: Use the SystemSettings service instead:
$briefpapier2 = app(\App\Core\Settings\SystemSettings::class)->get('briefpapier2');
It is highly recommended to stop using direct SQL queries also with the firmendaten_werte table.
Old code:
$land = $this->app->DB->Select("SELECT wert FROM firmendaten_werte WHERE name = 'land'");
How to fix:
$land = app(\App\Core\Settings\SystemSettings::class)->get('land');