Menu

ForGen Will Not recognize MySQL Database

Help
jmm
2007-11-13
2013-06-03
  • jmm

    jmm - 2007-11-13

    Hello

    I was installing v. 2.09 today.  Everything was going fine until I got to step 4. (database/ email info)

    When I choose yes pertaining to the option to "insert data to MySQL data table." I then  put my host name, username, password, and the database name into the required fields. 

    When I submitted this information the following response occurred in step 5:

    "thats it! now we're ready to generate your form. if you encounter any errors, please make sure that you provided the correct database information (if any), and please maintain that everything is case sensitive. also remember to give read+write permissions to the forms directory (located under the phpformgen directory). thank you.

    Now verifying MySQL database access information (some test data will be entered into the database table)...

    Could not access MySQL database with information provided."

    I looked at the database to verify all the info was correct but nothing still happened.  Could someone please help me

    Thanks,

    Lesli

     
    • TNTEverett

      TNTEverett - 2007-11-13

      It's hard to tell because the program works for so many other people without error.  Can you use the generator anyway?  Try it by accessing the generator folder with your browser.  The gui for starting your first form should appear.

       
      • jmm

        jmm - 2007-11-13

        the generator seems to work fine.  its when I attempt to put in the info for the Mysql that I have the problem.  I installed it and tried without using the db connections and worked fine. 

        What file would be responsible for connecting the db to the generator?

         
        • TNTEverett

          TNTEverett - 2007-11-14

          While generating a form the last step uses a file called process3.php to finalize the gernation of the form.  The lines below are responsible for the error message you receive.  THese are simple mysql commands that work under normal circumstances.  I suspect that maybe you are not providing the right information or there are other requirements for you sql db access. 
          You can try manually creating at least the top level db name before generating your form. 
          You should also check the following file:
          config.inc.php
          It is used to hold the db access info you have supplied when creating a form that uses sql.  See if the variables below appear in the file. 

          $link = mysql_connect($dbhostname,$dbuser,$dbpass) or die("<br /><br />Could not establish connection to MySQL database with the information provided.");
             mysql_select_db($dbname,$link) or die ("<br /><br />Could not access MySQL database with information provided.");

           
    • jmm

      jmm - 2007-11-14

      This variable does appear in the process3.php file.  I also spoke with my Host Admin who stated it's a configuration issue on my side.  My guess is it's in my logon to my sql db.

      How can I manually create a top level db name?  Also is there any way to manually go into the files to establish a connection.

      When I go to the config.inc.php file it has the following text:

      <?php
      $file_db=1

      Your help is greatly appreaciated

       
      • TNTEverett

        TNTEverett - 2007-11-14

        A file_db variable indicates you specified a file based db instead of sql.  Maybe you specified both and this can work but you will have to manage the two yourself.  Otherwise generate the form again and only chose one or the other not both.
        You can manually see your sql db using something like phpmyadmin.  This is usually a tool made available by your host. 

         
    • jmm

      jmm - 2007-11-14

      So would I add something like

      $mysql_db=1 to the config.inc.php file?

      Also, if I manually set this in phpmyadmin, how will the form gen detect this db?

       
      • TNTEverett

        TNTEverett - 2007-11-14

        Variables in the config file are automatically set by the generator.  Don't try manually modifying this file unless you understand php, sql, and the form generator code. 
        If you manually create a table byt the name "test" then during form generation if you define the table name as "test" then the last step of the form generation does not have to create the table test and it may help.  Since I am not sure what your problem is it's hard for me to guess what might be going on. 

         
    • jmm

      jmm - 2007-11-14

      Everything seems to work fine.  I have been looking at all of the files extensively for the past four days so I know where everything is.  I was looking at the process3.php where it gets into the database section.

      Do you have any suggestions about how I can manipulate the code to work with the db I set up for the generator?  I'm pretty comfortable with all the coding.  I know its a small config issue because my host provider looked at it and said he could fix it.

       
      • TNTEverett

        TNTEverett - 2007-11-14

        I don't know what to tell you since the generator works for 99.99% percent of the people using it including me.  The generator takes the data that you provide and creates new databases with tables and fields that you also define when using the generator. 
        This can fail in only 2 ways.
        1.) You provide the wrong information.
        2.) Your sql db requires something that is not accounted for in the code.

        If you follow the step by step proceedure for generating a form the generator should not have any problems unless you are running across case number 2. 

        If your provider looked at it and said that he can fix it, why didn't he either fix it or tell you what to do to fix it???

        To have the generator use a db you manually setup you just need to provide the right db name, username, and password when running the generator. 

        If can not do much else without looking at how it runs on your host. 
        It should work for you as it does for literally hundreds, if not thousands, of other users. 

         
    • jmm

      jmm - 2007-11-14

      He wants to charge me.  I believe the software works perfectly fine.  Its on my side.

      Thanks for your time

      Lesli

       
      • TNTEverett

        TNTEverett - 2007-11-14

        You are already paying him!
        I can help but I would either need lots more detail or access to your site. 
        You can try this:
        Create a simple db using phpmyadmin
        firstname
        lastname
        email
        Make note of the
        username
        password
        dbname

        Use these variables when you create a matching form with these 3 fields and see if you get past the issues you are having. 

         
    • jmm

      jmm - 2007-11-14

      No,

      He wants me to pay him.  Software support is not part of my server package.  Besides,  where's the fun in that?  I want to figure out the whys. 

      I will try this here and see if this solves the problem.  Thank you so much for your help.

       
    • jmm

      jmm - 2007-11-14

      Its not working and I know its something I'm doing. 

      What info do you need for my site?

      I appreciate your help

       
      • TNTEverett

        TNTEverett - 2007-11-14

        Send me an email through sourceforge with a link to the generator.  We can communicate further once we establish the email outside this forum.  Once we finish I would only ask that you post your experience back in the forum for others to benifit from whatever work we do. 

         
    • jmm

      jmm - 2007-11-15

      Sounds good. 

      I really appreciate the help and will gladly comment on such a helpful and insightful experience I have had on forum.

       
    • jmm

      jmm - 2007-11-15

      Do you want me to send you my database information too?

       
    • jmm

      jmm - 2007-11-15

      Thanks so much for all of your help.  It works and I learned so much.

      I will look carefully at your test db to fully understand it.

      ~All the Best

       

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.