tried the sql thingy that everyone was talking about but it didn't work for me either
You do this at your own risk!
It worked for me but hey I don't know what I am doing, I have no technical skills whatsever but I do try to remember exact what I am doing so i can go back to original way if required.
So if there is problems down the track don't complain to me I have no knowledge of problems......
that should read... No problems yet
I will post back here if I find any.
Logged into cpanel,
I went to phpmyadmin,
tried the sql thingy that everyone was talking about but it didn't work for me either,
so went to oc_database,
scrolled down to orders,
clicked on that file,
went to last order
changed the order number
and clicked on Go,
I have put through a couple of orders with no problems
Note: It would only accept changing the number, could not add letters before the number.
Like I said at the beginning, I know NOT what I am doing so its at your own risk and if anyone knows why I can't do it let me know, I am happy to learn