demo.sql fails due to missing accountgroups table

[dalers]

demo.sql fails execution on new db with following error (MariaDb v10.6):

Error in query (1146): Table 'weberp_scc.accountgroups' doesn't exist

--
-- Dumping data for table `accountgroups`
--

[LOCK TABLES](https://mariadb.com/kb/en/library/lock-tables/) `accountgroups` WRITE

Until this issue is resolved, the workaround for configuring a new database is to:

1. configure an empty database with schema using sql/mysql/country_sql/default.sql
2. manually update to v4.15.2 schema following default.sql is inconsistent with VersionNumber 4.15.1 #236
3. update to latest schema by logging in for the first time (Z_UpgradeDatabase.php runs automatically)

[timschofield]

Hi Dale, are you trying to configure the database manually rather than with the installer? Tim

…

On Mon, 18 Nov 2024 at 23:46, Dale Scott ***@***.***> wrote: demo.sql fails with following error on MariaDb v10.6: Error in query (1146): Table 'weberp_scc.accountgroups' doesn't exist -- -- Dumping data for table `accountgroups` -- [LOCK TABLES](https://mariadb.com/kb/en/library/lock-tables/) `accountgroups` WRITE Until this issue is resolved, the workaround for configuring a new database is to use sql/mysql/country_sql/default.sql and manually update to v4.15.2 following #236 <#236> (followed by automatically run Z_UpgradeDatabase.php after logging in for the first time). — Reply to this email directly, view it on GitHub <#246>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAL6LEQNAZ6GTV3KW2QQDL2BJ35HAVCNFSM6AAAAABSA2JAF2VHI2DSMVQWIX3LMV43ASLTON2WKOZSGY3TAMZTGI3TGNA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

-- www.weberp.org <http://www.weberpafrica.com> @TimSchofield2 Blog: https://kwamoja.home.blog/