I have installed "Grid 3" Quickstart template, looks to have installed OK with all the sample data [articles etc] in place.

The home page works OK except I have 2 "Warning invalid arguments" in the lower part of the home page.

One for:
components/com_content/models/articles.php on line 486.

The file 'models/articles.php' only goes to line 315 not line 486 ?

the other for:
modules/mod_zentools/includes/zenj17contenthelper.php on line 158

This is the code for lines 158 -161 from this file

foreach ($items as $item) {
$item->slug = $item->id.':'.$item->alias;
$item->catslug = $item->catid.':'.$item->category_alias;
$item->text = $item->introtext;


Also I get this error when trying to open any other page of the site.

500 - Unknown column 'a.title_alias' in 'field list' SQL=SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROM grid3_content AS a LEFT JOIN grid3_categories AS c on c.id = a.catid LEFT JOIN grid3_users AS u on u.id = a.created_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM grid3_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN grid3_categories as parent ON parent.id = c.parent_id LEFT JOIN grid3_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM grid3_categories AS cat JOIN grid3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 21 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-03-24 01:09:55') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-03-24 01:09:55') AND (a.state = 1 OR a.state =2)

Any help would be greatly appreciated

I have also just noticed that I cannot open any menus [main, footer or template features] in the Menu Manger I get this 500 error:

500 - An error has occurred.

Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `grid3_menu` AS a LEFT JOIN `grid3_languages` AS l ON l.lang_code = a.language LEFT JOIN `grid3_users` AS u ON u.id = a.checked_out LEFT JOIN `grid3_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN grid3_viewlevels AS ag ON ag.id = a.access LEFT JOIN grid3_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `grid3_menu` AS a LEFT JOIN `grid3_languages` AS l ON l.lang_code = a.language LEFT JOIN `grid3_users` AS u ON u.id = a.checked_out LEFT JOIN `grid3_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN grid3_viewlevels AS ag ON ag.id = a.access LEFT JOIN grid3_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `grid3_menu` AS a LEFT JOIN `grid3_languages` AS l ON l.lang_code = a.language LEFT JOIN `grid3_users` AS u ON u.id = a.checked_out LEFT JOIN `grid3_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN grid3_viewlevels AS ag ON ag.id = a.access LEFT JOIN grid3_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc


This is a link to the site

www.gridqs.arterymediadesign.com.au/

Thanks for any help going with this problem

Hi,

I can confirm this bug.

The bug comes from the incorrect sample data for Joomla 2.5.x. I am going to report this bug to our developer.

Thank you,

Hi RobinL,

I've received an update from our developer that this issue has been fixed recently, please download the latest package and install again. If you do not want to re-install, you can raise a support ticket with a phpMyAdmin or CPanel account and our developer will fix it for you.

Regards,

Hello. I just downloaded a fresh copy of JB_Grid3_Quickstart_J259_v1.2.0.zip.

I get the two errors on the home page:

Warning: Invalid argument supplied for foreach() in /home/content/47/10469847/html/components/com_content/models/articles.php on line 486

Warning: Invalid argument supplied for foreach() in /home/content/47/10469847/html/modules/mod_zentools/includes/zenj17contenthelper.php on line 158

No content assigned to be displayed.

And a 500 error when I go into Main Menu:

500 - An error has occurred.

Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `vs8lh_menu` AS a LEFT JOIN `vs8lh_languages` AS l ON l.lang_code = a.language LEFT JOIN `vs8lh_users` AS u ON u.id = a.checked_out LEFT JOIN `vs8lh_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN vs8lh_viewlevels AS ag ON ag.id = a.access LEFT JOIN vs8lh_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `vs8lh_menu` AS a LEFT JOIN `vs8lh_languages` AS l ON l.lang_code = a.language LEFT JOIN `vs8lh_users` AS u ON u.id = a.checked_out LEFT JOIN `vs8lh_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN vs8lh_viewlevels AS ag ON ag.id = a.access LEFT JOIN vs8lh_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc LIMIT 0, 20 Unknown column 'a.ordering' in 'field list' SQL=SELECT a.id, a.menutype, a.title, a.alias, a.note, a.path, a.link, a.type, a.parent_id, a.level, a.published as apublished, a.component_id, a.ordering, a.checked_out, a.checked_out_time, a.browserNav, a.access, a.img, a.template_style_id, a.params, a.lft, a.rgt, a.home, a.language, a.client_id,CASE a.type WHEN 'component' THEN a.published+2*(e.enabled-1) WHEN 'url' THEN a.published+2 WHEN 'alias' THEN a.published+4 WHEN 'separator' THEN a.published+6 END AS published,l.title AS language_title, l.image as image,u.name AS editor,c.element AS componentname,ag.title AS access_level,e.name AS name FROM `vs8lh_menu` AS a LEFT JOIN `vs8lh_languages` AS l ON l.lang_code = a.language LEFT JOIN `vs8lh_users` AS u ON u.id = a.checked_out LEFT JOIN `vs8lh_extensions` AS c ON c.extension_id = a.component_id LEFT JOIN vs8lh_viewlevels AS ag ON ag.id = a.access LEFT JOIN vs8lh_extensions AS e ON e.extension_id = a.component_id WHERE a.id > 1 AND a.client_id = 0 AND (a.published IN (0, 1)) AND a.menutype = 'mainmenu' ORDER BY a.lft asc

The response above says the issue has been fixed but seemingly has not.

Hi

Very sorry about this - we seem to have a glitch with a script which is corrupting the sample data files

Can you create a ticket so we can fix this issue in your site

We will need access details for the DB..phpMyAdmin or cPanel so we can upload the correct sample data

Our apologies again for this issue

Regards
Paul

And I want to add, I am very sorry for this. It is our stupid bug that is reintroducing over and over again.

Anyway, I just tested and fixed that package. So from now it should really be OK.

Hi Zuzuzu,

Thank you for the update.

Cheers,