Errors when editing posts in Joomla 1.6

Sonic · Post by **Sonic** » 28 Jan 2011, 10:48

Good day.

I have Joomla! 1.6.0 Stable [ Onward ] 10-Jan-2011 23:00 GMT
and Phoca guestbook 2.0.0 Beta3

When i try to edit post fron Back-end all fields are empty and it says:

Code: Select all

Check-out failed with the following error: The database row is empty.

Notice: Trying to get property of non-object in /home/xxx/xxx/docs/administrator/components/com_phocaguestbook/views/phocaguestbookb/view.html.php on line 40

Notice: Trying to get property of non-object in /home/xxx/xxx/docs/administrator/components/com_phocaguestbook/views/phocaguestbookb/view.html.php on line 41

Notice: Trying to get property of non-object in /home/xxx/xxx/docs/administrator/components/com_phocaguestbook/views/phocaguestbookb/view.html.php on line 42

Joomla debug:

Code: Select all

Errors

The database row is empty.
Information


Backtrace

Call stack
#	Function	Location
1	JAdministrator->dispatch()	/home/xxx/xxx/docs/administrator/index.php:47
2	JComponentHelper::renderComponent()	/home/xxx/xxx/docs/administrator/includes/application.php:152
3	require_once()	/home/xxx/xxx/docs/libraries/joomla/application/component/helper.php:152
4	JController->execute()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/phocaguestbook.php:18
5	PhocaGuestbookCpController->display()	/home/xxx/xxx/docs/libraries/joomla/application/component/controller.php:629
6	JController->display()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/controller.php:51
7	PhocaGuestbookCpViewPhocaGuestbookb->display()	/home/xxx/xxx/docs/libraries/joomla/application/component/controller.php:596
8	JView->get()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/views/phocaguestbookb/view.html.php:24
9	PhocaGuestbookCpModelPhocaGuestbookb->getForm()	/home/xxx/xxx/docs/libraries/joomla/application/component/view.php:365
10	JModelForm->loadForm()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/models/phocaguestbookb.php:40
11	PhocaGuestbookCpModelPhocaGuestbookb->loadFormData()	/home/xxx/xxx/docs/libraries/joomla/application/component/modelform.php:143
12	JModelAdmin->getItem()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/models/phocaguestbookb.php:53
13	JTable->load()	/home/xxx/xxx/docs/libraries/joomla/application/component/modeladmin.php:281
The database row is empty.
Information


Backtrace

Call stack
#	Function	Location
1	JAdministrator->dispatch()	/home/xxx/xxx/docs/administrator/index.php:47
2	JComponentHelper::renderComponent()	/home/xxx/xxx/docs/administrator/includes/application.php:152
3	require_once()	/home/xxx/xxx/docs/libraries/joomla/application/component/helper.php:152
4	JController->execute()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/phocaguestbook.php:18
5	PhocaGuestbookCpController->display()	/home/xxx/xxx/docs/libraries/joomla/application/component/controller.php:629
6	JController->display()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/controller.php:51
7	PhocaGuestbookCpViewPhocaGuestbookb->display()	/home/xxx/xxx/docs/libraries/joomla/application/component/controller.php:596
8	JView->get()	/home/xxx/xxx/docs/administrator/components/com_phocaguestbook/views/phocaguestbookb/view.html.php:25
9	JModelAdmin->getItem()	/home/xxx/xxx/docs/libraries/joomla/application/component/view.php:365
10	JTable->load()	/home/xxx/xxx/docs/libraries/joomla/application/component/modeladmin.php:281
Profile Information

Application 0.001 seconds (+0.001); 0.31 MB (+0.31) - afterLoad
Application 0.046 seconds (+0.045); 2.86 MB (+2.56) - afterInitialise
Application 0.046 seconds (+0.000); 2.87 MB (+0.00) - afterRoute
Application 0.122 seconds (+0.075); 5.61 MB (+2.74) - afterDispatch
Application 0.155 seconds (+0.033); 6.16 MB (+0.55) - afterRender
Memory Usage

6.17 MB (6,465,568 Bytes)
17 Queries Logged

SELECT `data` 
  FROM `jos_session` 
  WHERE `session_id` = 'bd2a6999c85cc5dc9cc9063ddd0a2955'
DELETE 
  FROM `jos_session` 
  WHERE `time` < 1296202517
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params 
  FROM jos_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,2,3) 
  ORDER BY ordering
