nefunguje zakladanie uctov vyskytla sa chyba počas vytvárania vášho účtu

[turbojustin]

Zdravim,

po upgrade na 1.3.1.1 final sa neda zalozit zakaznicky ucet. Po zadani mena adresy a pod mi vyhodi:

Vyskytla sa 1 chyba :

01. vyskytla sa chyba počas vytvárania vášho účtu

Skusal som uz vsetky navody z EN, FR fora, a nic....viete niekto poradit? Diki za kazdu radu.

www.inalepky.info

[JAKCRABBIT]

Zdravim,

po upgrade na 1.3.1.1 final sa neda zalozit zakaznicky ucet. Po zadani mena adresy a pod mi vyhodi:

Vyskytla sa 1 chyba :

01. vyskytla sa chyba počas vytvárania vášho účtu

Skusal som uz vsetky navody z EN, FR fora, a nic....viete niekto poradit? Diki za kazdu radu.

www.inalepky.info

Zřejmě chyba v upgradování, ověř si soubory validation, adress, adresses apod...

[romanotulini]

Zmaž tabulky ps_address a ps_customer a daj tam tento SQL príkaz: (teda iba ak máš aj IČO a DIČ rozšírenie, lebo to povodne nešlo)

 

 

CREATE TABLE IF NOT EXISTS `ps_customer` (

`id_customer` int(10) unsigned NOT NULL auto_increment,

`id_gender` int(10) unsigned NOT NULL,

`id_default_group` int(10) unsigned NOT NULL DEFAULT '1',

`secure_key` varchar(32) NOT NULL default '-1',

`company` varchar(45) default NULL,

`IC` varchar(10) default NULL,

`DIC` varchar(15) default NULL,

`email` varchar(128) NOT NULL,

`passwd` varchar(32) NOT NULL,

`last_passwd_gen` timestamp NOT NULL default CURRENT_TIMESTAMP,

`birthday` date default NULL,

`lastname` varchar(32) NOT NULL,

`newsletter` tinyint(1) unsigned NOT NULL default '0',

`ip_registration_newsletter` varchar(15) default NULL,

`newsletter_date_add` datetime default NULL,

`optin` tinyint(1) unsigned NOT NULL default '0',

`firstname` varchar(32) NOT NULL,

`dni` varchar(16) DEFAULT NULL,

`active` tinyint(1) unsigned NOT NULL default '0',

`deleted` tinyint(1) NOT NULL default '0',

`date_add` datetime NOT NULL,

`date_upd` datetime NOT NULL,

PRIMARY KEY (`id_customer`),

UNIQUE KEY `customer_email` (`email`),

KEY `customer_login` (`email`,`passwd`),

KEY `id_customer_passwd` (`id_customer`,`passwd`),

KEY `id_gender` (`id_gender`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `ps_address` (

`id_address` int(10) unsigned NOT NULL auto_increment,

`id_country` int(10) unsigned NOT NULL,

`id_state` int(10) unsigned default NULL,

`IC` varchar(15) default NULL,

`DIC` varchar(15) default NULL,

`email` varchar(128) NOT NULL,

`id_customer` int(10) unsigned NOT NULL default '0',

`id_manufacturer` int(10) unsigned NOT NULL default '0',

`id_supplier` int(10) unsigned NOT NULL default '0',

`alias` varchar(32) NOT NULL,

`company` varchar(32) default NULL,

`lastname` varchar(32) NOT NULL,

`firstname` varchar(32) NOT NULL,

`address1` varchar(128) NOT NULL,

`address2` varchar(128) default NULL,

`postcode` varchar(12) default NULL,

`city` varchar(64) NOT NULL,

`other` text,

`phone` varchar(16) default NULL,

`phone_mobile` varchar(16) default NULL,

`date_add` datetime NOT NULL,

`date_upd` datetime NOT NULL,

`active` tinyint(1) unsigned NOT NULL default '1',

`deleted` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`id_address`),

KEY `address_customer` (`id_customer`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;