Jump to content

Edit History

ChiaraQ

ChiaraQ

Hello, I have a similar problem with PrestaShopDatabaseException, this is the result of my debug:

[PrestaShopDatabaseException]

Unknown column 'sdi' in 'field list'

 

INSERT INTO `psgf_address` (`id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `id_country`, `id_state`, `alias`, `company`, `lastname`, `firstname`, `vat_number`, `sdi`, `pec`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `dni`, `deleted`, `date_add`, `date_upd`) VALUES ('7', '0', '0', '0', '10', '210', 'Il mio indirizzo', 'Azienda', 'Cognome', 'Nome', '', '', '', 'Indirizzo', '', 'CAP', 'Citta', '', '', '', '', '0', '', '')

at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $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 740 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 476 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 551 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 178 - classes/Address.php] - [2 Arguments]
AddressCore->add - [line 508 - classes/ObjectModel.php] - [2 Arguments]
ObjectModelCore->save - [line 74 - classes/form/CustomerAddressPersister.php]
CustomerAddressPersisterCore->save - [line 157 - classes/form/CustomerAddressForm.php] - [2 Arguments]
CustomerAddressFormCore->submit - [line 109 - classes/checkout/CheckoutAddressesStep.php]
CheckoutAddressesStepCore->handleRequest - [line 59 - classes/checkout/CheckoutProcess.php] - [1 Arguments]
CheckoutProcessCore->handleRequest - [line 265 - controllers/front/OrderController.php] - [1 Arguments]
OrderControllerCore->initContent - [line 281 - classes/controller/Controller.php]
ControllerCore->run - [line 511 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

I also installed a module that can add some fields in the registration form, but only in the first block (personal information), not in the addresses section, I don't think this module can cause problems.
Can someone please help me?

Thank you for any help,
Chiara

ChiaraQ

ChiaraQ

Hello, I have a similar problem with PrestaShopDatabaseException, this is the result of my debug:

[PrestaShopDatabaseException]

Unknown column 'sdi' in 'field list'

 

INSERT INTO `psgf_address` (`id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `id_country`, `id_state`, `alias`, `company`, `lastname`, `firstname`, `vat_number`, `sdi`, `pec`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `dni`, `deleted`, `date_add`, `date_upd`) VALUES ('7', '0', '0', '0', '10', '210', 'Il mio indirizzo', 'pari srl', 'Pi', 'Chiara', '', '', '', 'via Roma 10', '', '47923', 'Rimini', '', '3409979042', '', '', '0', '2019-08-20 09:55:17', '2019-08-20 09:55:17')

at line 769 in file classes/db/Db.php

764.         if ($webservice_call && $errno) {
765.             $dbg = debug_backtrace();
766.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $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 740 - classes/db/Db.php] - [1 Arguments]
DbCore->q - [line 476 - classes/db/Db.php] - [2 Arguments]
DbCore->insert - [line 551 - classes/ObjectModel.php] - [3 Arguments]
ObjectModelCore->add - [line 178 - classes/Address.php] - [2 Arguments]
AddressCore->add - [line 508 - classes/ObjectModel.php] - [2 Arguments]
ObjectModelCore->save - [line 74 - classes/form/CustomerAddressPersister.php]
CustomerAddressPersisterCore->save - [line 157 - classes/form/CustomerAddressForm.php] - [2 Arguments]
CustomerAddressFormCore->submit - [line 109 - classes/checkout/CheckoutAddressesStep.php]
CheckoutAddressesStepCore->handleRequest - [line 59 - classes/checkout/CheckoutProcess.php] - [1 Arguments]
CheckoutProcessCore->handleRequest - [line 265 - controllers/front/OrderController.php] - [1 Arguments]
OrderControllerCore->initContent - [line 281 - classes/controller/Controller.php]
ControllerCore->run - [line 511 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

I also installed a module that can add some fields in the registration form, but only in the first block (personal information), not in the addresses section, I don't think this module can cause problems.
Can someone please help me?

Thank you for any help,
Chiara

×
×
  • Create New...