0
Hi,
I purchased this component today and got it fully installed and working (ie successfully collecting results and inputing these to the database). After this i had a number of issues getting the modules to work correctly within the front end of my site. After switching system debug on i have noticed that the Module Manager is completely in-accessible and i get this error message:
##################################################################################
JDatabaseMySQLi::query: 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 '' at line 1 SQL=SELECT element FROM j25_extensions WHERE type = "module" AND extension_id =
**Return to Control Panel**
Call stack
# Function Location
1 JAdministrator->initialise() C:\xampp\htdocs\surgeTest\administrator\index.php:34
2 JApplication->initialise() C:\xampp\htdocs\surgeTest\administrator\includes\application.php:81
3 JApplication->triggerEvent() C:\xampp\htdocs\surgeTest\libraries\joomla\application\application.php:258
4 JDispatcher->trigger() C:\xampp\htdocs\surgeTest\libraries\joomla\application\application.php:670
5 JEvent->update() C:\xampp\htdocs\surgeTest\libraries\joomla\event\dispatcher.php:161
6 call_user_func_array() C:\xampp\htdocs\surgeTest\libraries\joomla\event\event.php:71
7 plgSystemContentstats->onAfterInitialise()
8 JDatabase->loadResult() C:\xampp\htdocs\surgeTest\plugins\system\contentstats\contentstats.php:57
9 JDatabaseMySQLi->query() C:\xampp\htdocs\surgeTest\libraries\joomla\database\database.php:1109
10 JError::raiseError() C:\xampp\htdocs\surgeTest\libraries\joomla\database\database\mysqli.php:396
11 JError::raise() C:\xampp\htdocs\surgeTest\libraries\joomla\error\error.php:251
#################################################################################
Where C:\xampp\htdocs\surgeTest is the root of my dev site. I subsequently installed a totally fresh version of Joomla 2.5 and have found that the same error is still present. I assume that the problems with the modules are a direct result of this.
Could you please let me know how to resolve this issue asap.
Thanks.
I purchased this component today and got it fully installed and working (ie successfully collecting results and inputing these to the database). After this i had a number of issues getting the modules to work correctly within the front end of my site. After switching system debug on i have noticed that the Module Manager is completely in-accessible and i get this error message:
##################################################################################
JDatabaseMySQLi::query: 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 '' at line 1 SQL=SELECT element FROM j25_extensions WHERE type = "module" AND extension_id =
**Return to Control Panel**
Call stack
# Function Location
1 JAdministrator->initialise() C:\xampp\htdocs\surgeTest\administrator\index.php:34
2 JApplication->initialise() C:\xampp\htdocs\surgeTest\administrator\includes\application.php:81
3 JApplication->triggerEvent() C:\xampp\htdocs\surgeTest\libraries\joomla\application\application.php:258
4 JDispatcher->trigger() C:\xampp\htdocs\surgeTest\libraries\joomla\application\application.php:670
5 JEvent->update() C:\xampp\htdocs\surgeTest\libraries\joomla\event\dispatcher.php:161
6 call_user_func_array() C:\xampp\htdocs\surgeTest\libraries\joomla\event\event.php:71
7 plgSystemContentstats->onAfterInitialise()
8 JDatabase->loadResult() C:\xampp\htdocs\surgeTest\plugins\system\contentstats\contentstats.php:57
9 JDatabaseMySQLi->query() C:\xampp\htdocs\surgeTest\libraries\joomla\database\database.php:1109
10 JError::raiseError() C:\xampp\htdocs\surgeTest\libraries\joomla\database\database\mysqli.php:396
11 JError::raise() C:\xampp\htdocs\surgeTest\libraries\joomla\error\error.php:251
#################################################################################
Where C:\xampp\htdocs\surgeTest is the root of my dev site. I subsequently installed a totally fresh version of Joomla 2.5 and have found that the same error is still present. I assume that the problems with the modules are a direct result of this.
Could you please let me know how to resolve this issue asap.
Thanks.
Responses (7)
-
Accepted Answer
0Hello!
this looks really strange. I hadnt seen it before. can you try to uninstall/reinstall?
we are currently out on vacation until Monday... if you can wait until then, then I'll be able to access your site if you want and give you a hand to see what's going on!
I'm sorry for the inconvenience...! -
Accepted Answer
-
Accepted Answer
0No i have been un-able to resolve this issue. As mentioned within my earlier post you do not need to access my site to see what is going on. You can clearly replicate this issue by installing joomla 2.5 then the plugin. After this enable the debug settings within the CMS and then try to navigate to the module manager. You should then be able to see the error messages. -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »