sqmany

Witam, mam problem z polskimi znakami ,przed chwilą zmieniłem kodowanie wszystkich tabel na utf8 a potem przebudowałem tematy i posty ale to nie pomogło. Help Me.

Dzięki, pomogło a jeżeli ktoś będzie chciał kiedyś przeprowadzać tą operację to proszę o to całe zapytanie, niektóre linijki mogą być wam nie potrzebne bo ja mam dodatkowe od modyfikacji i nie tylko, ale to chyba nie problem usunąć te kilka: ALTER TABLE `admin_login_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `admin_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `admin_permission_rows` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `announcements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `api_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `api_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `attachments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `attachments_type` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_queue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_vars` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `badwords` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `banfilters` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `bbcode_mediatag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `bulk_mail` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `cache_simple` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `cache_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `captcha` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `content_cache_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `content_cache_sigs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_applications` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_restore` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_rules` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_editor_autosave` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_geolocation_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_hooks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_hooks_files` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_incoming_emails` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_incoming_email_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_inline_messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_item_markers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_item_markers_storage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_like` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_like_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_rss_imported` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_share_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_share_links_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_soft_delete_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_bookmarks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_conf_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_cp_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_lang` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_lang_words` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_login` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_module` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_settings_titles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags_perms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_uagents` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_uagent_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `custom_bbcode` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `custom_sidebar_blocks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `dnames_change` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_currency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_demote` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_gateways` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_goals` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_rewards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `dp3_fi_icons` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `duplicates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `emoticons` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `error_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `exclusions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `faq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums_archive_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums_recent_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forum_perms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `fusion_menus` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `ignored_users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `inactivemembers_excludedmembers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `inline_notifications` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_auto_awards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_awarded` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_cats` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `login_methods` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mail_error_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mail_queue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_partial` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_reasons` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_replies` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_updates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_topic_user_map` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_app_style` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_device_map` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_notifications` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `moderators` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `moderator_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mod_queued_items` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `permission_index` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_content` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_data` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_topic_user_map` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `polls` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `posts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_friends` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_friends_flood` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_portal` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_portal_views` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_ratings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu_bugs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `question_and_answer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_classes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_modpref` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_reports` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_reports_index` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_status` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_status_sev` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_index` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_levels` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_totals` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_export` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_import` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_imported` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_keywords` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_visitors` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `seo_acronyms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `seo_meta` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `shoutbox_mods` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `shoutbox_shouts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_collections` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_css` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_css_previous` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_generator_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_merge_changes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_merge_session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_replacements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates_cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates_previous` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_url_mapping` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `spam_service_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `spider_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `tags_index` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `task_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `task_manager` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `template_sandr` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `titles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topics` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_mmod` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_ratings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_views` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `twitter_connect` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `upgrade_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `upgrade_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `validating` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_cat` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_comments` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_favorites` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_rate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_thumbnail_sites` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `voters` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `warn_logs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `admin_login_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `admin_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `admin_permission_rows` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `announcements` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `api_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `api_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `attachments` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `attachments_type` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_queue` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `backup_vars` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `badwords` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `banfilters` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `bbcode_mediatag` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `bulk_mail` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `cache_simple` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `cache_store` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `captcha` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `content_cache_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `content_cache_sigs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_applications` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_restore` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_archive_rules` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_editor_autosave` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_geolocation_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_hooks` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_hooks_files` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_incoming_emails` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_incoming_email_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_inline_messages` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_item_markers` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_item_markers_storage` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_like` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_like_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_rss_imported` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_share_links` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_share_links_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_soft_delete_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_bookmarks` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_conf_settings` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_cp_sessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_lang` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_lang_words` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_login` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_module` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_sys_settings_titles` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_tags_perms` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_uagents` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `core_uagent_groups` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `custom_bbcode` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `custom_sidebar_blocks` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `dnames_change` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_currency` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_demote` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_gateways` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_goals` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_rewards` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `donate_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `dp3_fi_icons` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `duplicates` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `emoticons` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `error_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `exclusions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `faq` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums_archive_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forums_recent_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `forum_perms` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `fusion_menus` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `groups` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `ignored_users` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `inactivemembers_excludedmembers` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `inline_notifications` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_auto_awards` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_awarded` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `jlogica_awards_cats` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `login_methods` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mail_error_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mail_queue` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_partial` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_actions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `members_warn_reasons` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_actions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_replies` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `member_status_updates` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_topics` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `message_topic_user_map` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_app_style` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_device_map` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mobile_notifications` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `moderators` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `moderator_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `mod_queued_items` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `permission_index` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_content` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_data` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pfields_groups` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_topics` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `pmviewer_message_topic_user_map` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `polls` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `posts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_friends` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_friends_flood` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_portal` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_portal_views` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `profile_ratings` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu_bugs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `promenu_groups` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `question_and_answer` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_classes` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_modpref` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_reports` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_reports_index` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_status` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rc_status_sev` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_index` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_levels` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `reputation_totals` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_export` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_import` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `rss_imported` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_keywords` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_sessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `search_visitors` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `seo_acronyms` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `seo_meta` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `sessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `shoutbox_mods` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `shoutbox_shouts` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_collections` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_css` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_css_previous` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_generator_sessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_merge_changes` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_merge_session` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_replacements` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates_cache` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_templates_previous` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `skin_url_mapping` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `spam_service_log` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `spider_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `tags_index` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `task_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `task_manager` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `template_sandr` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `titles` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topics` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topics_włam` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_mmod` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_ratings` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `topic_views` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `twitter_connect` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `upgrade_history` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `upgrade_sessions` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `validating` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_cat` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_comments` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_favorites` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_rate` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `videos_thumbnail_sites` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `voters` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci; ALTER TABLE `warn_logs` DEFAULT CHARACTER SET utf8 COLLATE utf8_polish_ci;

