Thanks, This site is hosted with cpanel access. From what I can tell, nothing has changed on the server and nothing changed on the mysql configuration. I did add some fields to the customer table; however the site has been working since I added the fields. I ran a check on the db
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 On Tue, May 18, 2010 at 2:41 PM, Paul Yasi <p...@coffeebuzz.com> wrote: > 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 > <corn...@gmail.com> wrote: >> 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 >> Citrusdb-users@lists.sourceforge.net >> 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 > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > ------------------------------------------------------------------------------ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
