Wednesday, 26 February 2020
  5 Replies
  629 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.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.