Page 1 of 2
problem with subcategory
Posted: 23 Mar 2015, 12:26
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'
What can be done to solve this problem?
Thx
Re: problem with dpcalendar
Posted: 26 Mar 2015, 21:44
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
Re: problem with dpcalendar
Posted: 26 Mar 2015, 22:21
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 ????
Re: problem with dpcalendar
Posted: 26 Mar 2015, 23:58
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?
Re: problem with dpcalendar
Posted: 27 Mar 2015, 08:13
by delan009
i will try to put on the php-errorlog
The server is by a provider.
Re: problem with dpcalendar
Posted: 27 Mar 2015, 16:29
by Jan
Ok
Re: problem with dpcalendar
Posted: 28 Mar 2015, 19:30
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
Re: problem with subcategory
Posted: 28 Mar 2015, 23:12
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
Re: problem with subcategory
Posted: 29 Mar 2015, 00:19
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)
Re: problem with subcategory
Posted: 29 Mar 2015, 01:54
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
Jan