I created a project a while back using the 5.1 phprunner. I do have the version 5.2 and I wanted to add the audit trail to the project. So I opened up the project and added the audit trail. Everything seems to have gone properly. I upload it, and indeed everything seems to work. When I log in as an admin user, I can view everything, and everything loads, however when a user with limited access logs in, I get a problem. I have users that are linked to a vendor, and when the user logs in, he/she can see all the products belonging to that particular vendor, also some registrations that goes along with those products. After the 5.2 upload, those users can no longer see the products, but they are still able to see the registrations belonging to those products.

Here is the error I'm encountering.
Error type 8

Error description Undefined variable: sqlWhere

URL domain.com/regtest/products_list.php?

Error file /home/web/regtest/classes/listpage.php

Error line 2515

SQL query SELECT productID, vendorID, tradeName, genericName, form, strength, memo, Source FROM products where vendorID=4 ORDER BY 1 ASC limit 0,20
File: line Function Arguments

0. classes/listpage.php:2515 countdetailsrecsnosubq N/A

1. classes/listpage.php:2515 listpage_simple->countdetailsrecsnosubq 1. 0;

2. Array ( [productID] => 161 [vendorID] => 4 [tradeName] => Abacavir Sulfate [genericName] => Abacavir [form] => Tablets 60s [strength] => 300mg [memo] => [Source] => )...;
   
3. Array ( [0] => 161 ) ;
   

   2. classes/listpage.php:2443 listpage_simple->proccessdetailgridinfo 1. Array ( [edit_link] => [inlineedit_link] => [view_link] => 1 [copy_link] => 1 ) ;
   

   
   
4. Array ( [productID] => 161 [vendorID] => 4 [tradeName] => Abacavir Sulfate [genericName] => Abacavir [form] => Tablets 60s [strength] => 300mg [memo] => [Source] => )...;
   

   3. classes/listpage.php:2063 listpage_simple->fillgriddata N/A
   

   4. classes/listpage.php:2624 listpage_simple->prepareforbuildpage N/A
   

   5. products_list.php:94 Global scope N/A
   

   
   
   Again, this is only happening after the 5.2 upgrade, as soon as I revert back to the 5.1 pages, everything works again, and the user can see the products belonging to them. Any thoughts of what could be the problem?
   
   Thanks.