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
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.