CREATE TABLE `mp3s` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`artist` varchar(511) COLLATE utf8_unicode_ci NOT NULL,
`aid` int(11) NOT NULL,
`oid` int(11) NOT NULL,
`lid` int(11) NOT NULL,
`song` varchar(511) COLLATE utf8_unicode_ci NOT NULL,
`duration` int(11) NOT NULL,
`show_artist_url` int(11) NOT NULL,
`show_song_url` int(11) NOT NULL,
`url_time` bigint(20) NOT NULL,
`size` int(11) DEFAULT NULL,
`bitrate` int(11) DEFAULT NULL,
`artist_id` int(11) DEFAULT NULL,
`public` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `artist` (`artist`(255),`song`(255)),
KEY `oid` (`oid`,`aid`),
KEY `size` (`size`),
KEY `lid` (`lid`),
KEY `artist_2` (`artist`(255),`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117625329 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
echo "deb http://repo.percona.com/apt xenial main" >> /etc/apt/sources.list
echo "deb-src http://repo.percona.com/apt xenial main" >> /etc/apt/sources.list
CREATE TABLE `finder_humans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`lastname_id` int(11) NOT NULL,
`firstname_id` int(11) NOT NULL,
`nickname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`vk_id` bigint(20) DEFAULT NULL,
`bdate` date DEFAULT NULL,
`info` varchar(1023) COLLATE utf8_unicode_ci DEFAULT NULL,
`photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`country_id` int(11) DEFAULT NULL,
`home_town` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`home_phone` varchar(63) COLLATE utf8_unicode_ci DEFAULT NULL,
`skype` varchar(127) COLLATE utf8_unicode_ci DEFAULT NULL,
`facebook` varchar(127) COLLATE utf8_unicode_ci DEFAULT NULL,
`twitter` varchar(127) COLLATE utf8_unicode_ci DEFAULT NULL,
`livejournal` varchar(127) COLLATE utf8_unicode_ci DEFAULT NULL,
`instagram` varchar(127) COLLATE utf8_unicode_ci DEFAULT NULL,
`occupation_type` enum('work','school','university') COLLATE utf8_unicode_ci DEFAULT NULL,
`occupation_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rate` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `vk_id` (`vk_id`),
KEY `patronymic` (`nickname`),
KEY `birthday` (`bdate`),
KEY `city_id` (`city_id`),
KEY `country_id` (`country_id`),
KEY `firstname_id` (`firstname_id`),
KEY `lastname_id` (`lastname_id`),
KEY `rate` (`rate`),
KEY `lastname_id_2` (`lastname_id`,`firstname_id`,`rate`)
) ENGINE=InnoDB AUTO_INCREMENT=134257090 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
define('VK_ID', ID_пользователя_в_виде_числа)
использовал self::$vk_id
. Как оказалось, self::$vk_id должна быть именно intager, у меня же была строка self::$vk_id = $user->vk_id; из-за которой все не работало, заработало после того, как исправил на self::$vk_id = (int)$user->vk_id;