sheepstations

I had to fix the syntax a little to ALTER TABLE `ps_layered_price_index` ADD `id_country` int(11) DEFAULT 8 ; but that worked perfectly. Thanks very much for your help. All good now. JR

Hi and thank you for the great reply. That makes things seem much clearer. So what I can tell you after looking at the table, the column id_country does not exist in (ps_layered_price_index.) Can I ask you to provide the SQL command to insert the column id_country into the table so that all values = 8 ? That would be very much appreciated. JR

Hi, I have just upgraded from P1.7.5.0 to P1.7.6.8 and now find that I can not view any category pages. Product pages are fine. When in debug mode, I get the following error messages. Can anybody offer a solution? I have looked around the forum on this topic and can't find an answer that helps me. Thanks in advance, JR [PrestaShopDatabaseException] Unknown column 'psi.id_country' in 'on clause'<br /><br /><pre>SELECT p.id_product, p.price, psi.price_min, psi.price_max FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND c.nleft>=84 AND c.nright<=91 AND ps.id_shop='1' GROUP BY p.id_product) p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) GROUP BY p.id_product ORDER BY psi.price_min ASC LIMIT 0, 20</pre> at line 769 in file classes/db/Db.php 764. if ($webservice_call && $errno) { 765. $dbg = debug_backtrace(); 766. WebserviceRequest::getInstance()->setError(500, ' ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97); 767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 768. if ($sql) { 769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>'); 770. } 771. 772. throw new PrestaShopDatabaseException($this->getMsgError()); 773. } 774. } DbCore->displayError - [line 385 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 92 - modules/ps_facetedsearch/src/Adapter/MySQL.php] - [1 Arguments] PrestaShop\Module\FacetedSearch\Adapter\MySQL->execute - [line 94 - modules/ps_facetedsearch/src/Filters/Products.php] PrestaShop\Module\FacetedSearch\Filters\Products->getProductByFilters - [line 133 - modules/ps_facetedsearch/src/Product/SearchProvider.php] - [5 Arguments] PrestaShop\Module\FacetedSearch\Product\SearchProvider->runQuery - [line 308 - classes/controller/ProductListingFrontController.php] - [2 Arguments] ProductListingFrontControllerCore->getProductSearchVariables - [line 580 - classes/controller/ProductListingFrontController.php] ProductListingFrontControllerCore->doProductSearch - [line 137 - controllers/front/listing/CategoryController.php] - [2 Arguments] CategoryControllerCore->initContent - [line 292 - classes/controller/Controller.php] ControllerCore->run - [line 515 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php]

Hello, is any body able to tell me how to delete the field that says 'Delivery Charges' in the invoice summary.

I suppose the obvious problem with the second site issue is that PS is trying to lookup a database connection using the old database name. Is there any other cache or setting that needs to be cleared / modified so that PS can connect to the DB using the new database name?

Hi, I have 2 sites using PS1.7.5.0 and PHP 7.2. I had to change the DB name for both sites to be less than 16 characters for a third-party service provider. (It's a long story). I did re-name the databases and then made sure the DB user was given all permissions to the re-named databases again. I changed the DB name values in ../parameters.php. I also cleared the cache in ../cache/smarty. No problem then logging on and viewing the frontend of both sites. This proves the change to the database name was implemented OK. The problem is viewing the backend login pages. The first site just returns a blank white page. The second site gives an error Access denied for user 'gwoyrfze_vbn2'@'localhost' to database 'gwoyrfze_cherbourg' The database has been re-named to gwoyrfze_cher and this value is definitely in the ../parameters.php file. What else could be stopping me viewing the backend login pages when I can see the frontend of the websites without any problem? Thanks in anticipation. JR

Problem solved by re-populating PS_access with values from new 1.7.5.0 install. The table was empty after the upgrade.

Hello, I have just used the 1-Click Upgrade to upgrade from P1.7.2.0 to P1.7.5.0. All seemed to go well with a final message saying the upgrade had been completed successfully. I cleared my cache and cookies as recommended and logged out. I am now getting an Access denied message in all areas of my dashboard. I was able to update my profile password though. That is the only function that seems to work. (The site is still locked in Maintenance Mode.) Can anybody suggest a solution to fix this so I can get full access to my dashboard again? Thanks, JR

Hi,thanks I did that which means the Shipping tab no longer appears as part of the checkout process. Unfortunately in the My Shopping Cart module, there is still a reference to 'Shipping (under conditions) Free'. Any ideas how to remove this entirely? (Or access the language files to change the wording?) Thanks, JR

Hello, at the very end of the checkout process, there is a button which says 'Order With An Obligation To Pay'. How do I change the text in this button. Is there a language file I can access and update? Any help would be appreciated. Thanks, JR

Hello All, with my client, they do not offer any sort of shipping or delivery. Everything is picked from the store. How can I delete all references to shipping on the checkout? At the moment, it notes shipping is 'free' which is misleading for the customer when no shipping is offered. Thanks in advance, JR

Hi, I have a PS1.7.2.0 store installed and find that the pagination does not work to scroll through product pages. For example, if I have say 3 product pages, hitting the link to bring up pages 2 or 3 does not work. Can anybody shed some light on how to fix this? Thanks, JR

Problem solved.

Hello, I have just migrated a PS1.7 site from my development server to the live server using a sub domain. Everything appears to be OK except no matter what I try, I can not login to the admin area. I know my username and password are OK. I have even tried going into the ps_employees table and over-riding my password directly in the database table but nothing works. Can anybody suggest what I need to do fix this problem? Thanks, JR

Hello, I am attempting to upgrade from 1.7.2.0 to 1.7.2.2 and I'm using the latest version of 1Click Upgrade 3.0.3. Everything goes smoothly until the very end of the process when I get the following error. I've tried the process twice and it stumbles at this last step both times. All files upgraded. Now upgrading database...... [Ajax / Server Error for action upgradeDb] textStatus: "error " errorThrown:"Internal Server Error " jqXHR: " " Can anyone suggest a solution for this please? Thanks, JR