[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4586: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3765)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4588: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3765)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4589: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3765)
[phpBB Debug] PHP Warning: in file /includes/functions.php on line 4590: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3765)
Xataface Forums • View topic - sql parser problem

sql parser problem

A place to discuss and receive support for the Library DB application.

sql parser problem

Postby raz3k » Thu Aug 18, 2011 3:27 am

raz3k
 
Posts: 3
Joined: Thu Aug 18, 2011 2:57 am

Re: sql parser problem

Postby shannah » Thu Aug 18, 2011 9:38 am

Looks like you don't have a table called "Personal" in your database.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: sql parser problem

Postby raz3k » Thu Aug 18, 2011 11:54 am

[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 .
raz3k
 
Posts: 3
Joined: Thu Aug 18, 2011 2:57 am

Re: sql parser problem

Postby shannah » Thu Aug 18, 2011 12:45 pm

shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: sql parser problem

Postby raz3k » Thu Aug 18, 2011 1:02 pm

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

Thanks.
raz3k
 
Posts: 3
Joined: Thu Aug 18, 2011 2:57 am

Re: sql parser problem

Postby shannah » Thu Aug 18, 2011 2:57 pm

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.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Library DB Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved