Yesterday your Joomla site worked just fine. Today is misbehaving. And you're clueless... Right? Hey, you're not the first one having this experience. You're on the good site where you might find the cure for your problem!
Did you ever get this annoying error?
Save failed with the following error: 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 '' at line 1 SQL=INSERT INTO ***_contentitem_tag_map
After solving couple of times the "500 Internal Server Error" problem as described in a previous post, I received another complaint from one of my clients I host:
"I also cannot save the articles and here is the error I got 500 - An error has occurred!"
Easy cake - I was thinking, but after checking his account, discovered, that all settings described on that article (namely the collation settings in database) where correct.
I had been driven crazy recently by couple of my sites suddenly beginning to exhibit a very annoying behavior. Sites, which worked flawlessly over past months/years began to die when I tried to save something, from new or edited articles, modules, menu items, contacts.
Of course the first thing I done was to look to the error logs, then to enable debug and set the error reporting level to maximum. Nothing helpful.
Time-to-time I am hitting the wall with this, even with 100+ VM sites in my portfolio, and parts of VM core having my signature. Here are few tricks wich usually solves the problem.
It's annoying... your own Joomla site don't let you log in in the backend, and you see the above error message... What's happened?
Humm, there are couple of things you can do. Contrary of the lots of "smart" blog entries on the subject out there (last search revealed about 2 million hits) in most of the cases, regardless to Joomla version the cause is simple:
Suddenly you get the JLIB_APPLICATION_ERROR_COMPONENT_NOT_LOADING all over the place - frontend and backend alike? And you searched the web and get all sorts of confusing tips?
Look no further - at least until you did not tried this simple trick! (Especially if you just relocated your site recently - or your hosting company did it for you). If you have plenty of space, check the following tip too.
What to do when you got hacked? Here you can find some advices, tricks and tips on what you can do!
Problems related with upgrading Joomla or components/plugins/modules. What to do and what mistakes to avoid.
