Are you enjoying the extensions? Did you like the support? Help others decide.

Leave a review

file SQL Error

More
4 months 4 weeks ago #6072 by Wortmann
SQL Error was created by Wortmann
Hello,
I am having problems creating a new Latest News Enhanced module. An SQL error keeps appearing, for example
"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 ') AND a.state = 1 AND a.created_by > 0) AND (`a`.`featured` = 0 OR (`fp`.`featu' at line 12"
What can I do?

Please Log in or Create an account to join the conversation.

More
4 months 4 weeks ago - 4 months 4 weeks ago #6073 by syw
Replied by syw on topic SQL Error
Hello,

Try unselecting the category(ies), then save.
Re-select the categories again and save.
Reload the frontend page, the error should be gone.
If not, let me know!
Olivier.
Last edit: 4 months 4 weeks ago by syw.

Please Log in or Create an account to join the conversation.

More
4 months 4 weeks ago #6074 by Wortmann
Replied by Wortmann on topic SQL Error
Sorry - the same error again...

Please Log in or Create an account to join the conversation.

More
4 months 4 weeks ago #6076 by syw
Replied by syw on topic SQL Error
Thanks for the feedback.
Which version of the extension are you using? free or pro?
Do you see any error related to this in the error logs (you can find logs under administrator/logs) ?
Olivier.

Please Log in or Create an account to join the conversation.

More
4 months 4 weeks ago #6078 by Wortmann
Replied by Wortmann on topic SQL Error
I use the pro Version and have the version 7.1.0

Please Log in or Create an account to join the conversation.

More
4 months 4 weeks ago #6079 by syw
Replied by syw on topic SQL Error
All right, please send me credentials so I can see the problem at hand, I cannot replicate the SQL errors on my test and demo sites.
To: [email protected]
Thank you!
Olivier.

Please Log in or Create an account to join the conversation.