Menu

file database issue

Help
z_bull
2005-07-07
2013-06-03
  • z_bull

    z_bull - 2005-07-07

    Hello. I have recently started playing with the form generator. I have made some forms that work great but i'm having some trouble with my latest one. It doesn't seem to be writing and/or reading correctly to the file database.  It seems to be confusing the rows/columns. You can see a screenshot here: http://samvacca.com/images/ss.jpg
    Any ideas?

    Also when i delete a record the page doesn't refresh, it returns a blank page. But when i go back and refresh the record was deleted.

    Thanks!

     
    • TNTEverett

      TNTEverett - 2005-07-07

      Open your data.dat file and examine the syntax.  The form fields are separated by the "|" symbol, all on the first line. 
      Form entries start on the 3rd line.  Each form entry should follow the same syntax and remain on a single line per form.  Looking at the data.dat file can tell you something about when and where the error occurs.  I suspect the form is not putting entries in the data.dat file properly.  I have seen this once before.  I looked at the data.dat file and ended up modifying the form.  I eventually decided to rearrange the form and deleted, then recreated the form.  The second time around I had no issues.  Unsure why it happens but you might resolve the issue by deleting and recreating your form. 

       
    • z_bull

      z_bull - 2005-07-07

      Figured it out!  Your response triggered an idea...thanks for posting tnteverett.

      i had named one of my fields "message".  The name was conflicting with the message function in process.php. 

      It's all good now.

      mental note: never name a field "message" :)

      Thanks again.

       
    • z_bull

      z_bull - 2005-07-07

      how about getting a blank screen after deleting a record?  Isn't it supposed to just refresh the list?

      Thanks again.

       
    • TNTEverett

      TNTEverett - 2005-07-07

      Yes the admin should refresh, but.  If the data file is corrupt the delete function may fail prematurely due to unexpected fields or data.  If the delete function error handler does not quit gracefully, you get what you get.  I've never seen this behavior before so I won't attempt to explain or justify it any further.  If you care to duplicate it, you can zip up the form directory tree and I'll see what I can do to explain it or fix it. 

       

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.