Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×

Błąd members

nOt

Przez nOt
w Ogólny support IPS4

 Udostępnij

Rekomendowane odpowiedzi

nOt Współtwórca

nOt

Opublikowano
Opublikowano (edytowane)

Witam,

Przeniosłem bazę użytkowników i wszystko pięknie, można się zalogować.

Krótki kod z core_members przy tworzeniu 

CREATE TABLE `ipb_core_members` (
  `member_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_group_id` smallint(3) NOT NULL DEFAULT '0',
  `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `joined` int(10) NOT NULL DEFAULT '0',

Dodam, że każdy użytkownik loguje się anonimowo z automatu

Natomiast w ACP, gdy kliknę na listę użytkowników wyskakuje: 

SELECT core_members.*, v.vid, v.coppa_user, v.lost_pass, v.forgot_security, v.new_reg, v.email_chg, v.user_verified, v.spam_flag, v.reg_cancelled, core_members.member_id as member_id,field_1 FROM `ipb_core_members` AS `core_members` FORCE INDEX(`joined`)  LEFT JOIN `ipb_core_validating` AS `v` ON v.member_id=core_members.member_id AND v.lost_pass != 1 AND v.forgot_security != 1  LEFT JOIN `ipb_core_pfields_content` AS `p` ON p.member_id=core_members.member_id WHERE email<>'' ORDER BY `joined`  desc LIMIT 0,25
IPS\Db\Exception: Key 'joined' doesn't exist in table 'core_members' (1176)
#0 /system/Db/Select.php(373): IPS\_Db->preparedQuery('/*IPS\\Helpers\\T...', Array, true)
#1 /system/Db/Select.php(436): IPS\Db\_Select->runQuery()
#2 /system/Helpers/Table/Db.php(397): IPS\Db\_Select->rewind()
#3 /system/Helpers/Table/Table.php(489): IPS\Helpers\Table\_Db->getRows(NULL)
#4 /applications/core/modules/admin/members/members.php(505): IPS\Helpers\Table\_Table->__toString()
#5 /system/Dispatcher/Controller.php(96): IPS\core\modules\admin\members\_members->manage()
#6 /system/Dispatcher/Dispatcher.php(152): IPS\Dispatcher\_Controller->execute()
#7 /adm/index.php(14): IPS\_Dispatcher->run()
#8 {main}
Edytowane przez nOt
Odnośnik do komentarza
Udostępnij na innych stronach
nOt Współtwórca

nOt

Opublikowano
  • Autor
Opublikowano
11 godzin temu, Weak. napisał:

Klucz na joined masz dodany? 


CREATE TABLE `ipb_core_members` (
  `member_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_group_id` smallint(3) NOT NULL DEFAULT '0',
  `email` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `joined` int(10) NOT NULL DEFAULT '0',
  `ip_address` varchar(46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `allow_admin_mails` bit(1) DEFAULT b'0',
  `skin` smallint(5) DEFAULT NULL,
  `warn_level` int(10) DEFAULT NULL,
  `warn_lastwarn` int(10) NOT NULL DEFAULT '0',
  `language` mediumint(4) DEFAULT NULL,
  `restrict_post` int(10) NOT NULL DEFAULT '0',
  `bday_day` int(2) DEFAULT NULL,
  `bday_month` int(2) DEFAULT NULL,
  `bday_year` int(4) DEFAULT NULL,
  `msg_count_new` int(2) NOT NULL DEFAULT '0',
  `msg_count_total` int(3) NOT NULL DEFAULT '0',
  `msg_count_reset` int(1) NOT NULL DEFAULT '0',
  `msg_show_notification` int(1) NOT NULL DEFAULT '0',
  `misc` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_visit` int(10) DEFAULT '0',
  `last_activity` int(10) DEFAULT '0',
  `mod_posts` int(10) NOT NULL DEFAULT '0',
  `auto_track` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '0',
  `temp_ban` int(10) DEFAULT '0',
  `mgroup_others` varchar(245) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `member_login_key_expire` int(10) NOT NULL DEFAULT '0',
  `has_blog` text COLLATE utf8mb4_unicode_ci,
  `blogs_recache` tinyint(1) DEFAULT NULL,
  `has_gallery` tinyint(1) NOT NULL DEFAULT '0',
  `members_seo_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `members_cache` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `members_disable_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
  `failed_logins` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `failed_login_count` smallint(3) NOT NULL DEFAULT '0',
  `members_profile_views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `members_pass_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `members_pass_salt` varchar(22) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `members_bitoptions` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `members_day_posts` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0',
  `notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
  `pp_last_visitors` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pp_main_photo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pp_main_width` int(5) DEFAULT NULL,
  `pp_main_height` int(5) DEFAULT NULL,
  `pp_thumb_photo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pp_thumb_width` int(5) DEFAULT NULL,
  `pp_thumb_height` int(5) DEFAULT NULL,
  `pp_setting_count_comments` int(2) DEFAULT NULL,
  `pp_reputation_points` int(10) DEFAULT NULL,
  `pp_photo_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pconversation_filters` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `pp_customization` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `timezone` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pp_cover_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `profilesync` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `profilesync_lastsync` int(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
  `members_bitoptions2` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `create_menu` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT 'Cached contents of the "Create" drop down menu.',
  `marked_site_read` int(10) UNSIGNED DEFAULT '0',
  `pp_cover_offset` int(10) NOT NULL DEFAULT '0',
  `acp_language` mediumint(9) DEFAULT NULL,
  `member_title` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_posts` mediumint(7) NOT NULL DEFAULT '0',
  `member_last_post` int(10) DEFAULT NULL,
  `member_streams` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `photo_last_update` int(10) DEFAULT NULL,
  `mfa_details` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `failed_mfa_attempts` smallint(3) UNSIGNED DEFAULT '0' COMMENT 'Number of times tried and failed MFA',
  `permission_array` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT 'A cache of the clubs and social groups that the member is in',
  `pp_setting_count_visitors` tinyint(1) NOT NULL DEFAULT '0',
  `time_spent` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0,0',
  `idm_block_submissions` tinyint(1) UNSIGNED DEFAULT '0' COMMENT 'Blocked from submitting Downloads files?',
  `failed_security_answers` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
  `completed` bit(1) NOT NULL DEFAULT b'0' COMMENT 'Whether the account is completed or not',
  `steamid` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `donate_donations` smallint(5) DEFAULT '0',
  `donate_amount` decimal(10,2) DEFAULT '0.00',
  `ProfileVideo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MSI_FacebookLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_TwitterLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_GoogleLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_YoutubeLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_WebsiteLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_GitHubLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_SteamLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_InstagramLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_LinkedinLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_SkypeName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_TwitchLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_OdnoklassnikiLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_vKontakteLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_DiscordLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_RedditLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_VineLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_VidmeLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_SnapchatLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_SmashcastLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_MixerLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_PlaystationLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_XboxLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `MSI_OriginLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `shop_points` int(255) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Przy dodawaniu użytkownika wycinki: 

INSERT INTO `ipb_core_members` (`member_id`, `name`, `member_group_id`, `email`, `joined`,

(1, 'nOt ', 4, '[email protected]', 1583164877,

Odnośnik do komentarza
Udostępnij na innych stronach
  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o założenie nowego tematu.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.

intermedia - profesjonalne rozwiązania Invision Power Board

---

Chcesz uzyskać szybko i sprawnie pomoc? Uzupełnij wersję i adres w profilu.

Odnośnik do komentarza
Udostępnij na innych stronach
Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij
Tematy

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.