Jump to content

Проблемка с БД


Recommended Posts

Не могу не как загрузить со старого бд форума файлы на новый форум вот ошибка заливки файла "members" :

SQL-запрос:

INSERT INTO members( member_id, name, member_group_id, email, joined, ip_address, posts, title, allow_admin_mails, time_offset, skin, warn_level, warn_lastwarn, language, last_post, restrict_post, view_sigs, view_img, bday_day, bday_month, bday_year, msg_count_new, msg_count_total, msg_count_reset, msg_show_notification, misc, last_visit, last_activity, dst_in_use, coppa_user, mod_posts, auto_track, temp_ban, sub_end, login_anonymous, ignored_users, mgroup_others, org_perm_id, member_login_key, member_login_key_expire, subs_pkg_chosen, has_blog, has_gallery, members_editor_choice, members_auto_dst, members_display_name, members_seo_name, members_created_remote, members_cache, members_disable_pm, members_l_display_name, members_l_username, failed_logins, failed_login_count, members_profile_views, members_pass_hash, members_pass_salt, identity_url, member_banned, member_uploader, members_bitoptions, fb_uid, fb_emailhash, fb_lastsync, members_day_posts, live_id, twitter_id, twitter_token, twitter_secret, notification_cnt, tc_lastsync, fb_session, fb_token, vk_uid, ips_mobile_token, vk_token, gallery_perms )

VALUES (

'1', 'Zarate', '4', '[email protected]', '1273139375', '10.0.244.239', '535', 'Смотрящий', '0', '3', '1', '0', '0', '1', '1327040813', '', '1', '1', '14', '9', '1988', '0', '0', '0', '0', NULL , '1337843815', '1337843846', '1', '0', '', '', '0', '0', '0&1', 'a:0:{}', '', ',4,2,5,6,1,3,', 'a3560365f0a82e5dea7a596677f651c5', '1338448646', '0', 'recache', '0', 'rte', '1', 'Zarate', 'zarate', '0', 'a:15:{s:11:"report_temp";a:0:{}s:19:"report_last_updated";i:1326841119;s:10:"report_num";s:1:"0";s:10:"rc_rss_key";s:32:"a40d8ce5622f2f93300a20b83b356cb9";s:7:"friends";a:1:{i:45;s:1:"1";}s:10:"rep_filter";s:1:"*";s:13:"notifications";a:18:{s:13:"report_center";a:1:{s:8:"selected";a:1:{i:0;s:5:"email";}}s:11:"new_comment";a:1:{s:8:"selected";a:1:{i:0;s:5:"email";}}s:9:"new_topic";a:1:{s:8:"selected";a:1:{i:0;s:5:"email";}}s:9:"new_reply";a:1:{s:8:"selected";a:1:{i:0;s:5:"email";}}s:11:"post_quoted";a:1:{s:8:"selected";a:0:{}}s:15:"profile_comment";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:23:"profile_comment_pending";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:14:"friend_request";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:22:"friend_request_pending";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:22:"friend_request_approve";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:19:"new_private_message";a:1:{s:8:"selected";a:2:{i:0;s:5:"email";i:1;s:6:"inline";}}s:21:"reply_private_message";a:1:{s:8:"selected";a:2:{i:0;s:5:"email";i:1;s:6:"inline";}}s:22:"invite_private_message";a:1:{s:8:"selected";a:2:{i:0;s:5:"email";i:1;s:6:"inline";}}s:17:"reply_your_status";a:1:{s:8:"selected";a:0:{}}s:16:"reply_any_status";a:1:{s:8:"selected";a:0:{}}s:20:"friend_status_update";a:1:{s:8:"selected";a:0:{}}s:8:"new_file";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}s:13:"file_approved";a:1:{s:8:"selected";a:1:{i:0;s:2:"pm";}}}s:23:"show_notification_popup";i:0;s:13:"gb_mark__blog";i:1315288867;s:18:"gb_mark__downloads";i:1315288867;s:15:"gb_mark__forums";i:1315288867;s:16:"gb_mark__gallery";i:1315288867;s:15:"gb_mark__videos";i:1315288867;s:13:"msgAlertReset";i:1316765791;s:14:"shoutbox_prefs";s:185:"a:6:{s:15:"shoutbox_height";i:275;s:16:"shoutbox_gheight";i:132;s:14:"global_display";i:1;s:15:"enter_key_shout";i:1;s:21:"enable_quick_commands";i:1;s:22:"display_refresh_button";i:1;}";}', '0', 'zarate', 'zarate', '', '0', '417', '9cb650913624d92ba53583fe9ddcd097', ':CMLP', '', '0', 'default', '0', '0', '', '0', '1,1327040813', NULL , '', '', '', '0', '0', '', NULL , '0', NULL , NULL , '1:1:1'

);

Ответ MySQL:

#1146 - Table 'forum.members' doesn't exist

и не только в этом файле проблема,кто знает как исправить просьба написать

Link to comment
Share on other sites

Удали содержимое новой базы, то есть почисти её полностью, затем импортируй старую базу и не будет никаких косяков!

Link to comment
Share on other sites

Не получилось :

Ошибка

SQL-запрос:

CREATE TABLE admin_permission_rows(

row_id int( 8 ) NOT NULL ,

row_id_type varchar( 13 ) NOT NULL default 'member',

row_perm_cache mediumtext,

row_updated int( 10 ) NOT NULL default '0',

PRIMARY KEY ( row_id, row_id_type )

) ENGINE = MYISAM DEFAULT CHARSET = utf8;

Ответ MySQL:

#1105 - MyISAM table 'admin_permission_rows' is in use (most likely by a MERGE table). Try FLUSH TABLES.

есть еще какие либо варианты?

Link to comment
Share on other sites

Все сделал Спасибо пришлось самому вручную файлы перезаливать со старой базы в новую,Respected,не подскажеш где отключать регистрацию пользователей по емайл?

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...