Menu

limited error message

Help
hindipogi
2008-01-25
2013-06-03
  • hindipogi

    hindipogi - 2008-01-25

    Please help me. i'm using the latest generator. when i run install.php all i got was:

    Error! Table not be created.

    I don't have any idea why.

    please help.
    thank you.

     
    • hindipogi

      hindipogi - 2008-01-25

      i finally solved the problem, i just uninstall mysql5.0 and replace it with easyphp with mysql.

      the form is now working but it got some message:

      Notice: Undefined index: field_3 in C:\Program Files\EasyPHP 2.0b1\www\form\processor.php on line 19

      i'm new to php and i don't know how to resolve this.

      thanks.

       
      • TNTEverett

        TNTEverett - 2008-01-25

        I have no idea what easyphp is and no idea what is on line 19 of your file.  It is therefore impossible to help you. 

         
    • hindipogi

      hindipogi - 2008-01-26

      I'm sorry if I have not been clear. I'm using "easyphp" as my php server, it has mysql server too. I have used mysql5.0 but it don't create table so I use "easyphp" which I can now create the table.
      I'm testing the generated form on my computer. I can upload thru the form.php which is ok, in text and the pictures are also being saved in the files folder. but when i use upload and dropdown fields i get that error which is on top of the thank you in the confirmation page.
      sample fields:
      field_1 = name = text
      field_2 = comments = text
      field_3 is the "file upload" field = text

      the fields are populated with names and comments but the upload field which is supposed to be pictures are empty. but the uploaded pictures are stored in the "files" folder.

      when I look at the created table it is text which is supposed to be blob or something, i think?

      I hope that I made my self clear because english is not my first language, sorry for the grammar.

      php is beyond my powers. please help.

      thanks a lot.

       
    • hindipogi

      hindipogi - 2008-01-26

      this are the codes:

      session_start();
      if( ($_SESSION['security_code']==$_POST['security_code']) && (!empty($_POST['security_code'])) ) {
      // File upload handling
      if($_FILES['field_3']['name']!=''){
      $field_3_filename = "file_3_".date("sihdmY").substr($_FILES['field_3']['name'],strlen($_FILES['field_3']['name'])-4);
      if(!move_uploaded_file($_FILES['field_3']['tmp_name'], "./files/".$field_3_filename)){
      die("File " .  $_FILES['field_3']['name'] . " was not uploaded.");
      }
      }

      include("config.inc.php");
      $link = mysql_connect($db_host,$db_user,$db_pass);
      if(!$link) die ('Could not connect to database: '.mysql_error());
      mysql_select_db($db_name,$link);

      this is the line 19:

      $query = "INSERT into `".$db_table."` (field_1,field_2,field_3) VALUES ('" . $_POST['field_1'] . "','" . $_POST['field_2'] . "','" . $_POST['field_3'] . "')";

       
      • TNTEverett

        TNTEverett - 2008-01-28

        The language barrier can be a difficult thing.  In any case if you still need help it would be best if you sent the form.html and processor.php to me in an email.  I can then try the form to see if I get the same error first. 

         

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.