Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me

error when migrating
(1 viewing) (1) Guest
Support forum for users using free edition of Book it!. These forums are for mutual help among users.

NOTE: Due to our capacity limitations, ARTIO does not monitor this forum category regularly. If you want direct support from ARTIO, please start a ticket at Support Dashboard. If you have no support ticket available, you need to purchase it. .
  • Page:
  • 1

TOPIC: error when migrating

error when migrating 8 years ago #47920

hello

trying to migrate from 2.5 to j3 :
i have migrated the tables from old base to new one and installed booking
I get this erro message :
1054 Unknown column 'customer.email' in 'field list' SQL=SELECT `customer`.*, COALESCE(`user`.`email`,`customer`.`email`) AS email, GROUP_CONCAT(`group`.`title`) AS `usertype` FROM `#__booking_customer` AS `customer` LEFT JOIN `#__user_usergroup_map` AS `map` ON `map`.`user_id` = `customer`.`user` LEFT JOIN `#__usergroups` AS `group` ON `group`.`id` = `map`.`group_id` LEFT JOIN `#__users` AS `user` ON `user`.`id` = `customer`.`user` WHERE `customer`.`id` = 0 GROUP BY `customer`.`user`

could you tell me what should be the error ?
thanks

Re: error when migrating 8 years ago #47921

i saw that a column customer.email was missing, so i uninstall the component and removes the tables.
I reinstalled in order to just inject only the datas
php my admin told me some tables were missing.
So i copied the tables they told me and inject only the old datas.
It seems to be working.
But migrating is not very easy
  • Page:
  • 1
Přihlášení uživatele Prázdný