SQL error

3 months ago · Last reply by Andrew Misplon 3 months ago

Hello,

My site uses the Vantage theme, and I’m getting this error on the homepage only. Do you have any ideas on how to resolve this issue?

(I didn’t create the site; I’m taking over maintenance.)

Database Error; SQL: SELECT DISTINCT `t`.* FROM `9El4zB_posts` AS `t` LEFT JOIN `9El4zB_postmeta` AS `date_de_debut_de_evenement` ON `date_de_debut_de_evenement`.`meta_key` = ‘date_de_debut_de_evenement’ AND `date_de_debut_de_evenement`.`post_id` = `t`.`ID` LEFT JOIN `9El4zB_postmeta` AS `date_de_fin_de_evenement` ON `date_de_fin_de_evenement`.`meta_key` = ‘date_de_fin_de_evenement’ AND `date_de_fin_de_evenement`.`post_id` = `t`.`ID` LEFT JOIN `9El4zB_postmeta` AS `statut_de_levenement` ON `statut_de_levenement`.`meta_key` = ‘statut_de_levenement’ AND `statut_de_levenement`.`post_id` = `t`.`ID` WHERE ( ( ( ( `date_de_debut_de_evenement`.`meta_value` > ‘2025-10-15 23:47:24’ ) OR ( ( ( `date_de_debut_de_evenement`.`meta_value` ‘2025-10-15 23:47:24’ ) AND ( `date_de_fin_de_evenement`.`meta_value` <= '(date_de_debut_de_evenement + INTERVAL 1 DAY)' ) ) ) ) ) AND ( `statut_de_levenement`.`meta_value` IN ( 'EventScheduled', 'EventRescheduled' ) ) AND ( `t`.`post_type` = 'evenements' ) AND ( `t`.`post_status` IN ( 'publish' ) ) ) ORDER BY date_de_debut_de_evenement ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date` LIMIT 0, 1; Response: Unknown column 'date_de_debut_de_evenement' in 'order clause'

Thank you

This is our free support forum. Replies can take several days.

Need fast email support? Get SiteOrigin Premium

Replies

1
  1. Andrew Misplon Staff 3 months, 30 days ago

    Hi Guillaume

    Thanks for getting in touch. Does the error persist if you temporarily switch to a default theme and temporarily deactivate all SiteOrigin plugins?

Replies on this thread are closed.

Please create a new thread if you have a question, or purchase a SiteOrigin Premium license if you need one-on-one email support.

Have a different question or issue?

Start New Thread