Hello,
This is a fairly simple Top Sellers/Recommended table, created from Brands, Items & Categories (all the same int(11) unsigned id's)
After Build, I first receive a parse error in sellers_events line 3 (uncommented ** and I did not modify any event code), fix that, then receive another error in commonfunctions.php line 294 which reads
$value=(int)value;
instead of
$value=(int)$value; // missing $ before final value;
Fix that, then go to add a record with a checkbox defaulting to 1 (it's a tinyint(1) unsigned default '1'), but the checkbox isn't checked? BTW, this did work just fine when I tried 3.0 with EITHER a set or enum value, why was that removed in 3.1?
But here's the killer:
brand_id is a lookup showing brand_name where brand_visible=1
item_id is a lookup showing item_name where visible=1, dependant on brand_id / brand_id
Everything works correctly here (it only shows items that belong to the selected brand), and I am able to save the record. BUT, the brand_id is not correct after adding (or editing). This does not happen to all records?
Is this somehow affected by whether there are brand_name and item_name records that contain apostrophes? I've viewed the source, and the select options are correct for brands, and the arr_item_id array has the correct values before saving.
I'm very confused, anybody have an idea what's going on here?
Help! John
