SQL syntax

I have a BIG problem I get

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 created_by=7' at line 1

when I try to add an article ?
I think I picked up the bug from coping the C Builder comprofiler tables from another website?

It's happening to many of my websites its a big problem.
Is there a step by step guide to explain the fix?

Thanks

when I try to add an article ?

Where? In Joomla content management component? Frontend article create? CB has nothing to do with article create queries.

I think I picked up the bug from coping the C Builder comprofiler tables from another website?

I don't see how CBs database tables could have anything to do with this.

Suggest checking what 3rd party extensions you've installed in Extensions > Plugins and try unpublishing them 1 by 1 until issue resolves. Only way I can see CB causing this is if you added custom behavior on Joomlas content events using CB Auto Actions and there's an issue in your auto action or if this was during usage of CB Blogs.

Why do you say
there's an issue in your auto action or if this was during usage of CB Blogs

OK what made you pin point (during usage of CB Blogs?) Im just trying to find the problem

Thanks

Hi,

Kyle worte 1 question, 1 statement, 1 suggestion, and another guess-suggestion. Last two suggestions where in the same paragraph:

krileon wrote:

when I try to add an article ?

1 question: Where? In Joomla content management component? Frontend article create? CB has nothing to do with article create queries.

I think I picked up the bug from coping the C Builder comprofiler tables from another website?

1 statement: I don't see how CBs database tables could have anything to do with this.

1 suggestion: Suggest checking what 3rd party extensions you've installed in Extensions > Plugins and try unpublishing them 1 by 1 until issue resolves.

1 guess-suggestion: Only way I can see CB causing this is if you added custom behavior on Joomlas content events using CB Auto Actions and there's an issue in your auto action or if this was during usage of CB Blogs.

So:
- without enough information (see question), it's difficult to guess the issue.
- as he stated: CB and our add-ons don't not have such a SQL statement part in them.
- So as he suggested and guess-suggested: it is either a 3rd party extension doing it, or a SQL query in a configuration on your site.
- As he guess-suggested: IF you use CB Auto-Action and have a SQL query action in it, it's the only place where it could be done.
- as he suggested: the best way to find out from where this comes is to turn off 3rd party extensions one by one.

I'm adding a third suggestion: Turn Joomla Site Debug ON in Joomla's global configuration, it will give you a backtrace of where that buggy query was made.

Is there any way to console log the button action when I try to add an article ?

Thanks

Ensure Joomla debug mode is enabled and error reporting set to maximum. Next within Extensions > Plugins ensure the debug extension is published. Retry and see if Joomlas debug output at the bottom of the page provides any hints. The only thing we have that directly queries Joomla content database table with a created_by condition is CB Articles and CB Blogs, but those queries are only relevant on your profile.

My guess is you've a 3rd party plugin in Extensions > Plugins trying to add some sort of custom behavior to Joomla content. Recommend temporarily unpublishing 3rd party content related plugins 1 by 1 to try and find it.