Messages postés par Bitfarmer

Currently I have SumUp Online Payments module v2.2.0 installed but it continuously says a further update is available. Updating never proceeds beyond v2.2.0.
Any ideas? KFS

Upon logging in after the upgrade having already flushed the caches, this error appeared:

×
[ SQL ERROR ]

Unknown column 'id_configuration' in 'field list'
                        SELECT CONCAT("
                            DELETE FROM `configuration_kpi` 
                            WHERE `name` = 'UPDATE_MODULES' 
                            AND `id_configuration` != ", MAX(`id_configuration`), "
                            AND `value` = '0'
                             
                AND (id_shop_group IS NULL OR id_shop_group = 0) 
                AND (id_shop IS NULL OR id_shop = 0)
                            ") as stmt
                        FROM `configuration_kpi`
                        WHERE `name` = 'UPDATE_MODULES'
                         
                AND (id_shop_group IS NULL OR id_shop_group = 0) 
                AND (id_shop IS NULL OR id_shop = 0)
                        GROUP BY name
                        HAVING COUNT(*) > 1 LIMIT 1
DbCore->displayError in /classes/db/Db.php:458
DbCore->query in /classes/db/Db.php:719
DbCore->getRow in /classes/db/Db.php:749
DbCore->getValue in /classes/Configuration.php:642
ConfigurationCore::updateValue in /classes/ConfigurationKPI.php:122
ConfigurationKPICore::updateValue in /controllers/admin/AdminModulesController.php:2196
AdminModulesControllerCore->initContent in /classes/controller/Controller.php:336
ControllerCore->run in /classes/Dispatcher.php:427
DispatcherCore->dispatch in /storeadmin/index.php:79

There is no field called 'id_configuration' in 'configuration_kpi' but there is a field called 'id_configuration_kpi'. Is that what is wrong I wonder.

Running Phenixsuite 1.6.2.31 and Paypal Module V15 I am still seeing an error that I believe is in the module itself. This is the error:

Fatal error: Uncaught Error: Call to undefined method Attribute::getAttributeMinimalQty() in 
 /var/www/sites/site/store/modules/paypal/paypal.php:1620
 Stack trace: 
#0 /var/www/sites/site/store/modules/paypal/paypal.php(1082): PayPal->renderExpressCheckoutForm() 
#1 /var/www/sites/site/store/classes/Hook.php(710): PayPal->hookProductFooter() 
#2 /var/www/sites/site/store/classes/Hook.php(650): HookCore::coreCallHook() 
#3 /var/www/sites/site/store/controllers/front/ProductController.php(1043): HookCore::exec() 
#4 /var/www/sites/site/store/controllers/front/ProductController.php(439): ProductControllerCore->assignCategory() 
#5 /var/www/sites/site/store/classes/controller/Controller.php(330): ProductControllerCore->initContent() 
#6 /var/www/sites/site/store/classes/Dispatcher.php(408): ControllerCore->run() 
#7 /var/www/sites/site/store/index.php(27): DispatcherCore->dispatch() 
#8 {main} thrown in /var/www/sites/site/store/modules/paypal/paypal.php on line 1620

When I change line 1620 from

$minimal_quantity = Attribute::getAttributeMinimalQty($id_product_attribute);

To this

$minimal_quantity = AttributeProduct::getAttributeMinimalQty($id_product_attribute);

Everything works. Now this bug might have been there a long time (or I'm stupid).
On the other hand it may save someone a lot of trouble. If it does please let me know

Sorry, I was suffering from "Brain Freeze". That should read PHP 8.1 not Python.

This is a deprecation error which won't show up on earlier versions of Python but does effect Python 8.1 up. The fix is very simple:

diff -wurp a/tools/swift/classes/Swift/Transport/AbstractSmtpTransport.php b/tools/swift/classes/Swift/Transport/AbstractSmtpTransport.php
--- a/tools/swift/classes/Swift/Transport/AbstractSmtpTransport.php	2023-09-27 21:04:32.000000000 +0000
+++ b/tools/swift/classes/Swift/Transport/AbstractSmtpTransport.php	2023-10-15 17:24:18.086451046 +0000
@@ -395,7 +395,7 @@ abstract class Swift_Transport_AbstractS
             do {
                 $line = $this->_buffer->readLine($seq);
                 $response .= $line;
-            } while (null !== $line && false !== $line && ' ' != $line{3});
+            } while (null !== $line && false !== $line && ' ' != $line[3]);
         } catch (Swift_TransportException $e) {
             $this->_throwException($e);
         } catch (Swift_IoException $e) {

@eolia I'm delighted to help. I found another one while debugging a different problem, this one is in the runtime rather than the installation directory. It's just another SQL reserved word issue:

diff a/classes/Product.php b/classes/Product.php
--- a/classes/Product.php	2023-07-28 20:40:48.000000000 +0000
+++ b/classes/Product.php	2023-08-02 11:16:45.000000000 +0000
@@ -5263,7 +5263,7 @@ class ProductCore extends ObjectModel
					 AND `fl`.`id_lang` = '.(int)$id_lang.')
				 INNER JOIN '._DB_PREFIX_.'feature_value `fv`
					 ON(`fv`.`id_feature_value` = `pf`.`id_feature_value`)
