Support

Hello Akeeba Support,

I'm experiencing precisely what the user in ticket #11713 and I'm looking at disabling "No dependency tracking". It does not seem to be an option in the backup configuration. Where do I disable this? I've looked at the options on the CPanel to change settings but can't locate. Is this something that only the ISP can change?

Thank you in advanced.

Bernard

I had trouble finding it too.

You need to switch your Database Backup Engine in Configuration to the Reverse engineering database dump engine. Then you will see the No dependency tracking check box.

Hi Dale,

Is there another way to restore that backup? I can no longer create another backup.

I accidentally deleted the extensions table while removing left-over tables from uninstalled components, and now the the site is hosed. That backup was my safe keep.

What would you suggest?

Bernard

Never-mind, Dale. I unpacked the backup and restored the DB one piece at a time. I'm back with you... found the reverse engineering option... am backing up again... perhaps this time it's a charm.

Thank you!

Hi Dale,

Maybe the issue I'm having is not actually the same as the ticket I found, thought is sure looks like it. Because even after selecting "No dependency tracking" I still cannot restore the site. Here is the error message I get:

Database error processing line 34
Database server error reply:

ErrNo #0
 SQL=CREATE OR REPLACE ALGORITHM=UNDEFINED  VIEW `tns_jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`jos_languages` `l` left join `jos_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`
Raw query text:

CREATE OR REPLACE ALGORITHM=UNDEFINED  VIEW `#__jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`jos_languages` `l` left join `jos_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`

For the record, No Dependency Tracking is also available with the Native MySQL backup engine. I was working from the Docs last night and only caught the second paragraph.

Has this restore ever worked? One thing that could be causing this is that your host doesn't allow you to create a VIEW. That would cause a permission problem with the restore. If it has worked in the past, that wouldn't be the problem.

Hi Dale,

This is the first time I try to restore this particular site, which is loaded with components and well over 200 tables. I've done many restores on this server. I also just added a new user to this DB and gave all permission including creating views.

I'll give the native engine dependency option a try shortly, and let you know what happens.

Thanks,

Bernard

Hi Dale,

Still no cigar. I Still get the same error.

When I did a manual resort of the DB I omitted the query string that creates the view (code). All other SQL seems to work. I'm tempted to edit the Akeeba archive to exclude the offending code and restore that .jpa archive. Do you recommend a .jpa editor? Is there such a thing?

CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `#__jf_languages` AS select `l`.`lang_id` AS `lang_id`,`l`.`lang_code` AS `lang_code`,`l`.`title` AS `title`,`l`.`title_native` AS `title_native`,`l`.`sef` AS `sef`,`l`.`description` AS `description`,`l`.`published` AS `published`,`l`.`image` AS `image`,`lext`.`image_ext` AS `image_ext`,`lext`.`fallback_code` AS `fallback_code`,`lext`.`params` AS `params`,`lext`.`ordering` AS `ordering` from (`jos_languages` `l` left join `jos_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;

Bernard

You can extract the .jpa file locally with the eXtract Wizard, available on our Downloads page.

The sql code would be in the /installation/sql folder in multiple files with extensions .sql, .s01, .s02, etc.

Bernard,

I talked to Nicholas about this. He says you need the CREATE VIEW permission for your database. Older versions of cPanel and all versions of Plesk don't offer this permission when setting up the user permissions. For those systems, the host has to assign the permission. He says it is literally a ten second job.

Thanks, Dale!

Well, a big duh hit me as I was ranting about getting rid of the offending code. After Kickstart extracted the archive, and before running the restore, I opened the sql file with the offending code and removed it. Ta-da!!! The restore worked as always!

Thanks for your help, and for letting me rant!

Have a great day!

Bernard

I didn't think of that either.

The problem with editing the sql code is that your restored site has a VIEW missing from its database. Something on the site isn't going to work. You may be able to recreate it by installing the component that uses it, but keep your backup handy.

Hi Dale,

Yea, I know. I wish there was a way to figure out what component uses each table. Some are obvious, but I can't figure this one out. I've found references that suggest this view (jf_languages) is a JoomFish table, but I don't have JoomFish installed. Go figure!

Any suggestions to figure out what table belongs to what component would be awesome.

Bernard

JoomFish is a good guess based on the name, but it is just a guess. I've never used JoomFish, so I don't have any experience. If it is a JoomFish remnant, it won't cause any problems because there is nothing left to call it.

Just "warm fuzzy" proof, but I found references to jf_languages in both the JoomFish and Joomla! forums as a JoomFish "table".