bug: delete namespce will cause error

[liyabing12138]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'namespace_id' in 'where clause' ### The error may exist in class path resource [mappers/auth-path-sqlmap.xml] ### The error may involve org.apache.shenyu.admin.mapper.AuthPathMapper.findByNamespaceIds-Inline ### The error occurred while setting parameters ### SQL: SELECT id, auth_id, app_name, path, enabled, date_created, date_updated FROM auth_path WHERE namespace_id IN ( ? ) ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'namespace_id' in 'where clause' ; bad SQL grammar []

Expected Behavior

No response

Steps To Reproduce

No response

Environment

ShenYu version(s):

Debug logs

No response

Anything else?

No response

[xcsnx]

Have you executed the SQL script for version update?

[Aias00]

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

[liyabing12138]

Have you executed the SQL script for version update?

The SQL has been validated and the code format needs to be adjusted again

[liyabing12138]

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

2.7.0-upgrade-2.7.1-mysql.sql

[xcsnx]

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

[Aias00]

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

he submit a pr already

[liyabing12138]

Have you executed the SQL script for version update?

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

I adjusted the code compilation issue

[xcsnx]

Have you executed the SQL script for version update?

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

I adjusted the code compilation issue

I'm sorry, the modification of this PR (#5913) is incorrect.

This should be querying appAuthMapper instead of authPathMapper. Would you be willing to change this PR to fix this bug

[liyabing12138]

Have you executed the SQL script for version update?

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

I adjusted the code compilation issue

I'm sorry, the modification of this PR (#5913) is incorrect.

This should be querying appAuthMapper instead of authPathMapper. Would you be willing to change this PR to fix this bug

Continue to solve it

[Aias00]

Have you executed the SQL script for version update?

Have you executed the SQL script for version update?

hi. the table name in error info is "auth_path", which is not in upgrade sql

Okay, I will fix this error

I adjusted the code compilation issue

I'm sorry, the modification of this PR (#5913) is incorrect.

This should be querying appAuthMapper instead of authPathMapper. Would you be willing to change this PR to fix this bug

Continue to solve it

close the previous pr, and submit a new pr to fix this