EE4 compatibility updates:
- Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field (it's in the works).
- Reel is EE4 and EE5 compatible, but it does not currently support the Fluid field.
Ticket: Upgrade to 3, getting error on save
Status | Resolved |
Add-on / Version | Publisher Lite 3.0.0 |
Severity | |
EE Version | 5.1.1 |
Mighty Citizen
Nov 25, 2019Here is the error that I’m getting - appears related to the empty parenthesis at the end of the query
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 53:
SELECT `t`.*, `exp_publisher_data_field_10`.`field_id_10` AS field_id_10, `exp_publisher_data_field_11`.`field_id_11` AS field_id_11, `exp_publisher_data_field_13`.`field_id_13` AS field_id_13, `exp_publisher_data_field_14`.`field_id_14` AS field_id_14, `exp_publisher_data_field_15`.`field_id_15` AS field_id_15, `exp_publisher_data_field_17`.`field_id_17` AS field_id_17, `exp_publisher_data_field_18`.`field_id_18` AS field_id_18, `exp_publisher_data_field_19`.`field_id_19` AS field_id_19, `exp_publisher_data_field_20`.`field_id_20` AS field_id_20, `exp_publisher_data_field_21`.`field_id_21` AS field_id_21, `exp_publisher_data_field_22`.`field_id_22` AS field_id_22, `exp_publisher_data_field_23`.`field_id_23` AS field_id_23, `exp_publisher_data_field_24`.`field_id_24` AS field_id_24, `exp_publisher_data_field_25`.`field_id_25` AS field_id_25, `exp_publisher_data_field_26`.`field_id_26` AS field_id_26, `exp_publisher_data_field_27`.`field_id_27` AS field_id_27, `exp_publisher_data_field_28`.`field_id_28` AS field_id_28, `exp_publisher_data_field_29`.`field_id_29` AS field_id_29, `exp_publisher_data_field_30`.`field_id_30` AS field_id_30, `exp_publisher_data_field_31`.`field_id_31` AS field_id_31, `exp_publisher_data_field_32`.`field_id_32` AS field_id_32, `exp_publisher_data_field_33`.`field_id_33` AS field_id_33, `exp_publisher_data_field_34`.`field_id_34` AS field_id_34, `exp_publisher_data_field_38`.`field_id_38` AS field_id_38, `exp_publisher_data_field_39`.`field_id_39` AS field_id_39, `exp_publisher_data_field_40`.`field_id_40` AS field_id_40, `exp_publisher_data_field_41`.`field_id_41` AS field_id_41, `exp_publisher_data_field_42`.`field_id_42` AS field_id_42, `exp_publisher_data_field_43`.`field_id_43` AS field_id_43, `exp_publisher_data_field_44`.`field_id_44` AS field_id_44, `exp_publisher_data_field_45`.`field_id_45` AS field_id_45, `exp_publisher_data_field_46`.`field_id_46` AS field_id_46, `exp_publisher_data_field_47`.`field_id_47` AS field_id_47, `exp_publisher_data_field_48`.`field_id_48` AS field_id_48, `exp_publisher_data_field_49`.`field_id_49` AS field_id_49, `exp_publisher_data_field_50`.`field_id_50` AS field_id_50, `exp_publisher_data_field_51`.`field_id_51` AS field_id_51, `exp_publisher_data_field_52`.`field_id_52` AS field_id_52, `exp_publisher_data_field_53`.`field_id_53` AS field_id_53, `exp_publisher_data_field_54`.`field_id_54` AS field_id_54, `exp_publisher_data_field_55`.`field_id_55` AS field_id_55, `exp_publisher_data_field_56`.`field_id_56` AS field_id_56, `exp_publisher_data_field_57`.`field_id_57` AS field_id_57, `exp_publisher_data_field_58`.`field_id_58` AS field_id_58, `exp_publisher_data_field_60`.`field_id_60` AS field_id_60, `exp_publisher_data_field_61`.`field_id_61` AS field_id_61, `exp_publisher_data_field_62`.`field_id_62` AS field_id_62, `exp_publisher_data_field_63`.`field_id_63` AS field_id_63, `exp_publisher_data_field_64`.`field_id_64` AS field_id_64, `exp_publisher_data_field_65`.`field_id_65` AS field_id_65 FROM (`exp_publisher_titles` AS t) LEFT JOIN `exp_publisher_data_field_10` ON `t`.`entry_id` = `exp_publisher_data_field_10`.`entry_id` AND t.lang_id = exp_publisher_data_field_10.lang_id AND t.status = exp_publisher_data_field_10.status LEFT JOIN `exp_publisher_data_field_11` ON `t`.`entry_id` = `exp_publisher_data_field_11`.`entry_id` AND t.lang_id = exp_publisher_data_field_11.lang_id AND t.status = exp_publisher_data_field_11.status LEFT JOIN `exp_publisher_data_field_13` ON `t`.`entry_id` = `exp_publisher_data_field_13`.`entry_id` AND t.lang_id = exp_publisher_data_field_13.lang_id AND t.status = exp_publisher_data_field_13.status LEFT JOIN `exp_publisher_data_field_14` ON `t`.`entry_id` = `exp_publisher_data_field_14`.`entry_id` AND t.lang_id = exp_publisher_data_field_14.lang_id AND t.status = exp_publisher_data_field_14.status LEFT JOIN `exp_publisher_data_field_15` ON `t`.`entry_id` = `exp_publisher_data_field_15`.`entry_id` AND t.lang_id = exp_publisher_data_field_15.lang_id AND t.status = exp_publisher_data_field_15.status LEFT JOIN `exp_publisher_data_field_17` ON `t`.`entry_id` = `exp_publisher_data_field_17`.`entry_id` AND t.lang_id = exp_publisher_data_field_17.lang_id AND t.status = exp_publisher_data_field_17.status LEFT JOIN `exp_publisher_data_field_18` ON `t`.`entry_id` = `exp_publisher_data_field_18`.`entry_id` AND t.lang_id = exp_publisher_data_field_18.lang_id AND t.status = exp_publisher_data_field_18.status LEFT JOIN `exp_publisher_data_field_19` ON `t`.`entry_id` = `exp_publisher_data_field_19`.`entry_id` AND t.lang_id = exp_publisher_data_field_19.lang_id AND t.status = exp_publisher_data_field_19.status LEFT JOIN `exp_publisher_data_field_20` ON `t`.`entry_id` = `exp_publisher_data_field_20`.`entry_id` AND t.lang_id = exp_publisher_data_field_20.lang_id AND t.status = exp_publisher_data_field_20.status LEFT JOIN `exp_publisher_data_field_21` ON `t`.`entry_id` = `exp_publisher_data_field_21`.`entry_id` AND t.lang_id = exp_publisher_data_field_21.lang_id AND t.status = exp_publisher_data_field_21.status LEFT JOIN `exp_publisher_data_field_22` ON `t`.`entry_id` = `exp_publisher_data_field_22`.`entry_id` AND t.lang_id = exp_publisher_data_field_22.lang_id AND t.status = exp_publisher_data_field_22.status LEFT JOIN `exp_publisher_data_field_23` ON `t`.`entry_id` = `exp_publisher_data_field_23`.`entry_id` AND t.lang_id = exp_publisher_data_field_23.lang_id AND t.status = exp_publisher_data_field_23.status LEFT JOIN `exp_publisher_data_field_24` ON `t`.`entry_id` = `exp_publisher_data_field_24`.`entry_id` AND t.lang_id = exp_publisher_data_field_24.lang_id AND t.status = exp_publisher_data_field_24.status LEFT JOIN `exp_publisher_data_field_25` ON `t`.`entry_id` = `exp_publisher_data_field_25`.`entry_id` AND t.lang_id = exp_publisher_data_field_25.lang_id AND t.status = exp_publisher_data_field_25.status LEFT JOIN `exp_publisher_data_field_26` ON `t`.`entry_id` = `exp_publisher_data_field_26`.`entry_id` AND t.lang_id = exp_publisher_data_field_26.lang_id AND t.status = exp_publisher_data_field_26.status LEFT JOIN `exp_publisher_data_field_27` ON `t`.`entry_id` = `exp_publisher_data_field_27`.`entry_id` AND t.lang_id = exp_publisher_data_field_27.lang_id AND t.status = exp_publisher_data_field_27.status LEFT JOIN `exp_publisher_data_field_28` ON `t`.`entry_id` = `exp_publisher_data_field_28`.`entry_id` AND t.lang_id = exp_publisher_data_field_28.lang_id AND t.status = exp_publisher_data_field_28.status LEFT JOIN `exp_publisher_data_field_29` ON `t`.`entry_id` = `exp_publisher_data_field_29`.`entry_id` AND t.lang_id = exp_publisher_data_field_29.lang_id AND t.status = exp_publisher_data_field_29.status LEFT JOIN `exp_publisher_data_field_30` ON `t`.`entry_id` = `exp_publisher_data_field_30`.`entry_id` AND t.lang_id = exp_publisher_data_field_30.lang_id AND t.status = exp_publisher_data_field_30.status LEFT JOIN `exp_publisher_data_field_31` ON `t`.`entry_id` = `exp_publisher_data_field_31`.`entry_id` AND t.lang_id = exp_publisher_data_field_31.lang_id AND t.status = exp_publisher_data_field_31.status LEFT JOIN `exp_publisher_data_field_32` ON `t`.`entry_id` = `exp_publisher_data_field_32`.`entry_id` AND t.lang_id = exp_publisher_data_field_32.lang_id AND t.status = exp_publisher_data_field_32.status LEFT JOIN `exp_publisher_data_field_33` ON `t`.`entry_id` = `exp_publisher_data_field_33`.`entry_id` AND t.lang_id = exp_publisher_data_field_33.lang_id AND t.status = exp_publisher_data_field_33.status LEFT JOIN `exp_publisher_data_field_34` ON `t`.`entry_id` = `exp_publisher_data_field_34`.`entry_id` AND t.lang_id = exp_publisher_data_field_34.lang_id AND t.status = exp_publisher_data_field_34.status LEFT JOIN `exp_publisher_data_field_38` ON `t`.`entry_id` = `exp_publisher_data_field_38`.`entry_id` AND t.lang_id = exp_publisher_data_field_38.lang_id AND t.status = exp_publisher_data_field_38.status LEFT JOIN `exp_publisher_data_field_39` ON `t`.`entry_id` = `exp_publisher_data_field_39`.`entry_id` AND t.lang_id = exp_publisher_data_field_39.lang_id AND t.status = exp_publisher_data_field_39.status LEFT JOIN `exp_publisher_data_field_40` ON `t`.`entry_id` = `exp_publisher_data_field_40`.`entry_id` AND t.lang_id = exp_publisher_data_field_40.lang_id AND t.status = exp_publisher_data_field_40.status LEFT JOIN `exp_publisher_data_field_41` ON `t`.`entry_id` = `exp_publisher_data_field_41`.`entry_id` AND t.lang_id = exp_publisher_data_field_41.lang_id AND t.status = exp_publisher_data_field_41.status LEFT JOIN `exp_publisher_data_field_42` ON `t`.`entry_id` = `exp_publisher_data_field_42`.`entry_id` AND t.lang_id = exp_publisher_data_field_42.lang_id AND t.status = exp_publisher_data_field_42.status LEFT JOIN `exp_publisher_data_field_43` ON `t`.`entry_id` = `exp_publisher_data_field_43`.`entry_id` AND t.lang_id = exp_publisher_data_field_43.lang_id AND t.status = exp_publisher_data_field_43.status LEFT JOIN `exp_publisher_data_field_44` ON `t`.`entry_id` = `exp_publisher_data_field_44`.`entry_id` AND t.lang_id = exp_publisher_data_field_44.lang_id AND t.status = exp_publisher_data_field_44.status LEFT JOIN `exp_publisher_data_field_45` ON `t`.`entry_id` = `exp_publisher_data_field_45`.`entry_id` AND t.lang_id = exp_publisher_data_field_45.lang_id AND t.status = exp_publisher_data_field_45.status LEFT JOIN `exp_publisher_data_field_46` ON `t`.`entry_id` = `exp_publisher_data_field_46`.`entry_id` AND t.lang_id = exp_publisher_data_field_46.lang_id AND t.status = exp_publisher_data_field_46.status LEFT JOIN `exp_publisher_data_field_47` ON `t`.`entry_id` = `exp_publisher_data_field_47`.`entry_id` AND t.lang_id = exp_publisher_data_field_47.lang_id AND t.status = exp_publisher_data_field_47.status LEFT JOIN `exp_publisher_data_field_48` ON `t`.`entry_id` = `exp_publisher_data_field_48`.`entry_id` AND t.lang_id = exp_publisher_data_field_48.lang_id AND t.status = exp_publisher_data_field_48.status LEFT JOIN `exp_publisher_data_field_49` ON `t`.`entry_id` = `exp_publisher_data_field_49`.`entry_id` AND t.lang_id = exp_publisher_data_field_49.lang_id AND t.status = exp_publisher_data_field_49.status LEFT JOIN `exp_publisher_data_field_50` ON `t`.`entry_id` = `exp_publisher_data_field_50`.`entry_id` AND t.lang_id = exp_publisher_data_field_50.lang_id AND t.status = exp_publisher_data_field_50.status LEFT JOIN `exp_publisher_data_field_51` ON `t`.`entry_id` = `exp_publisher_data_field_51`.`entry_id` AND t.lang_id = exp_publisher_data_field_51.lang_id AND t.status = exp_publisher_data_field_51.status LEFT JOIN `exp_publisher_data_field_52` ON `t`.`entry_id` = `exp_publisher_data_field_52`.`entry_id` AND t.lang_id = exp_publisher_data_field_52.lang_id AND t.status = exp_publisher_data_field_52.status LEFT JOIN `exp_publisher_data_field_53` ON `t`.`entry_id` = `exp_publisher_data_field_53`.`entry_id` AND t.lang_id = exp_publisher_data_field_53.lang_id AND t.status = exp_publisher_data_field_53.status LEFT JOIN `exp_publisher_data_field_54` ON `t`.`entry_id` = `exp_publisher_data_field_54`.`entry_id` AND t.lang_id = exp_publisher_data_field_54.lang_id AND t.status = exp_publisher_data_field_54.status LEFT JOIN `exp_publisher_data_field_55` ON `t`.`entry_id` = `exp_publisher_data_field_55`.`entry_id` AND t.lang_id = exp_publisher_data_field_55.lang_id AND t.status = exp_publisher_data_field_55.status LEFT JOIN `exp_publisher_data_field_56` ON `t`.`entry_id` = `exp_publisher_data_field_56`.`entry_id` AND t.lang_id = exp_publisher_data_field_56.lang_id AND t.status = exp_publisher_data_field_56.status LEFT JOIN `exp_publisher_data_field_57` ON `t`.`entry_id` = `exp_publisher_data_field_57`.`entry_id` AND t.lang_id = exp_publisher_data_field_57.lang_id AND t.status = exp_publisher_data_field_57.status LEFT JOIN `exp_publisher_data_field_58` ON `t`.`entry_id` = `exp_publisher_data_field_58`.`entry_id` AND t.lang_id = exp_publisher_data_field_58.lang_id AND t.status = exp_publisher_data_field_58.status LEFT JOIN `exp_publisher_data_field_60` ON `t`.`entry_id` = `exp_publisher_data_field_60`.`entry_id` AND t.lang_id = exp_publisher_data_field_60.lang_id AND t.status = exp_publisher_data_field_60.status LEFT JOIN `exp_publisher_data_field_61` ON `t`.`entry_id` = `exp_publisher_data_field_61`.`entry_id` AND t.lang_id = exp_publisher_data_field_61.lang_id AND t.status = exp_publisher_data_field_61.status LEFT JOIN `exp_publisher_data_field_62` ON `t`.`entry_id` = `exp_publisher_data_field_62`.`entry_id` AND t.lang_id = exp_publisher_data_field_62.lang_id AND t.status = exp_publisher_data_field_62.status LEFT JOIN `exp_publisher_data_field_63` ON `t`.`entry_id` = `exp_publisher_data_field_63`.`entry_id` AND t.lang_id = exp_publisher_data_field_63.lang_id AND t.status = exp_publisher_data_field_63.status LEFT JOIN `exp_publisher_data_field_64` ON `t`.`entry_id` = `exp_publisher_data_field_64`.`entry_id` AND t.lang_id = exp_publisher_data_field_64.lang_id AND t.status = exp_publisher_data_field_64.status LEFT JOIN `exp_publisher_data_field_65` ON `t`.`entry_id` = `exp_publisher_data_field_65`.`entry_id` AND t.lang_id = exp_publisher_data_field_65.lang_id AND t.status = exp_publisher_data_field_65.status WHERE `t`.`entry_id` IN ()
Mighty Citizen
Comment has been marked private.
BoldMinded (Brian)
Comment has been marked private.
BoldMinded (Brian)
Did the new build fix the issue for you?
BoldMinded (Brian)
I’m closing this ticket b/c the latest build should fix the issue and I have not heard back in over 30 days.