Loading...
 

Category: Logs (system & action)

Logs (system & action)
Show subcategories objects

Name Type
1.9.x: mysql error: tikilog iattempts to nsert new actions in tiki_logs as logId=0, on mysql 4.0.x
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/

tracker item
changi67
Contributors
tracker item
Access to syslog display an "empty" confirmation dialog
tracker item
action log + contribution: admin should be able to edit contributors also, besides contribution type
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).
tracker item
Action log broken: wiki page editions not shown (and detecting & banning spammers much harder)
tracker item
Action log error and no results
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.
tracker item
Action Log filter Start and End date only show range 2004-2011 in dropdown
tracker item
Action log form broken in doc.t.o (fivealive theme)
tracker item
Action log: Filters not localized
tracker item
Action log: changing settings on filtered view removes checkmarks on other views
tracker item
Activity stream can't be chosen in PivotTable Plugin Edit UI
tracker item
Activity Stream doesn't display created or modified wiki pages
tracker item
Add help link to tiki-admin_actionlog.php
The tiki-admin_actionlog.php page does not have a help icon that links to docs.
tracker item
Add IP to syslog and/or action log when anons (at least) add content (for spam protection)
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.
tracker item
All preferences changes in logs
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.
tracker item
Category changes in watch and logs
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.
tracker item
Community Currencies
wiki
DB error: Column 'commentDate' in where clause is ambiguous
tracker item
Display Realname instead of login at ActionLog feature
tracker item
emails appended to tiki-syslog.php data
tracker item
Empty screen after select date range in action log and pressing report
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.
tracker item
Error after to login at dev
tracker item
Expose Action log data to the pivottable plugin
tracker item
Getting the users IP when Tiki is behind a reverse proxy
tracker item
Tiki-Log sort by ID broken
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.

tracker item
  • «
  • 1 (current)
  • 2

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Diagram
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw -superseded by Diagram
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Gantt
Group
Groupmail
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend
Terms and Conditions
Theme
TikiTests
Timesheet
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools