From: Date: January 31 2005 7:57pm Subject: Re: #1005 - Can't create table (errno: 4242) - importing table to NDB from myISAM List-Archive: http://lists.mysql.com/cluster/1441 Message-Id: <379f2ead0501311057219523bf@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Dear All, I have finally got it working with the following config.ini file: [NDBD DEFAULT] NoOfReplicas=3D2 DataMemory =3D 200MB IndexMemory =3D 100MB MaxNoOfAttributes =3D 2000 MaxNoOfOrderedIndexes =3D 5000 MaxNoOfUniqueHashIndexes =3D 5000 And by ALTERING the tables from myISAM. Now, I have met two problems. One I think is a confirmed bug which has been fixed but is not in 4.1.9 and a whole load of other SQL errors, mainly like this: 1271 : Illegal mix of collations for operation ' IN ' For a query such as=20 SELECT name, value FROM xcart_languages WHERE code =3D 'US' AND name IN ('lbl_sku','lbl_product','lbl_price','lbl_default','lbl_search_results','lb= l_select_language','lbl_products','lbl_and','lbl_items','lbl_online','lbl_p= hone_1_title','lbl_phone_2_title','lbl_search','lbl_advanced_search','lbl_b= estsellers','lbl_other_manufacturers','lbl_manufacturers','lbl_special','lb= l_gift_certificates','lbl_contact_us','lbl_privacy_statement','lbl_terms_n_= conditions','lbl_help','lbl_error','lbl_warning','lbl_information','lbl_clo= se','lbl_go_to_last_edit_section','lbl_search_for_pattern','lbl_search_in',= 'lbl_title','lbl_short_description','lbl_det_description','lbl_search_also_= in','lbl_advanced_search_options','lbl_search_in_category','lbl_as','lbl_ma= in_category','lbl_additional_category','lbl_search_in_subcategories','lbl_w= eight','lbl_search_products','txt_N_results_found','txt_displaying_X_Y_resu= lts','lbl_search_again','lbl_in_this_section','lbl_see_also','lbl_admin_s',= 'lbl_provider_s','lbl_partner_s','lbl_registered_customer_s','lbl_anonymous= _customer_s','lbl_unregistered_customer_s','lbl_users_online','lbl_view_car= t','lbl_checkout','lbl_friends_wish_list','lbl_wish_list','lbl_gift_registr= y','lbl_modify_profile','lbl_delete_profile','lbl_orders_history','lbl_your= _cart','lbl_cart_is_empty','lbl_total','lbl_username','lbl_password','lbl_r= ecover_password','lbl_insecure_login','txt_javascript_disabled','txt_javasc= ript_enabled','lbl_authentication','lbl_log_in','lbl_register','lbl_your_em= ail','lbl_news','lbl_copyright') Does anyone have any ideas what that could be (I am trying to get XCart working). With many thanks, Alex On Mon, 31 Jan 2005 18:49:43 +0100, pekka@stripped wrote= : > > CREATE TABLE `xcart_counties` ( > >... > > MySQL said: > > #1005 - Can't create table './test2/xcart_counties.frm' (errno: 4242) >=20 > I can create both tables in 4.1.10 (started with --initial). > Nothing special about config: >=20 > [DB DEFAULT] > NoOfReplicas: 2 > DataMemory: 50M > IndexMemory: 10M > MaxNoOfTables: 100 > MaxNoOfOrderedIndexes: 500 >=20 > -- > Pekka Nousiainen, Software Engineer > MySQL AB, www.mysql.com > pekka@stripped +46 (0) 73 068 4978 >=20 --=20 Alex Davies // http://www.davz.net This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.