backend doesn't work anymore after installing CB 2.0.11

I recently have installed CB version 2.0.11 via the extension manager of Joomla. Up till that moment we used CB version 1.9.1 without any problem.

However, since the installation of CB 2.0.11 I've problems with my backend. It is not possible to manage my backend anymore. I got a message 1064 problem (see attachment). Frontend didn't give any problem.

I wonder what was going wrong? Was it not allowed to install a newer version of CB (from 1.9.1 to 2.0.11)? Or is it something else?

Joomla 2.5

You can't reach Joomla backend at all or you can't reach CB backend pages? If you can't reach Joomla backend at all then edit configuration.php and set the following configuration variables then retry to expose the error further is it's not providing any hint as to what query exactly is erroring.


Changing the two variables should enable debug mode and maximum error reporting. If backend isn't blocked then enable debug mode and maximum error reporting in Joomla global configuration. Most likely you've something installed that may have been integrating with CB and is not compatible with CB 2.x.

I got the following messages:

Strict Standards: Only variables should be assigned by reference in /www/s/p/h/sphv.nl/public_html/plugins/system/advga/advga.php on line 21 Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /www/s/p/h/sphv.nl/public_html/libraries/joomla/html/parameter.php on line 512


and

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 'LIMIT 5' at line 1 SQL=LIMIT 5
Call stack
# Function Location
1 JAdministrator->dispatch() JROOT/administrator/index.php:46
2 JError::raiseError() JROOT/administrator/includes/application.php:164
3 JError::raise() JROOT/libraries/joomla/error/error.php:251

Navigate to plugins/system/ then rename the "advga" folder to "advgaDISABLED". Then see if you can access your backend again. That plugin is just throwing a strict standards warning. Not sure if it's the source of your query. I've no idea what you have installed that could be doing a query of just "LIMIT 5", but it's not valid. My guess is maybe a 3rd party CB plugin or some other extension installed. It also doesn't look like your Joomla install is up to date.

I've changed the plugins/system/advga folder in advgaDISABLED. But the problem with the backend still exist.

I have installed the latest version of Joomla: 2.5.28 As far as I know, this is the latest version of Joomla.

We have the intention to migrate the website to Joomla 3.#. May be it is better to wait for this Joomla install. For the time being I use a backup version before the installation of CB 2.0.11 Than we will use version 1.9.1

What do you suggest?

Problem is the query provides absolutely no hint as to where it's coming from. So I've no idea what is causing your issue. The only way to find out would be to disable extensions and CB plugins 1 by 1 in hopes the issue resolves, which would give you what is causing it. As it's happening directly on backend and blocking backend it most likely is a Joomla system plugin. I recommend renaming the folders of non-Joomla plugins in the below directory and append DISABLED to them to see if it resolves.

plugins/system/