Page 2 of 3
Re: Can't Edit or Create Menu Item
Posted: 28 Sep 2010, 03:25
by jay44
Hi again
Tried another tactic:
On another server - upgraded to Joomla version 1.5.20 (from 15), then upgraded to 2.5.7 - all fine all menu creation working as expected. > proof it does all work under j v 20
On this problem server - Installed the older version of Phoca, got the menu working.
Then tried an upgraded to the 2.7.5
This is the error:
in administrator/index.php?option=com_phocagallery&controller=phocagalleryinstall&task=upgrade
500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'userb_jo151.jos_phocagallery_user_category' doesn't exist SQL=SELECT * FROM `jos_phocagallery_user_category` LIMIT 1;
Call stack
# Function Location
1 JAdministrator->dispatch() /home/userb/public_html/test/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/userb/public_html/test/administrator/includes/application.php:136
3 require_once() /home/userb/public_html/test/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/userb/public_html/test/administrator/components/com_phocagallery/admin.phocagallery.php:40
5 PhocaGalleryCpControllerPhocaGalleryinstall->upgrade() /home/userb/public_html/test/libraries/joomla/application/component/controller.php:236
6 JDatabaseMySQL->loadResult() /home/userb/public_html/test/administrator/components/com_phocagallery/controllers/phocagalleryinstall.php:832
7 JDatabaseMySQL->query() /home/userb/public_html/test/libraries/joomla/database/database/mysql.php:355
8 JError->raiseError() /home/userb/public_html/test/libraries/joomla/database/database/mysql.php:231
9 JError->raise() /home/userb/public_html/test/libraries/joomla/error/error.php:171
10 JException->__construct() /home/userb/public_html/test/libraries/joomla/error/error.php:136
So wierd things continue to happen on this set up only!
Any suggestion please - will be much appreciated!
J
Re: Can't Edit or Create Menu Item
Posted: 28 Sep 2010, 17:26
by Jan
Hi, while installation (install and upgrade) the debug mode needs to be disabled (see the instructions for installing Phoca Gallery). Just disable debug mode for installation, install Phoca Gallery with "Upgrade" button and then enable the debug mode again.
Jan
Re: Can't Edit or Create Menu Item
Posted: 01 Oct 2010, 13:52
by bornakke
We have the same problem. Tried with two different versions of joomla.
Joomla 1.5.15 og 1.5.20
Phoca 2.7.5
PHP 5.2.10
No error - No problems with other menus or components - No nothing...
Jay44: What earlier version of Phoca did you not have any problems with?
Best regards
Tobias Bornakke
Re: Can't Edit or Create Menu Item
Posted: 02 Oct 2010, 00:00
by Jan
Hi, I still test it.
Seems like the controller in Menu Manager does not get any information about "edit" option, so the problem is before the edit (or cancel, etc.) can be run.
The difference is in the size of xml (so the problem can be the size of xml, or the count of parameters, the sent size of post data, etc.)
Please let me know, which php parameters you have set on your server (you can find info about php settings in: Joomla! administration - Help - System Info - PHP Information)
Let me know the value for this parameter:
post_max_size
Do you have enabled
suhosin extension (or similar extension) in your php settings (just try to find a string "suhosin" on the site with PHP information)?
Jan
EDIT: I have done some tests on some user's server, where the
suhosin extension is enabled.
Saving Phoca Gallery Categories View with less than 200 values is OK (e.g. Phoca Gallery 2.7.4) but saving Phoca Gallery Categories View with more than 200 values redirects to Menu Manager.
So it seems like this php settings:
suhosin.post.max_vars = 200 (value can be different, or other similar parameter)
will prevent from saving parameters where the account of parameter is higher than this value
Please check your php settings and if there is some settings or similar, try to make this value higher.
Jan
Re: Can't Edit or Create Menu Item
Posted: 02 Oct 2010, 22:42
by Jan
Re: Can't Edit or Create Menu Item
Posted: 04 Oct 2010, 08:34
by suspgr
Hey Jan many the thanks for the solution
If you may please tell us where the file is located to change the parameter setting because i am not a programmer
Re: Can't Edit or Create Menu Item
Posted: 04 Oct 2010, 18:45
by Jan
Hi, this is not setting of Phoca Gallery or settings of some code stored on your server. This settings is stored in your php.ini (maybe because there are two ways how to embed Suhosin extension). So maybe contacting your webhosting operator will be needed.
Jan
Re: Can't Edit or Create Menu Item
Posted: 07 Oct 2010, 18:49
by Wael
Hello,
I have the same problem. I asked my hosting service and they changed the php.ini (they increase the value of suhosin.post.max_vars to 250).
But still now, I have the same problem, I can't create menu for Phoca Gallery
Any suggestions?
Regards.
Re: Can't Edit or Create Menu Item
Posted: 08 Oct 2010, 14:10
by Jan
Hmmm, no idea there, maybe there is other security setting which doesn't fit the limits
Re: Can't Edit or Create Menu Item
Posted: 08 Oct 2010, 16:14
by Wael
Here my Suhosin configuration server, if that can help.
Code: Select all
This server is protected with the Suhosin Extension 0.9.27
Directive Local Value Master Value
suhosin.apc_bug_workaround Off Off
suhosin.cookie.checkraddr 0 0
suhosin.cookie.cryptdocroot On On
suhosin.cookie.cryptkey [ protected ] [ protected ]
suhosin.cookie.cryptlist no value no value
suhosin.cookie.cryptraddr 0 0
suhosin.cookie.cryptua On On
suhosin.cookie.disallow_nul 1 1
suhosin.cookie.disallow_ws 1 1
suhosin.cookie.encrypt Off Off
suhosin.cookie.max_array_depth 50 50
suhosin.cookie.max_array_index_length 64 64
suhosin.cookie.max_name_length 64 64
suhosin.cookie.max_totalname_length 256 256
suhosin.cookie.max_value_length 10000 10000
suhosin.cookie.max_vars 100 100
suhosin.cookie.plainlist no value no value
suhosin.coredump Off Off
suhosin.disable.display_errors Off Off
suhosin.executor.allow_symlink Off Off
suhosin.executor.disable_emodifier Off Off
suhosin.executor.disable_eval Off Off
suhosin.executor.eval.blacklist no value no value
suhosin.executor.eval.whitelist no value no value
suhosin.executor.func.blacklist no value no value
suhosin.executor.func.whitelist no value no value
suhosin.executor.include.blacklist no value no value
suhosin.executor.include.max_traversal 0 0
suhosin.executor.include.whitelist no value no value
suhosin.executor.max_depth 0 0
suhosin.filter.action no value no value
suhosin.get.disallow_nul 1 1
suhosin.get.disallow_ws 0 0
suhosin.get.max_array_depth 50 50
suhosin.get.max_array_index_length 64 64
suhosin.get.max_name_length 64 64
suhosin.get.max_totalname_length 256 256
suhosin.get.max_value_length 512 512
suhosin.get.max_vars 100 100
suhosin.log.file 0 0
suhosin.log.file.name no value no value
suhosin.log.phpscript 0 0
suhosin.log.phpscript.is_safe Off Off
suhosin.log.phpscript.name no value no value
suhosin.log.sapi 0 0
suhosin.log.script 0 0
suhosin.log.script.name no value no value
suhosin.log.syslog no value no value
suhosin.log.syslog.facility no value no value
suhosin.log.syslog.priority no value no value
suhosin.log.use-x-forwarded-for Off Off
suhosin.mail.protect 0 0
suhosin.memory_limit 0 0
suhosin.mt_srand.ignore On On
suhosin.multiheader Off Off
suhosin.perdir 0 0
suhosin.post.disallow_nul 1 1
suhosin.post.disallow_ws 0 0
suhosin.post.max_array_depth 50 50
suhosin.post.max_array_index_length 64 64
suhosin.post.max_name_length 64 64
suhosin.post.max_totalname_length 256 256
suhosin.post.max_value_length 65000 65000
suhosin.post.max_vars 250 250
suhosin.protectkey On On
suhosin.request.disallow_nul 1 1
suhosin.request.disallow_ws 0 0
suhosin.request.max_array_depth 50 50
suhosin.request.max_array_index_length 64 64
suhosin.request.max_totalname_length 256 256
suhosin.request.max_value_length 65000 65000
suhosin.request.max_varname_length 64 64
suhosin.request.max_vars 200 200
suhosin.server.encode On On
suhosin.server.strip On On
suhosin.session.checkraddr 0 0
suhosin.session.cryptdocroot On On
suhosin.session.cryptkey [ protected ] [ protected ]
suhosin.session.cryptraddr 0 0
suhosin.session.cryptua On On
suhosin.session.encrypt On On
suhosin.session.max_id_length 128 128
suhosin.simulation Off Off
suhosin.sql.bailout_on_error Off Off
suhosin.sql.comment 0 0
suhosin.sql.multiselect 0 0
suhosin.sql.opencomment 0 0
suhosin.sql.union 0 0
suhosin.sql.user_postfix no value no value
suhosin.sql.user_prefix no value no value
suhosin.srand.ignore On On
suhosin.stealth On On
suhosin.upload.disallow_binary 0 0
suhosin.upload.disallow_elf 1 1
suhosin.upload.max_uploads 25 25
suhosin.upload.remove_binary 0 0
suhosin.upload.verification_script no value no value