"joomla3_ " replaced by #__ in my sql query.

[leblancphil]

Hi
When I try to join my own tables to joomla3, the sql query report error while naming, for example joomla3_users in #__users.
"Fabrik has generated an incorrect query for the list test connexion joom3_users: <br /><br /><pre>Unknown column '#__users.id' in 'field list' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINC..."
I'm stuck with that, please help.
Thank you

 

[cheesegrits]

Not sure what you mean by "my own tables". Are you using a different database connection?

I need more details about your setup and what you are trying to do.

Also, a login to your site would help.

-- hugh

 

[leblancphil]

My own tables are the tables I create that I nedd to join to joomla3 tables

 

[cheesegrits]

I'm now aware of any issues, so I'll need to look at your setup. Update http://fabrikar.com/you/my-sites with a backend login, and in the notes section anything I need to know about which list / elements etc.

-- hugh

 

[leblancphil]

The problem is solved but I have another thread about unix date fields.
Joyeux No?l