Thread

Could you have ANSI_QUOTES enabled on your MySQL server? This would mean that the double quote is not treated as a string quote character and double quotes can’t be used to quote literal strings because they are interpreted as identifier.

Turn it off, there’s no good reason to have it enabled. It’s decidedly non-standard, ANSI and ANSI_QUOTES will kill most commercial MySQL apps.

sql mode =  REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI

What/how should I change it? I can admin it in phpMyAdmin.

REAL_AS_FLOAT will not affect you, but PIPES_AS_CONCAT will not work with ExpressionEngine (or most apps expecting standard syntax), and the same is true for ANSI and ANSI_QUOTES. IGNORE_SPACE is not needed, but not an issue, either.

Not quite sure what I need to change to fix? I switched mySQL to ANSI because I could not install EE in strict mode.

No, STRICT mode is not an option, either. In fact, you don’t have to set any particular server mode, default settings should be fine on most setups. The default value is empty (no modes set).

A resounding THANK YOU. It was in fact the SQL mode. I was not aware the default was blank, as mine was set to strict. The entry deletion worked after using this command in phpMyAdmin

SET @@global.sql_mode = '';

Thank you!

Hi rt30000-

Glad you got things solved! Please feel free to post again, should you run into anymore issues 😊