Wednesday, 26 February 2020
  5 Replies
  633 Visits
0
Votes
Undo
i have 2 joomla www pages with 1 database for both.
first www page has RW user to access to DB, and second www page has RO (read only) user to access to DB. i have installed JEvents plugin. from first page, where is RW DB user is everything OK (here i create, edit, delete events on my page), but from second page with RO DB user if i want to see (only see - view) event from calendar, there is error UPDATE command denied to user 'userRO'@'domain' for table '#__jevents_vevdetail' ... why i need UPDATE command for see/view event from calendar??

thank you form help me
5 years ago
·
#215290
0
Votes
Undo
Hello,

You will get the error as we are trying to update the hits record entry. I am a little unsure why you want to provide a read only state for a functional website.

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

5 years ago
·
#215293
0
Votes
Undo
thank you for reply. is it possible to turn of hits recording? or i must grand only updating this table with RO user for example, bud i dont know if it is possible.
and our situation ... we have 2 sites with 1 DB because - security. one "backend" site (access only from some IP adrresses - restricted area) with RW DB user for insert articles and editing ... and "frontend" site for public reading only with RO DB access. so ...
5 years ago
·
#215298
0
Votes
Undo
Hello,

You could edit the core code. But then Joomla! will likely have issues with hits too? I would suggest allowing updates by default.

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

5 years ago
·
#215300
0
Votes
Undo
and wich file (part of code) i must edit/dele to disable UPDATEing table in view/see event? i will do this after every update of course. but i need to disable any WRITE to table things in my "frontend" site :(
5 years ago
·
#215320
0
Votes
Undo
ok, i used grant update for nedded table (and column hits) for ReadOnly user and everything is running now :)
  • Page :
  • 1
There are no replies made for this post yet.