Re: [Citrusdb-users] Query Failed
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
Re: [Citrusdb-users] Query Failed
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
Re: [Citrusdb-users] Query failed when trying to change the billing type for a customer.
I don't have an XP machine with AMP on it to try, but It's doing two different things when you change a billing record. It's updating what you changed on the record, and also updating the to_date according to the billing type selected. You can watch it do queries by turning on ADODB's debug feature. You'll need to add a line to the file /modules/billing/edit.php: $DB-debug = true; right after line 104, if ($save) { and before the UPDATE query would be a fine place for it You'll also have to comment out line 134 that redirects back the the billing index, so it stays on the update page and will show you the output and any errors. Paul On Thu, Apr 10, 2008 at 2:04 PM, Daniel Diaz [EMAIL PROTECTED] wrote: I install Citrusdb on linux and run without problem. When I tried on Xp it gave me Query failed when change the billing type for a customer. If I go to the billing table through mysql and change the billing type of a customer, and then trying the Print New Invoices tool on citrusdb it gave me: history update failed. Any suggestion? OS : Widows XP Prof MySql: MySql5.0.51a-community Citrus Database Version: 1.2.2 Citrus Software Version: 1.2.2 Apache 2.2 PHP Version 5.2.5 Thanks, Daniel Díaz - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ 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 - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users