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

Commit 8395 does not install database #198

Closed efeoli closed 4 weeks ago

efeoli commented 1 month ago

Hi, I was waiting for your installer rewritted script, since the application could not be installed when clicking the INSTALL button.

Despite the improvements the files get installed but not the database.

Enrique

timschofield commented 1 month ago

Hello Enrique,

The changes committed yesterday were just some minor fixes that happened in a general sweep of the code. The new installer will be loaded up later today I hope. I will let you know when, and it would be great if you could test again.

Tim

timschofield commented 4 weeks ago

The new installer is now in the master branch. I would really appreciate it if you could test on your system.

Thanks Tim

efeoli commented 4 weeks ago

Hello Tim. Thank you for letting me know about the latest master.

It gets to the database credentials, but it will accept the data. Tried repeatedly.

Attachments might help. Enrique

Captura de pantalla_25-10-2024_103115_kwa bioacyl com after Captura de pantalla_25-10-2024_102628_kwa bioacyl com

efeoli commented 4 weeks ago

I clarify: it will not accept data

efeoli commented 4 weeks ago

Also images are diproportionatelly large and disturbs format for data to be eneterd and it is not what goes where.

timschofield commented 4 weeks ago

It looks like the css isn't applying. Can you try ctrl-f5 in the browser to force a css reload.

Tim

efeoli commented 4 weeks ago

Yes it did loas the correct css and the procedure went through, but it loaded only 57 tables of the database ínstead of 175. Enrique

efeoli commented 4 weeks ago

Not it will perform upgrade to a 4.15.2 database. It gets stuck at steps 5,6,7. Screenshot 2024-10-25 at 12-23-51 Database Upgrade

timschofield commented 4 weeks ago

What was the last table it created? It creates them in alphabetic order

efeoli commented 4 weeks ago

These are the 57 tables that it creatres. Captura de pantalla_25-10-2024_13748_da4613 squidix net

timschofield commented 4 weeks ago

I have just pushed two files install/tables/jnltmpldetails.sql install/tables/jnltmplheader.sql

Can you try downloading them and trying again?

Tim

efeoli commented 4 weeks ago

It only improved installing 60 tablea and the last one is “modules”.

Enrique

efeoli commented 4 weeks ago

I also the notice of the 5,6,7 steps to go attached above.

timschofield commented 4 weeks ago

That's very strange as the 60th table is labelfields.

Did you get any error message?

efeoli commented 4 weeks ago

No error message.

Would you like a snapshot of tables?

timschofield commented 4 weeks ago

Yes please. I ran the installer with mysql mode set as STRICT_TRANS_TABLES and it threw a couple of errors that I have corrected and pushed.

Are you deleting the database between attempts?

efeoli commented 4 weeks ago

I was emptying the database. I will delete and rey again.

We are 6 hours earlier in Costa Rica. I will be available tomorrow in case you will need further testimg. Captura de pantalla_25-10-2024_153658_da4613 squidix net

efeoli commented 4 weeks ago

Success!

I comment tomorrow on how it is working.

timschofield commented 4 weeks ago

Glad it now works for you.

I ran the installer again with everything (web server/mysql/PHP) set on their most severe settings. Found 3 more errors that I have now fixed and uploaded