[RISOLTO] Problema query in migrazione

[asder99]

Salve!
Stavo portando un sito fatto con joomla 2.5.2 dal mio pc ad un server remoto. Al momento di fare il dump del DB mi da un errore sull'ultima tabella:

CREATE ALGORITHM = UNDEFINED DEFINER = `admin`@`localhost` SQL SECURITY DEFINER VIEW `tpvrk_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 (

`tpvrk_languages` `l` LEFT JOIN `tpvrk_jf_languages_ext` `lext` ON ( (`l`.`lang_id` = `lext`.`lang_id`) ))ORDER BY `lext`.`ordering` ;
Messaggio di MySQL:
#1227 - Access denied; you need the SUPER privilege for this operation "

Quindi ho tolto "UNDEFINED DEFINER = `admin`@`localhost'", per mi da un nuovo errore, questa volta di sintassi:

CREATE ALGORITHM = SQL SECURITY DEFINER VIEW  `tpvrk_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 (
`tpvrk_languages`  `l`
LEFT JOIN  `tpvrk_jf_languages_ext`  `lext` ON ( (
`l`.`lang_id` =  `lext`.`lang_id`
) )
)
ORDER BY  `lext`.`ordering` ;
Messaggio di MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL SECURITY DEFINER VIEW `tpvrk_jf_languages` AS select `l`.`lang_id` AS `lang_' at line 1


Qualcuno mi può aiutare, per favore? Non riesco a capire dove sta l'errore...

[asder99]

Risolto dopo ore e ore di tentativi.
Invece di rimuovere "

UNDEFINED DEFINER = `admin`@`localhost'" avrei dovuto togliere solamente "

[/size]

DEFINER = `admin`@`localhost'".

[/size]

[/size]

[iLorenz]

Ciao Asder99,


ho lo stesso tuo identico problema:
--------------------------------------------------------

CREATE ALGORITHM = UNDEFINED DEFINER =  `root`@`localhost` SQL SECURITY DEFINER VIEW  `utqdo_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 (


`utqdo_languages`  `l`
LEFT JOIN  `utqdo_jf_languages_ext`  `lext` ON ( (
`l`.`lang_id` =  `lext`.`lang_id`
) )
)
ORDER BY  `lext`.`ordering` ;


Messaggio di MySQL:


#1227 - Access denied; you need the SUPER privilege for this operation


--------------------------------------------------------


Cosa vuole dire che hai tolto:
DEFINER = `admin`@`localhost' ?
In fase di esportazione ?


http://forum.joomla.it/index.php/topic,161830.msg725717.html#msg725717

[iLorenz]

ok trovato tramite grep:

grep -rn "UNDEFINED DEFINER" *
Sulla piattaforma phpmyadmin non mi usciva un tubazzo.



47377:CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `utqdo_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 (`utqdo_languages` `l` left join `utqdo_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;




Quindi stà a 47377.
E ora ?
Cancello?

[iLorenz]

Dunque il sito non si vede importando il tutto ma si riesce ad entrare nel backend e ho quindi disabilitato per un dubbio che mi assaliva la configurazione SEF "Attiva URL SEF" ed ora funziona tutto.

Bah. Ora per scrupolo farò il dump senza attivarlo per vedere se era solo quello.

[iLorenz]

Niente. Non era la soluzione. La configurazione SEF non c'entra, da sempre l'errore.

[asder99]

ok trovato tramite grep:

grep -rn "UNDEFINED DEFINER" *
Sulla piattaforma phpmyadmin non mi usciva un tubazzo.



47377:CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `utqdo_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 (`utqdo_languages` `l` left join `utqdo_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;




Quindi stà a 47377.
E ora ?
Cancello?

Se la query per l'import è quella qui sopra, sostituiscila con questa:
CREATE ALGORITHM=UNDEFINED  SQL SECURITY DEFINER VIEW `utqdo_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 (`utqdo_languages` `l` left join `utqdo_jf_languages_ext` `lext` on((`l`.`lang_id` = `lext`.`lang_id`))) order by `lext`.`ordering`;

[iLorenz]

Grande grazie. Funziona!