Javascript error adding eCart Add To Cart Button
I read many old posts regarding this error so figured it was resolved; however I am getting it now. I have deleted the windat file and have met the other requirements having the latest extensions in the correct order.
I am going through step by step the Integrating Data Bridge and eCart tutorial and when I get to the Add To Cart Button step where you select the "Look up item ID from recordset" I get the same JS error everyone else had.
I then tried to look at the recordset in Server Behaviors and got a message that the table did not exist so I then looked at the SELECT statement in the Source Code and saw that the table was there but had a lower case "p" (products). So I looked in the database and see that there is a Products table with a upper case "P" (Products). I changed the SELECT statement and now I do now get the Javascript error and the Recordset: and ID Column populate now in the eCart Add To Cart Button dialog.
Also, there are two order tables in the database (orders and Orders). Both have the same columns although orders has only 15 columns and Orders has 27 columns and they are not in the same order. Are both tables supposed to be here?
I started from scratch twice using blank databases and empty DW sites and followed the tutorial word for word and came up with the same results both times.
I'll try a third time after uninstalling all three extensions and deleting the Configuration directory and installing eCart 5.0.6, Design Extender 1.1.1 and Data Bridge 1.1.1 in that order (using DW CS5.5 on Win7) but first wanted to post this and get some feedback.
I'm guessing this a workaround but I have a question. Do you think this is user error and I made a mistake in the steps or is there an issue?