Getting issue in category url generation

[akshaypitale]

Hi,

I am getting issue in category url generation it gets when trying to create a new category.

It is working on local system.
I debug the issue , it seems I don't have proper permissions on database Function which creates category URL.
I talk to the hosting provider but they are saying they will not provide permission on MySQL Database Function because of security reasons.

Is there any work around for this ?

[vaishaliwebkul]

@akshaypitale
could you please show the screenshot of the error getting while creating new category?

[akshaypitale]

@akshaypitale
could you please show the screenshot of the error getting while creating new category?

@vaishaliwebkul

Below is the screenshot of the database function.

[ghermans]

Hi @akshaypitale as @vaishaliwebkul asked, is it possible to also provide us the error you receive so that we can investigate this?

[akshaypitale]

Hi @akshaypitale as @vaishaliwebkul asked, is it possible to also provide us the error you receive so that we can investigate this?

@ghermans Error: MySQL said: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation IF NOT EXISTS ( SELECT id FROM categories WHERE id = categoryId AND parent_id IS NULL

[vaishaliwebkul]

@akshaypitale
may I know your Mysql version?

[rahulshukla-webkul]

Hi @akshaypitale

Either remove the DEFINER=.. statement from your sqldump file, or replace the user values with CURRENT_USER.

The MySQL server provided by RDS does not allow a DEFINER syntax for another user (in my experience).

You can use a sed script to remove them from the file:

sed 's/\sDEFINER=[^`]*`@`[^`]*//g' -i oldfile.sql

[akshaypitale]

Thanks for the help @rahulshukla-webkul .
Replacing value with CURRENT_USER worked for me.

[sandeep-ed]

I remove definer from phpmyadmin but still its showing same error Please check screenshot for the same