How to fix ER_WINDOW_FRAME_START_ILLEGAL (3584): Illegal frame start in MySQL

OVER (
  [PARTITION BY ...]
  [ORDER BY ...]
  [ROWS|RANGE BETWEEN frame_start AND frame_end]
)

-- INCORRECT (causes error):
SELECT name, salary,
  ROW_NUMBER() OVER (ORDER BY salary GROUPS BETWEEN 1 PRECEDING AND 1 FOLLOWING)
FROM employees;

-- CORRECT:
SELECT name, salary,
  ROW_NUMBER() OVER (ORDER BY salary ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)
FROM employees;

-- INCORRECT:
SELECT * FROM users
WINDOW user_window AS (
  ORDER BY created_at
  ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE CURRENT ROW
);

-- CORRECT:
SELECT * FROM users
WINDOW user_window AS (
  ORDER BY created_at
  ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
);

-- CORRECT:
SELECT name, salary,
  AVG(salary) OVER (
    ORDER BY hire_date
    ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING
  ) as avg_surrounding
FROM employees;

-- CORRECT with INTERVAL (for temporal data):
SELECT order_date, amount,
  SUM(amount) OVER (
    ORDER BY order_date
    RANGE BETWEEN INTERVAL 7 DAY PRECEDING AND CURRENT ROW
  ) as weekly_total
FROM orders;

-- Frame clause is ignored and causes complexity:
SELECT name,
  ROW_NUMBER() OVER (ORDER BY salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
FROM employees;

-- Simpler (frame is ignored anyway):
SELECT name,
  ROW_NUMBER() OVER (ORDER BY salary)
FROM employees;