Please note that this forum is only available to you in read only mode. In order to contribute to this conversation you will need to renew your subscription.
grid 3 warning invalid arguement
If you use Zentools please post a review at the Joomla! Extensions Directory.
11 years 4 days ago
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
- [email protected]
- 3 Month Basic
- 9 posts
- Karma: 0
The administrator has disabled public write access.
11 years 4 days ago
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
- [email protected]
- 3 Month Basic
- 9 posts
- Karma: 0
The administrator has disabled public write access.
11 years 4 days ago
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,
- vietvu
- 12 Month basic
- 605 posts
- 51 Thanks
- Karma: 22
The administrator has disabled public write access.
10 years 11 months ago
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,
- vietvu
- 12 Month basic
- 605 posts
- 51 Thanks
- Karma: 22
The administrator has disabled public write access.
10 years 11 months ago
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.
- slabcinema
- 12 Month basic
- 1 posts
- Karma: 0
The administrator has disabled public write access.
10 years 11 months ago
HiVery 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
- manh
- Moderator
- 45248 posts
- 2106 Thanks
- Karma: 603
The administrator has disabled public write access.
10 years 11 months ago
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.
- Zuzuzu
- LIfetime Developer - Big Bamboo
- 1925 posts
- 107 Thanks
- Karma: 67
The administrator has disabled public write access.
10 years 11 months ago
Hi Zuzuzu,Thank you for the update.
Cheers,
- vietvu
- 12 Month basic
- 605 posts
- 51 Thanks
- Karma: 22
The administrator has disabled public write access.
If you use Zentools please post a review at the Joomla! Extensions Directory.