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)
Comment has been marked private.
Riccardo Melzi
Comment has been marked private.
BoldMinded (Brian)
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)
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
Comment has been marked private.
BoldMinded (Brian)
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
Comment has been marked private.
BoldMinded (Brian)
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)
You don’t need to do anything, when I click Resolve ticket it will immediately delete the FTP info from the database.
BoldMinded (Brian)
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
It works now. Thank you so much. Riccardo
Riccardo Melzi
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
Comment has been marked private.
BoldMinded (Brian)
Comment has been marked private.