Menu
▾
▴
Re: [WebERP-developers] Database upgrade issues
|
From: Tim S. <tim...@gm...> - 2024-10-26 19:17:25
|
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/ |
