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.6
PHP version: (unknown)
MySQL version: 5.0.77
Host: (optional, but it helps us help you) www.genotec.ch
Akeeba Backup version which took the backup: 3.5.2
Kickstart version used to extract the backup: 3.5.2
Description of my issue:
While trying to restore to my webspace (which I've done many times before...) I now get the following error:
Fehler in der Zeile 71: 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 1142 (CREATE VIEW command denied to user '23169_joomla2'@'localhost' for table 'ow57p_jf_languages'). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `ow57p_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 (`ow57p_languages` `l` left join `ow57p_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`
I've read in other posts that his has to do with user-rights or external tables. However, I could easily transfer the database "by hand" - is there a possibility to skip the database setup in the kickstart process?
Thomas
P.S. Update: I just tried to export the database and import it on my webhost and got the following error from PHPMyAdmin:#1227 - Access denied; you need the SUPER privilege for this operation. So it's definitely some SQL problem I have to sort out...
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.6
PHP version: (unknown)
MySQL version: 5.0.77
Host: (optional, but it helps us help you) www.genotec.ch
Akeeba Backup version which took the backup: 3.5.2
Kickstart version used to extract the backup: 3.5.2
Description of my issue:
While trying to restore to my webspace (which I've done many times before...) I now get the following error:
Fehler in der Zeile 71: 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 1142 (CREATE VIEW command denied to user '23169_joomla2'@'localhost' for table 'ow57p_jf_languages'). The query was:CREATE OR REPLACE ALGORITHM=UNDEFINED VIEW `ow57p_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 (`ow57p_languages` `l` left join `ow57p_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`
I've read in other posts that his has to do with user-rights or external tables. However, I could easily transfer the database "by hand" - is there a possibility to skip the database setup in the kickstart process?
Thomas
P.S. Update: I just tried to export the database and import it on my webhost and got the following error from PHPMyAdmin:#1227 - Access denied; you need the SUPER privilege for this operation. So it's definitely some SQL problem I have to sort out...
