Develop / Update DB not possible anymore (update_cli.php --update_db)

Isaac

I'm getting this error when trying to update the db through cli

# php8.2 update_cli.php --update_db

PHP Warning:  require_once(../database_updates.php): Failed to open stream: No such file or directory in /home/domain/web/domain.de/public_html/scripts/update_cli.php on line 117
PHP Fatal error:  Uncaught Error: Failed opening required '../database_updates.php' (include_path='.:/usr/share/php') in /home/domain/web/domain.de/public_html/scripts/update_cli.php:117
Stack trace:
#0 {main}
  thrown in /home/domain/web/domain.de/public_html/scripts/update_cli.php on line 117

Line 117 should be changed from

require_once "../database_updates.php";

require_once "../admin/database_updates.php";

shouldn't it? 🤔

wrongecho

What version of ITFlow are you running, because the move to /admin/ isn't out officially yet.

Isaac

yes, forgot to mention. I use the develop branch here locally for my tests.

wrongecho

Gotcha. We are always looking for help testing the upcoming features, so thanks for pointing this out. We'll make sure it's fixed before release!

johnny

yeah deff a bug in develop WIP

wrongecho

Looks fixed in develop, @Isaac can you confirm this is now working for you please?

Isaac

pulled all the dev updates today - firstly the db update worked. But can't go from 2.2.9 to 2.3.2 now.

Database updated from version 2.2.8 to 2.2.9.
The latest database version is 2.3.2.

# scripts/update_cli.php --update_db
PHP Warning:  Trying to access array offset on value of type null in /home/domain/web/helpdesk.domain.de/public_html/admin/database_updates.php on line 3912
PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'rp.recurring_payment_saved_payment_id' in 'SET' in /home/domain/web/helpdesk.domain.de/public_html/admin/database_updates.php:3915
Stack trace:
#0 /home/domain/web/helpdesk.domain.de/public_html/admin/database_updates.php(3915): mysqli_query()
#1 /home/domain/web/helpdesk.domain.de/public_html/scripts/update_cli.php(117): require_once('...')
#2 {main}
  thrown in /home/domain/web/helpdesk.domain.de/public_html/admin/database_updates.php on line 3915

Don't know why these two commands didn't find the way to my db 🤔

ALTER TABLE `recurring_payments` ADD `recurring_payment_saved_payment_id` INT(11) DEFAULT NULL AFTER `recurring_payment_recurring_invoice_id`
ALTER TABLE `recurring_payments` ADD CONSTRAINT `fk_recurring_saved_payment` FOREIGN KEY (`recurring_payment_saved_payment_id`) REFERENCES `client_saved_payment_methods`(`saved_payment_id`) ON DELETE CASCADE

Rest was ok - so after I manually did above two commands the updatecli-php --update_db worked again up to version 2.3.2