aktualizacja tabeli ,,, duże forum, problemy
: 12 stycznia 2007, 17:31
witam.
Moje forum jest b. duże. Ma 11 tys. userów. Przy odinstalowaniu darobb v.2.1 pojawil mi sie problem:
[piszę tylko błędy bo pare succes było]:
co mam zrobić w phpmyadminie abym mogl te tabele usunac, wgrac itp co tam pisze. Bardzo prosze o pomoc.
Moje forum jest b. duże. Ma 11 tys. userów. Przy odinstalowaniu darobb v.2.1 pojawil mi sie problem:
[piszę tylko błędy bo pare succes było]:
Kod: Zaznacz cały
ALTER TABLE phpbb_users CHANGE user_field_1 user_icq VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_1' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_2 user_website VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_2' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_3 user_from VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_3' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_4 user_aim VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_4' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_5 user_yim VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_5' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_6 user_msnm VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_6' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_7 user_occ VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_7' in 'phpbb_users'
ALTER TABLE phpbb_users CHANGE user_field_8 user_interests VARCHAR( 255 ) DEFAULT NULL
+++ Błąd: Unknown column 'user_field_8' in 'phpbb_users'
ALTER TABLE phpbb_posts DROP raport
+++ Błąd: Can't DROP 'raport'; check that column/key exists
ALTER TABLE phpbb_users DROP raports
+++ Błąd: Can't DROP 'raports'; check that column/key exists
ALTER TABLE phpbb_forums DROP raport_on
+++ Błąd: Can't DROP 'raport_on'; check that column/key exists
DELETE FROM phpbb_config WHERE config_name = 'raport_email'
+++ Sukces
ALTER TABLE phpbb_posts_text DROP mods_notice
+++ Błąd: Can't DROP 'mods_notice'; check that column/key exists
ALTER TABLE phpbb_posts DROP notice
+++ Błąd: Can't DROP 'notice'; check that column/key exists
DROP TABLE phpbb_raports
+++ Błąd: Unknown table 'phpbb_raports'
DROP TABLE phpbb_note
+++ Błąd: Unknown table 'phpbb_note'
DROP TABLE phpbb_jr_admin_users
+++ Błąd: Unknown table 'phpbb_jr_admin_users'
DROP TABLE phpbb_attachments_config
+++ Błąd: Unknown table 'phpbb_attachments_config'
DROP TABLE phpbb_forbidden_extensions
+++ Błąd: Unknown table 'phpbb_forbidden_extensions'
DROP TABLE phpbb_extension_groups
+++ Błąd: Unknown table 'phpbb_extension_groups'
DROP TABLE phpbb_extensions
+++ Błąd: Unknown table 'phpbb_extensions'
DROP TABLE phpbb_attachments_desc
+++ Błąd: Unknown table 'phpbb_attachments_desc'
DROP TABLE phpbb_attachments
+++ Błąd: Unknown table 'phpbb_attachments'
DROP TABLE phpbb_quota_limits
+++ Błąd: Unknown table 'phpbb_quota_limits'
DROP TABLE phpbb_attach_quota
+++ Błąd: Unknown table 'phpbb_attach_quota'
ALTER TABLE phpbb_forums DROP auth_download
+++ Błąd: Can't DROP 'auth_download'; check that column/key exists
ALTER TABLE phpbb_auth_access DROP auth_download
+++ Błąd: Can't DROP 'auth_download'; check that column/key exists
ALTER TABLE phpbb_posts DROP post_attachment
+++ Błąd: Can't DROP 'post_attachment'; check that column/key exists
ALTER TABLE phpbb_topics DROP topic_attachment
+++ Błąd: Can't DROP 'topic_attachment'; check that column/key exists
ALTER TABLE phpbb_privmsgs DROP privmsgs_attachment
+++ Błąd: Can't DROP 'privmsgs_attachment'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_color
+++ Błąd: Can't DROP 'rank_color'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_bold
+++ Błąd: Can't DROP 'rank_bold'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_prefix
+++ Błąd: Can't DROP 'rank_prefix'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_style
+++ Błąd: Can't DROP 'rank_style'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_list
+++ Błąd: Can't DROP 'rank_list'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_order
+++ Błąd: Can't DROP 'rank_order'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_onlygfx
+++ Błąd: Can't DROP 'rank_onlygfx'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_titlelist
+++ Błąd: Can't DROP 'rank_titlelist'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_female
+++ Błąd: Can't DROP 'rank_female'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_ignore_nick
+++ Błąd: Can't DROP 'rank_ignore_nick'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_ignore_rank
+++ Błąd: Can't DROP 'rank_ignore_rank'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_show_ekipa
+++ Błąd: Can't DROP 'rank_show_ekipa'; check that column/key exists
ALTER TABLE phpbb_ranks DROP rank_group_ekipa
+++ Błąd: Can't DROP 'rank_group_ekipa'; check that column/key exists
ALTER TABLE phpbb_users DROP user_urank
+++ Błąd: Can't DROP 'user_urank'; check that column/key exists
ALTER TABLE phpbb_groups DROP group_rank
+++ Błąd: Can't DROP 'group_rank'; check that column/key exists
ALTER TABLE phpbb_groups DROP group_rank_mod
+++ Błąd: Can't DROP 'group_rank_mod'; check that column/key exists
ALTER TABLE phpbb_groups DROP group_rank_user
+++ Błąd: Can't DROP 'group_rank_user'; check that column/key exists
ALTER TABLE phpbb_users DROP user_plusp
+++ Błąd: Can't DROP 'user_plusp'; check that column/key exists
ALTER TABLE phpbb_users DROP user_minusp
+++ Błąd: Can't DROP 'user_minusp'; check that column/key exists
ALTER TABLE phpbb_users DROP user_disallowed_write
+++ Błąd: Can't DROP 'user_disallowed_write'; check that column/key exists
ALTER TABLE phpbb_posts DROP post_plusp
+++ Błąd: Can't DROP 'post_plusp'; check that column/key exists
ALTER TABLE phpbb_posts DROP post_minusp
+++ Błąd: Can't DROP 'post_minusp'; check that column/key exists
DROP TABLE phpbb_plusminus
+++ Błąd: Unknown table 'phpbb_plusminus'
ALTER TABLE phpbb_groups DROP auth_disallow_write
+++ Błąd: Can't DROP 'auth_disallow_write'; check that column/key exists
ALTER TABLE phpbb_groups DROP auth_ban
+++ Błąd: Can't DROP 'auth_ban'; check that column/key exists
ALTER TABLE phpbb_groups DROP auth_remove_points
+++ Błąd: Can't DROP 'auth_remove_points'; check that column/key exists
ALTER TABLE phpbb_forums DROP enable_pluspoints
+++ Błąd: Can't DROP 'enable_pluspoints'; check that column/key exists
ALTER TABLE phpbb_forums DROP enable_minuspoints
+++ Błąd: Can't DROP 'enable_minuspoints'; check that column/key exists
ALTER TABLE phpbb_users DROP user_sex
+++ Błąd: Can't DROP 'user_sex'; check that column/key exists
DROP TABLE phpbb_rules
+++ Błąd: Unknown table 'phpbb_rules'
ALTER TABLE phpbb_users DROP user_view_rules
+++ Błąd: Can't DROP 'user_view_rules'; check that column/key exists
ALTER TABLE phpbb_forums DROP forum_parent
+++ Błąd: Can't DROP 'forum_parent'; check that column/key exists
ALTER TABLE phpbb_users DROP hide_quick_reply
+++ Błąd: Can't DROP 'hide_quick_reply'; check that column/key exists
DROP TABLE phpbb_shoutbox
+++ Błąd: Unknown table 'phpbb_shoutbox'
DROP TABLE phpbb_shoutbox_config
+++ Błąd: Unknown table 'phpbb_shoutbox_config'
DROP TABLE phpbb_backup
+++ Błąd: Unknown table 'phpbb_backup'
DROP TABLE phpbb_cms
+++ Błąd: Unknown table 'phpbb_cms'
ALTER TABLE phpbb_topics DROP topic_tag
+++ Błąd: Can't DROP 'topic_tag'; check that column/key exists
ALTER TABLE phpbb_forums DROP forum_tags_list
+++ Błąd: Can't DROP 'forum_tags_list'; check that column/key exists
ALTER TABLE phpbb_forums DROP forum_require_tag
+++ Błąd: Can't DROP 'forum_require_tag'; check that column/key exists