[Citrusdb-users] Query Failed

[Cornita Tutt-Pinchinat]

Hi,

I have been using Citrus for my customer DB without any problems until
yesterday. Now when I search most fields I get a query failed
message. For example if I search Name/Company I get data but If I
search Account Number I get the message query failed. The last day I
used it successfully was 5/5/10. I have not made any changes since
then. I am able to query some fields without any problems. I am
unable to add any new customers. Any ideas? If you need any
additional info let me know and I will get it to you.

[Paul Yasi]

You can enable the debug function by adding:

$DB->debug = true;

Near the top of the index.php file.

Adding debug will print out all the database queries all over the
page. You will only need to pay attention to the one that shows up
right before the query failed message.

You should look through the log files for mysql or apache. Is this
site hosted on a server you control? Did something change on the
server or mysql configuration?

Paul

On Tue, May 18, 2010 at 2:19 PM, Cornita Tutt-Pinchinat

Post by Cornita Tutt-Pinchinat
Hi,
I have been using Citrus for my customer DB without any problems until
yesterday.  Now when I search most fields I get a query failed
message.  For example if I search Name/Company I get data but If I
search Account Number I get the message query failed.  The last day I
used it successfully was 5/5/10. I have not made any changes since
then.  I am able to query some fields without any problems.   I am
unable to add any new customers.  Any ideas?  If you need any
additional info let me know and I will get it to you.
------------------------------------------------------------------------------
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users

[Cornita Tutt-Pinchinat]

Thanks,
This site is hosted with cpanel access.

[Tshering Dhendup]

Dear Users
Please clarify with this doubt.
I want to enter the payment,
So i went to Tools, and then to Enter Payments.
There are fields like ;
1. acc no
2. biling id
3. invoice number
4. Amt Type
5. Check No.
and on submitting, i get the error as
"select detail Query Failed"


Further , if any one can send me the documentation about the customization
of the citrudb.
i m newbie to Citrusdb. And if the documentation is not available, let me
know where/in which file , actually the customization can be one...either in
mysql table fields or in the files under the directory citrusdb.

thanks in advance..

On Wed, May 19, 2010 at 1:59 AM, Cornita Tutt-Pinchinat

Post by Cornita Tutt-Pinchinat
Thanks,