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 <corn...@gmail.com>wrote: > 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 >
------------------------------------------------------------------------------
_______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users