Huge Problem!

Phoca Gallery - image gallery extension
phontas
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 16 Oct 2010, 13:36

Huge Problem!

Post by phontas »

aargh! This was the first time I installed Phoca Gallery and nothing seems working and now even after unintalled the component I'm having problems in my page. I explain my case below.

I succefully installed Phocagallery and faced the problem with importing tables into which I found these instuctions: https://www.phoca.cz/documents/2-phoca-g ... em-solving . I enableb debug mode and got different viwe of image load page that at the beginning. I took the php.MyAdmin connetion to my site and started looking the install.bak file ... without succes. I went to the SQL tab and triend to import .. this file, but instead PhpMyAdmin let me to choose the whole component.zip file which I imported for curiosity to see what ahhpens. I'm not so used to use PhpMyadmin or things like this. Well I got huge amount of all kinds of errore messages and then I tried to Undo what I just did --- BUT I don't now how. There's no undo or Uninstall in PhpMyadmin !!! I previed my page online and saw there was code below my page and the same code appears also Joomla BackEnd below. I tried to uninstall all the Phoca Component, but the code resist there. What to do??? Please help me, This makes me desparate!!

This is the code below my page:

Profile Information
Application afterLoad: 0.000 seconds, 0.21 MB
Application afterInitialise: 0.019 seconds, 1.26 MB
Application afterRoute: 0.022 seconds, 1.48 MB
Application afterDispatch: 0.048 seconds, 2.46 MB
Application afterRender: 0.074 seconds, 2.83 MB
Memory Usage
3015752
11 queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = '7c78ee17415d656727cc766cb08af51b'
2.
DELETE
FROM jos_session
WHERE ( time < '1287228120' )
3.
SELECT *
FROM jos_session
WHERE session_id = '7c78ee17415d656727cc766cb08af51b'
4.
UPDATE `jos_session`
SET `time`='1287229020',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:4:{s:22:\"session.client.browser\";s:112:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.10) Gecko/20100914 Firefox/3.6.10 ( .NET CLR 3.5.30729)\";s:15:\"session.counter\";i:1;s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:92:\"/var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'
WHERE session_id='7c78ee17415d656727cc766cb08af51b'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
7.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
8.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
9.
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 1
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-10-16 11:37:00' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-10-16 11:37:00' ) ) OR ( a.state = -1 ) )
10.
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='1'
11.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY position, ordering

Language Files Loaded

* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.plg_system_debug.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.com_content.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/administrator/language/en-GB/en-GB.plg_content_cdwebgallery.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.plg_content_pagebreak.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.tpl_template_tut.ini
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.mod_newsletter_subscriber_hrz.ini
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.mod_jt_slideshow.ini 1
* /var/www/userhome/maire/sites/maire.kapsi.fi/www/Ava/language/en-GB/en-GB.mod_superfishmenu.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 10081
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Huge Problem!

Post by Benno »

Hi,
I enableb debug mode
Try to disable debug mode and check your site.
Kind regards,
Benno
phontas
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 16 Oct 2010, 13:36

Re: Huge Problem!

Post by phontas »

Ha! ..was this the solution to my ..umm huge problem. Huuh could have never quessed that the debug mode could cause code like this... what is this debug mode anyway?? Thanks man, you saved my site!!!!
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 10081
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Huge Problem!

Post by Benno »

You`re welcome!
Kind regards,
Benno
Post Reply