Menu
▾
▴
Re: [WebERP-developers] Database upgrade issues
|
From: Dale S. <dal...@sh...> - 2024-10-26 23:16:31
|
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 |
