[WebERP-developers] New install issue

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Tim,

I pulled again and see eight new commits. You've been busy! :-)

This time I ran the installer. I renamed config.php (leaving the original config.distrib.php) and the installer ran when I browsed to the site.

I created a "weberp" database in advance and entered the name, username and password in the installer (and also the admin user email and password), and checked the "enter demo data" box. The installer then reported:

The companies directory has been successfully created
Your logo has been successfully uploaded
The config.php file has been created based on your settings.
All database tables have been created
Populating the database with demo data.

Inspecting the weberp database, the tables were created but there are no entries in the www_users table. From the wording in the installer, I thought the installer would install the demo data into the database I specified, but I suspect it tried creating a "weberpdemo" database for the demo data and hung not having the necessary MariaDb credentials. I'll cleanup the environment and try again tomorrow giving the root MariaDb user and password to the installer. 

Dale

----- Original Message -----
> From: "Dale Scott (dalescott@shaw)" <dal...@sh...>
> To: "webERP Developers" <web...@li...>
> Sent: Saturday, October 26, 2024 5:16:23 PM
> Subject: Re: [WebERP-developers] Database upgrade issues

> I'm not trying to "install" per se, just clone the code, edit config.php, and
> login (using a circa-2018 database with about a dozen parts and a couple
> purchase orders for stock).
> 
> Is running the install script required?
> 
> 
> 
> ----- Original Message -----
>> From: "Tim Schofield" <tim...@gm...>
>> To: "webERP Developers" <web...@li...>
>> Sent: Saturday, October 26, 2024 1:34:46 PM
>> Subject: Re: [WebERP-developers] Database upgrade issues
> 
>> I miss snow, we don't have it any more here!
>> 
>> It's a bit frustrating because it installs fine here. Have you the
>> very latest code?
>> 
>> On Sat, 26 Oct 2024 at 19:24, Dale Scott <dal...@sh...> wrote:
>>>
>>> Hi Tim, I browsed the topic you linked and will comment after reviewing in more
>>> detail.
>>>
>>> I can't trust upgrades weren't partially applied, so will restore the database
>>> from backup and experiment more later (our front porch needs some restoration
>>> work completed before the snow starts here in earnest next week...)
>>>
>>> Cheers,
>>> Dale
>>>
>>>
>>> ----- Original Message -----
>>> > From: "Tim Schofield" <tim...@gm...>
>>> > To: "webERP Developers" <web...@li...>
>>> > Sent: Saturday, October 26, 2024 1:17:03 PM
>>> > Subject: Re: [WebERP-developers] Database upgrade issues
>>>
>>> > Hi Dale, you are not alone having this issue. I am not, but I think
>>> > it's because I have some uncommitted stuff on my machine
>>> >
>>> > See here:
>>> >
>>> > https://github.com/timschofield/webERP/discussions/204#discussioncomment-11061609
>>> >
>>> > Basically set that value in the config table to 7
>>> >
>>> > Thanks
>>> > Tim
>>> >
>>> > Tim
>>> >
>>> > On Sat, 26 Oct 2024 at 19:13, Dale Scott <dal...@sh...> wrote:
>>> >>
>>> >> Tim, you are correct. I had forgotten to re-create the companies directory
>>> >> corresponding to the database name. Doh!
>>> >>
>>> >> After recreating the companies directory with company logo I was able to login
>>> >> to my Nov-2018 demo database (same database I used to create my blog tutorial
>>> >> posts). Woo hoo! :-)
>>> >>
>>> >> My jubilation was shortlived though.
>>> >>
>>> >> Z_UpgradeDatabase.php ran immediateley after login (i.e. without seeing the
>>> >> dashboard) showing a table indicating database upgrades 0 through 7 were
>>> >> required. I clicked "Continue with Upgrades" and the page then showed only the
>>> >> header "Database Upgrade". Nothing happened after several minutes so I tried
>>> >> refreshing the browser tab to no effect. I then browsed to the index page and
>>> >> Z_UpgradeDatabase.php ran againm, but this time showing only upgrades 5 to 7
>>> >> were required. I clicked "Continue with Upgrades" again, and again the system
>>> >> seemed stuck showing only header "Database Upgrades". I browsed back to the
>>> >> index page, and again Z_UpgradeDatabase.php ran, which listed upgrades 5 to 7
>>> >> again.
>>> >>
>>> >> At this point I'm stuck. I'm going to restore the database backup again and
>>> >> retrace my steps to confirm behavior. I'm assuming investigating this is of
>>> >> benefit because I presume active webERP users will want to upgrade their
>>> >> databases.
>>> >>
>>> >> Do you want me to send the database sql.gz? (it's not confidential or
>>> >> proprietary). I didn't keep a copy of the companys/company/part_pics directory,
>>> >> but don't expect this would be a cause of problems (only that pics wouldn't be
>>> >> shown viewing browsing stock items, if I should I get that far....)
>>> >>
>>> >> Would you like me to enable debugging before I try again?
>>> >>
>>> >> Fwiw, I copied some errors from the Apache httpd-error.log below in case they
>>> >> are helpful. The app stack is PHP 8.1.29, Apache 2.4.62 and MariaDb 10.6.18.
>>> >>
>>> >> Cheers,
>>> >> Dale
>>> >>
>>> >>
>>> >> /var/log/httpd-error.log
>>> >>
>>> >> [Sat Oct 26 12:21:21.183082 2024] [php:error] [pid 10098] [client
>>> >> 174.0.43.39:59461] PHP Fatal error:  Uncaught mysqli_sql_exception: Table
>>> >> 'weberp_scc.session_data' doesn't exist in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc:58\nStack trace:\n#0
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc(58): mysqli_query()\n#1
>>> >> /usr/local/www/weberp/index.php(19): DB_query()\n#2 {main}\n  thrown in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc on line 58
>>> >> [Sat Oct 26 12:21:30.977154 2024] [php:error] [pid 10134] [client
>>> >> 174.0.43.39:59462] PHP Fatal error:  Uncaught mysqli_sql_exception: Data too
>>> >> long for column 'reportlink' at row 1 in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc:58\nStack trace:\n#0
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc(58): mysqli_query()\n#1
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(36): DB_query()\n#2
>>> >> /usr/local/www/weberp/includes/UpgradeDB_mysqli.php(130): executeSQL()\n#3
>>> >> /usr/local/www/weberp/sql/updates/5.php(33): NewModule()\n#4
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(124): include('...')\n#5 {main}\n
>>> >> thrown in /usr/local/www/weberp/includes/ConnectDB_mysqli.inc on line 58,
>>> >> referer: http://weberp.dalescott.net/Z_UpgradeDatabase.php
>>> >> [Sat Oct 26 12:47:35.972660 2024] [php:error] [pid 10215] [client
>>> >> 174.0.43.39:59790] PHP Fatal error:  Uncaught mysqli_sql_exception: Data too
>>> >> long for column 'reportlink' at row 1 in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc:58\nStack trace:\n#0
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc(58): mysqli_query()\n#1
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(36): DB_query()\n#2
>>> >> /usr/local/www/weberp/includes/UpgradeDB_mysqli.php(130): executeSQL()\n#3
>>> >> /usr/local/www/weberp/sql/updates/5.php(33): NewModule()\n#4
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(124): include('...')\n#5 {main}\n
>>> >> thrown in /usr/local/www/weberp/includes/ConnectDB_mysqli.inc on line 58,
>>> >> referer: http://weberp.dalescott.net/Z_UpgradeDatabase.php
>>> >> [Sat Oct 26 12:47:40.562651 2024] [php:error] [pid 10457] [client
>>> >> 174.0.43.39:59791] PHP Fatal error:  Uncaught mysqli_sql_exception: Data too
>>> >> long for column 'reportlink' at row 1 in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc:58\nStack trace:\n#0
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc(58): mysqli_query()\n#1
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(36): DB_query()\n#2
>>> >> /usr/local/www/weberp/includes/UpgradeDB_mysqli.php(130): executeSQL()\n#3
>>> >> /usr/local/www/weberp/sql/updates/5.php(33): NewModule()\n#4
>>> >> /usr/local/www/weberp/Z_UpgradeDatabase.php(124): include('...')\n#5 {main}\n
>>> >> thrown in /usr/local/www/weberp/includes/ConnectDB_mysqli.inc on line 58,
>>> >> referer: http://weberp.dalescott.net/Z_UpgradeDatabase.php
>>> >> [Sat Oct 26 12:47:46.035669 2024] [php:error] [pid 10112] [client
>>> >> 174.0.43.39:59794] PHP Fatal error:  Uncaught mysqli_sql_exception: Table
>>> >> 'weberp_scc.session_data' doesn't exist in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc:58\nStack trace:\n#0
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc(58): mysqli_query()\n#1
>>> >> /usr/local/www/weberp/index.php(19): DB_query()\n#2 {main}\n  thrown in
>>> >> /usr/local/www/weberp/includes/ConnectDB_mysqli.inc on line 58
>>> >> dale@whizzer:/usr/local/www/weberp/companies/weberp_scc $
>>> >>
>>> >>
>>> >>
>>> >> ----- Forwarded Message -----
>>> >> From: "Tim Schofield" <tim...@gm...>
>>> >> To: "webERP Developers" <web...@li...>
>>> >> Cc: "For the general discussion of webERP project"
>>> >> <web...@li...>
>>> >> Sent: Saturday, October 26, 2024 12:20:35 AM
>>> >> Subject: Re: [webERP-users] [WebERP-developers]  Project status
>>> >>
>>> >> Hi Dale, in the companies/YOURCO/ directory, is there a logo.png with
>>> >> your logo in it>
>>> >>
>>> >> Tim
>>> >>
>>> >>
>>> >> ----- Original Message -----
>>> >> > From: "Dale Scott (dalescott@shaw)" <dal...@sh...>
>>> >> > To: "For the general discussion of webERP project"
>>> >> > <web...@li...>
>>> >> > Cc: "webERP Developers" <web...@li...>
>>> >> > Sent: Friday, October 25, 2024 10:28:39 PM
>>> >> > Subject: Re: [WebERP-developers] [webERP-users]  Project status
>>> >>
>>> >> > First time login to new code and restorated 2018 database. The login window
>>> >> > shows the webERP demo logo instead of my database.
>>> >> >
>>> >> > Is this possible I don't have the password correct in config.php?
>>> >> >
>>> >> > Cheers,
>>> >> > Dale
>>> >> >
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> Web-erp-developers mailing list
>>> >> Web...@li...
>>> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>> >
>>> >
>>> >
>>> > --
>>> > www.weberpafrica.com
>>> > @TimSchofield2
>>> > Blog: https://kwamoja.home.blog/
>>> >
>>> >
>>> > _______________________________________________
>>> > Web-erp-developers mailing list
>>> > Web...@li...
>>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> 
>> 
>> 
>> --
>> www.weberpafrica.com
>> @TimSchofield2
>> Blog: https://kwamoja.home.blog/
>> 
>> 
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 
> 
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] New install issue

Accounting & Best Practice Business Administration System

[WebERP-developers] New install issue