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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tvnaidu
    Contributor
    • Oct 2009
    • 365

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

    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
    Recognized Expert Contributor
    • May 2008
    • 250

    #2
    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- ...?

    Comment

    • tvnaidu
      Contributor
      • Oct 2009
      • 365

      #3
      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]["networkMod e"] = "4"
      ntp[1]["timezone"] = "0"
      ntp[1]["useDefServ ers"] = "1"
      ntp[1]["server1"] = "0.us.pool.ntp. org"
      ntp[1]["autoDaylig ht"] = "0"
      ntp[1]["reSyncNtpV al"] = "120"
      ntp[1]["_ROWID_"] = "1"
      ntp[1]["server2"] = "1.us.pool.ntp. org"

      Comment

      • dgreenhouse
        Recognized Expert Contributor
        • May 2008
        • 250

        #4
        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...

        Comment

        • tvnaidu
          Contributor
          • Oct 2009
          • 365

          #5
          I can see some database questions here, that is why posted here, because php script calls DB calls. any other database group here?

          Comment

          • dgreenhouse
            Recognized Expert Contributor
            • May 2008
            • 250

            #6
            Oracle, PostgreSQL, and SQL Server...

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

            Comment

            Working...