Причина - какая-то конфликтация при настройке полей, заполняемых покупателем. Решение, позволяющее обнулить эти настройки на работоспособные.
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 15, 2010 at 11:07 AM
-- Server version: 5.1.40
-- PHP Version: 5.2.12
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `gorodki`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_user_info`
--
DROP TABLE IF EXISTS `jos_vm_order_user_info`;
CREATE TABLE IF NOT EXISTS `jos_vm_order_user_info` (
`order_info_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`address_type` char(2) DEFAULT NULL,
`address_type_name` varchar(32) DEFAULT NULL,
`company` varchar(64) DEFAULT NULL,
`title` varchar(32) DEFAULT NULL,
`last_name` varchar(32) DEFAULT NULL,
`first_name` varchar(32) DEFAULT NULL,
`middle_name` varchar(32) DEFAULT NULL,
`phone_1` varchar(32) DEFAULT NULL,
`phone_2` varchar(32) DEFAULT NULL,
`fax` varchar(32) DEFAULT NULL,
`address_1` varchar(64) NOT NULL DEFAULT '',
`address_2` varchar(64) DEFAULT NULL,
`city` varchar(32) NOT NULL DEFAULT '',
`state` varchar(32) NOT NULL DEFAULT '',
`country` varchar(32) NOT NULL DEFAULT 'US',
`zip` varchar(32) NOT NULL DEFAULT '',
`user_email` varchar(255) DEFAULT NULL,
`extra_field_1` varchar(255) DEFAULT NULL,
`extra_field_2` varchar(255) DEFAULT NULL,
`extra_field_3` varchar(255) DEFAULT NULL,
`extra_field_4` char(1) DEFAULT NULL,
`extra_field_5` char(1) DEFAULT NULL,
`bank_account_nr` varchar(32) NOT NULL DEFAULT '',
`bank_name` varchar(32) NOT NULL DEFAULT '',
`bank_sort_code` varchar(16) NOT NULL DEFAULT '',
`bank_iban` varchar(64) NOT NULL DEFAULT '',
`bank_account_holder` varchar(48) NOT NULL DEFAULT '',
`bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL DEFAULT 'Checking',
PRIMARY KEY (`order_info_id`),
KEY `idx_order_info_order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stores the BillTo and ShipTo Information at order time' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_order_user_info`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_userfield`
--
DROP TABLE IF EXISTS `jos_vm_userfield`;
CREATE TABLE IF NOT EXISTS `jos_vm_userfield` (
`fieldid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`type` varchar(50) NOT NULL DEFAULT '',
`maxlength` int(11) DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`required` tinyint(4) DEFAULT '0',
`ordering` int(11) DEFAULT NULL,
`cols` int(11) DEFAULT NULL,
`rows` int(11) DEFAULT NULL,
`value` varchar(50) DEFAULT NULL,
`default` int(11) DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '1',
`registration` tinyint(1) NOT NULL DEFAULT '0',
`shipping` tinyint(1) NOT NULL DEFAULT '0',
`account` tinyint(1) NOT NULL DEFAULT '1',
`readonly` tinyint(1) NOT NULL DEFAULT '0',
`calculated` tinyint(1) NOT NULL DEFAULT '0',
`sys` tinyint(4) NOT NULL DEFAULT '0',
`vendor_id` int(11) DEFAULT NULL,
`params` mediumtext,
PRIMARY KEY (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds the fields for the user information' AUTO_INCREMENT=36 ;
--
-- Dumping data for table `jos_vm_userfield`
--
INSERT INTO `jos_vm_userfield` (`fieldid`, `name`, `title`, `description`, `type`, `maxlength`, `size`, `required`, `ordering`, `cols`, `rows`, `value`, `default`, `published`, `registration`, `shipping`, `account`, `readonly`, `calculated`, `sys`, `vendor_id`, `params`) VALUES
(1, 'email', 'REGISTER_EMAIL', '', 'emailaddress', 100, 30, 1, 2, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(7, 'title', 'PHPSHOP_SHOPPER_FORM_TITLE', '', 'select', 0, 0, 0, 8, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(3, 'password', 'PHPSHOP_SHOPPER_FORM_PASSWORD_1', '', 'password', 25, 30, 1, 4, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(4, 'password2', 'PHPSHOP_SHOPPER_FORM_PASSWORD_2', '', 'password', 25, 30, 1, 5, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(6, 'company', 'PHPSHOP_SHOPPER_FORM_COMPANY_NAME', '', 'text', 64, 30, 0, 7, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(5, 'delimiter_billto', 'PHPSHOP_USER_FORM_BILLTO_LBL', '', 'delimiter', 25, 30, 0, 6, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 0, 1, NULL),
(2, 'username', 'REGISTER_UNAME', '', 'text', 25, 30, 1, 3, 0, 0, '', 0, 1, 1, 0, 1, 0, 0, 1, 1, ''),
(35, 'address_type_name', 'PHPSHOP_USER_FORM_ADDRESS_LABEL', '', 'text', 32, 30, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 0, 0, 1, 1, NULL),
(8, 'first_name', 'PHPSHOP_SHOPPER_FORM_FIRST_NAME', '', 'text', 32, 30, 1, 9, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(9, 'last_name', 'PHPSHOP_SHOPPER_FORM_LAST_NAME', '', 'text', 32, 30, 1, 10, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(10, 'middle_name', 'PHPSHOP_SHOPPER_FORM_MIDDLE_NAME', '', 'text', 32, 30, 0, 11, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(11, 'address_1', 'PHPSHOP_SHOPPER_FORM_ADDRESS_1', '', 'text', 64, 30, 1, 12, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(12, 'address_2', 'PHPSHOP_SHOPPER_FORM_ADDRESS_2', '', 'text', 64, 30, 0, 13, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(13, 'city', 'PHPSHOP_SHOPPER_FORM_CITY', '', 'text', 32, 30, 1, 14, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(14, 'zip', 'PHPSHOP_SHOPPER_FORM_ZIP', '', 'text', 32, 30, 1, 15, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(15, 'country', 'PHPSHOP_SHOPPER_FORM_COUNTRY', '', 'select', 0, 0, 1, 16, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(16, 'state', 'PHPSHOP_SHOPPER_FORM_STATE', '', 'select', 0, 0, 1, 17, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(17, 'phone_1', 'PHPSHOP_SHOPPER_FORM_PHONE', '', 'text', 32, 30, 1, 18, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(18, 'phone_2', 'PHPSHOP_SHOPPER_FORM_PHONE2', '', 'text', 32, 30, 0, 19, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(19, 'fax', 'PHPSHOP_SHOPPER_FORM_FAX', '', 'text', 32, 30, 0, 20, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(20, 'delimiter_bankaccount', 'PHPSHOP_ACCOUNT_BANK_TITLE', '', 'delimiter', 25, 30, 0, 21, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 0, 1, NULL),
(21, 'bank_account_holder', 'PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_HOLDER', '', 'text', 48, 30, 0, 22, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(22, 'bank_account_nr', 'PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_NR', '', 'text', 32, 30, 0, 23, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(23, 'bank_sort_code', 'PHPSHOP_ACCOUNT_LBL_BANK_SORT_CODE', '', 'text', 16, 30, 0, 24, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(24, 'bank_name', 'PHPSHOP_ACCOUNT_LBL_BANK_NAME', '', 'text', 32, 30, 0, 25, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(25, 'bank_account_type', 'PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE', '', 'select', 0, 0, 0, 26, 0, 0, '', 0, 1, 0, 0, 1, 1, 0, 1, 1, ''),
(26, 'bank_iban', 'PHPSHOP_ACCOUNT_LBL_BANK_IBAN', '', 'text', 64, 30, 0, 27, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(27, 'delimiter_sendregistration', 'BUTTON_SEND_REG', '', 'delimiter', 25, 30, 0, 28, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, 0, 0, 1, NULL),
(28, 'agreed', 'PHPSHOP_I_AGREE_TO_TOS', '', 'checkbox', NULL, NULL, 1, 29, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, 0, 1, 1, NULL),
(29, 'delimiter_userinfo', 'PHPSHOP_ORDER_PRINT_CUST_INFO_LBL', '', 'delimiter', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 0, 1, NULL),
(30, 'extra_field_1', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_1', '', 'text', 255, 30, 0, 31, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(31, 'extra_field_2', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_2', '', 'text', 255, 30, 0, 32, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(32, 'extra_field_3', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_3', '', 'text', 255, 30, 0, 33, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(33, 'extra_field_4', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_4', '', 'select', 1, 1, 0, 34, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(34, 'extra_field_5', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_5', '', 'select', 1, 1, 0, 35, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_user_info`
--
DROP TABLE IF EXISTS `jos_vm_user_info`;
CREATE TABLE IF NOT EXISTS `jos_vm_user_info` (
`user_info_id` varchar(32) NOT NULL DEFAULT '',
`user_id` int(11) NOT NULL DEFAULT '0',
`address_type` char(2) DEFAULT NULL,
`address_type_name` varchar(32) DEFAULT NULL,
`company` varchar(64) DEFAULT NULL,
`title` varchar(32) DEFAULT NULL,
`last_name` varchar(32) DEFAULT NULL,
`first_name` varchar(32) DEFAULT NULL,
`middle_name` varchar(32) DEFAULT NULL,
`phone_1` varchar(32) DEFAULT NULL,
`phone_2` varchar(32) DEFAULT NULL,
`fax` varchar(32) DEFAULT NULL,
`address_1` varchar(64) NOT NULL DEFAULT '',
`address_2` varchar(64) DEFAULT NULL,
`city` varchar(32) NOT NULL DEFAULT '',
`state` varchar(32) NOT NULL DEFAULT '',
`country` varchar(32) NOT NULL DEFAULT 'US',
`zip` varchar(32) NOT NULL DEFAULT '',
`user_email` varchar(255) DEFAULT NULL,
`extra_field_1` varchar(255) DEFAULT NULL,
`extra_field_2` varchar(255) DEFAULT NULL,
`extra_field_3` varchar(255) DEFAULT NULL,
`extra_field_4` char(1) DEFAULT NULL,
`extra_field_5` char(1) DEFAULT NULL,
`cdate` int(11) DEFAULT NULL,
`mdate` int(11) DEFAULT NULL,
`perms` varchar(40) NOT NULL DEFAULT 'shopper',
`bank_account_nr` varchar(32) NOT NULL DEFAULT '',
`bank_name` varchar(32) NOT NULL DEFAULT '',
`bank_sort_code` varchar(16) NOT NULL DEFAULT '',
`bank_iban` varchar(64) NOT NULL DEFAULT '',
`bank_account_holder` varchar(48) NOT NULL DEFAULT '',
`bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL DEFAULT 'Checking',
PRIMARY KEY (`user_info_id`),
KEY `idx_user_info_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Customer Information, BT = BillTo and ST = ShipTo';
--
-- Dumping data for table `jos_vm_user_info`
--
INSERT INTO `jos_vm_user_info` (`user_info_id`, `user_id`, `address_type`, `address_type_name`, `company`, `title`, `last_name`, `first_name`, `middle_name`, `phone_1`, `phone_2`, `fax`, `address_1`, `address_2`, `city`, `state`, `country`, `zip`, `user_email`, `extra_field_1`, `extra_field_2`, `extra_field_3`, `extra_field_4`, `extra_field_5`, `cdate`, `mdate`, `perms`, `bank_account_nr`, `bank_name`, `bank_sort_code`, `bank_iban`, `bank_account_holder`, `bank_account_type`) VALUES
('bfe985ac5324802110a860d436f6ae5d', 62, 'BT', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '', 'US', '', 'antfrolov@mail.ru', NULL, NULL, NULL, NULL, NULL, 1277913989, 1277892488, 'shopper', '', '', '', '', '', 'Checking');
22.08.2020, 08:44:29