Friday, 13 September 2013

MySQL error #1227 - Access denied; you need the SUPER privilege for this operation from godaddy to 1and1

MySQL error #1227 - Access denied; you need the SUPER privilege for this
operation from godaddy to 1and1

I exported my MySQL database from Godaddy and was getting ready to
transfer them to 1and1 and when I uploaded them to 1and1 I got this error
in the SQL query
/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`cedsajoomla`@`%` SQL SECURITY
DEFINER VIEW `dnbhf_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 (`dnbhf_languages` `l` left
join `dnbhf_jf_languages_ext` `lext` on((`l`.`lang_id` =
`lext`.`lang_id`))) order by `lext`.`ordering` */
Can someone tell me what I am doing wrong. I have also uploaded the error
to pastebin http://pastebin.com/WPr813RH Thank You in advance for your
help

No comments:

Post a Comment