Have I read the related troubleshooter articles above before posting (which pages?)? https://www.akeebabackup.com/documentation/troubleshooter/abidatabase.html
Have I searched the tickets before posting? yes
Have I read the documentation before posting (which pages?)? No
Joomla! version: 1.5.25
PHP version: 5.2.17
MySQL version: 5.0.91-community-cll
Host: evohosting moving to WebGo24
Akeeba Backup version which took the backup: 3.4.3
Kickstart version used to extract the backup: xtract Wizard 3.3, extracted to C and uploaded with FTP
The New Server: PHP 5.2 and MySQL 5.1.49-3-log
Description of my issue:
Good morgning
After extracting and uploading our files and changing the database information, we a getting errors like this:
Error at the line 143: 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` ... MySQL: MySQL query failed with error 1054 (Unknown column 'l.lang_id' in 'field list'). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `ccj_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 (`ccj_languages` `l` left join `ccj_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`
I'm restoring my site on a diferent hosting, but I'm getting only errors like this