Support

Mandatory information about my setup:

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
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Akeeba Backup version which took the backup: (unknown)
Kickstart version used to extract the backup: (unknown)

Description of my issue:


Hi, I get the following problem when I try to restore my site:

Error at the line 103: CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `#__gigcal_gigs_import` AS select `topfarms_findyourlocalie`.`j17_gigcal_gigs`.`id` AS `id`,concat(`topfarms_findyourlocalie`.`j17_gigcal_gigs`.`band_id`,'| ... MySQL: MySQL query failed with error 1146 (Table 'topfarms_findyourlocalie.j17_gigcal_gigs' doesn't exist). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `fyl_gigcal_gigs_import` AS select `topfarms_findyourlocalie`.`j17_gigcal_gigs`.`id` AS `id`,concat(`topfarms_findyourlocalie`.`j17_gigcal_gigs`.`band_id`,'|',`topfarms_findyourlocalie`.`j17_gigcal_gigs`.`venue_id`,'|',`topfarms_findyourlocalie`.`j17_gigcal_gigs`.`gigdate`) AS `gigname` from `j17_gigcal_gigs`

This happens after I click next from the DB Restore screen.
I can send you the backup via dropbox if you want?

Please help me restore - this website was the culmination of months of work.
I have restored sites hundreds of times using akeebabackup and never had a problem.
kind regards,
Steve
[email protected]

OK, database dump files: is that all the files in the sql folder of the backup?

Hi Nicholas,

thanks for your help. I have been following the steps and i found the line in one of the files.
Now I am a bit stuck with Step 4 of the emergency restoration procedure:

We did the following:

edited the joomla.sql file in the extracted version of my backup
removed the line as suggested from joomla.s15

Now I am left with 2 problems

Firstly, I don't know how to restore the database as suggested in Step 4

Secondly, you said to continue with restore using kickstart. Does that mean i have to convert the extracted version back into a JPA file. If so, how can I do that?

Kind regards,
Steve

Hi Nicholas
thanks for your reply - can you tell me something please?

Do I have to complete Step 3 (changing the table names) for each file in the SQL folder?

Because otherwise I am getting this message:


#1146 - Table 'topfarms_findyourlocalie.#__content' doesn't exist

Thanks Nicholas,

I am using Notepad++ as per the user guide and it has a mass search and replace function which is working well thanks

Thanks again for your help - can i ask you one more thing?

After I restore the database, what file do i run with the kickstart.php?

Am i supposed to use the original jpa file? - (does that not have the old database files?)