salve
importando il database il dbms mi da questo errore:
Errore
query SQL:
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `elenco` AS SELECT `discussioni`.`CodDisc` AS `CodDisc` , `discussioni`.`Titolo` AS `Titolo` , `discussioni`.`User` AS `User` , `discussioni`.`DataOra` AS `DataOra` , max( `commenti`.`DataOra` ) AS `CommentoRecente` , count( `commenti`.`DataOra` ) AS `NumeroCommenti`
FROM (
`discussioni`
LEFT JOIN `commenti` ON ( (
`discussioni`.`CodDisc` = `commenti`.`Discus`
) )
)
GROUP BY `discussioni`.`CodDisc`
ORDER BY max( `commenti`.`DataOra` ) DESC ;
Messaggio di MySQL:
#1227 - Access denied; you need the SUPER privilege for this operation