Connect with Expertise | Find Experts, Get Answers, Share Insights

Getting an error "table insert failed for eventLog" any idea what is the reason?

C
 
Join Date: Oct 2009
Posts: 298
#1: Jan 29 '10
Getting an error "table insert failed for eventLog" any idea what is the reason?, I have this table called "eventLog", earlier DB comesup, now I saved more data and I am getting the above error when it is loading tables. thanks

dgreenhouse's Avatar
E
C
 
Join Date: May 2008
Location: San Francisco
Posts: 154
#2: Jan 29 '10

re: Getting an error "table insert failed for eventLog" any idea what is the reason?


Unless this is part of an earlier thread that others might know of, there's limited information in your post that helps narrow down your problem.

0- There are a number of reasons a table insert might fail...
1- What application are you using?
2- When did it stop working?
3- Did you change anything recently that affects this application?
4- If on a hosting site, did they recently make changes to the server configuration?
5- If on a hosting site, have you gone over a pre-set database size allotment?
5- Is the database hosed?
6- ...?
C
 
Join Date: Oct 2009
Posts: 298
#3: Jan 29 '10

re: Getting an error "table insert failed for eventLog" any idea what is the reason?


It is lua script runs with database file and default configuration, I get this error, I need to sabe some log across reboots, I added new fields into defaulu file just like older fileds, I get this error, I am struggling for a week, thanks in advance.

default config file is just ascii file like below, if anybody good in DB, I would like to upload those files,

systemConfig = {}
systemConfig[1] = {}
systemConfig[1]["checksum"] = "0"
systemConfig[1]["configMinorVer"] = "0"
systemConfig[1]["configMajorVer"] = "12"
systemConfig[1]["_ROWID_"] = "1"
ntp = {}
ntp[1] = {}
ntp[1]["enabled"] = "1"
ntp[1]["networkMode"] = "4"
ntp[1]["timezone"] = "0"
ntp[1]["useDefServers"] = "1"
ntp[1]["server1"] = "0.us.pool.ntp.org"
ntp[1]["autoDaylight"] = "0"
ntp[1]["reSyncNtpVal"] = "120"
ntp[1]["_ROWID_"] = "1"
ntp[1]["server2"] = "1.us.pool.ntp.org"
dgreenhouse's Avatar
E
C
 
Join Date: May 2008
Location: San Francisco
Posts: 154
#4: Jan 30 '10

re: Getting an error "table insert failed for eventLog" any idea what is the reason?


I don't know "Lua", although it does look very inviting...

This is a PHP forum...

Might I suggest - http://www.lua.org/community.html...
C
 
Join Date: Oct 2009
Posts: 298
#5: Jan 30 '10

re: Getting an error "table insert failed for eventLog" any idea what is the reason?


I can see some database questions here, that is why posted here, because php script calls DB calls. any other database group here?
dgreenhouse's Avatar
E
C
 
Join Date: May 2008
Location: San Francisco
Posts: 154
#6: Jan 30 '10

re: Getting an error "table insert failed for eventLog" any idea what is the reason?


Oracle, PostgreSQL, and SQL Server...

Look in the /bytes/it section in the right column; second group...
Reply