container settings save error - Remository Forum

Home

Forum

Remository Forum

home | post reply | threaded view | help | rules

Boardwalk :: Forum List

Remository

Joomla 1.5 and Remository

<< Start < Previous 1 2 Next > End >>

floyte

Karma: 0

container settings save error - 2011/07/30 22:21 The permission settings of containers can't be changed. Only first switch from Visitors to Registered is saved, any further change doesn't get saved in database (verified directly with SQL).
In normal mode no error is raised.

With debug=on and maximum log, a 500-error is raised (error in SQL sintax)

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ('1') AND system = 0 AND action = 'upload'' at line 1 SQL=DELETE FROM npm_permissions WHERE IN ('1') AND system = 0 AND action = 'upload'

Tried both in local (LAMPP) and online installation, Joomla 1.5.23 and remository 3.53.12J - otherwise working fine.

Post edited by: floyte, at: 2011/07/30 22:49

Post edited by: floyte, at: 2011/07/30 22:51

| | Sorry, you do not currently have permission to write here.

floyte

Karma: 0

Re:container settings save error - 2011/08/18 16:30 (I answer myself in lack of other responses..)

DELETE FROM npm_permissions WHERE IN ('1') AND system = 0 AND action = 'upload'

the SQL syntax is wrong, because the WHERE clause must contain a field name ( id , in this case I think)

In /aliro/remositoryAuthorizer.php at line 528 you read:

return "IN ('$idlist');

and the query fails. So there i put:

return "id IN ('$idlist');

The query now is right.. but the permissions don't get updated all the same!

| | Sorry, you do not currently have permission to write here.

zeed Karma: 0	Re:container settings save error - 2011/08/20 23:49 I have exactly the same problem. The changes are not recorded. I really need this to work, because there is no point of using the component without the right permissions. Anyone can help, please? Thanks
	\| \| Sorry, you do not currently have permission to write here.

Megalol Karma: 0	Re:container settings save error - 2011/08/21 14:56 I got same error as mentioned above . Upd: i found a fix. truncated in phpmyadmin jos_permissions table and now it works fine after resetting it! Post edited by: Megalol, at: 2011/08/21 15:12
	\| \| Sorry, you do not currently have permission to write here.

floyte Karma: 0	Re:container settings save error - 2011/08/21 17:47 Well, you could share the fix you found with us all... Where is it? Or you mean that's enough to truncate the table?
	\| \| Sorry, you do not currently have permission to write here.

Megalol Karma: 0	Re:container settings save error - 2011/08/21 21:57 floyte wrote: Or you mean that's enough to truncate the table? Yes, it was enough for me...
	\| \| Sorry, you do not currently have permission to write here.

<< Start < Previous 1 2 Next > End >>

Boardwalk :: Forum List Remository Joomla 1.5 and Remository

Aliroboard Forum Component 1.2
Aliro Software

Advice Notes

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Or purchase a year's support:

Recommended SEF

Who is Online

Remository welcomes guests and visitors

remository