Re: #1005 - Can't create table (errno: 4242) - importing table to NDB from myISAM

[Alex Davies]

Dear All,

I have finally got it working with the following config.ini file:

[NDBD DEFAULT]
NoOfReplicas=2
DataMemory = 200MB
IndexMemory = 100MB
MaxNoOfAttributes = 2000
MaxNoOfOrderedIndexes = 5000
MaxNoOfUniqueHashIndexes = 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 

SELECT name, value FROM xcart_languages WHERE code = 'US' AND name IN
('lbl_sku','lbl_product','lbl_price','lbl_default','lbl_search_results','lbl_select_language','lbl_products','lbl_and','lbl_items','lbl_online','lbl_phone_1_title','lbl_phone_2_title','lbl_search','lbl_advanced_search','lbl_bestsellers','lbl_other_manufacturers','lbl_manufacturers','lbl_special','lbl_gift_certificates','lbl_contact_us','lbl_privacy_statement','lbl_terms_n_conditions','lbl_help','lbl_error','lbl_warning','lbl_information','lbl_close','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_main_category','lbl_additional_category','lbl_search_in_subcategories','lbl_weight','lbl_search_products','txt_N_results_found','txt_displaying_X_Y_results','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_cart','lbl_checkout','lbl_friends_wish_list','lbl_wish_list','lbl_gift_registry','lbl_modify_profile','lbl_delete_profile','lbl_orders_history','lbl_your_cart','lbl_cart_is_empty','lbl_total','lbl_username','lbl_password','lbl_recover_password','lbl_insecure_login','txt_javascript_disabled','txt_javascript_enabled','lbl_authentication','lbl_log_in','lbl_register','lbl_your_email','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 <pekka@stripped> wrote:
> > CREATE TABLE `xcart_counties` (
> >...
> > MySQL said:
> > #1005 - Can't create table './test2/xcart_counties.frm' (errno: 4242)
> 
> I can create both tables in 4.1.10 (started with --initial).
> Nothing special about config:
> 
> [DB DEFAULT]
> NoOfReplicas: 2
> DataMemory: 50M
> IndexMemory: 10M
> MaxNoOfTables: 100
> MaxNoOfOrderedIndexes: 500
> 
> --
> Pekka Nousiainen, Software Engineer
> MySQL AB, www.mysql.com
> pekka@stripped [phone]
> 


-- 
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.