Incompatible carrier module Geispoint (for PS 1.6)

[luksl]

This module is for choosing a delivery point of the Geispoint carrier when making an order. (Downloaded from official website: http://www.geispoint.cz/)

01520066117244geispoint_CZ.zip

It works with Prestashop 1.6 (I have tested it) without problems but doesnt work with TB.

When I choose Geis Point carrier and in the end confirm an order I get this: [ThirtyBeesDatabaseException] Unknown column 'o.idGP' in 'field list' SELECT o.idGP FROM tb_geispoint_order o WHERE o.id_order = 98 LIMIT 1 at line 808 in file classes/db/Db.php

I checked the table tb_geispoint_order for column idGP and it really doesnt exist but id_gp does.

I wonder why its not a problem for PS.

So I had made changes (in /modules/geispoint/geispoint.php): 1) // if(!($res = Db::getInstance()->getRow('SELECT o.idGP FROM '._DB_PREFIX_.'geispoint_order o WHERE o.idorder = '. ((int) $params['idorder'])))) { if(!($res = Db::getInstance()->getRow('SELECT o.idgp FROM '._DB_PREFIX_.'geispoint_order o WHERE o.idorder = '. ((int) $params['idorder'])))) { 2) // if(!($res = Db::getInstance()->getRow('SELECT o.idGP FROM '._DB_PREFIX_.'geispoint_order o WHERE o.idorder = '. ((int) $params['order']->id)))) { if(!($res = Db::getInstance()->getRow('SELECT o.idgp FROM '._DB_PREFIX_.'geispoint_order o WHERE o.idorder = '. ((int) $params['order']->id)))) { 3) // if(!($res = Db::getInstance()->getRow('SELECT o.idGP FROM '._DB_PREFIX_.'geispoint_order o WHERE o.idorder = '. ((int) $params['objOrder']->id)))) { if(!($res = Db::getInstance()->getRow('SELECT o.idgp FROM '._DB_PREFIX_.'geispoint_order o WHERE o.id_order = '. ((int) $params['objOrder']->id)))) {

When I confirmed an order I got this:

Notice: Undefined index: idGP in /home/www/eshop/modules/geispoint/geispoint.php on line 802

Warning: Missing argument 2 for GeisPointSoapClient::searchGP(), called in /home/www/eshop/modules/geispoint/webService/GeisPointWebService.php on line 95 and defined in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 71

Warning: Missing argument 3 for GeisPointSoapClient::searchGP(), called in /home/www/eshop/modules/geispoint/webService/GeisPointWebService.php on line 95 and defined in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 71

Warning: Missing argument 4 for GeisPointSoapClient::searchGP(), called in /home/www/eshop/modules/geispoint/webService/GeisPointWebService.php on line 95 and defined in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 71

Notice: Undefined variable: postcode in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 74

Notice: Undefined variable: city in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 75

Notice: Undefined variable: idGP in /home/www/eshop/modules/geispoint/webService/GeispointWS/GeisPointSoapClient.php on line 76

Notice: Undefined index: idGP in /home/www/eshop/modules/geispoint/geispoint.php on line 804

I would appreciate any help or advice.

[lesley]

It looks like the module might not be creating all needed table, I would look through the module to find the mySQL and see what tables it creates and create the missing ones.

[luksl]

Thanks for the suggestion - but it is working with PS 1.6 with no problems. So I am confused :-(