Posts Tagged “ClientExec”

If you have ClientExec installed in a sub-directory say /clientexec and want to require HTTPS only for ClientExec the easiest way to accomplish this is by putting a .htaccess file inside of the sub directory itself. There are numerous solutions to this posted as CE Knowledge Base Articles and within the CE forums but many of them did not work for me so I wanted to post the solution that worked on setup using CentOS as the operating system and using Apache/PHP/MySQL on that platform.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , ,

Comments No Comments »

I am a big fan of ClientExec as it is easy to install and very easy to use. Over the years it has always been easy to upgrade and the support is prompt. If you want to add Google Analytics to your ClientExec installation you simply need to add it in two locations if you are using the default template and if you are using a custom ClientExec template then you need to add it in one more location.

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , , , , , , , ,

Comments No Comments »

When attempting to process an order using ClientExec you may get error messages like the following:

An error has occurred with the given operation

Type: Warning (2)
Description: mysql_real_escape_string() expects parameter 1 to be string, object given
Request: POST /signup.php
Script: <clientexec-root>/newedge/classes/NE_Mysql.php
Line Number: 198
Stack:
var/www/web2/web/client/newedge/classes/NE_Mysql.php(138) : regexp code (1) : ne_mysql::escape_string
<clientexec-root>/newedge/classes/NE_Mysql.php (138) : preg_replace
<clientexec-root>/classes/domain.php (1463) : ne_mysql::query
<clientexec-root>/modules/admin/views/Signup_4_CreateAccounts.php (424) : domain::updaterecord
<clientexec-root>/modules/admin/views/Signup_3_Validation.php (316) : Signup_4_CreateAccounts::dispatch
<clientexec-root>/newedge/classes/NE_Controller.php (167) : Signup_3_Validation::dispatch
<clientexec-root>/newedge/front.php (76) : ne_controller::processview
<clientexec-root>/signup.php (70) : require

In this situation I was using ClientExec with Authorize.net as the payment gateway. The basic error revolved around the Authorize.net processing needing mcrypt and not being able to find it on the server. To resolve this issue install php-mcrypt on the server using the below commands.

shell# yum install php-mcrypt

Make sure to restart apache!

shell#/etc/init.d/httpd restart

That should resolve your issue if you are in fact using ClientExec with the  Authorize.net payment module.

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , , ,

Comments No Comments »

I recently upgraded a customer management software called ClientExec from a very old version (2.4.9__2.5beta4) to the latest stable version (ClientExec 3.1.4).  It had been a long time since the administration type settings had been updated but it was time to clean things up. One area lets you manage billing types which I was about to attempt. You can either delete or edit current entries or add a new entry. First I attempted to add a new entry and was greeted with the error below.

[quickcode:billingtype]
An error has occurred with the given operation

Type: User Error (256)
Description: QUERY: INSERT INTO billingtype (id, name, description, detail) VALUES(’2147483648′,’Test’,'Test’,'Test’) – ERROR: Duplicate entry ’2147483647′ for key 1
Request: POST /client/index.php?fuse=billing&action=AddBillingType
Script: client/newedge/classes/NE_Mysql.php
Line Number: 154
Stack:
client/modules/billing/models/BillingType.php (50) : ne_mysql::query
client/modules/billing/actions/AddBillingType.php (16) : billingtype::update
client/newedge/classes/NE_Controller.php (200) : addbillingtype::dispatch
client/newedge/front.php (74) : ne_controller::processaction
client/index.php (4) : unknown
[/quickcode]

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , ,

Comments No Comments »

It has been awhile since I have used ClientExec and the Authorize.net plugin. ClientExec has really come a long way and everything went really smooth until I tried to start testing processing credit card orders. I filled in a new customer and attempted to save a credit card for the new user and the screen would go completely white on submit and not do anything. I wasn’t able to get much from the Apache logs or MySQL logs but finally remembered a couple packages that have to be installed for the Authorize.Net plugin to work.

All of the following can be installed with yum:

yum install libmcrypt php-mcrypt curl

Read the rest of this entry »

DeliciousStumbleUponDiggTwitterFacebookRedditLinkedInEmail
Tags: , , , , ,

Comments No Comments »