WP Version: 6.8.3
PG4WP Version: 3.4.1
Error:
----> ERROR: syntax error at or near "VALUES"
LINE 3: WHERE ( SELECT NULL FROM DUAL ) IS NULL RETURNING * VALUES
^
RAW SQL
INSERT INTO wp_actionscheduler_actions ( `hook`, `status`, `scheduled_date_gmt`, `scheduled_date_local`, `schedule`, `group_id`, `priority`, `args` )
SELECT 'aioseo_ai_update_credits', 'pending', '2025-10-08 14:16:58', '2025-10-08 14:16:58', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"', 1, 10, '[]' FROM DUAL
WHERE ( SELECT NULL FROM DUAL ) IS NULL
Expected Rewritten SQL
INSERT INTO wp_actionscheduler_actions ( hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, priority, args )
SELECT 'aioseo_ai_update_credits', 'pending', '2025-10-08 14:16:58', '2025-10-08 14:16:58', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"', 1, 10, '[]'
WHERE ( SELECT NULL ) IS NULL RETURNING *
Actual Rewritten SQL
INSERT INTO wp_actionscheduler_actions ( hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, priority, args )
SELECT 'aioseo_ai_update_credits', 'pending', '2025-10-08 14:16:58', '2025-10-08 14:16:58', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"', 1, 10, '[]' FROM DUAL
WHERE ( SELECT NULL FROM DUAL ) IS NULL RETURNING * VALUES
MySQL's FROM DUAL can be removed completely.
Also remove VALUES from the end. (This may get fixed automatically with the removal of FROM DUALs.)
WP Version: 6.8.3
PG4WP Version: 3.4.1
Error:
RAW SQL
Expected Rewritten SQL
Actual Rewritten SQL
MySQL's
FROM DUALcan be removed completely.Also remove
VALUESfrom the end. (This may get fixed automatically with the removal of FROM DUALs.)