- [RISOLTO] Problema query in migrazione

Joomla! 2.5 (versione con supporto terminato) => Joomla! 1.6/1.7/2.5 => Installazione, migrazione e aggiornamento => : asder99 13 Mar 2012, 14:40:56

: [RISOLTO] Problema query in migrazione
: asder99 13 Mar 2012, 14:40:56

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...

: Re:Problema query in migrazione
: asder99 13 Mar 2012, 20:03:29

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

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

[/size]

DEFINER = `admin`@`localhost'".

[/size]

: Re:[RISOLTO] Problema query in migrazione
: iLorenz 24 Apr 2012, 17:21:39

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

: Re:[RISOLTO] Problema query in migrazione
: iLorenz 24 Apr 2012, 17:50:21

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?

: Re:[RISOLTO] Problema query in migrazione
: iLorenz 24 Apr 2012, 18:31:07

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.

: Re:[RISOLTO] Problema query in migrazione
: iLorenz 24 Apr 2012, 19:00:58

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

: Re:[RISOLTO] Problema query in migrazione
: asder99 24 Apr 2012, 19:46:18

: iLorenz 24 Apr 2012, 17:50:21

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`;

: Re:[RISOLTO] Problema query in migrazione
: iLorenz 26 Apr 2012, 11:49:09

Grande grazie. Funziona! ;)

Joomla.it Forum

Joomla! 2.5 (versione con supporto terminato) => Joomla! 1.6/1.7/2.5 => Installazione, migrazione e aggiornamento => : asder99 13 Mar 2012, 14:40:56