Loading...
 
Skip to main content

1.9.x: mysql error: tikilog iattempts to nsert new actions in tiki_logs as logId=0, on mysql 4.0.x

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
1.9.x: mysql error: tikilog iattempts to nsert new actions in tiki_logs as logId=0, on mysql 4.0.x
Version
1.9.x
Category
  • Usability
Feature
Database MySQL (MyISAM)
Logs (system & action)
Submitted by
Xavier de Pedro
Lastmod by
Marc Laporte
Rating
(0)
Description

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:

Copy to clipboard
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


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/Question

Importance
6
Priority
30
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1285
Created
Tuesday 07 August, 2007 14:14:44 UTC
by Unknown
LastModif
Monday 19 April, 2010 04:57:58 UTC


Show PHP error messages