After creating a new category

[zainawan99]

"SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION new_bagisto.get_url_path_of_category does not exist (SQL: update categories set _lft = case when _lft >= 50 then _lft+2 else _lft end, _rgt = case when _rgt >= 50 then _rgt+2 else _rgt end where (_lft >= 50 or _rgt >= 50)) "

[Vaishali Agarwal]

@zainawan99
could you please mention the database environment.

[zainawan99]

@Vaishali-Agarwal
database wamp server 3.23
mysql 8.0.21
php 7.3

[Vaishali Agarwal]

@zainawan99
solution is here https://forums.bagisto.com/topic/1414/error-while-adding-categories/4
Hope this will work for you.

[zainawan99]

@Vaishali-Agarwal but same issue come

[Vaishali Agarwal]

@zainawan99
could you show the database collation type ?

[zainawan99]

@Vaishali-Agarwal said in After creating a new category:

collation

Which one

[zainawan99]

@zainawan99 they have bagisto by default

[zainawan99]

@Vaishali-Agarwal

[Vaishali Agarwal]

@zainawan99
kindly change the collation type to utf8_unicode_ci
from database -> Operation -> go down to the collation setting -> choose "utf8_unicode_ci" then apply to all table and column to be safe.

[zainawan99]

@Vaishali-Agarwal sir, i m already try this query in database

[Vaishali Agarwal]

@zainawan99
please try again as you may check this all over the forum query and GitHub issue, solution is same for this issue
https://github.com/bagisto/bagisto/issues/4175
https://github.com/bagisto/bagisto/issues/2562

Once check the above link again & change collation type utf8_unicode_ci and clear the cache using
php artisan config:cache

If still not works then let me know.

[zainawan99]

@Vaishali-Agarwal i m already try this link guide lines

[Vaishali Agarwal]

@zainawan99
kindly raise the support ticket here https://bagisto.uvdesk.com/en/customer/create-ticket/ and also provide your SSH/SFTP server details along with website URL, so we could check at our end.

[zainawan99]

@Vaishali-Agarwal not login required?

[Vaishali Agarwal]

@zainawan99
you need to fill the form then your account will automatically create on the support system. You will get the account activation on the provided email.

[zainawan99]

@Vaishali-Agarwal ok

[SourabhAkash]

Hi,
This error is because of Access problem actually, please change the mysql
GRANT SYSTEM_USER ON . TO user@localhost;
GRANT SUPER ON . TO user@localhost;

So run above commands and check now.

Regards,
Sourabh Akash