problem with subcategory

Phoca Gallery - image gallery extension
Post Reply
delan009
Phoca Member
Phoca Member
Posts: 10
Joined: 23 Mar 2015, 12:20

problem with subcategory

Post by delan009 »

Hi,
I was using phoca gallery until now without problem.
Now, due gcalender was stopping, i nstalled dpcalendar.(mini)
The maincategory from logged in users are disapeared and they only can choose something else, 'the calendarnames' :x
What can be done to solve this problem?

Thx
Last edited by delan009 on 28 Mar 2015, 19:38, edited 1 time in total.
Top
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:
Contact Jan

Re: problem with dpcalendar

Post by Jan »

Hi, when you enable php error reporting, do you get any error there?
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan
If you find Phoca extensions useful, please support the project
Top
delan009
Phoca Member
Phoca Member
Posts: 10
Joined: 23 Mar 2015, 12:20

Re: problem with dpcalendar

Post by delan009 »

Thanks Jan,

I have enable debug
This is the first :

SELECT folder AS type, element AS name, params

FROM pog30_extensions

WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)

ORDER BY ordering
Verklaren
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE pog30_extensions ref extension extension 62 const 90 Using where; Gebruikt bestandssortering
Profiel
Gestapelde oproeplijst

I see index key missing (several times)
The second is :

SELECT *

FROM pog30_languages

WHERE published=1

ORDER BY ordering ASC
Verklaren
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE pog30_languages ALL NULL INDEX KEY ONTBREEKT NULL NULL 2 Using where; Gebruikt bestandssortering
Profiel
Gestapelde oproeplijst

Thirth:

SELECT id, home, template, s.params

FROM pog30_template_styles as s

LEFT JOIN pog30_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id

WHERE s.client_id = 0
AND e.enabled = 1
Verklaren
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s ALL idx_template INDEX KEY ONTBREEKT NULL NULL 4 Using where
1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 303 vtiveurne2014.s.template,const 1 Using where

There are a lot more after those

So i think there is a table with wrong data ????
Top
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:
Contact Jan

Re: problem with dpcalendar

Post by Jan »

Hi, this is debug mode and it is about the database problems. But I don't see some fatal problems there. What if you enable php error reporting or see the errorLog - are there any php errors?
If you find Phoca extensions useful, please support the project
Top
delan009
Phoca Member
Phoca Member
Posts: 10
Joined: 23 Mar 2015, 12:20

Re: problem with dpcalendar

Post by delan009 »

i will try to put on the php-errorlog
The server is by a provider.
Top
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:
Contact Jan

Re: problem with dpcalendar

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Top
delan009
Phoca Member
Phoca Member
Posts: 10
Joined: 23 Mar 2015, 12:20

Re: problem with dpcalendar

Post by delan009 »

i couldn't access the php.ini by the provider.
So copied the map and the database from the server.
I plced on my NAS and ik worked just like on the server.

What i did :

i changed the php.ini with :

error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
display_errors = On
display_startup_errors = On

i restarted the service (telnet) with : httpd -k restart

When i go to the homepage = everyting ok
when i log on (frontend) = everything is ok

When i go to 'photos' with a new user = everything is ok

Then i make a new main category and then its go wrong.
I get a non - layouted page with data from the user, data from the main category and then for the subcategory page not found

No errors where displayed

When i look to the page source then i see the head-section and the body-section in the last part of the page????
So, my page is not starting with :
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="nl-nl" lang="nl-nl" dir="ltr">
<head>
but this is in the middle of the page ???


What can i do more to figure out what the problem is ????

Thx
Top
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:
Contact Jan

Re: problem with subcategory

Post by Jan »

Hi, hmm, hard to say. Are you not able to see the errorLog on your server? Did you test that the php error reporting is really displaying the error messages (e.g. with running some php script with fatal error)?

Jan
If you find Phoca extensions useful, please support the project
Top
delan009
Phoca Member
Phoca Member
Posts: 10
Joined: 23 Mar 2015, 12:20

Re: problem with subcategory

Post by delan009 »

an you do with something like that ???

[Sat Mar 28 15:38:16 2015] [error] [client 192.168.10.131] FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Warning: is_writable(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/services/tmp:/etc.defaults:/usr/bin/php:/usr/syno/synoman:/etc:/var/run:/volume1/@tmp/php:/var/services/web:/var/services/photo:/var/services/blog:/var/services/homes) in /volume1/web/vtivtest/libraries/joomla/filesystem/path.php on line 240, referer: 192.168.10.111/vtivtest/administrator/index.php?option=com_config
[Sat Mar 28 15:38:16 2015] [error] [client 192.168.10.131] FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Warning: is_writable(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/services/tmp:/etc.defaults:/usr/bin/php:/usr/syno/synoman:/etc:/var/run:/volume1/@tmp/php:/var/services/web:/var/services/photo:/var/services/blog:/var/services/homes) in /volume1/web/vtivtest/libraries/joomla/filesystem/path.php on line 240, referer: 192.168.10.111/vtivtest/administrator/index.php?option=com_config
[Sat Mar 28 16:05:36 2015] [error] [client 192.168.10.131] FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Fatal error: Class 'JSchemaChangeset' not found in /volume1/web/vtivtest/administrator/components/com_installer/models/database.php on line 78, referer: 192.168.10.111/vtivtest/administrator/index.php?option=com_installer
[Sat Mar 28 16:44:39 2015] [error] [client 192.168.10.131] Directory index forbidden by Options directive: /var/services/web/vtivtest/
[Sat Mar 28 17:06:36 2015] [error] [client 192.168.10.131] Directory index forbidden by Options directive: /var/services/web/vtivtest/
[Sat Mar 28 18:04:31 2015] [notice] SIGHUP received. Attempting to restart
[Sat Mar 28 18:04:31 2015] [notice] Digest: generating secret for digest authentication ...
[Sat Mar 28 18:04:31 2015] [notice] Digest: done
[Sat Mar 28 18:04:31 2015] [notice] Apache/2.2.29 (Unix) mod_fastcgi/mod_fastcgi-SNAP-0910052141 configured -- resuming normal operations
[Sat Mar 28 18:04:31 2015] [notice] FastCGI: process manager initialized (pid 18887)
Top
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:
Contact Jan

Re: problem with subcategory

Post by Jan »

Hi, you get the php fatal error here:

Class 'JSchemaChangeset' not found in /volume1/web/vtivtest/administrator/components/com_installer/models/database.php on line 78

But now there is a question if this fatal error is causing this problem - this seems like it was in past when installing something :idea: :idea:

Jan
If you find Phoca extensions useful, please support the project
Top
Post Reply

Return to “Phoca Gallery”