Pqluglist- MySQL Error, was: Thanks everyone for subscribing

Parksville-Qualicum Linux Users group mail list pqluglist at pqlug.org
Wed Sep 16 13:47:21 EDT 2009


> Hi Alfred, the error message doesn't give the actual mysql error message, so
> it's not that helpful.  Any chance you could post the structure of the
> tiki_logs table?  I might be able to figure it out from that.  You'd get the
> structure by using phpmyadmin or some such program to export the table
> structure.
> 
> Ken
> 
Hi Ken, thanks for replying. The error started after I moved the web site and
database to a new server, so I'm thinking I might just re-do the move and see if
that fixes it. Here is the structure:

tiki_logs
Field 	Type 	Null 	Default 	Comments
logId 	int(8) 	No  	  	
logtype 	varchar(20) 	No  	  	
logmessage 	text 	No  	  	
loguser 	varchar(40) 	No  	  	
logip 	varchar(200) 	Yes  	NULL  	
logclient 	text 	No  	  	
logtime 	int(14) 	No  	  	


Indexes:
Keyname 	Type 	Cardinality 	Field
PRIMARY 	PRIMARY 	1  	logId
logtype 	INDEX 	1  	logtype


Space usage:
Type 	Usage
Data 	156 	B
Index 	3,072 	B
Total 	3,228 	B
	  	Row Statistics:
Statements 	Value
Format 	dynamic
Rows 	1
Row length ø 	156
Row size  ø 	3,228 B
Creation 	Sep 15, 2009 at 04:50 AM
Last update 	Sep 15, 2009 at 04:50 AM
Last check 	Sep 15, 2009 at 12:30 PM




More information about the PQLUGlist mailing list