-                LEFT JOIN '._DB_PREFIX_.'separator `s`
+                LEFT JOIN `'._DB_PREFIX_.'separator` `s`
					 ON(`s`.`id_separator` = `f`.`id_separator`)
				 '.($use_bl ? 'LEFT JOIN `'._DB_PREFIX_.'layered_indexable_feature_lang_value` `liflv`
								 ON(`f`.`id_feature` = `liflv`.`id_feature`

Forgive me if I am telling you something you already know, I am relatively new the PhenixSuite. While attempting to install 1.6.2.12 on a debian test machine I ran into two problems. I surely can't be the first to discover them. The first is caused but the use of an unescaped MySQL reserved word as a table name. The second by an unencoded & in the name of a TAB. I enclose the relevant patches below. Maybe I've been staring at code for too long, but on the other hand maybe it will help someone else!

diff a/install/classes/xmlLoader.php b/install/classes/xmlLoader.php
--- a/install/classes/xmlLoader.php	2023-02-13 13:54:58.000000000 +0000
+++ b/install/classes/xmlLoader.php	2023-07-16 13:30:51.764484508 +0000
@@ -578,7 +578,7 @@ class InstallXmlLoader
     public function generatePrimary($entity, $primary)
     {
         if (!isset($this->primaries[$entity])) {
-            $this->primaries[$entity] = (int)Db::getInstance()->getValue('SELECT '.$primary.' FROM '._DB_PREFIX_.$entity.' ORDER BY '.$primary.' DESC');
+            $this->primaries[$entity] = (int)Db::getInstance()->getValue('SELECT '.$primary.' FROM `'._DB_PREFIX_.$entity.'` ORDER BY '.$primary.' DESC');
         }
         return ++$this->primaries[$entity];
     }
diff a/install/langs/en/data/tab.xml b/install/langs/en/data/tab.xml
--- s/install/langs/en/data/tab.xml	2023-03-17 19:07:54.000000000 +0000
+++ b/install/langs/en/data/tab.xml	2023-07-16 12:02:23.991545234 +0000
@@ -75,7 +75,7 @@
   <tab id="Maintenance" name="Maintenance"/>
   <tab id="Geolocation" name="Geolocation"/>
   <tab id="Configuration_Information" name="Configuration Information"/>
-  <tab id="Performance" name="Performance & Security"/>
+  <tab id="Performance" name="Performance &amp; Security"/>
   <tab id="E-mail" name="E-mail"/>
   <tab id="Multistore" name="Multistore"/>
   <tab id="CSV_Import" name="CSV Import"/>