[fw_db_error: message="SQL execution error" code=-3 mode=return level=notice prefix="" info="Got error 28 from storage engine [nativecode=1030]: SELECT
page_title,
CONCAT('http://', account_domain, '.familyroutes.com/p', `m_wejourn__PAGE`.page_id, '/') as page_link,
( SELECT thought_text
FROM `m_wejourn__THOUGHT` t
WHERE thought_is_approved = 1 AND
t.moderated >= 10 AND
t.page_id = `m_wejourn__PAGE`.page_id
ORDER BY created DESC LIMIT 1
) as last_thought,
( SELECT
IF (`m_wejourn__PHOTO`.`photo_file_name` <> '',
CONCAT('/img/photos/', `m_wejourn__PHOTO`.`creator_account_id`, '/', `m_wejourn__PHOTO`.`photo_file_name`, 'fh.jpg'),
`m_wejourn__PHOTO`.`photo_file_name`) as last_photo
FROM
`m_wejourn__PHOTO`, `m_wejourn__ALBUM`, `m_wejourn__ALBUM_PHOTO`
WHERE
`m_wejourn__ALBUM_PHOTO`.`album_photo_is_approved` <> 0 AND
`m_wejourn__PHOTO`.`moderated` >= 10 AND
`m_wejourn__PHOTO`.`photo_id` = `m_wejourn__ALBUM_PHOTO`.`photo_id` AND
`m_wejourn__ALBUM_PHOTO`.`album_id` = `m_wejourn__ALBUM`.`album_id` AND
`m_wejourn__ALBUM`.`page_id` = `m_wejourn__PAGE`.page_id
ORDER BY `m_wejourn__ALBUM_PHOTO`.`updated` DESC LIMIT 1
) as last_photo,
`m_wejourn__ACCOUNT`.`account_id` as user_id,
account_first_name as user_name,
IF (account_image <> '',
CONCAT('/img/accounts/', account_image, 't.jpg'),
'/img/site/d_man.gif') as user_img
FROM
`m_wejourn__PAGE`
LEFT JOIN `m_wejourn__ACCOUNT` on `m_wejourn__PAGE`.`account_id` = `m_wejourn__ACCOUNT`.`account_id`
LEFT JOIN `m_wejourn__CATEGORY` on `m_wejourn__CATEGORY`.`category_id` = `m_wejourn__PAGE`.`category_id`
WHERE
(page_restrict_view = 0
) AND
page_title <> 'user_photos' AND
category_title = 'Children' AND
account_is_inactive = 0
ORDER BY
`m_wejourn__PAGE`.`updated` DESC
"]ERROR
SQL execution error, -3
Array
(
[0] => Array
(
[file] => /home/data.new/index.php
[line] => 13
[function] => run
[class] => application
[type] => ->
[args] => Array
(
)
)
[1] => Array
(
[file] => /home/data.new/framework/application.php
[line] => 53
[function] => run_runmode
[class] => application
[type] => ->
[args] => Array
(
[0] => site_search
)
)
[2] => Array
(
[file] => /home/data.new/framework/application.php
[line] => 109
[function] => run
[class] => module_site
[type] => ->
[args] => Array
(
)
)
[3] => Array
(
[file] => /home/data.new/modules/SiteSection.php
[line] => 22
[function] => run_action
[class] => module_site
[type] => ::
[args] => Array
(
[0] => site_search
)
)
[4] => Array
(
[file] => /home/data.new/mod_Site.php
[line] => 42
[function] => run
[class] => action_site
[type] => ->
[args] => Array
(
[0] => module_site Object
(
)
)
)
[5] => Array
(
[file] => /home/data.new/modules/Action/Site.php
[line] => 50
[function] => _site_search
[class] => action_site
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/data.new/modules/Action/Site.php
[line] => 456
[function] => _search_category
[class] => action_site
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /home/data.new/modules/Action/Site.php
[line] => 413
[function] => getall
[class] => fw_db_interface
[type] => ->
[args] => Array
(
[0] => SELECT
page_title,
CONCAT('http://', account_domain, '.familyroutes.com/p', `m_wejourn__PAGE`.page_id, '/') as page_link,
( SELECT thought_text
FROM `m_wejourn__THOUGHT` t
WHERE thought_is_approved = 1 AND
t.moderated >= 10 AND
t.page_id = `m_wejourn__PAGE`.page_id
ORDER BY created DESC LIMIT 1
) as last_thought,
( SELECT
IF (`m_wejourn__PHOTO`.`photo_file_name` <> '',
CONCAT('/img/photos/', `m_wejourn__PHOTO`.`creator_account_id`, '/', `m_wejourn__PHOTO`.`photo_file_name`, 'fh.jpg'),
`m_wejourn__PHOTO`.`photo_file_name`) as last_photo
FROM
`m_wejourn__PHOTO`, `m_wejourn__ALBUM`, `m_wejourn__ALBUM_PHOTO`
WHERE
`m_wejourn__ALBUM_PHOTO`.`album_photo_is_approved` <> 0 AND
`m_wejourn__PHOTO`.`moderated` >= 10 AND
`m_wejourn__PHOTO`.`photo_id` = `m_wejourn__ALBUM_PHOTO`.`photo_id` AND
`m_wejourn__ALBUM_PHOTO`.`album_id` = `m_wejourn__ALBUM`.`album_id` AND
`m_wejourn__ALBUM`.`page_id` = `m_wejourn__PAGE`.page_id
ORDER BY `m_wejourn__ALBUM_PHOTO`.`updated` DESC LIMIT 1
) as last_photo,
`m_wejourn__ACCOUNT`.`account_id` as user_id,
account_first_name as user_name,
IF (account_image <> '',
CONCAT('/img/accounts/', account_image, 't.jpg'),
'/img/site/d_man.gif') as user_img
FROM
`m_wejourn__PAGE`
LEFT JOIN `m_wejourn__ACCOUNT` on `m_wejourn__PAGE`.`account_id` = `m_wejourn__ACCOUNT`.`account_id`
LEFT JOIN `m_wejourn__CATEGORY` on `m_wejourn__CATEGORY`.`category_id` = `m_wejourn__PAGE`.`category_id`
WHERE
(page_restrict_view = 0
) AND
page_title <> 'user_photos' AND
category_title = 'Children' AND
account_is_inactive = 0
ORDER BY
`m_wejourn__PAGE`.`updated` DESC
[1] => Array
(
)
)
)
[8] => Array
(
[file] => /home/data.new/framework/fw_DB.php
[line] => 244
[function] => execute
[class] => fw_db_interface
[type] => ->
[args] => Array
(
[0] => 7
[1] => Array
(
)
)
)
[9] => Array
(
[file] => /home/data.new/framework/fw_DB.php
[line] => 204
[function] => _raiseerror
[class] => fw_db_interface
[type] => ->
[args] => Array
(
[0] => -3
)
)
[10] => Array
(
[file] => /home/data.new/framework/fw_DB.php
[line] => 441
[function] => fw_db_error
[class] => fw_db_error
[type] => ->
[args] => Array
(
[0] =>
[1] => -3
[2] =>
[3] =>
[4] => SELECT
page_title,
CONCAT('http://', account_domain, '.familyroutes.com/p', `m_wejourn__PAGE`.page_id, '/') as page_link,
( SELECT thought_text
FROM `m_wejourn__THOUGHT` t
WHERE thought_is_approved = 1 AND
t.moderated >= 10 AND
t.page_id = `m_wejourn__PAGE`.page_id
ORDER BY created DESC LIMIT 1
) as last_thought,
( SELECT
IF (`m_wejourn__PHOTO`.`photo_file_name` <> '',
CONCAT('/img/photos/', `m_wejourn__PHOTO`.`creator_account_id`, '/', `m_wejourn__PHOTO`.`photo_file_name`, 'fh.jpg'),
`m_wejourn__PHOTO`.`photo_file_name`) as last_photo
FROM
`m_wejourn__PHOTO`, `m_wejourn__ALBUM`, `m_wejourn__ALBUM_PHOTO`
WHERE
`m_wejourn__ALBUM_PHOTO`.`album_photo_is_approved` <> 0 AND
`m_wejourn__PHOTO`.`moderated` >= 10 AND
`m_wejourn__PHOTO`.`photo_id` = `m_wejourn__ALBUM_PHOTO`.`photo_id` AND
`m_wejourn__ALBUM_PHOTO`.`album_id` = `m_wejourn__ALBUM`.`album_id` AND
`m_wejourn__ALBUM`.`page_id` = `m_wejourn__PAGE`.page_id
ORDER BY `m_wejourn__ALBUM_PHOTO`.`updated` DESC LIMIT 1
) as last_photo,
`m_wejourn__ACCOUNT`.`account_id` as user_id,
account_first_name as user_name,
IF (account_image <> '',
CONCAT('/img/accounts/', account_image, 't.jpg'),
'/img/site/d_man.gif') as user_img
FROM
`m_wejourn__PAGE`
LEFT JOIN `m_wejourn__ACCOUNT` on `m_wejourn__PAGE`.`account_id` = `m_wejourn__ACCOUNT`.`account_id`
LEFT JOIN `m_wejourn__CATEGORY` on `m_wejourn__CATEGORY`.`category_id` = `m_wejourn__PAGE`.`category_id`
WHERE
(page_restrict_view = 0
) AND
page_title <> 'user_photos' AND
category_title = 'Children' AND
account_is_inactive = 0
ORDER BY
`m_wejourn__PAGE`.`updated` DESC
)
)
[11] => Array
(
[file] => /home/data.new/framework/fw_DB.php
[line] => 896
[function] => pear_error
[class] => fw_db_error
[type] => ->
[args] => Array
(
[0] => SQL execution error
[1] => -3
[2] =>
[3] =>
[4] => Got error 28 from storage engine [nativecode=1030]: SELECT
page_title,
CONCAT('http://', account_domain, '.familyroutes.com/p', `m_wejourn__PAGE`.page_id, '/') as page_link,
( SELECT thought_text
FROM `m_wejourn__THOUGHT` t
WHERE thought_is_approved = 1 AND
t.moderated >= 10 AND
t.page_id = `m_wejourn__PAGE`.page_id
ORDER BY created DESC LIMIT 1
) as last_thought,
( SELECT
IF (`m_wejourn__PHOTO`.`photo_file_name` <> '',
CONCAT('/img/photos/', `m_wejourn__PHOTO`.`creator_account_id`, '/', `m_wejourn__PHOTO`.`photo_file_name`, 'fh.jpg'),
`m_wejourn__PHOTO`.`photo_file_name`) as last_photo
FROM
`m_wejourn__PHOTO`, `m_wejourn__ALBUM`, `m_wejourn__ALBUM_PHOTO`
WHERE
`m_wejourn__ALBUM_PHOTO`.`album_photo_is_approved` <> 0 AND
`m_wejourn__PHOTO`.`moderated` >= 10 AND
`m_wejourn__PHOTO`.`photo_id` = `m_wejourn__ALBUM_PHOTO`.`photo_id` AND
`m_wejourn__ALBUM_PHOTO`.`album_id` = `m_wejourn__ALBUM`.`album_id` AND
`m_wejourn__ALBUM`.`page_id` = `m_wejourn__PAGE`.page_id
ORDER BY `m_wejourn__ALBUM_PHOTO`.`updated` DESC LIMIT 1
) as last_photo,
`m_wejourn__ACCOUNT`.`account_id` as user_id,
account_first_name as user_name,
IF (account_image <> '',
CONCAT('/img/accounts/', account_image, 't.jpg'),
'/img/site/d_man.gif') as user_img
FROM
`m_wejourn__PAGE`
LEFT JOIN `m_wejourn__ACCOUNT` on `m_wejourn__PAGE`.`account_id` = `m_wejourn__ACCOUNT`.`account_id`
LEFT JOIN `m_wejourn__CATEGORY` on `m_wejourn__CATEGORY`.`category_id` = `m_wejourn__PAGE`.`category_id`
WHERE
(page_restrict_view = 0
) AND
page_title <> 'user_photos' AND
category_title = 'Children' AND
account_is_inactive = 0
ORDER BY
`m_wejourn__PAGE`.`updated` DESC
)
)
)