Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

table name 'wp_mmp_rechnung_history_2014-05-19' crashes srdb #382

Open
Martin-Eckleben opened this issue Jan 23, 2023 · 1 comment
Open

Comments

@Martin-Eckleben
Copy link

Hi,

first let me thank you for your great work!
I LOVE srdb and use it a lot!

I called:
php srdb.cli.php --host 127.0.0.1 --name <dbname> --user <user> --pass <password> --search <string> --replace <string> --dry-run
on a Wordpress 4.9.5 DB.

It stated a lot of tables and finds as usual i.e.:

wp_em_rechnungen_710: replacing <string> with <string>
wp_em_rechnungen_710: 31157 rows, 0 changes found, 0 updates made in 0.22814703 seconds

But then it crashes with:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-05-19' at line 1
on a table
wp_mmp_rechnung_history_2014-05-19

(web client crashes with ajax error as well)

mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

No Problem for me I'll simply rename the table.
Just thought I'd tell you to do some good in the world :)
Is a a PR wanted?

@MadtownLems
Copy link

The web client halts execution, reporting an AJAX error, if it encounters any table with a dash (-) in its name.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants