Be sure to checkout our newest add-on, Speedy — Advanced Caching for ExpressionEngine.

Compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field (it's in the works).

Ticket: Upgrade to 3, getting error on save

Status Client Wait
Add-on / Version Publisher Lite 3.0.0
Severity
EE Version 5.1.1

Mighty Citizen

Nov 25, 2019

Here 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 ()
#1

Mighty Citizen

Nov 25, 2019

Comment has been marked private.

#2

BoldMinded (Brian)

Nov 25, 2019

Comment has been marked private.

Login to reply

Contact

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.