Looking for Customer Service & Support

IMPORTANT: This is a Community Forum. Answers are given by the community. If you are a Customer, please, Open New Issue to get access to the support service.

Customer Support is only provided through our ticketing system https://support.extly.com/. If you do not have a paid membership, please create a new topic in the community forum.

error in xtdir table when restoring database of joomla website

More
9 months 5 days ago #10408 by Pablo Orcajo Carreton
Pablo Orcajo Carreton created the topic: error in xtdir table when restoring database of joomla website
Hi,

I cannot restores my joomla database because I have an error in xtdir table that I cannot solve.

The error that I obtain with akeeba restoration process is

ErrNo #1267
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
SQL=CREATE VIEW `pcz8o_xtdir_promosection_dynamic_view` AS select `t`.`section` AS `section_id`,`t`.`id` AS `entry_id`,`promo`.`ordering` AS `ordering`,`promo`.`promotype_id` AS `promotype_id`,`promo`.`tiertype_id` AS `tiertype_id`,`promo`.`disable_entries` AS `disable_entries`,`promo`.`max_entries` AS `max_entries`,NULL AS `promoentry_id`,NULL AS `promoorder_id` from (((`pcz8o_xtdir_trees` `t` join `pcz8o_sobipro_object` `o` on(((`t`.`id` = `o`.`id`) and (`o`.`oType` = 'entry')))) join `pcz8o_xtdir_promotions` `promo` on(((`t`.`section` = `promo`.`section_id`) and (`promo`.`category_id` = 0) and (`promo`.`published` = 1) and (`promo`.`tiertype_id` = 'D')))) left join `pcz8o_xtdir_promosection_paid_view` `psp` on((`t`.`id` = `psp`.`entry_id`))) where (isnull(`psp`.`entry_id`) and ((`t`.`id` = (select `opt`.`sid` from `pcz8o_sobipro_field_option_selected` `opt` where ((`opt`.`sid` = `t`.`id`) and (`opt`.`fid` = `promo`.`field_id`) and (convert(`opt`.`optValue` using utf8mb4) = `promo`.`field_value`)) limit 1)) or (`t`.`id` = (select `d`.`sid` from `pcz8o_sobipro_field_data` `d` where ((`d`.`sid` = `t`.`id`) and (`d`.`fid` = `promo`.`field_id`) and (convert(`d`.`baseData` using utf8mb4) = `promo`.`field_value`)) limit 1))))

Texto de la query
CREATE VIEW `#__xtdir_promosection_dynamic_view` AS select `t`.`section` AS `section_id`,`t`.`id` AS `entry_id`,`promo`.`ordering` AS `ordering`,`promo`.`promotype_id` AS `promotype_id`,`promo`.`tiertype_id` AS `tiertype_id`,`promo`.`disable_entries` AS `disable_entries`,`promo`.`max_entries` AS `max_entries`,NULL AS `promoentry_id`,NULL AS `promoorder_id` from (((`#__xtdir_trees` `t` join `#__sobipro_object` `o` on(((`t`.`id` = `o`.`id`) and (`o`.`oType` = 'entry')))) join `#__xtdir_promotions` `promo` on(((`t`.`section` = `promo`.`section_id`) and (`promo`.`category_id` = 0) and (`promo`.`published` = 1) and (`promo`.`tiertype_id` = 'D')))) left join `#__xtdir_promosection_paid_view` `psp` on((`t`.`id` = `psp`.`entry_id`))) where (isnull(`psp`.`entry_id`) and ((`t`.`id` = (select `opt`.`sid` from `#__sobipro_field_option_selected` `opt` where ((`opt`.`sid` = `t`.`id`) and (`opt`.`fid` = `promo`.`field_id`) and (convert(`opt`.`optValue` using utf8mb4) = `promo`.`field_value`)) limit 1)) or (`t`.`id` = (select `d`.`sid` from `#__sobipro_field_data` `d` where ((`d`.`sid` = `t`.`id`) and (`d`.`fid` = `promo`.`field_id`) and (convert(`d`.`baseData` using utf8mb4) = `promo`.`field_value`)) limit 1))))



Could you help me to solve this?

Please Log in or Create an account to join the conversation.

More
9 months 1 day ago #10409 by Support Team
Support Team replied the topic: error in xtdir table when restoring database of joomla website
Hi,

The error is generated in a MySQL view (a SQL query). It is not a table.

There is an inconsistency in the declaration of XTDir views in your database.

Please, update to the latest XTDir 6.4.2 and recreate the views. Check this similar topic in your FAQs: www.extly.com/docs/xtdir_for_sobipro/ins...tion-sql-create-view

Best Regards,
The following user(s) said Thank You: Pablo Orcajo Carreton

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Join the Club!

Access and support services to all Extly's extensions for 1-Year. The Extly Club is your source for all of our extensions.

Join Now