Be sure to checkout our newest add-on Reading Time Pro!

Compatibility updates:

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

Ticket: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax.

Status Client Wait
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

 

 

#1

BoldMinded (Brian)

Nov 05, 2019

Comment has been marked private.

#2

Riccardo Melzi

Nov 05, 2019

Comment has been marked private.

#3

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.

#4

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.

#5

Riccardo Melzi

Nov 07, 2019

Comment has been marked private.

#6

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.

#7

Riccardo Melzi

Nov 08, 2019

Comment has been marked private.

#8

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.

#9

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.

#10

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.

#11

Riccardo Melzi

Nov 09, 2019

It works now.
Thank you so much.
Riccardo

#12

Riccardo Melzi

9 hours ago

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

#13

Riccardo Melzi

8 hours ago

Comment has been marked private.

#14

BoldMinded (Brian)

5 hours ago

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.