unknown
1970-01-01 00:00:00 UTC
MySQL Databases
Checking Database
gc2009_citrus is now being checked.
gc2009_citrus.activity_log OK gc2009_citrus.batch OK
gc2009_citrus.billing OK gc2009_citrus.billing_details OK
gc2009_citrus.billing_history OK gc2009_citrus.billing_types OK
gc2009_citrus.cancel_reason OK gc2009_citrus.credit_options OK
gc2009_citrus.customer OK gc2009_citrus.customer_history OK
gc2009_citrus.example_options OK gc2009_citrus.general OK
gc2009_citrus.groups OK gc2009_citrus.holiday OK
gc2009_citrus.linked_services OK gc2009_citrus.login_failures OK
gc2009_citrus.master_services OK gc2009_citrus.module_permissions OK
gc2009_citrus.modules OK gc2009_citrus.options_urls OK
gc2009_citrus.payment_history OK gc2009_citrus.payment_mode OK
gc2009_citrus.prorate_options OK gc2009_citrus.searches OK
gc2009_citrus.sessions2 OK gc2009_citrus.settings OK
gc2009_citrus.sub_history OK gc2009_citrus.tax_exempt OK
gc2009_citrus.tax_rates OK gc2009_citrus.taxed_services OK
gc2009_citrus.user OK gc2009_citrus.user_services OK
Everything looks okay there. I added the debugger and it didn't show
anything on any of the searches that I get query failed and on the
ones that work It shows the SQL
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
-------------------------------------------------------------------------=
-----
Checking Database
gc2009_citrus is now being checked.
gc2009_citrus.activity_log OK gc2009_citrus.batch OK
gc2009_citrus.billing OK gc2009_citrus.billing_details OK
gc2009_citrus.billing_history OK gc2009_citrus.billing_types OK
gc2009_citrus.cancel_reason OK gc2009_citrus.credit_options OK
gc2009_citrus.customer OK gc2009_citrus.customer_history OK
gc2009_citrus.example_options OK gc2009_citrus.general OK
gc2009_citrus.groups OK gc2009_citrus.holiday OK
gc2009_citrus.linked_services OK gc2009_citrus.login_failures OK
gc2009_citrus.master_services OK gc2009_citrus.module_permissions OK
gc2009_citrus.modules OK gc2009_citrus.options_urls OK
gc2009_citrus.payment_history OK gc2009_citrus.payment_mode OK
gc2009_citrus.prorate_options OK gc2009_citrus.searches OK
gc2009_citrus.sessions2 OK gc2009_citrus.settings OK
gc2009_citrus.sub_history OK gc2009_citrus.tax_exempt OK
gc2009_citrus.tax_rates OK gc2009_citrus.taxed_services OK
gc2009_citrus.user OK gc2009_citrus.user_services OK
Everything looks okay there. I added the debugger and it didn't show
anything on any of the searches that I get query failed and on the
ones that work It shows the SQL
$DB->debug =3D true;
Near the top of the index.php file.
Adding debug will print out all the database queries all over the
page. =A0You 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. =A0Is this
site hosted on a server you control? =A0Did something change on the
server or mysql configuration?
Paul
On Tue, May 18, 2010 at 2:19 PM, Cornita Tutt-Pinchinat
------Near the top of the index.php file.
Adding debug will print out all the database queries all over the
page. =A0You 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. =A0Is this
site hosted on a server you control? =A0Did something change on the
server or mysql configuration?
Paul
On Tue, May 18, 2010 at 2:19 PM, Cornita Tutt-Pinchinat
Hi,
I have been using Citrus for my customer DB without any problems until
yesterday. =A0Now when I search most fields I get a query failed
message. =A0For example if I search Name/Company I get data but If I
search Account Number I get the message query failed. =A0The last day I
used it successfully was 5/5/10. I have not made any changes since
then. =A0I am able to query some fields without any problems. =A0 I am
unable to add any new customers. =A0Any ideas? =A0If you need any
additional info let me know and I will get it to you.
------------------------------------------------------------------------=
I have been using Citrus for my customer DB without any problems until
yesterday. =A0Now when I search most fields I get a query failed
message. =A0For example if I search Name/Company I get data but If I
search Account Number I get the message query failed. =A0The last day I
used it successfully was 5/5/10. I have not made any changes since
then. =A0I am able to query some fields without any problems. =A0 I am
unable to add any new customers. =A0Any ideas? =A0If 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
--Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
-------------------------------------------------------------------------=
_______________________________________________
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
Citrusdb-users mailing list
https://lists.sourceforge.net/lists/listinfo/citrusdb-users