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.

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.

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.