Valadi

Już wcześniej pojawiał mi się ten błąd więc zacząłem się bawić bazą danych, zmieniałem na utf8 itd. Ale w każdym razie to tu tkwi przyczyna tak ? Muszę tak doprowadzić bazę aby był wszędzie ten sam język ?

members_extra: CREATE TABLE `ibf_member_extra` ( `id` mediumint(8) NOT NULL default '0', `notes` text character set latin2, `links` text character set latin2, `bio` text character set latin2, `ta_size` char(3) character set latin2 default NULL, `photo_type` varchar(10) character set latin2 default '', `photo_location` varchar(255) character set latin2 default '', `photo_dimensions` varchar(200) character set latin2 default '', `aim_name` varchar(40) character set latin2 NOT NULL default '', `icq_number` int(15) NOT NULL default '0', `website` varchar(250) character set latin2 NOT NULL default '', `yahoo` varchar(40) character set latin2 NOT NULL default '', `interests` text character set latin2, `msnname` varchar(200) character set latin2 NOT NULL default '', `vdirs` text character set latin2, `location` varchar(250) character set latin2 NOT NULL default '', `signature` text character set latin2, `avatar_location` varchar(255) character set latin2 NOT NULL default '', `avatar_size` varchar(9) character set latin2 NOT NULL default '', `avatar_type` varchar(15) character set latin2 NOT NULL default 'local', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_polish_ci PACK_KEYS=1 CHECKSUM=1 DELAY_KEY_WRITE=1 ibf_members: CREATE TABLE `ibf_members` ( `id` mediumint(8) NOT NULL default '0', `name` varchar(255) character set latin2 NOT NULL default '', `mgroup` smallint(3) NOT NULL default '0', `email` varchar(150) character set latin2 NOT NULL default '', `joined` int(10) NOT NULL default '0', `ip_address` varchar(16) character set latin2 NOT NULL default '', `posts` mediumint(7) default '0', `title` varchar(64) character set latin2 default NULL, `allow_admin_mails` tinyint(1) default NULL, `time_offset` varchar(10) character set latin2 default NULL, `hide_email` varchar(8) character set latin2 default NULL, `email_pm` tinyint(1) default '1', `email_full` tinyint(1) default NULL, `skin` smallint(5) default NULL, `warn_level` int(10) default NULL, `warn_lastwarn` int(10) NOT NULL default '0', `language` varchar(32) character set latin2 default NULL, `last_post` int(10) default NULL, `restrict_post` varchar(100) character set latin2 NOT NULL default '0', `view_sigs` tinyint(1) default '1', `view_img` tinyint(1) default '1', `view_avs` tinyint(1) default '1', `view_pop` tinyint(1) default '1', `bday_day` int(2) default NULL, `bday_month` int(2) default NULL, `bday_year` int(4) default NULL, `new_msg` tinyint(2) default '0', `msg_total` smallint(5) default '0', `show_popup` tinyint(1) default '0', `misc` varchar(128) character set latin2 default NULL, `last_visit` int(10) default '0', `last_activity` int(10) default '0', `dst_in_use` tinyint(1) default '0', `view_prefs` varchar(64) character set latin2 default '-1&-1', `coppa_user` tinyint(1) default '0', `mod_posts` varchar(100) character set latin2 NOT NULL default '0', `auto_track` varchar(50) character set latin2 default '0', `temp_ban` varchar(100) character set latin2 default '0', `sub_end` int(10) NOT NULL default '0', `login_anonymous` char(3) character set latin2 NOT NULL default '0&0', `ignored_users` text character set latin2, `mgroup_others` varchar(255) character set latin2 NOT NULL default '', `org_perm_id` varchar(255) character set latin2 NOT NULL default '', `member_login_key` varchar(32) character set latin2 NOT NULL default '', `member_login_key_expire` int(10) NOT NULL default '0', `subs_pkg_chosen` smallint(3) NOT NULL default '0', `has_blog` tinyint(1) NOT NULL default '0', `has_gallery` tinyint(1) NOT NULL default '0', `members_markers` text character set latin2, `members_editor_choice` char(3) character set latin2 NOT NULL default 'std', `members_auto_dst` tinyint(1) NOT NULL default '1', `members_display_name` varchar(255) character set latin2 NOT NULL default '', `members_created_remote` tinyint(1) NOT NULL default '0', `members_cache` mediumtext character set latin2, `members_disable_pm` int(1) NOT NULL default '0', `members_l_display_name` varchar(255) character set latin2 NOT NULL default '0', `members_l_username` varchar(255) character set latin2 NOT NULL default '0', `failed_logins` text character set latin2, `failed_login_count` smallint(3) NOT NULL default '0', `members_profile_views` int(10) unsigned NOT NULL default '0', `points` int(11) default '0', `deposited_points` int(11) default '0', `arcade_ban` tinyint(1) NOT NULL default '0', `arcade_activity` int(10) NOT NULL default '0', `arcade_activitywon` int(10) NOT NULL default '0', `times_played` int(11) NOT NULL default '0', `is_arcade_mod` tinyint(1) NOT NULL default '0', `fav_games` text character set latin2, `user_sort` varchar(15) character set latin2 NOT NULL default '0', `user_order` varchar(4) character set latin2 NOT NULL default '0', `user_g_pp` mediumint(8) NOT NULL default '0', `user_s_pp` mediumint(8) NOT NULL default '0', `user_r_pp` mediumint(8) NOT NULL default '0', `def_g_cat` mediumint(8) NOT NULL default '0', `game_skin` tinyint(1) NOT NULL default '0', `arcade_mod_privs` text character set latin2, `arcade_gtype` int(11) NOT NULL default '0', `arcade_sess_gid` mediumint(8) NOT NULL default '1', `arcade_sess_start` int(11) NOT NULL default '0', `arcade_b_challenges` text character set latin2, `arcade_usepm` tinyint(1) NOT NULL default '0', `arcade_challenge_banned` tinyint(1) NOT NULL default '0', `arcade_challengeid` mediumint(8) NOT NULL default '0', `arcade_challenge` tinyint(1) NOT NULL default '0', `arcade_u_cha` tinyint(3) NOT NULL default '2', `arcade_session` mediumint(8) NOT NULL default '0', `arcade_time_spent` int(10) NOT NULL default '0', `jackpots_won` int(10) NOT NULL default '0', `jackpots_points` int(10) NOT NULL default '0', `arcade_won` int(10) NOT NULL default '0', `user_u_columns` tinyint(3) NOT NULL default '1', `arcade_spent` int(10) NOT NULL default '0', `arcade_downloads` int(10) NOT NULL default '0', `arcade_colamount` tinyint(4) NOT NULL default '0', `arcade_sngsess` int(11) NOT NULL default '0', `arcade_sngact` int(11) NOT NULL default '0', `arcade_columnsol` tinyint(1) NOT NULL default '0', `arcade_sng_wins` int(11) NOT NULL default '0', `arcade_postcount` int(11) NOT NULL default '0', `user_arcade_ng` mediumint(8) NOT NULL default '0', `user_arcade_pg` mediumint(8) NOT NULL default '0', `user_arcade_rg` smallint(8) NOT NULL default '0', `user_arcade_nwch` mediumint(8) NOT NULL default '0', `user_arcade_ltsc` mediumint(8) NOT NULL default '0', `icon_ol` tinyint(1) NOT NULL default '0', `gow_score` float NOT NULL default '0', `gow_date` int(11) NOT NULL default '0', `arcade_points` int(11) NOT NULL default '100', `gname` varchar(40) character set latin2 default NULL, `gow_wins` int(11) NOT NULL default '0', `gow_points` int(11) NOT NULL default '0', `msg_msg_id` mediumint(8) NOT NULL default '0', `msg_from_id` mediumint(8) NOT NULL default '0', `can_create_tourney` tinyint(1) NOT NULL default '1', `arcade_sess_gow` tinyint(1) NOT NULL default '0', `arcade_lastplay` int(11) NOT NULL default '0', `arcade_highscores` int(11) NOT NULL default '0', `arcade_twon` int(11) NOT NULL default '0', `arcade_chwon` int(11) NOT NULL default '0', `user_columns_nocollapse` tinyint(1) NOT NULL default '0', `arcade_skin` tinyint(1) NOT NULL default '1', `arcade_posts` int(11) NOT NULL default '0', `converted_points` int(11) NOT NULL default '0', `arcade_pass` int(11) NOT NULL default '0', `arcade_pass_time` int(11) NOT NULL default '0', `arcade_pass_type` tinyint(1) NOT NULL default '0', `arcade_pass_percent` tinyint(3) NOT NULL default '100', PRIMARY KEY (`id`), KEY `members_l_display_name` (`members_l_display_name`), KEY `members_l_username` (`members_l_username`), KEY `mgroup` (`mgroup`), KEY `bday_day` (`bday_day`), KEY `bday_month` (`bday_month`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci

Z miejsca przepraszam za swój poprzedni top. Ale do rzeczy. Mam problem z tym iż wyskakuje mi błąd IPS Driver Error w momencie kiedy przejdę do drugiej strony. Dzieje się tak w momencie wpisywania w Lokację polskich znaków. Tutaj kawałek z cache: Date: Sun, 05 Jul 2009 18:24:18 +0200 Error Number: 1267 Error: Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like' IP Address: 127.0.0.1 Page: /%7Evaldi/index.php?&name_box=begins&sort_key=members_display_name&sort_order=asc&filter=ALL&act=members&max_results=20&aim=&yahoo=&icq=&msn=&posts=&joined=&lastpost=&lastvisit=&interests=&location=%C5%81%C3%B3d%C5%BA&signature=&homepage=&name=&photoonly=&st=20 mySQL query error: SELECT COUNT(*) as total_members FROM ibf_members m LEFT JOIN ibf_member_extra me ON (me.id=m.id) WHERE m.mgroup NOT IN(5,8) AND me.location LIKE '%ĹĂłdĹş%' AND m.members_display_name != '' Wiecie jak to naprawić ? Z góry dziękuję za pomoc.

Mam maluśki problem. Otóż zainstalowałem sobie: (DP23) Location & Interests in Search Members 1.1 Problem polega na tym, iż po wpisaniu w Lokację miasta z polskimi znakami np: Łódź wyświetla mi się tylko jedna strona. Znaczy się wyświetla się więcej ale po wejściu na drugą wyskakuję błąd: IPS Driver Error There appears to be an error with the database. You can try to refresh the page by clicking here Gdy zmienię wyświetlanie na stronie np: 40 userów to wszystko jest ok, chyba, że znów pojawi się druga strona. Wiecie jak to naprawić ? Będę bardzo wdzięczny za pomoc.