Problems after install

After installation I needed to run the query mentioned above, which was successful. I am now getting the following error messages.

Customer Groups: Warning: Undefined variable $customer_groups_query in ~/admin123/customers.app/customer_groups.inc.php (Line 57)Warning: Attempt to read property "num_rows" on null in ~/includes/library/lib_database.inc.php (Line 257)

includes/references/ref_product.inc.php
includes/references/ref_product.inc.php

Operation #1
Operation #2
Search not found

Has anyone else had this problem? Is there a fix?

Also, when attempting to edit any of the Customer Groups the following error message is all that appears on the screen.
Fatal error: array_intersect_key(): Argument #2 must be of type array, null given in ~/includes/entities/ent_customer_group.inc.php (Line 44)

I have disabled the Customer Group Prices module because it completely rearranges the website with the following error message.

Fatal error: 1146 - Table 'edbeliv513_lite123.lcjh_products_prices_by_customer_group' doesn't exist select p., pi.name, pi.short_description, m.name as manufacturer_name, pp.price,ppbcg.customer_group_price, pc.campaign_price, if(pc.campaign_price, pc.campaign_price, pp.price) as final_price, pa.attributes from ( select p.id, p.sold_out_status_id, p.code, p.sku, p.mpn, p.gtin, p.manufacturer_id, p.keywords, p.image, p.recommended_price, p.tax_class_id, p.quantity, p.views, p.purchases, p.date_created from lcjh_products p left join lcjh_sold_out_statuses ss on (p.sold_out_status_id = ss.id) where p.status and (p.quantity > 0 or ss.hidden != 1) and (p.date_valid_from is null or p.date_valid_from <= '2025-04-09 11:43:28') and (p.date_valid_to is null or year(p.date_valid_to) < '1971' or p.date_valid_to >= '2025-04-09 11:43:28') ) p left join lcjh_products_info pi on (pi.product_id = p.id and pi.language_code = 'en') left join lcjh_manufacturers m on (m.id = p.manufacturer_id) left join ( select product_id, group_concat(concat(group_id, '-', if(custom_value != '', custom_value, value_id)) separator ',') as attributes from lcjh_products_attributes group by product_id order by id ) pa on (p.id = pa.product_id) left join ( select product_id, if(USD, USD 1, USD) as price from lcjh_products_prices ) pp on (pp.product_id = p.id) left join ( select product_id, if(USD, USD 1, USD) as customer_group_price from lcjh_products_prices_by_customer_group where group_id = 3 ) ppbcg on (ppbcg.product_id = p.id) left join ( select product_id, min(if(USD, USD 1, USD)) as campaign_price from lcjh_products_campaigns where (start_date is null or start_date <= '2025-04-09 11:43:28') and (end_date is null or year(end_date) < '1971' or end_date >= '2025-04-09 11:43:28') group by product_id ) pc on (pc.product_id = p.id) where (p.id and campaign_price > 0 ) group by p.id order by rand() limit 7; in ~/includes/library/lib_database.inc.php (Line 199)

Hi, I think I need to troubleshoot what's going on.

You are entitled to create a support ticket. Click here to begin.

I tried to send the support ticket, but the form would not accept any of the FTP settings I entered and thus would not submit. Please advise.

It's ok to send them to support (at) litecart.net.

This case was related to manually edited core files. Restoring them back to the originals and use vMod for virtual modifications is the solution.