Hi there im getting this error on 2.2.9  would anyone help ?

Notice: Undefined index: name in ~/includes/boxes/box_product_reviews.inc.php (Line 56)
Notice: Undefined index: upvotes in ~/includes/entities/ent_product_review.inc.php (Line 108)
Notice: Undefined index: downvotes in ~/includes/entities/ent_product_review.inc.php (Line 109)
Fatal error: 1054 - Unknown column 'upvotes' in 'field list' update lc_products_reviews set status = '0', product_id = 440, customer_id = 537, customer_email = 'xxxxxxx@gmail.com', customer_name = '', rating = 5, upvotes = 0, downvotes = 0, date_updated = '2022-04-03 22:17:00' where id = '12' limit 1; in ~/includes/library/lib_database.inc.php (Line 260)

Many thanks

Is this a new install of the add-on?
Or upgrading from an older version?

Hi Tim is upgrade from lower version

Try running this upgrade sql from an earlier version:

``ALTER TABLElc_products_reviews ADD COLUMNcustomer_emailVARCHAR(64) NOT NULL DEFAULT '' AFTERcustomer_id, ADD COLUMNcustomer_nameVARCHAR(64) NOT NULL DEFAULT '' AFTERcustomer_email, ADD COLUMNexternal_linkVARCHAR(256) NOT NULL DEFAULT '' AFTERcustomer_name, ADD COLUMNexternal_sourceVARCHAR(64) NOT NULL DEFAULT '' AFTERexternal_link, ADDupvotesINT NOT NULL DEFAULT '0' AFTERexternal_source, ADDdownvotesINT NOT NULL DEFAULT '0' AFTERupvotes, ADD INDEXrating(rating`);

CREATE TABLE lc_products_reviews_attachments (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
review_id INT(11) UNSIGNED NOT NULL DEFAULT '0',
attachment VARCHAR(512) NOT NULL DEFAULT '',
filename VARCHAR(128) NOT NULL DEFAULT '',
mime VARCHAR(32) NOT NULL DEFAULT '',
priority INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX review_id (review_id)
);```

Or compare your db structure to the README and add missing columns using phpMyadmin, HeidiSQL or what might be your favourite mysql manager.

Getting this message 

SQL query: Copy

CREATE TABLE lc_products_reviews_attachments (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
review_id INT(11) UNSIGNED NOT NULL DEFAULT '0',
attachment VARCHAR(512) NOT NULL DEFAULT '',
filename VARCHAR(128) NOT NULL DEFAULT '',
mime VARCHAR(32) NOT NULL DEFAULT '',
priority INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
INDEX review_id (review_id)
);
MySQL said: Documentation

1050 - Table 'lc_products_reviews_attachments' already exists

bump

[quote]Table 'lc_products_reviews_attachments' already exists[/quote]

It already exists, so simply don't attempt to create it again. See if the columns match.

Hi Tim i did check all columns still getting error so actually i'm not able to create review from admin panel as getting this error

Then when you trying to leave review as a customer page i all over and this error 

Notice: Undefined index: downvotes in ~/includes/entities/ent_product_review.inc.php (Line 107)
Fatal error: 1054 - Unknown column 'upvotes' in 'field list' update lc_products_reviews set status = '0', product_id = 504, customer_id = 537, rating = 5, upvotes = 0, downvotes = 0, date_updated = '2022-04-21 21:09:46' where id = '16' limit 1; in ~/includes/library/lib_database.inc.php (Line 260)```

Ok managed to find one problem now im getting this on page with product 

) customer reviews```

Create a support ticket and I will sort this out.
You are entitled to create a support ticket. Click here to begin.

Hi i have upgraded to LiteCart® 2.4.3  now when testing getting this missing 

[quote]includes/functions/func_draw.inc.php
Operation #1  Search not found[/quote]
Many thanks for help

I uploaded an update I think solves the compatibility with func_draw.in.php in 2.4.3.

Thanks Tim all working now

Wonderful to hear :)