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.