Cannot add new Test VRT 1.7.0 about visual-regression-tests HOT 6 CLOSED

@domtra the error was because the table name was changed to base_screenshot_date during one of the version updates and the ALTER table statement didn't work, so I just renamed the table in MySQL and the error is gone.

from visual-regression-tests.

Hi @billiemead, the version 1.7.0 wasn't ready for public release yesterday as we needed also to adjust our service to support some features first.

The 1.7.0 is ready now to be used and now it's also published on wordpress.org.

from visual-regression-tests.

Still having issues. npm run build is failing (very minimal details). Also, https://bleech-vrts-app.blee.ch/api/v1/ is giving a 404 error.

> @bleech/[email protected] build
> run-s --silent lint wp:scripts:build

'.' is not recognized as an internal or external command,
operable program or batch file.

from visual-regression-tests.

@steffenbew ok, as mentioned in the other issue, I am able to run npm run start and that builds the CSS & JS so now I can add my first test! But the API URL https://bleech-vrts-app.blee.ch/api/v1/ is still down.

And the list of tests is still empty, it currently shows Running (2):

from visual-regression-tests.

@steffenbew deleted as I see you did account for table prefix. This might be more helpful, from debug.log:

[19-Dec-2023 18:42:15 UTC] WordPress database error Unknown column 'tests.base_screenshot_date' in 'field list' for query 
			SELECT
				tests.id,
				tests.status,
				tests.base_screenshot_date,
				tests.post_id,
				tests.current_alert_id,
				tests.service_test_id,
				tests.hide_css_selectors,
				tests.next_run_date,
				tests.last_comparison_date,
				tests.is_running,
				posts.post_title
			FROM wpi5_vrts_tests as tests
			INNER JOIN wpi5_posts as posts ON posts.id = tests.post_id
			WHERE 1=1
			ORDER BY id DESC
			LIMIT 0, 20
		 made by do_action('toplevel_page_vrts'), WP_Hook->do_action, WP_Hook->apply_filters, Vrts\Features\Tests_Page->render_page, Vrts\Core\Plugin->component, Vrts\Core\Plugin->get_component, include('/plugins/visual-regression-tests-main/components/tests-page/index.php'), include('/plugins/visual-regression-tests-main/components/tests-page/views/tests-page-list.php'), Vrts\List_Tables\Tests_List_Table->prepare_items, Vrts\Models\Test::get_items

from visual-regression-tests.

hey @billiemead. unfortunately, it is really hard to make sense of all of this.
could you please try to upgrade to v1.7.1 of the plugin? best use either the update functionality in wp-admin, or if through composer via https://wpackagist.org/.
if things still do not work after that, please uninstall the plugin via wp-admin. if you cannot do this, i will provide you with a couple of db queries you can alternatively try out.

from visual-regression-tests.