The transaction was refused as a result of a dupli

-- HikaShop version -- : 2.6.2
-- Joomla version -- : 3.5.0
-- PHP version -- : 5.4.45
-- Browser(s) name and version -- : Firefox 39.0.3
-- Error-message(debug-mod must be tuned on) -- : Error 10536: The transaction was refused as a result of a duplicate invoice ID supplied. Attempt with a new invoice ID

When I try to make a purchase I get this message.
Error 10536: The transaction was refused as a result of a duplicate invoice ID supplied. Attempt with a new invoice ID
Using PaypalPro Sandbox with a fake credit card.
I tried as a guest and as a registered user.
This is on a test site. On the live site, (out of the sandbox)when I get to this point, I get this message:

Catchable fatal error: Object of class stdClass could not be converted to string in /home/tiffinta/public_html/administrator/components/com_hikashop/helpers/helper.php on line 2578

Is there a relationship here? What is the problem?Solution??

I followed the link but the information seems to be outdated - for one it still refers to tables starting jos_. Anyway, I ran that query in SQL (first replacing the table prefix of course). I got "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0035 seconds.)" which I kind of expected as there's nowhere in that table which refers to auto_increment.

Can you confirm the PHPMyAdmin fix for this, please? I have had the client apply the PayPal fix temporarily, but that's not satisfactory long term to allow duplicates.

Cheers

I'm sorry you didn't follow my post. Let me try to be clearer for you.

In a post above, there was a link given to some HS documentation - www.hikashop.com/support/documentation/i...l-error.html#already - I followed this link.

That page had this following help:

"On the HikaShop side:

Open your phpmyadmin (a tool provided by your hosting company in order to administer your database) and select your database. There, increase the auto_increment value of the hikashop_order table by running a query like this:

ALTER TABLE jos_hikashop_order auto_increment = 100000;

That query will result in the order id of your orders to start at 100000. That way, it won't conflict with other e-commerce application using your paypal account with order ids starting at 0 like HikaShop does by default. Note that if you use another table prefix than jos_ you need to change it to your table prefix in the query. "

I did actually read this carefully and understand completely what it's saying to do. I know enough about PHPMyAdmin to enter SQL queries, and this was very easy as the query was already in the help. I copied this query, replacing jos_ with my database prefix name (as mentioned in my previous post). The query executed correctly, without errors, but, as previously mentioned, the query made no changes (SQL returned an empty set), and the problem remains.

Given that the documentation refers to tables starting with jos_ (from Joomla 1.5) I asked if the documentation was up to date and if the SQL query was still correct.

Sorry, I can't make it any clearer than that.

Ahh thank you Jerome. I was looking for a row. Yep I see the order numbers now start at 100000.