No valid database connection Got error 28 from storage engine SQL=SELECT cc.*, COUNT(a.id) AS numlinks, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug FROM jos_categories AS cc LEFT JOIN jos_weblinks AS a ON a.catid = cc.id WHERE a.published = 1 AND section = 'com_weblinks' AND cc.published = 1 AND cc.access <= 0 GROUP BY cc.id ORDER BY cc.ordering
Links
Page 1 of 5
Popular
No valid database connection Got error 28 from storage engine SQL=SELECT DISTINCT
cats.title AS cat,
users.name AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.images AS images,
content.id AS IID,
tabs.name AS TNAME,
tabs.type AS type,
tabs.content AS content,
tabs.id AS TID,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", `content`.`id`, `content`.`alias`)
ELSE `content`.`id` END as ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", `cats`.`id`, `cats`.`alias`)
ELSE `cats`.`id` END as CID
FROM
jos_gk3_tabs_manager_tabs AS `tabs`
LEFT JOIN
jos_content AS `content`
ON `tabs`.`content` = `content`.`id`
LEFT JOIN
jos_categories AS `categories`
ON `categories`.`id` = `content`.`catid`
LEFT JOIN
jos_sections AS `sections`
ON `sections`.`id` = `content`.`sectionid`
LEFT JOIN
jos_menu AS `menu`
ON `menu`.`componentid` = `content`.`id`
LEFT JOIN
jos_users AS `users`
ON `users`.`id` = `content`.`created_by`
LEFT JOIN
jos_categories AS `cats`
ON `content`.`catid` = `cats`.`id`
WHERE
`tabs`.`group_id` = 1
AND
`tabs`.`published` = 1
AND
`tabs`.`access` <= 0
ORDER BY
`tabs`.`order` ASC
;
Partneri
Forum > Latest posts
Copyright © 4Dportal.com | All rights reserved.
