Eroare creare cont client prestashop 1.6

[marian170876]

Salut.

Sunt un utilizator nou de Prestashop. Am instalat prestashop 1.6 local dupa care l-am mutat pe un domeniu. Dupa mutare in sectiunea de creare cont sau comanda fara cont am unele erori: Atunci cand creezi cont dupa introducerea datelor personale la urmatorul pas si anume la completarea adresei site-ul nu ma mai lasa sa fac asta! Daca incerc sa fac comanda fara cont imi da eroare si anume ca CNP sau nr de indentificare este eronat sau nu exista in baza de date in contextul in care eu am sters toti clientii din BO. Ma poate ajuta cineva cu asta? Imi storc creierii de vreo doua zile si nu ii dau de cap si nici pe forumuri nu am gasit o rezolvare.  Adrea Site-ului este http://electromag-romania.ro. Astept un raspuns de la cine poate sa imi dea o mana de ajutor!

Edited June 5, 2014 by marian170876 (see edit history)

[lightsb]

Salut,

activeaza consola de debug si vezi unde se opreste.

 

bafta.

[marian170876]

Salut,

activeaza consola de debug si vezi unde se opreste.

 

bafta.

Multumesc pentru raspuns! hai sa vad ce naiba are...

[marian170876]

Multumesc pentru raspuns! hai sa vad ce naiba are...

Asta e ceea ce imi afiseaza consola:

[PrestaShopDatabaseException]

Unknown column 'citycode' in 'field list'

 

