Corrected one problem, uncovered a similiar
OrderReferenceID was ok so I checked the Store Cart Details to Database Server Behavior and to correct the problem I had to change the Details ID to Type:Text and it worked but now I have a new error...Unknown column 'RightPegs' in 'field list'. ('RightPegs' is my $1 test product's ItemName.) The result is the same as the previous error; blank page with this error, no checkout success or failure page, and the transaction goes through with receipts being sent.
Going back to the first correction we made (so I can understand what is happening), I am a bit confused because the structure in the mysql db has the DetailsID set to int(10) and auto_increment. Is this new 26 character field being assigned by Authorize.net (because the receipt labels it the 'Invoice:')? Here's what one looks like after being truncated to 20 characters for the receipt 'Invoice: 2m15bu5u99g74gsgeonq'. Either way, it works but I am just wondering where this number is being assigned because apparently I'm not assigning it.
Thank you for helping me finish my gateway integration. You guys are awesome.