Re: Guest not asking for email address
Posted: 09 Sep 2022, 14:21
I had ver 4.0.3 installed. 4.0.5 did solve the problem in that the email address was retained in the backend. I did get a copy of the order which I didn't before. The only glitch is that I'm getting errant code displayed at the top of the cart which I've pasted below. I don't see any obvious errors using Chrome developer tools but I'm not good at reading that. Is this a function of a version that is still in beta. Would ver 4.0.4 address this? If necessary I could wait until you have 4.05 completely finished. I have a backup of the prior version I can restore to.
Code at top of each page in checkout follows:
SELECT a.id,a.title,a.image,a.alias,a.unit_amount,a.unit_unit,a.description,a.sku,a.ean,a.upc,a.type,a.points_received,a.price_original,a.stock,a.stock_calculation,a.min_quantity,a.min_multiple_quantity,a.stockstatus_a_id,a.stockstatus_n_id,a.date,a.sales,a.featured,a.external_id,a.external_link,a.external_text,a.price,a.gift_types, GROUP_CONCAT(DISTINCT c.id) AS catid, GROUP_CONCAT(DISTINCT c.title) AS cattitle, GROUP_CONCAT(DISTINCT c.alias) AS catalias, a.catid AS preferred_catid, t.id as taxid, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle,at.required AS attribute_required, MIN(ppg.price) as group_price, MAX(pptg.points_received) as group_points_received, m.id as manufacturerid, m.title as manufacturertitle, m.alias as manufactureralias, AVG(r.rating) AS rating FROM jos_phocacart_products AS a LEFT JOIN jos_phocacart_product_categories AS pc ON pc.product_id = a.id LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id LEFT JOIN jos_phocacart_reviews AS r ON a.id = r.product_id AND r.id > 0 LEFT JOIN jos_phocacart_manufacturers AS m ON m.id = a.manufacturer_id LEFT JOIN jos_phocacart_taxes AS t ON t.id = a.tax_id LEFT JOIN jos_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 LEFT JOIN jos_phocacart_item_groups AS ga ON a.id = ga.item_id AND ga.type = 3 LEFT JOIN jos_phocacart_item_groups AS gc ON c.id = gc.item_id AND gc.type = 2 LEFT JOIN jos_phocacart_product_price_groups AS ppg ON a.id = ppg.product_id AND ppg.group_id IN (SELECT group_id FROM jos_phocacart_item_groups WHERE item_id = a.id AND group_id IN (1) AND type = 3) LEFT JOIN jos_phocacart_product_point_groups AS pptg ON a.id = pptg.product_id AND pptg.group_id IN (SELECT group_id FROM jos_phocacart_item_groups WHERE item_id = a.id AND group_id IN (1) AND type = 3) WHERE a.published = 1 AND c.published = 1 AND c.type IN (0,1) AND c.access IN (1,5) AND a.access IN (1,5) AND (ga.group_id IN (1) OR ga.group_id IS NULL) AND (gc.group_id IN (1) OR gc.group_id IS NULL) AND c.id IN (9) GROUP BY a.id ORDER BY c.id, pc.ordering ASC
SELECT a.id FROM jos_phocacart_products AS a LEFT JOIN jos_phocacart_product_categories AS pc ON pc.product_id = a.id LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id LEFT JOIN jos_phocacart_manufacturers AS m ON m.id = a.manufacturer_id LEFT JOIN jos_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 LEFT JOIN jos_phocacart_item_groups AS ga ON a.id = ga.item_id AND ga.type = 3 LEFT JOIN jos_phocacart_item_groups AS gc ON c.id = gc.item_id AND gc.type = 2 WHERE a.published = 1 AND c.published = 1 AND c.type IN (0,1) AND c.access IN (1,5) AND a.access IN (1,5) AND (ga.group_id IN (1) OR ga.group_id IS NULL) AND (gc.group_id IN (1) OR gc.group_id IS NULL) AND c.id IN (9) GROUP BY a.id
Code at top of each page in checkout follows:
SELECT a.id,a.title,a.image,a.alias,a.unit_amount,a.unit_unit,a.description,a.sku,a.ean,a.upc,a.type,a.points_received,a.price_original,a.stock,a.stock_calculation,a.min_quantity,a.min_multiple_quantity,a.stockstatus_a_id,a.stockstatus_n_id,a.date,a.sales,a.featured,a.external_id,a.external_link,a.external_text,a.price,a.gift_types, GROUP_CONCAT(DISTINCT c.id) AS catid, GROUP_CONCAT(DISTINCT c.title) AS cattitle, GROUP_CONCAT(DISTINCT c.alias) AS catalias, a.catid AS preferred_catid, t.id as taxid, t.tax_rate as taxrate, t.calculation_type as taxcalculationtype, t.title as taxtitle,at.required AS attribute_required, MIN(ppg.price) as group_price, MAX(pptg.points_received) as group_points_received, m.id as manufacturerid, m.title as manufacturertitle, m.alias as manufactureralias, AVG(r.rating) AS rating FROM jos_phocacart_products AS a LEFT JOIN jos_phocacart_product_categories AS pc ON pc.product_id = a.id LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id LEFT JOIN jos_phocacart_reviews AS r ON a.id = r.product_id AND r.id > 0 LEFT JOIN jos_phocacart_manufacturers AS m ON m.id = a.manufacturer_id LEFT JOIN jos_phocacart_taxes AS t ON t.id = a.tax_id LEFT JOIN jos_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 LEFT JOIN jos_phocacart_item_groups AS ga ON a.id = ga.item_id AND ga.type = 3 LEFT JOIN jos_phocacart_item_groups AS gc ON c.id = gc.item_id AND gc.type = 2 LEFT JOIN jos_phocacart_product_price_groups AS ppg ON a.id = ppg.product_id AND ppg.group_id IN (SELECT group_id FROM jos_phocacart_item_groups WHERE item_id = a.id AND group_id IN (1) AND type = 3) LEFT JOIN jos_phocacart_product_point_groups AS pptg ON a.id = pptg.product_id AND pptg.group_id IN (SELECT group_id FROM jos_phocacart_item_groups WHERE item_id = a.id AND group_id IN (1) AND type = 3) WHERE a.published = 1 AND c.published = 1 AND c.type IN (0,1) AND c.access IN (1,5) AND a.access IN (1,5) AND (ga.group_id IN (1) OR ga.group_id IS NULL) AND (gc.group_id IN (1) OR gc.group_id IS NULL) AND c.id IN (9) GROUP BY a.id ORDER BY c.id, pc.ordering ASC
SELECT a.id FROM jos_phocacart_products AS a LEFT JOIN jos_phocacart_product_categories AS pc ON pc.product_id = a.id LEFT JOIN jos_phocacart_categories AS c ON c.id = pc.category_id LEFT JOIN jos_phocacart_manufacturers AS m ON m.id = a.manufacturer_id LEFT JOIN jos_phocacart_attributes AS at ON a.id = at.product_id AND at.id > 0 AND at.required = 1 LEFT JOIN jos_phocacart_item_groups AS ga ON a.id = ga.item_id AND ga.type = 3 LEFT JOIN jos_phocacart_item_groups AS gc ON c.id = gc.item_id AND gc.type = 2 WHERE a.published = 1 AND c.published = 1 AND c.type IN (0,1) AND c.access IN (1,5) AND a.access IN (1,5) AND (ga.group_id IN (1) OR ga.group_id IS NULL) AND (gc.group_id IN (1) OR gc.group_id IS NULL) AND c.id IN (9) GROUP BY a.id