@UP To dużo roboty ale spróbuję.A może znacie jakieś konkretne zapytanie na zmienienie kodowania wszystkich tabel?

Te wasze ironiczne odpowiedzi.

Witam. Moje pytanie jest podane w tytule tematu.

Dziękuję za pomoc, temat można zamknąć

Witam, wczoraj zaktualizowałem forum na wersje 3.4.0 ale dziś się okazało że nie da się wejść w temat ani dział bo wyskakuje Driver Error O to log błędu: ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Thu, 29 Nov 2012 14:13:12 +0000 Error: 1267 - Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '=' IP Address: XX.XXX.XXX.XX - /index.php?/topic/180-dlswitchbot-by-padmak-v3006/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=180 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | ips_kernel/classDb.php | [ipsBackup_db].query | 1125 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [app_class_forums].__construct | 1377 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Proszę o szybką pomoc, za którą z góry dziękuję.

Witam, napotkał mnie pewien problem po z aktualizowaniu forum, kiedy zalogowałem się to wyskoczył mi taki błąd Warning: require_once(/home/platne/sqmany/public_html/admin/applications_addon/other/forumicons/sources/classes/library.php): failed to open stream: Nie ma takiego pliku ani katalogu in /home/platne/sqmany/public_html/admin/sources/base/core.php on line 1142 Fatal error: require_once(): Failed opening required '/home/platne/sqmany/public_html/admin/applications_addon/other/forumicons/sources/classes/library.php' (include_path='.:/usr/share/php:/usr/share/pear:/home/platne/sqmany/public_html/ips_kernel/') in /home/platne/sqmany/public_html/admin/sources/base/core.php on line 1142

@DawPi Niestety nie pomogło

Witam, mam pytanie, czy jest jakaś modyfikacja blokująca odnośniki dla gości, potrzebne mi to bo mam zainstalowaną modyfikację (Pav32) Retrieve Link Titles 1.1.1.Wcześniej wystarczała tylko modyfikacja (Bim) Ukrywanie linków oraz code ,ale ona nie blokuje odnośników.

Nie rozumiem definicji pewnie, czy to taka? pewnie adverb pewnie [pɛvɲɛ] 1 bez wahania, zdecydowanie pewnie prowadzić samochód 2 prawdopodobnie, pewno Pewnie zadzwoni do mnie jutro. 3 oczywiście czuć się pewnie być pewnym siebie Czuł się pewnie. (No) pewnie! (no) oczywiście Przyjdziesz w piątek? - No pewnie!

Beta 2? To była już Beta 1?

Dzięki, temat do zamknięcia.

Witam, mam problem ze skinem a dokładniej to ,przed chwilą podmieniałem obrazki i nie które mi się nie zmieniły. Kiedy sprawdzałem źródło obrazku to wyświetlił mi się taki link: i2.wp.com/awesome-games.pl/public/style_images/awesome/profile/default_large.png zamiast takiego: awesome-games.pl/public/style_images/awesome/profile/default_large.png Pomożecie?

Aha, rozumiem, a jaki jest na to kod? @Edit Albo pobawię się sam z tym kodem, jak będę miał jakieś z tym problemy to napisze new topic Temat do zamknięcia.

No to spójrz na forum GramyTu.pl i tam w tematach jest bot GramyTu.pl który pisze w każdym temacie.

Ja wolałbym aby to pisał jakiś bot a nie że by reklama wyświetliła się między postami. GramyTu.pl zrobili tak bez modyfikacji Adverts in Topic

Witam ,mam pytanie czy jest możliwość dodania automatycznych reklam w temacie, chodzi mi o takie reklamy jak są w (DP33)Adverts in topic?

Tak, działa tylko nie których rzeczy po prostu nie zmieniaj. Ps.Miesiąc temu jeszcze z tego poradniku korzystałem.

Tu masz poradnik http://forum.invisionize.pl/topic/26-polskie-daty-oraz-czas-w-ipb/

Tylko w shoutboxie mas angielskie daty?

Udało mi się usunąć, temat do zamknięcia.

Jakoś nie mogę znaleźć tego pliku tam.

Witam ,mam pytanie jak usunąć zakładkę status z profilu ?

Temat do zamknięcia