Can't Edit or Create Menu Item

[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

[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

[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

[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

[Jan]

https://www.phoca.cz/news/30-phoca-news/ ... nd-suhosin

[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

[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

[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.

[Jan]

Hmmm, no idea there, maybe there is other security setting which doesn't fit the limits

[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