Menu

Could not create MySQL database table.

Help
Anonymous
2004-01-01
2004-03-04
  • Anonymous

    Anonymous - 2004-01-01

    I get the following message in step 3:

    "Could not create MySQL database table. Maybe a table of the same name already exists?"

    I'm pretty sure that I have the mysql data entered correctly. I have the phpform directory in a subdirectory of a nuke site. Any ideas? Can u create a table on an existing nuke database?

     
    • Musawir Ali

      Musawir Ali - 2004-01-05

      make sure that column names you entered are valid (i.e. no spaces or any special characters in the column name)

       
    • Anonymous

      Anonymous - 2004-01-11

      I have the same problem. I'm sure, that the names of the columns and directories are valid. I have tested on LAMP and WAMP(TSW) systems. The message  is always the same.

      "Could not create MySQL database table. Maybe a table of the same name already exists?"

       
    • Anonymous

      Anonymous - 2004-01-13

      I was getting the same thing. I would check everything twice but would still get it, I think I know what the problem is....

      The problem isn't the table name, it is the field names. I'm not sure why this is....

      I would enter real information and it would reject it with that message, but when would enter in complete bullshit (ie: afghjrds) for all the field names and table column names, it wouldn't reject it. So, if I used unique names for everything, it excepted it again. (ie: profiles_name). It didn't used to do this, so I don't know what is going on. I'm guess it checks to see if you have tables already named that but also columns that already have that name. Does phpFormGen keep a log of the tables and forms it has created? Something the developer should look into.

       
      • Anonymous

        Anonymous - 2004-01-14

        You're right Jesse. I tried entering weird table and column names and it took.  You're a true hacker I must say. I'm ashamed of myself for not realizing your hacking spirit in my php/mysql ventures.

        A toast. To Jesse!!

         
    • sys admin

      sys admin - 2004-03-02

      I have tested it and it does not work
      Help !!! what code should I look at

       
    • sys admin

      sys admin - 2004-03-02

      problem discovered !!!
      The issue is with the Mysql query statement and using special characters.

       
    • Rob Brownlee

      Rob Brownlee - 2004-03-04

      Ok. Yesterday, I was having the same problem as all of you. It wouldn't create a table in the specified database I created.

      My server: Operating System: Linux; Apache Version: 1.3.29 (Unix); Kernel Version: 2.4.25-grsec; PERL Version: 5.8.1; PHP Version: 4.3.4; MySQL Version: 4.0.15-standard

      My home OS: Mac OS X

      Solution: I FTP the whole phpform folder to public_html. Accessed the phpform with https://secure?.yourserver.com/~username//phpform/

      This successfully created the form and table name in the selected MySQL database.

      Hope this helps someone.

       

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.