Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
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
Nov 25, 2019
Comment has been marked private.
BoldMinded (Brian)
Nov 25, 2019
Comment has been marked private.
BoldMinded (Brian)
Dec 10, 2019
Did the new build fix the issue for you?
BoldMinded (Brian)
Dec 27, 2019
I’m closing this ticket b/c the latest build should fix the issue and I have not heard back in over 30 days.