Re: [Citrusdb-users] Query Failed

2010-05-19 Thread 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 on

Re: [Citrusdb-users] Query Failed

2010-05-18 Thread Cornita Tutt-Pinchinat
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 Database

Re: [Citrusdb-users] Query Failed

2010-05-18 Thread 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 throug

Re: [Citrusdb-users] Query failed when trying to change the billing type for a customer.

2008-04-10 Thread Paul Yasi
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 featu