SteveTalbot

Hi all, I experienced a problem today with v5.2.5, when I tried paying an invoice as our test client. I chose the option not to store the card details, and I got the following response in the gateway log: SagePay Tokens 3DAuth VPSProtocol => 2.23 Status => MALFORMED StatusDetail => 3051 : The CardNumber field is required. Credit/Debit Card Remote Storage VPSProtocol => 2.23 TxType => TOKEN Status => MALFORMED StatusDetail => 3051 : The CardNumber field is required. But when I allowed WHMCS to store the card details, the transaction worked OK. So if anyone else experiences the same issue, the fix is to go into Setup, General Settings, Security and untick the box next to "Allow Client CC Removal". If you want to allow clients to make single payments by card, I guess the solution is to set up one of the other SagePay payment gateways as well. Hope this is helpful to someone. Cheers, Steve

Had the same problem and WHMCS support have confirmed this is a bug. It worked for us to revert sagepaytokens.php to v5.1.5. Cheers, Steve

Hi guys, Does anyone know how to make WHMCS connect to its MySQL database using SSL when the database is on a different server from Apache? I know you can specify the DB host, username and password in configuration.php, but how to you specify the location of the three certificate/key files? Currently the only way I can find to secure the connection is to tunnel the MySQL connection over SSH, but I'm looking to move my WHMCS database onto a cloud-hosted database, and they support SSL connections but not tunneling over SSH. Thanks, Steve

Came across this thread when I had the same problem. Here is my workaround for the Vertical Steps order form. In templates/orderforms/verticalsteps/configureproductdomain.tpl, find this bit of markup: <table class="styled textcenter"> <tr><th>{$LANG.domainname}</th><th>{$LANG.domainstatus}</th><th>{$LANG.domainmoreinfo}</th></tr> {foreach key=num item=result from=$availabilityresults} <tr><td>{$result.domain}</td><td class="{if $result.status eq $searchvar}textgreen{else}textred{/if}">{if $result.status eq $searchvar}<input type="checkbox" name="domains[]" value="{$result.domain}"{if $num eq 0} checked{/if} /> {$LANG.domainavailable}{else}{$LANG.domainunavailable}{/if}</td><td>{if $result.regoptions}<select name="domainsregperiod[{$result.domain}]">{foreach key=period item=regoption from=$result.regoptions}{if $regoption.$domainoption}<option value="{$period}">{$period} {$LANG.orderyears} @ {$regoption.$domainoption}</option>{/if}{/foreach}</select>{/if}</td></tr> {/foreach} </table> And replace with: {foreach key=num item=result from=$availabilityresults} {assign var="strpos_tld" value=$result.domain|strpos:"."} {assign var="this_tld" value=$result.domain|substr:$strpos_tld} <tr><td>{$result.domain}</td><td class="{if $result.status eq $searchvar}textgreen{else}textred{/if}">{if $result.status eq $searchvar}<input type="checkbox" name="domains[]" value="{$result.domain}"{if $num eq 0} checked{/if} /> {$LANG.domainavailable}{else}{$LANG.domainunavailable}{/if}</td><td> {if $freedomaintlds && $freedomaintlds|strstr:$this_tld}{$LANG.orderfree}{foreach key=period item=regoption from=$result.regoptions name=period}{if $smarty.foreach.period.first}<input type="hidden" name="domainsregperiod[{$result.domain}]" value="{$period}" />{/if}{/foreach} {elseif $result.regoptions}<select name="domainsregperiod[{$result.domain}]">{foreach key=period item=regoption from=$result.regoptions}{if $regoption.$domainoption}<option value="{$period}">{$period} {$LANG.orderyears} @ {$regoption.$domainoption}</option>{/if}{/foreach}</select> {/if}</td></tr> {/foreach} Now this only displays the registration period dropdown if the client has to pay for the domain. For free TLDs, it will automatically select the shortest registration period and display "FREE!" instead of the dropdown. I knocked this up quite quickly so please let me know if you discover any problems!