sql parser problem

[raz3k]

[shannah]

Looks like you don't have a table called "Personal" in your database.

[raz3k]

[users]
__sql__ = "select Personal.Personal_ID as userid, SUBSTRING_INDEX(mailbox.username,'@',1) as username from postfix.mailbox, condica.Personal where (LOWER(CONCAT(Personal.prenume,'.',Personal.nume))= LOWER(SUBSTRING_INDEX(mailbox.username,'@',1)) and mailbox.username != '\.') order by username"

I have a database called Personal and a table called Personal_ID, but instead of Personal.Personal_ID it searches for virtual_lib.Personal .

[shannah]

[raz3k]

Very odd, this sql query worked like a charm before the update, i will try to rewrite it and post back.

Thanks.

[shannah]

Personal_ID is a very strange name for a table. Are you sure that this is not actually a column, and Personal is not actually a table? The SQL query suggests this... otherwise there's no way it ever ran correctly.