After upgrade to 4.2.2 from 4.2.1 error with "Modify ad"

[redmtnex +]

Hi everyone.
I am running v4.2.1 Designer. I recently upgraded it to 4.2.2 and after doing so users got an error when trying to modify an ad. Also "Browse your listings" reports no listings. Here is the error generated

Notice: Query failed: Column 'orderID' in field list is ambiguous SQL: SELECT id,title,section,price,display,hitcount,dateadded,expiration,orderID,oType,oStatus,oProductID,class_products.pGroup FROM class_listings LEFT JOIN class_orders ON orderID=oID LEFT JOIN class_products ON class_products.pID=class_orders.oProductID WHERE owner = '2' ORDER BY dateadded DESC in C:\xampp\htdocs\classifieds\includes\classes\database\mysql.php on line 146
Notice: Query failed: Column 'orderID' in field list is ambiguous SQL: SELECT id,title,section,price,display,hitcount,dateadded,expiration,orderID,oType,oStatus,oProductID,class_products.pGroup FROM class_listings LEFT JOIN class_orders ON orderID=oID LEFT JOIN class_products ON class_products.pID=class_orders.oProductID WHERE owner = '2' ORDER BY dateadded DESC LIMIT 0, 10 in C:\xampp\htdocs\classifieds\includes\classes\database\mysql.php on line 146

I was unable to fix it and did a database restore and of course a file restore.
So I then installed it (4.2.1) on my localhost using the database from the site tested the "modify ad" and it worked OK. Then proceeded to do the upgrade to 4.2.2 and tested the "modify ad" and the problem reproduced. I have used both the files from the site and fresh files from the customer download area as tests.
Any help would be greatly appreciated.

[Mike-N-Tosh +]

I don't have an answer for your issue, however I'm curious why you would be doing an upgrade from v4.2.1 to 4.2.2 instead of directly to the latest released version, 4.23?

[redmtnex +]

Originally I had upgraded to 4.2.3 and the error surfaced. I restored the site back to 4.2.1 (files and database) and upgraded to 4.2.2 and the same problem occurred. This is reproduced on my localhost as well, but only using my database from the actual site. A fresh install does not have the error. I am pointing my finger at my database but for me I might as well be pointing at the sky.

[redmtnex +]

Google "Column 'orderID' in field list is ambiguous SQL:" and what I see is that there is a possibility that a column ID is maybe duplicated in two different tables. Anyhow looking over the tables I don't see that. But then I might not know what I am looking for.