Category: Logs (system & action)

Using 1.9.7 or 1.9.cvs from mid july 2007, and mysql 4.0.x

When clearing cache through "Admin > System Admin", for instance (tiki-admin_system.php?do=templates_c), I hit a warning mysql error:

{CODE(wrap=>1)}
Warning: mysql error: Duplicate entry '0' for key 1 in query:

insert into `tiki_logs` (`logtype`,`logmessage`,`loguser`,`logip`,`logclient`,`logtime`) values (?,?,?,?,?,?)


in /home/virtual/site21/fst/var/www/html/tikiwiki/lib/tikidblib.php on line 134
{CODE}

Looking at tikilog table in tiki db, I see:
^0 system erased templates_c content Xavi 161.116.71.36 Mozilla/5.0 (Windows; U; Windows NT 5.0; ca; rv:1.... 1186492878^

When I delete this record from the db, then Tiki can delete templates once (through "Admin > System Admin"), but if I attempt to do it a second time, I get the same mysql error message.

It looks as if those actions are not saved with the right logId number, but to logId=0

This happens to one of the tikis I admin at:
http://precarios.org/tikiwiki/

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

ON tiki23 at https://next.tiki.org/tiki-syslog.php when accessing to the Tiki logs from the new admin lead to a confirmation dialog (that shouldn't be here).

{img fileId="1593" thumb="box"}

{img fileId="1594" thumb="box"}

Visible on Tiki24 on next.tiki.org

Using tiki 2.1., action log + contribution feature.
Admin cannot re-set the contributors to a wiki edition, for instance.
Admin can re-set the contribution type, but not change the co-authors, and this is needed (in educational scenarios, students select no mates by mistake, and then, there is no way for the admin to re-set the author or co-autors).

Action log broken: wiki page editions not shown

Reproduced in demo.t.o/12x:

I've edited today the homepage, and yesterday somebody else did, as it can be seen in the wiki page history or the wiki last changes for the past 2 days:
* http://demo.tiki.org/12x/tiki-pagehistory.php?page=HomePage
* http://demo.tiki.org/12x/tiki-lastchanges.php?days=2

But when in the action log, nothing is reported as changed regarding wiki pages (and it's set to show wiki editions):
* http://demo.tiki.org/12x/tiki-admin_actionlog.php?startDate_Month=12&startDate_Day=02&startDate_Year=2003&Time_Hour=13&Time_Minute=00&Time_Second=18&endDate_Month=12&endDate_Day=14&endDate_Year=2003&end_Hour=13&end_Minute=00&end_Second=18&categId=&unit=bytes&contribTime=w&find=&max=25&list=Report#Report

This feature is __very important__ to be working bug-free since it's one of the easy ways to detect damage by intruders, and ban them in bulk through the action log.

----
For some reason, the day I first tested this and reported as a bug, the years were staying in the past (2003, and not 2013, ...). It seems fixed. Closing.

At the MyTiki Action Log page (a URL like tiki-admin_actionlog.php?selectedUsers%5B0%5D=admin), this message displays a number of times at the top of the page:

"Deprecated: Assigning the return value of new by reference is deprecated in ...\tiki-admin_actionlog.php on line 392"

And no results display. This is in trunk r22552, but has probably been like this for quite a while.

The action log filter Year dropdown only displays a range of 2004-2011 with no way to change it or choose another date.

{img fileId="695" thumb="y" rel="box[g]"}

Logged in nextdoc.t.o as user xavi. Interface in Spanish (in case it matters).
I went to action log interface, searched for a date range:
https://nextdoc.tiki.org/tiki-admin_actionlog.php?startDate_Month=06&startDate_Day=10&startDate_Year=2013&endDate_Month=06&endDate_Day=11&endDate_Year=2013&selectedUsers[]=&categId=&unit=bytes&contribTime=w&find=&max=50&list=Report#Report

Then I clicked at the "Options" tab, and the options tab is NOT shown.
In fact, it shows up at the very bottom of the page.

I noticed that the yellowish background of the tab "Report" does not contain the lower part related to Category and Misc. Maybe that's related to the source of the issue?

This seems to be a regression from Tiki9, since the issue is found already in tiki 10.x, it seems ( https://doc.tiki.org/tiki-admin_actionlog.php?startDate_Month=06&startDate_Day=10&startDate_Year=2013&endDate_Month=06&endDate_Day=11&endDate_Year=2013&selectedUsers[]=&categId=&unit=bytes&contribTime=w&find=&max=50&list=Report )
{img fileId="281" thumb="y" rel="box[g]"}

The action log in itself is localized via tra(), but the filter settings are not.

When you utilize Tiki's action log, you must first set which actions to record and which to review. Because the list is quite long (although some actions are inexplicably missing, like 'remove' on articles) you can filter the view.

Let's make it a use case: You want to record & review all creations and all deletions.

So you set the filter to type="All" and action="create". Then you check all checkmarks and press Ok to save.

Then you set filters to type="All" and action="remove". Then you check all checkmarks here, too and press Ok to save.

This should be it.

When you now set filters again to type="All" and action="create" you'll see that all your checkmarks have magically disappeared.

Analysis shows that when to check checkmarks on all elements on the current view, upon saving ALL those currently not viewed get saved als "unchecked", which is wrong... Those ''must'' remain unchanged!

There is only one way to deal with all elements, and that is the unfiltered list. That gets saved faithfully. This bug renders the filtered view useless for all purposes except for viewing...

Pivottable allows using activitystream as data source in Tiki19. But the edit plugin UI in Tiki doesn't allow the user to do so, it seems to be hardcoded to get some tracker in the first and compulsory field. Otherwise, it complains saying that that field is compulsory (even if you wrote activitystream in the text field), and it doesn't let you save the form.

Activity stream / Activitystream doesn't seem to be able to display changes in wiki pages.
Tested in 20.x, with admin, adding new pages from tiki profiles, and editing pages from there.

Activity stream reports no changes in wiki pages.
This might be either a bug in the feature or a problem with the documentation about the feature:
https://doc.tiki.org/tiki-index.php?page=Activity%20Stream

Reproduced here:
http://xavi-9794-6803.show2.tikiwiki.org/tiki-index.php?page=Profile_Activity_Stream
u: admin
p: 12345

The tiki-admin_actionlog.php page does not have a help icon that links to docs.

Add ip to syslog and/or action log, so that when anons (at least) are allowed to add content and it's spam (robots seem to be able to post with our current antibot captcha), there is way to identify the ip of the spammer.

So far, antibot captcha is added (in trunk, at least) to:
* wiki edit
* wiki page comments
* forum posts
* tracker item comments
* freetags
* calendar items
* newsletter subscription

The action of adding content on those features should be logged in syslog and/or action log and IP recorded.

When we have many admins on a site, it's hard to keep track of who changed what.

One admin may turn on a feature, and a second turns it off. This should be logged.


So when a change is done on tiki-admin.php, the old & new value should be available in the logs.

This will permit a "manual restore" after applying a profile.

There is currently no history of changes to categories.

Since permissions can now be restricted by categories, it is more & more important to know when an object is changed from one category to another.

Therefore, we need this info to be logged in tiki-syslog.php and to be added to the watch item feature.

Reminder: categories can be assigned in tiki-admin_categories.php but also when editing a wiki page.

I have noticed there are db errors in https://tiki.org/tiki-syslog.php like Column 'commentDate' in where clause is ambiguous ...

What is that?
Can be fixed easily?

Display Realname instead of login at the ((doc:Action Log)) for admins or non-admins with permission to see log reports (teachers seeing reports of their students, project managers seeing reports on their workers, etc)

For those cases (such as LDAP in which username can be just a numeric ID of the user but RealName is the meaningful info/name for that user) where the tiki admin chose to display Realname instead of login where possible.

Setting, for instance, at : tiki-wizard_admin.php?&stepNr=17&url=index.php (Set up User & Community features):
user_show_realnames : "Show user's real name instead of login (when possible)"

See: https://doc.tiki.org/tiki-syslog.php

{img fileId="658"}

{syntax type="tiki" editor="plain"}
Empty screen after select date range in __Admin/Action log__ and pressing __report__. Logging on __Action Log__ settings page set up correctly. I have tried different data ranges and selecting different users and groups and it combination. The result the same. Pressing __export__ instead __report__ also produces empty screen.

I had an error trying to login at dev from my iphone as well as on Chrome desktop

{img fileId="1550" thumb="box"}
{img fileId="1551" thumb="box"}

Expose ((doc:Action log)) data to the pivottable plugin. Some data can be seen through ((doc:Activity Stream)) feature, but it seems it only allows to display tracker item events, and something related to socialnetworking.

I don't know whether this means exposing the action log data to the unified search index or not, but exposing the activity in the site to admins to easily review and visualize with some charts and summary tables what's going on would be very helpful.

Hi to the readers,
I had an issue on a Tiki that I'm administrating.
This issue was that I had always the same IP address both in tiki-syslog.php and the history of a wiki page.
This happened because this Tiki installation is behind a reverse proxy.

To get the correct IPs, I had to check the "feature_loadbalancer" option in the "general" icon from the admin panel.

The strange thing about this from an user point of view is that I shouldn't expect to tick that box option as I'm not doing nothing about load-balancing. I was expecting to see an option such as "click that check-box if your Tiki installation is behind a reverse proxy".

It may be only a definition issue or a bigger bug. I don't know really and this is far away from my knowledge and skills.

Hope that helps and thanks again for this beautiful piece of software that Tiki is.

in debug mode (eg. when debugging ldap logins) many log entries are created at the same time so sorting by time is not sufficient to get the entries in their real order. Sorting by ID is better then.

Unfortunately sorting by ID leads to an unexpected result.

Looking at the code the problem can be fixed easily: The problem is that two tables are being joined (actionlog and actionlog_conf) and sorting by ID leads to sorting by actionlog_conf.id instead of actionlog.actionID.

Both needs to be fixed - in the SQL query the table for sorting must be added in the sort statement, in the template the columnname must be changed from Id to ActionId.

See patch.