search

timschofield / webERP

webERP Accounting and Business Administration ERP system
https://www.weberp.org
GNU General Public License v2.0
29 stars 113 forks source link

demo.sql fails due to missing accountgroups table #246

Open dalers opened 1 week ago

dalers commented 1 week ago

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 #236
  3. update to latest schema by logging in for the first time (Z_UpgradeDatabase.php runs automatically)
timschofield commented 4 days ago

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 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 https://github.com/timschofield/webERP/issues/236 (followed by automatically run Z_UpgradeDatabase.php after logging in for the first time).

— Reply to this email directly, view it on GitHub https://github.com/timschofield/webERP/issues/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/

dalers commented 4 days ago

Hi Tim, I was trying to create a test database.

I was doing it manually instead of using the installer because it seems the installer is only suitable for initial webERP installation since it requires config.php to be deleted (or renamed) to run. What procedure would you have used?

P.S. this topic is related in a larger way to the installer and the discussion in isue #214

timschofield commented 3 days ago

These days the installer can be used even if config.php exists, you just have to type in the URL. It is my intention to replace the Z_MakeNewCompany.php function with the installer, just skipping those bits not applicable.

Thanks Tim

On Sun, 24 Nov 2024 at 03:48, Dale Scott @.***> wrote:

Hi Tim, I was trying to create a test database.

I was doing it manually instead of using the installer because it seems the installer is only suitable for initial webERP installation since it requires config.php to be deleted (or renamed) to run. What procedure would you have used?

P.S. this topic is related in a larger way to the installer and the discussion in isue #214 https://github.com/timschofield/webERP/issues/214

— Reply to this email directly, view it on GitHub https://github.com/timschofield/webERP/issues/246#issuecomment-2495784718, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAL6LH5XUI4LIZJLYSKXZL2CFD7PAVCNFSM6AAAAABSA2JAF2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOJVG44DINZRHA . You are receiving this because you commented.Message ID: @.***>

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

dalers commented 3 days ago

I suspect the check boxes were intended for printing parts of the manual.

Is anyone interested in having the check boxes work? If not, I suggest they be removed as they're an obvious fail for a new user.

timschofield commented 3 days ago

I would definitely vote to remove. They have been there since before I started with the project which was 2006, and I have never really seen their point. I think you are probably right when you say it is related to physically print it.

Thanks Tim

On Sun, 24 Nov 2024 at 17:55, Dale Scott @.***> wrote:

I suspect the check boxes were intended for printing parts of the manual.

Is anyone interested in having the check boxes work? If not, I suggest they be removed as they're an obvious fail for a new user.

— Reply to this email directly, view it on GitHub https://github.com/timschofield/webERP/issues/246#issuecomment-2496137582, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAL6LHPAZWZBWXAT6QQDQD2CIHKBAVCNFSM6AAAAABSA2JAF2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOJWGEZTONJYGI . You are receiving this because you commented.Message ID: @.***>

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