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