- Hits: 4580
- 13 Comments
- Subscribe to updates
- Bookmark
Reported problem with Joomla! 1.7 upgrade - Fatal error: Cannot instantiate abstract class JDatabaseQuery
We came across a problem when updating one of our Joomla! 1.6 sites to 1.7, which relates to Joomlart templates.
Thanks to John47 for his post on the Joomla! forums which identified a fix for this issue:
This is a problem with Joomlart templates, causing the following error:Fatal error: Cannot instantiate abstract class JDatabaseQuery in mysite/plugins/system/jat3/jat3/core/joomla/modulehelper.php on line 292
and can be resolved by amending the following:
Change the code in the modulehelper.php file
yoursite/plugins/system/jat3/jat3/core/joomla/modulehelper.php
The problem code is on line 292
$Itemid = JRequest::getInt('Itemid');
$app = JFactory::getApplication();
$user = JFactory::getUser();
$groups = implode(',', $user->getAuthorisedViewLevels());
$db = JFactory::getDbo();
jimport("joomla.database.databasequery");
// comment out the line below
// $query = new JDatabaseQuery;
// add the line below
$query = $db->getQuery(true);
$query->select('id, title, module, position, content, showtitle, params, mm.menuid');
$query->from('#__modules AS m');
$query->join('LEFT','#__modules_menu AS mm ON mm.moduleid = m.id');
$query->where('m.published = 1');
Comments
Adam why did you have to apply the same to the menu. after i followed the instructions mine worked again fine. will there be a problem with the menu???
@ Ruth. Thanks for your insight. You cant believe the amount of time you saved me.
We didn't need to apply Adam's suggestion on any of our JA templated sites, perhaps it relates to an older version of the framework or one particular template?
Ruth
Louigi: No problem, it's the kind of thing that usually takes us ages to figure out so we always write a blog post about it to shorten that timeframe for others! Actually it was John47 on the Joomla! forums who came up with the solution so make sure you thank him too!!!
Ruth
Hi ruth, I GOT same problem, PLease help me,
Fatal error: Cannot instantiate abstract class JDatabaseQuery in mysite/plugins/system/jat3/jat3/core/joomla/modulehelper.php on line 292
I have worked for month on my site, i need ur help please
Mikey
Mikey,
Did you apply the fix which is mentioned in the post above? This should fix your problem immediately.
Ruth
I also had to do Adam's fix ... just upgraded to J 1.7, and running JA Teline iv version 1.2.0 if that helps anyone 
thanks vary much it worked also forn me!!! upgraded J1.6.6 to 1.7.0 with JA Teline iv 1.1.0
Also had to apply same update to base.class.php located in
yoursite/plugins/system/jat3/jat3/core/menu/