solarsurfer Merchant Fra United Kingdom Medlem siden mar. 2021 solarsurfer des. 8 2023 10:22 a.m. Hi Purchased "Product Qty Prices" Most of the file changes are ok, but I am having a problem locating "pages/product.inc.php" (The last file to change lol) The only file I can find is "includes\templates\default.catalog\pages\product.inc.php" and the file contents of this file are totally different to the one mentioned in the add on package ? Regards
solarsurfer Merchant Fra United Kingdom Medlem siden mar. 2021 solarsurfer des. 9 2023 07:10 a.m. Hi Tim, what about the above file not being found ? Regards
solarsurfer Merchant Fra United Kingdom Medlem siden mar. 2021 solarsurfer des. 9 2023 08:05 a.m. ERROR DB fields seem to install correctly, but after entry in cart and "Save" I get error. Fatal error: 1146 - Table 'shearsco_litec50.lcdt_products_quantity_prices' doesn't exist delete from lcdt_products_quantity_prices where product_id = '6' and id not in ('', ''); in ~/includes/library/lib_database.inc.php (Line 177) I enclose pic of Mysql. I didnt change file "pages/product.inc.php" because it didnt seem to exist in the same format as to the only one i could find. Hope you can help.
solarsurfer Merchant Fra United Kingdom Medlem siden mar. 2021 solarsurfer des. 9 2023 11:16 a.m. Found problem with MySQL install but not with the file "pages/product.inc.php" There is a code error in the MySQL install in the package. CREATE TABLE IF NOT EXISTS [b]lc_products_quantity_prices[/b] ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, product_id INT(11) UNSIGNED NOT NULL DEFAULT '0', quantity FLOAT(11,4) NOT NULL DEFAULT '0', EUR FLOAT(11,4) NOT NULL DEFAULT '0', USD FLOAT(11,4) NOT NULL DEFAULT '0', GBP FLOAT(11,4) NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY product_id (product_id) ); The first line should be CREATE TABLE IF NOT EXISTS lcdt_products_quantity_prices ( Then it seems to work
solarsurfer Merchant Fra United Kingdom Medlem siden mar. 2021 solarsurfer des. 9 2023 02:33 p.m. Tried fresh install after findling all files to amend, of "product Qty prices" , and there seems to be some coding errors after installation. The add on also causes coding errors even before the addon is enabled. The addon needs to be disabled before instaltion of MySql and code changes.
tim Founder Fra Sweden Medlem siden mai 2013 tim des. 10 2023 01:56 a.m. You missed the note right above it [quote][b][i](Note: If your table prefix is not lc_ you need to change it into your table prefix)[/i][/b][/quote] I will help you get it installed for you. There are no current errors reported for this addon so I think this is a simple fix. You are entitled to create a support ticket. Click here to begin.