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: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax.
| Status | Resolved |
| Add-on / Version | Publisher 3.0.0 |
| Severity | |
| EE Version | 5.3.0 |
Riccardo Melzi
Nov 05, 2019
Hello,
I’ve just updated your module and I get this error when I try to open a specific channel.
The entries of any other channel works fine.
If you can access to CP with the login details I provide you, try to edit any entries in “Models” channel.
It looks like the entry id is missing in the sql query: [... exp_publisher_data_field_104.status WHERE `t`.`entry_id` IN () ]
Let me know if you need any other info
Thanks
Riccardo
BoldMinded (Brian)
Nov 05, 2019
Comment has been marked private.
Riccardo Melzi
Nov 05, 2019
Comment has been marked private.
BoldMinded (Brian)
Nov 07, 2019
Can you share what the entries tag looks like that is throwing that error? Just the opening tag pair with all the parameters.
BoldMinded (Brian)
Nov 07, 2019
You also provided a domain but did not mention what template this is occurring in or what url I can see the error happen at. It’s best if you create a new template that has nothing in it but the entries tag that is causing the problem.
Riccardo Melzi
Nov 07, 2019
Comment has been marked private.
BoldMinded (Brian)
Nov 07, 2019
Can you provide FTP access to that environment so I can do some debugging? If so edit the ticket and add the creds in the provided fields.
Riccardo Melzi
Nov 08, 2019
Comment has been marked private.
BoldMinded (Brian)
Nov 08, 2019
I just removed the info from your comment. As mentioned, please edit the ticket and add the info in the fields provided. When the ticket is closed, those fields are erased from the database. I don’t want FTP information hanging out in comments forever. Thanks.
BoldMinded (Brian)
Nov 08, 2019
You don’t need to do anything, when I click Resolve ticket it will immediately delete the FTP info from the database.
BoldMinded (Brian)
Nov 09, 2019
Should be fixed now. Check it out to see if everything is looking correct. The issue is that it was trying to find the draft version of those entries, which did not exist.
Riccardo Melzi
Nov 09, 2019
It works now.
Thank you so much.
Riccardo
Riccardo Melzi
Nov 18, 2019
Hello Brian,
I added a new language, but when I save the entries the translation is not saved.
Can you take a look? I updated the FTP access details. Thanks
Riccardo
Riccardo Melzi
Nov 18, 2019
Comment has been marked private.
BoldMinded (Brian)
Nov 18, 2019
Comment has been marked private.