Customer or customer group specific items
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 8
- Joined: 17 Aug 2018, 09:18
Re: Customer or customer group specific items
nos3 wrote:Regarding the infinitive loop, can you post a dump of your users, users_list and mshop_customer_group tables (structure and data) nevertheless? Because we are unable to reproduce the problem.
Code: Select all
# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.6.38)
# Database: ceod
# Generation Time: 2018-09-05 14:12:03 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table mshop_customer_group
# ------------------------------------------------------------
DROP TABLE IF EXISTS `mshop_customer_group`;
CREATE TABLE `mshop_customer_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`siteid` int(11) DEFAULT NULL,
`code` varchar(32) CHARACTER SET utf8 NOT NULL,
`label` varchar(255) CHARACTER SET utf8 NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unq_mscusgr_sid_code` (`siteid`,`code`),
KEY `idx_mscusgr_sid_label` (`siteid`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `mshop_customer_group` WRITE;
/*!40000 ALTER TABLE `mshop_customer_group` DISABLE KEYS */;
INSERT INTO `mshop_customer_group` (`id`, `siteid`, `code`, `label`, `mtime`, `ctime`, `editor`)
VALUES
(1,1,'admin','Administrator','2018-06-25 04:34:39','2018-06-25 04:34:39','core:setup'),
(2,1,'customer','Customer','2018-08-16 12:40:38','2018-06-25 04:34:39','ivancik@studiotem.com');
/*!40000 ALTER TABLE `mshop_customer_group` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 DEFAULT '',
`email` varchar(255) CHARACTER SET utf8 DEFAULT '',
`password` varchar(255) CHARACTER SET utf8 DEFAULT '',
`remember_token` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`superuser` smallint(6) DEFAULT '0',
`siteid` int(11) DEFAULT NULL,
`label` varchar(255) CHARACTER SET utf8 DEFAULT '',
`salutation` varchar(8) CHARACTER SET utf8 DEFAULT '',
`company` varchar(100) CHARACTER SET utf8 DEFAULT '',
`coc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`vatid` varchar(32) CHARACTER SET utf8 DEFAULT '',
`taxid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`title` varchar(64) CHARACTER SET utf8 DEFAULT '',
`firstname` varchar(64) CHARACTER SET utf8 DEFAULT '',
`lastname` varchar(64) CHARACTER SET utf8 DEFAULT '',
`address1` varchar(200) CHARACTER SET utf8 DEFAULT '',
`address2` varchar(200) CHARACTER SET utf8 DEFAULT '',
`address3` varchar(200) CHARACTER SET utf8 DEFAULT '',
`postal` varchar(16) CHARACTER SET utf8 DEFAULT '',
`city` varchar(200) CHARACTER SET utf8 DEFAULT '',
`state` varchar(200) CHARACTER SET utf8 DEFAULT '',
`langid` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
`countryid` char(2) CHARACTER SET utf8 DEFAULT NULL,
`telephone` varchar(32) CHARACTER SET utf8 DEFAULT '',
`telefax` varchar(32) CHARACTER SET utf8 DEFAULT '',
`website` varchar(255) CHARACTER SET utf8 DEFAULT '',
`longitude` decimal(8,6) DEFAULT NULL,
`latitude` decimal(8,6) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`vdate` date DEFAULT NULL,
`status` smallint(6) NOT NULL DEFAULT '1',
`editor` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
`pcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
KEY `idx_lvusr_langid` (`langid`),
KEY `idx_lvusr_last_first` (`lastname`,`firstname`),
KEY `idx_lvusr_post_addr1` (`postal`,`address1`),
KEY `idx_lvusr_post_city` (`postal`,`city`),
KEY `idx_lvusr_lastname` (`lastname`),
KEY `idx_lvusr_address1` (`address1`),
KEY `idx_lvusr_city` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `superuser`, `siteid`, `label`, `salutation`, `company`, `coc`, `vatid`, `taxid`, `title`, `firstname`, `lastname`, `address1`, `address2`, `address3`, `postal`, `city`, `state`, `langid`, `countryid`, `telephone`, `telefax`, `website`, `longitude`, `latitude`, `birthday`, `vdate`, `status`, `editor`, `pcode`)
VALUES
(3267,'ivancik@studiotem.com','ivancik@studiotem.com','$2y$10$q3/IJECE4xcuSz.Fb94lFevsB8BYubZbwjlGBWRM9fyCoKe40Op76','UTYz1WgZyS3ZhvXObgaTolscaFeZSQSCgVGOX9cUsON95U4VLvbTuc3uyOvD',NULL,'0000-00-00 00:00:00',1,1,' test','mr','','','','','','test','test','test','','','94912','test','','sk','SK','','','',NULL,NULL,NULL,NULL,1,'ivancik@studiotem.com','');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table users_list
# ------------------------------------------------------------
DROP TABLE IF EXISTS `users_list`;
CREATE TABLE `users_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeid` int(11) NOT NULL,
`parentid` int(11) NOT NULL,
`siteid` int(11) NOT NULL,
`domain` varchar(32) CHARACTER SET utf8 NOT NULL,
`refid` varchar(32) CHARACTER SET utf8 NOT NULL,
`start` datetime DEFAULT NULL,
`end` datetime DEFAULT NULL,
`config` text CHARACTER SET utf8 NOT NULL,
`pos` int(11) NOT NULL,
`status` smallint(6) NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unq_lvuli_sid_dm_rid_tid_pid` (`siteid`,`domain`,`refid`,`typeid`,`parentid`),
KEY `idx_lvuli_sid_stat_start_end` (`siteid`,`status`,`start`,`end`),
KEY `idx_lvuli_pid_sid_rid_dom_tid` (`parentid`,`siteid`,`refid`,`domain`,`typeid`),
KEY `idx_lvuli_pid_sid_start` (`parentid`,`siteid`,`start`),
KEY `idx_lvuli_pid_sid_end` (`parentid`,`siteid`,`end`),
KEY `idx_lvuli_pid_sid_pos` (`parentid`,`siteid`,`pos`),
KEY `IDX_8B41B616E70B032` (`typeid`),
KEY `IDX_8B41B616856A684C` (`parentid`),
CONSTRAINT `fk_lvuli_pid` FOREIGN KEY (`parentid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `fk_lvuli_typeid` FOREIGN KEY (`typeid`) REFERENCES `users_list_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;