INSERT INTO `ps_address` (`id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `id_country`, `id_state`, `alias`, `company`, `lastname`, `firstname`, `vat_number`, `address1`, `address2`, `postcode`, `city`, `citycode`, `other`, `phone`, `phone_mobile`, `dni`, `deleted`, `date_add`, `date_upd`) VALUES ('3', '0', '0', '0', '36', '338', 'Adresa mea', 'Luxury Interiors Design Srl', 'Mag', 'Electro', '', 'Strada Pipera Tunari nr. 48A', '', '729951', 'Voluntari', '', '', '40726265530', '40726265530', '1170876075085', '0', '2014-06-06 12:11:20', '2014-06-06 12:11:20')

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

629.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);

630.         }

631.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))

632.         {

633.             if ($sql)

634.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');

635.             throw new PrestaShopDatabaseException($this->getMsgError());

636.         }

637.     }

638.

639.     /**

• DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
  319.         if ($sql instanceof DbQuery)

  320.             $sql = $sql->build();

  321.

  322.         $this->result = $this->_query($sql);

  323.         if (_PS_DEBUG_SQL_)

  324.             $this->displayError($sql);

  325.         return $this->result;

  326.     }

  327.

  328.     /**

  329.      * Execute an INSERT query

• DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]
  603.     {

  604.         if ($sql instanceof DbQuery)

  605.             $sql = $sql->build();

  606.

  607.         $this->result = false;

  608.         $result = $this->query($sql);

  609.         if ($use_cache && $this->is_cache_enabled)

  610.             Cache::getInstance()->deleteQuery($sql);

  611.         if (_PS_DEBUG_SQL_)

  612.             $this->displayError($sql);

  613.         return $result;

• DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]
  384.             $keys_stringified = implode(', ', $keys);

  385.             $values_stringified[] = '('.implode(', ', $values).')';

  386.         }

  387.

  388.         $sql = $insert_keyword.' INTO `'.$table.'` ('.$keys_stringified.') VALUES '.implode(', ', $values_stringified);

  389.         return (bool)$this->q($sql, $use_cache);

  390.     }

  391.

  392.     /**

  393.      * @param string $table Table name without prefix

  394.      * @param array $data Data to insert as associative array. If $data is a list of arrays, multiple insert will be done

• DbCore->insert - [line 455 - classes/ObjectModel.php] - [3 Arguments]
  449.         // Database insertion

  450.         if (isset($this->id) && !Tools::getValue('forceIDs'))

  451.             unset($this->id);

  452.         if (Shop::checkIdShopDefault($this->def['table']))

  453.             $this->id_shop_default = min($id_shop_list);

  454.         if (!$result = ObjectModel::$db->insert($this->def['table'], $this->getFields(), $null_values))

  455.             return false;

  456.

  457.         // Get object id in database

  458.         $this->id = ObjectModel::$db->Insert_ID();

  459.

• ObjectModelCore->add - [line 174 - override/classes/Address.php] - [2 Arguments]
  168.     /**

  169.      * @see ObjectModel::add()

  170.      */

  171.     public function add($autodate = true, $null_values = false)

  172.     {

  173.         if (!parent::add($autodate, $null_values))

  174.             return false;

  175.

  176.         if (Validate::isUnsignedId($this->id_customer))

  177.             Customer::resetAddressCache($this->id_customer);

  178.         return true;

• AddressCore->add - [line 554 - controllers/front/AuthController.php]
  548.                                     $post = $_POST[$key.'_invoice'];

  549.         

  550.                         $this->errors = array_unique(array_merge($this->errors, $addresses_type->validateController()));

  551.                         if ($addresses_type == 'address_invoice')

  552.                             $_POST = $post_back;

  553.                         if (!count($this->errors) && (Configuration::get('PS_REGISTRATION_PROCESS_TYPE') || $this->ajax || Tools::isSubmit('submitGuestAccount')) && !$addresses_type->add())

  554.                             $this->errors[] = Tools::displayError('An error occurred while creating your address.');

  555.                     }

  556.                     if (!count($this->errors))

  557.                     {

  558.                         if (!$customer->is_guest)

• AuthControllerCore->processSubmitAccount - [line 252 - controllers/front/AuthController.php]
  246.     {

  247.         if (Tools::isSubmit('SubmitCreate'))

  248.             $this->processSubmitCreate();

  249.

  250.         if (Tools::isSubmit('submitAccount') || Tools::isSubmit('submitGuestAccount'))

  251.             $this->processSubmitAccount();

  252.

  253.         if (Tools::isSubmit('SubmitLogin'))

  254.             $this->processSubmitLogin();

  255.     }

  256.

• AuthControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
  165.             // setMedia MUST be called before postProcess

  166.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))

  167.                 $this->setMedia();

  168.

  169.             // postProcess handles ajaxProcess

  170.             $this->postProcess();

  171.

  172.             if (!empty($this->redirect_after))

  173.                 $this->redirect();

  174.

  175.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))

• ControllerCore->run - [line 373 - classes/Dispatcher.php]
  367.             // Execute hook dispatcher

  368.             if (isset($params_hook_action_dispatcher))

  369.                 Hook::exec('actionDispatcher', $params_hook_action_dispatcher);

  370.

  371.             // Running controller

  372.             $controller->run();

  373.         }

  374.         catch (PrestaShopException $e)

  375.         {

  376.             $e->displayMessage();

  377.         }

• DispatcherCore->dispatch - [line 28 - index.php]
  22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)

  23. * International Registered Trademark & Property of PrestaShop SA

  24. */

  25.

  26. require(dirname(__FILE__).'/config/config.inc.php');

  27. Dispatcher::getInstance()->dispatch();

[lightsb]

Aceasta coloana "`citycode`," nici nu exista in acea tabela...

 

Eu as recopia fisierul /classes/db/Db.php din folderul downloadat de prestashop si as reincerca.

 

Bafta.

[costi43]

cred ca ai incercat sa pui un modul ceva, incearca sa intri in phpmyacmin si sterge randul citycode dina tabelul ps_address

[marian170876]

cred ca ai incercat sa pui un modul ceva, incearca sa intri in phpmyacmin si sterge randul citycode dina tabelul ps_address

Multumesc tuturor! S-a rezovat. Intr-adevar citycode nu exista in db.

Edited June 7, 2014 by marian170876 (see edit history)

[xpc]

Buna

am nevoie de ajutor daca are cineva timp si rabdare

am tot citit peste tot si nu am reusit sa ma lamuresc

am o problema la adaugare adresa noua la client asta dupa ce am sters modulul de la urgent curier

 

se poate testa la http://pcdex.ro/cart/

Edited July 18, 2014 by xpc (see edit history)

[cristic]

Unknown column 'citycode' in 'field list' 

Vine de la modulul celor de la Urgent Curier. Rezolvarea ar fi sa se adauge acest camp in tabela ps_address.

[Ovidiu H]

Unknown column 'citycode' in 'field list' 

Vine de la modulul celor de la Urgent Curier. Rezolvarea ar fi sa se adauge acest camp in tabela ps_address.

 

 

 

Da asa este . Modulul Urgent Cargus e scris putin aiurea. In cazul in care apare eroarea Unknown column 'citycode' in 'field list'  trebuie aduagat un capm in tabela ps_adress sub city.

[NVS2016]

Salut,

 

Poti sa-mi trimiti un prtsc exact cu ceea ce ai scris in linia 16 ( other ) ? am aceeasi problema.

[Ovidiu H]

E total aiurea modulul lor , Faci o linie noua cu citycode sub city cu aceleasi valori ca la city.