SELECT template, params 
  FROM jos_template_styles 
  WHERE client_id = 1 
  AND home = 1
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_phocaguestbook'
SHOW FIELDS 
  FROM jos_phocaguestbook_books
SELECT * 
  FROM jos_phocaguestbook_books 
  WHERE `id` = '4'
SELECT * 
  FROM jos_phocaguestbook_books 
  WHERE `id` = '4'
SELECT a.id AS value, a.title AS text 
  FROM jos_viewlevels AS a 
  GROUP BY a.id 
  ORDER BY a.ordering ASC,`title` ASC
SELECT extension_id AS "id", element AS "option", params, enabled 
  FROM jos_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_media'
SELECT id, title, module, position, content, showtitle, params, mm.menuid 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-01-28 08:30:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-01-28 08:30:17') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY position, ordering
SELECT COUNT(*) 
  FROM jos_messages 
  WHERE state = 0 
  AND user_id_to = 42
SELECT COUNT(session_id) 
  FROM jos_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM jos_session 
  WHERE guest = 0 
  AND client_id = 0
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1 
  ORDER BY m.lft
UPDATE `jos_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1296203397;s:18:\"session.timer.last\";i:1296203417;s:17:\"session.timer.now\";i:1296203417;s:22:\"session.client.browser\";s:132:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.10 (KHTML, like Gecko) Iron/8.0.555.0 Chrome/8.0.555.0 Safari/534.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:18:\"com_phocaguestbook\";O:8:\"stdClass\":1:{s:15:\"phocaguestbooks\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:7:\"uc.name\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"Sonic\";s:5:\"email\";s:18:\"supersonic45@ya.ru\";s:8:\"password\";s:65:\"8048c61f377c2dda0838f129ebef9af3:7SVEQLV7qfDHEdpSDnkqvOHXbO5KdH1N\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-01-11 10:55:09\";s:13:\"lastvisitDate\";s:19:\"2011-01-28 08:29:57\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:96:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:4:\"none\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8613e2ca9af65a18033baec7f9a9fb82\";}',	 `time` = 1296203417 
  WHERE `session_id` = 'bd2a6999c85cc5dc9cc9063ddd0a2955'
13 Query Types Logged, Sorted by Occurrences DESC

SELECT Tables:

3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
2 × SELECT COUNT(session_id) FROM jos_session
2 × SELECT * FROM jos_phocaguestbook_books
1 × SELECT folder AS type, element AS name, params FROM jos_extensions
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT COUNT(*) FROM jos_messages
1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
1 × SELECT `data` FROM `jos_session`
1 × SELECT a.id AS value, a.title AS text FROM jos_viewlevels AS a GROUP BY a.id
1 × SELECT template, params FROM jos_template_styles
OTHER Tables:

1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1296203397;s:18:\"session.timer.last\";i:1296203417;s:17:\"session.timer.now\";i:1296203417;s:22:\"session.client.browser\";s:132:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/534.10 (KHTML, like Gecko) Iron/8.0.555.0 Chrome/8.0.555.0 Safari/534.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:18:\"com_phocaguestbook\";O:8:\"stdClass\":1:{s:15:\"phocaguestbooks\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:7:\"uc.name\";}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:5:\"Sonic\";s:5:\"email\";s:18:\"supersonic45@ya.ru\";s:8:\"password\";s:65:\"8048c61f377c2dda0838f129ebef9af3:7SVEQLV7qfDHEdpSDnkqvOHXbO5KdH1N\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-01-11 10:55:09\";s:13:\"lastvisitDate\";s:19:\"2011-01-28 08:29:57\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:96:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:4:\"none\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8613e2ca9af65a18033baec7f9a9fb82\";}', `time` = 1296203417
1 × SHOW FIELDS FROM jos_phocaguestbook_book
1 × DELETE FROM `jos_session`

When i click "Cancel" on that page, it says: "You are not permitted to use that link to directly access that page (#4)."

And When i try to add new post from Back-end, it adds new guestbook, not new post. But if i add post from Front-end all ok.

Also sometimes when after adding post from Front-end, in Back-end this post displayed as unpublished, but stil visible from Front-end.

Can anyone help me?

Post by **Jan** » 29 Jan 2011, 16:18

Hi, thank you for this info. I will take a look at it. But this seems like some problem with Joomla! security features (e.g. opening the item to edit it in other tab, etc.

)

Jan

Phoca Forum

Errors when editing posts in Joomla 1.6

Errors when editing posts in Joomla 1.6

Re: Errors when editing posts in Joomla 1.6