Creating Order History error
I have gone through the tutorial several times following the instructions to the letter. When I thought there was a possibility that I was entering the data incorrectly, my frustrations led me to just cut and paste each line as I was instructed.
So, I have been through the Create Order History page and have been unsuccessful. I then turned to the only other support available - the forums. I found that others have been getting the same error going back several years.
When I test the recordset, I get the following:
MySQL Error#: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version forthe right syntax to use near '-1 WHERE orderdetails.-1 = WADAOrderID AND orders.OrderUserID = -1 at line 1
As I may have missed the spaces when retyping that, I have attached a jpg of the error message.
I have tried every possible solution from the forums going back several years, and have not been able to get rid of the error.
And when I test the page, I get the following:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1 WHERE orderdetails.-1 = WADAOrderID AND orders.OrderUserID = 1 LIMIT 0, 20' at line 1
That I am getting an error there isn't surprising in the least as the problem with the recordset dialog (MySQL Error#: 1064 above) is the probable cause of the SQL syntax error.
Attached are two jpg's of the errors.
Please help. I have been spending hours and hours dealing with this and other documentation-related problems, causing incredible frustration and because of the time spent, revenue loss.
Please help me resolve this issue.