Form Tools: Why Are MySQL Tables Showing As In Use?

Discussion in 'PHP' started by rhyswynne, Sep 8, 2008.

  1. #1
    Hi everybody :)

    We have been using Form Tools - http://www.formtools.org/ - to try and run multiple client forms from one location, and it's been working fairly well. However, get in this morning and the forms are not working. I check PHPMyAdmin and they say that the tables are "in use", and any check/repair/export/import operation results in a "Can't find file: '[table_name].MYI' (errno: 2)" error (with [table_name] being the name of the table).

    I've done a bit of snooping around, and feel we should reinstall this piece of software, but at the moment I'm apprehensive to do so, as we're planning to use this on a major project, but if this things falls over a lot, then it'll probably be better using something else.

    With that in mind, here's a few questions:-

    If you've used form tools before

    1. Have you seen this error before?
    2. How did you fix it?
    3. How did you stop it happening again?

    If you haven't used form tools before

    1. Do you use a similar application which grabs information from a form entry, and saves it into a back end database, and also sends emails to a specific email address (so it's like a contact form, but on top of it the contents of the form is saved into a backend database which can be exported/manipulated etc).

    Many thanks!
     
    rhyswynne, Sep 8, 2008 IP
  2. Limotek

    Limotek Peon

    Messages:
    165
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I haven't used formtools before but using the form data to send an email and add to a database is very simple and you should consider coding one yourself.

    All you really need is the mail() function and and one sql query.
     
    Limotek, Sep 8, 2008 IP