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 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 > 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] Query Failed
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
Re: [Citrusdb-users] error posting an invoice
Thank you so much! Cornita On Fri, Mar 26, 2010 at 9:39 AM, Paul Yasi wrote: > You need to edit citrus to use a new path to save the data to. That > is done by going to Tools and Opening the Settings tool. Here you'll > see a Path to Credit Card File field. You need to change that to your > own file path where the invoice can be stored. It is also where card > data would be exported to if you are exporting card batches. > > Paul > > On Thu, Mar 25, 2010 at 2:46 PM, Cornita Tutt-Pinchinat > wrote: >> Hi, >> I get an error message when trying to post invoices for a customer. >> The error is below the config file. I am new to PHP and Citrus so >> excuse me if this is obvious. >> >> >> $sys_dbhost = 'localhost'; >> $sys_dbuser = 'myusername'; >> $sys_dbpasswd = 'mypassword'; >> $sys_dbname = 'mydb_citrus'; >> $sys_dbtype = 'mysql'; >> $path_to_citrus = '/home/gc2009/public_html/l4adb'; >> $hidden_hash_var='myIhavechangedthis'; >> $lang = './include/local/us-english.inc.php'; >> $gpg_command = "/usr/bin/gpg --homedir /home/www-data/.gnupg --armor >> --batch -e -r 'CitrusDB'"; >> $gpg_decrypt = "/usr/bin/gpg --homedir /home/www-data/.gnupg >> --passphrase-fd 0 --yes --no-tty --skip-verify --decrypt"; >> >> // use these url prefixes to redirect between the ssl carddata and regular >> pages >> // also maybe can be used with base href to help limit cross site scripting >> $url_prefix = "http://greencorn.net/l4adb/";; >> $ssl_url_prefix = "http://greencorn.net/l4adb/";; >> >> >> >> ERROR MESSAGE >> >> Warning: fopen() [function.fopen]: open_basedir restriction in effect. >> File(/home/pyasi/sites/io/invoice3.pdf) is not within the allowed >> path(s): >> (/home/migrate.a2/web:/home/gc2009:/usr/lib/php:/usr/local/lib/php:/tmp) >> in /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046 >> >> Warning: fopen(/home/pyasi/sites/io/invoice3.pdf) [function.fopen]: >> failed to open stream: Operation not permitted in >> /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046 >> FPDF error: Unable to create output file: /home/pyasi/sites/io/invoice3.pdf >> >> -- >> Download Intel® Parallel Studio Eval >> Try the new software tools for yourself. Speed compiling, find bugs >> proactively, and fine-tune applications for parallel performance. >> See why Intel Parallel Studio got high marks during beta. >> http://p.sf.net/sfu/intel-sw-dev >> ___ >> 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 > > -- > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > ___ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users
[Citrusdb-users] error posting an invoice
Hi, I get an error message when trying to post invoices for a customer. The error is below the config file. I am new to PHP and Citrus so excuse me if this is obvious. $sys_dbhost = 'localhost'; $sys_dbuser = 'myusername'; $sys_dbpasswd = 'mypassword'; $sys_dbname = 'mydb_citrus'; $sys_dbtype = 'mysql'; $path_to_citrus = '/home/gc2009/public_html/l4adb'; $hidden_hash_var='myIhavechangedthis'; $lang = './include/local/us-english.inc.php'; $gpg_command = "/usr/bin/gpg --homedir /home/www-data/.gnupg --armor --batch -e -r 'CitrusDB'"; $gpg_decrypt = "/usr/bin/gpg --homedir /home/www-data/.gnupg --passphrase-fd 0 --yes --no-tty --skip-verify --decrypt"; // use these url prefixes to redirect between the ssl carddata and regular pages // also maybe can be used with base href to help limit cross site scripting $url_prefix = "http://greencorn.net/l4adb/";; $ssl_url_prefix = "http://greencorn.net/l4adb/";; ERROR MESSAGE Warning: fopen() [function.fopen]: open_basedir restriction in effect. File(/home/pyasi/sites/io/invoice3.pdf) is not within the allowed path(s): (/home/migrate.a2/web:/home/gc2009:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046 Warning: fopen(/home/pyasi/sites/io/invoice3.pdf) [function.fopen]: failed to open stream: Operation not permitted in /home/gc2009/public_html/l4adb/include/fpdf.php on line 1046 FPDF error: Unable to create output file: /home/pyasi/sites/io/invoice3.pdf -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users