whmcsmerge.php invalid query

[CCSupport]

Hello all,

 

Firstly, I know this might be moved to the 'script' section, however it very rarely gets checked so thought it better go in this section as a technical issue. So here goes:

 

I have tried to merge (using the WHMCS merge script (whmcsmerge.php) and I am having issues.

 

The merge says it's successful, however it also shows invalid entries. Also, if I try to put an order through or even create a new client it fails and says "Client ID Not Found".

 

Just to note, I can confirm that the pre-requisites of same currency and same payment gateways are covered.

 

I have pasted the full merge report below. It's very weird as it pulls in all the products but fails on the users then does not allow me to create any in the new WHMCS installation.

 

One thing I was thinking was that the script says its for 'WHMCS V4', however it's the only merge script in the downloads section.

 

Here's the script output after the merge:

 

WHMCS V4 Importer Script

This import script allows you to merge data from 2 seperate WHMCS installations into one

 

Step 3 - Import Process

 

 

Imported Server WSP1

 

Imported Product Hosting 1

Imported Product Hosting 2

Imported Product Hosting 3

Imported Product Hosting 4

Imported Product Hosting 5

Imported Product Hosting 6

Imported Product Hosting 7

 

Found Existing Client 5

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

 

Found Existing Client 6

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

 

Found Existing Client 7

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

 

Found Existing Client 8

Invalid query - :

Invalid query - :

Invalid query - :

Invalid query - :

 

Import Completed Successfully!

Edited October 27, 2012 by CCSupport