3.10 entries won't delete

4 posts by 2 authors in: Forums > CMS Builder
Last Post: July 18, 2017   (RSS)

By KennyH - July 18, 2017

I upgraded several sites to 3.10 over the past few days and for only those websites, I cannot delete any CMSB entries.  Everythign else works. You can add entries, modify them,etc but cannot delete them. If I click delete, I get the following error:

(An unexpected error occurred: #14085) (An unexpected error occurred: #14086) (An unexpected error occurred: #14087) MySQL Error: Access denied for user 'root'@'localhost' (using password: NO)

I checked the setting file and everything is in order from what I can tell. Proper username and password to the MySQL database is there.

I didn't think we had to use MySQLi yet.  These are just basic websites with no extra coding or programming. Is there something I am missing here?

In the PHP error logs, I see:

E_WARNING: mysql_query(): Access denied for user 'root'@'localhost' (using password: NO)

E_WARNING: mysql_query(): A link to the server could not be established

E_DEPRECATED: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

By Dave - July 18, 2017

Hi KennyH, 

That's unusual.  My first guess is you've got a plugin that is using the old PHP mysql functions.  Everything in CMSB v3.10 has been switched to use the new mysqli_ functions.  

Can you try enabling the legacy MySQL compatibility mode under: Admin > General > Advanced

Legacy MySQL Support [_] Connect to legacy PHP MySQL library to support old code (doubles required MySQL connections)

Let me know if that fixes it for you.

Dave Edis - Senior Developer
interactivetools.com

By KennyH - July 18, 2017

Hi Dave - 

That worked.

For plugins, I noticed that two of them were out of date

  • CSV Import 1.09 (needed 1.11)
  • Website Membership 1.11 (needed 1.12)

I updated both of them and went back to mysqli. Still got the same error. Switched back to Legacy mysql and entries delete as normal.

Any other things I might look at to get it functioning as intended?

Thanks,

Kenny