Support

Mandatory information about my setup:

Environment where I am restoring to:
Akeeba Kickstart Pro 3.5.1
ABI 3.6.12
Debian 6.0.7
Plesk 11.0.9
PHP 5.3.3-7
mysql 5.1.66-0


Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 2.5.11
PHP version: 5.3.3-7
MySQL version: 5.1.66-0
Host: 94.198.160.68
Akeeba Backup version which took the backup: Akeeba Pro 3.7.7
Kickstart version used to extract the backup: Akeeba Pro Kickstart 3.5.1

Description of my issue:
Extract of the archve goes fine
connection to the db goes fine
extract of the db fails around 85%, with error MySQL: MySQL query failed with error 1146 (Table 'iticaorg.j25_toes_view_full_entry' doesn't exist).

This view is in the original database, this view has the same J25_ prefix as any other table view in the db.
Strange thing is, this same archive extracts without a problem on a shared host with the same provider (the one I am installing on here is a VPS)
No idea what is going on, and would like to prevent having to manually restore the db

Thank you in advance for any assistance you may provide

PS: if needed I can grant you access to the VPS for hands on test

Hello Nicolas,
It is already in lowercase now.
error MySQL: MySQL query failed with error 1146 (Table 'iticaorg.j25_toes_view_full_entry' doesn't exist).

Error at the line 24: CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `#__toes_view_cats_per_division` AS select `e`.`show_id` AS `show_id`,`e`.`show_day` AS `show_day`,`sc`.`show_class` AS `show_class`,`e`.`breed_name` AS `br ... MySQL: MySQL query failed with error 1146 (Table 'iticaorg.j25_toes_view_full_entry' doesn't exist). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `j25_toes_view_cats_per_division` AS select `e`.`show_id` AS `show_id`,`e`.`show_day` AS `show_day`,`sc`.`show_class` AS `show_class`,`e`.`breed_name` AS `breed_name`,concat(`e`.`category`,' ',`e`.`division_name`,' Division') AS `catalog_division`,count(`e`.`entry_id`) AS `cats_in_this_division` from ((((`j25_toes_view_full_entry` `e` left join `j25_toes_show_class` `sc` on((`e`.`Show_Class` = `sc`.`show_class`))) left join `j25_comprofiler` `c` on((`c`.`user_id` = `e`.`summary_user`))) left join `j25_toes_club_organizes_show` `cos` on((`cos`.`show` = `e`.`show_id`))) left join `j25_toes_club` `club` on((`club`.`club_id` = `cos`.`club`))) where ((`sc`.`show_class_id` > 0) and (`sc`.`show_class_id` <= 17) and ((`e`.`entry_status` = 'Accepted') or (`e`.`entry_status` = 'Confirmed') or (`e`.`entry_status` = 'Confirmed & Paid')) and (`e`.`show_id` = 5)) group by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division` order by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division`,`e`.`cat`

I checked the settings, but that check box was already unchecked.
I took another backup and tried restoring again, but the problem remains. This is a backup of another version of the same site, but it seems restoring the views remains an issue.

Any other suggestions?

Database error processing line 99

Database server error reply:

SQL=CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `j25_toes_view_cats_per_division` AS select `e`.`show_id` AS `show_id`,`e`.`show_day` AS `show_day`,`sc`.`show_class` AS `show_class`,`e`.`breed_name` AS `breed_name`,concat(`e`.`category`,' ',`e`.`division_name`,' Division') AS `catalog_division`,count(`e`.`entry_id`) AS `cats_in_this_division` from ((((`j25_toes_view_full_entry` `e` left join `j25_toes_show_class` `sc` on((`e`.`Show_Class` = `sc`.`show_class`))) left join `j25_comprofiler` `c` on((`c`.`user_id` = `e`.`summary_user`))) left join `j25_toes_club_organizes_show` `cos` on((`cos`.`show` = `e`.`show_id`))) left join `j25_toes_club` `club` on((`club`.`club_id` = `cos`.`club`))) where ((`sc`.`show_class_id` > 0) and (`sc`.`show_class_id` <= 17) and ((`e`.`entry_status` = 'Accepted') or (`e`.`entry_status` = 'Confirmed') or (`e`.`entry_status` = 'Confirmed & Paid')) and (`e`.`show_id` = 5)) group by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division` order by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division`,`e`.`cat`

Raw query text:

CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `#__toes_view_cats_per_division` AS select `e`.`show_id` AS `show_id`,`e`.`show_day` AS `show_day`,`sc`.`show_class` AS `show_class`,`e`.`breed_name` AS `breed_name`,concat(`e`.`category`,' ',`e`.`division_name`,' Division') AS `catalog_division`,count(`e`.`entry_id`) AS `cats_in_this_division` from ((((`j25_toes_view_full_entry` `e` left join `#__toes_show_class` `sc` on((`e`.`Show_Class` = `sc`.`show_class`))) left join `#__comprofiler` `c` on((`c`.`user_id` = `e`.`summary_user`))) left join `#__toes_club_organizes_show` `cos` on((`cos`.`show` = `e`.`show_id`))) left join `#__toes_club` `club` on((`club`.`club_id` = `cos`.`club`))) where ((`sc`.`show_class_id` > 0) and (`sc`.`show_class_id` <= 17) and ((`e`.`entry_status` = 'Accepted') or (`e`.`entry_status` = 'Confirmed') or (`e`.`entry_status` = 'Confirmed & Paid')) and (`e`.`show_id` = 5)) group by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division` order by `e`.`show_day`,`sc`.`show_class_id`,`e`.`breed_name`,`e`.`copy_cat_category`,`e`.`copy_cat_division`,`e`.`cat`

Tried that, no succes either.

This is what I did now:

• manually export import all TABLES from the source database

• manually import all tables on target database

• run scripts to create all the views again on the target database

once this was done, the site works on the target server.

Then, I tried running kickstart again, with the SAME jpa file that failed before.
This time it installs successfully.

So I see two possible explanations:
1 - there is something wrong in the backup or restore that makes the restore fail if the tables were not already on the target server to begin with
2 - not all tables are being restored before the views are being restored, causing erros like the ones encountered

Could you please advise on how to determine this? I need to be able to trust that the backup I am running is good, and can restore on a clean host


Thank you