Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Nov 2004
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL processing format

    I am having problems with the sql database from a script I downloaded from this link

    http://jonroig.com/freecode/openautoclassifieds/

    From the phpMyAdmin console I scroll down to

    Run SQL query/queries on database and then I cut-n-paste the code below and click "go". I get the following pop-up window...

    Missing Value In The Form

    Can anyone please offer some assistance?

    ---------- SQL Code ----------

    CREATE TABLE agent_tbl_Files (id_files tinyint(3) unsigned NOT NULL auto_increment, bin_data longblob NOT NULL,description tinytext NOT NULL,filename varchar(50) NOT NULL,filesize varchar(50) NOT NULL,filetype varchar(50) NOT NULL,agentnum int(11) DEFAULT '0' NOT NULL,owner int(11) DEFAULT '0' NOT NULL,PRIMARY KEY (id_files));
    CREATE TABLE agents (id int(11) NOT NULL auto_increment,agent varchar(30),agentpass varchar(10),agenturl varchar(70),agentemail varchar(70),notes text NOT NULL,agentphone varchar(30) NOT NULL,agentcell varchar(30) NOT NULL,agentfax varchar(30) NOT NULL,PRIMARY KEY (id));

    CREATE TABLE tbl_Files (id_files tinyint(3) unsigned NOT NULL auto_increment,bin_data longblob NOT NULL,description tinytext NOT NULL,filename varchar(50) NOT NULL,filesize varchar(50) NOT NULL,filetype varchar(50) NOT NULL,owner varchar(30) NOT NULL,prop_num int(11) DEFAULT '0' NOT NULL,PRIMARY KEY (id_files));

    CREATE TABLE vehicles (id int(11) NOT NULL auto_increment,title varchar(250),city varchar(50),state varchar(20),zip varchar(20),price int(11),fulldesc text NOT NULL,type varchar(20),featured char(1),dateposted date,agent varchar(30), notes mediumtext NOT NULL,owner int(11) DEFAULT '0' NOT NULL,model varchar(30) NOT NULL, make varchar(30) NOT NULL,year year(4) DEFAULT '0000' NOT NULL,drivetrain varchar(30) NOT NULL,transmission varchar(30) NOT NULL,body varchar(30) NOT NULL,doors int(11) DEFAULT '0' NOT NULL,features text NOT NULL,stereo varchar(30) NOT NULL,color varchar(30) NOT NULL,miles int(11) DEFAULT '0' NOT NULL,opt1 char(1) DEFAULT 'N' NOT NULL,opt2 char(1) DEFAULT 'N' NOT NULL,opt3 char(1) DEFAULT 'N' NOT NULL,opt4 char(1) DEFAULT 'N' NOT NULL,opt5 char(1) DEFAULT 'N' NOT NULL,opt6 char(1) DEFAULT 'N' NOT NULL,opt7 char(1) DEFAULT 'N' NOT NULL,opt8 char(1) DEFAULT 'N' NOT NULL,opt9 char(1) DEFAULT 'N' NOT NULL,opt10 char(1) DEFAULT 'N' NOT NULL,PRIMARY KEY (id));

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    You have four table creation statements there. tell us which separate table statement is giving you the error. try one table at a time.

  • #3
    $object->toCD-R(LP); vinyl-junkie's Avatar
    Join Date
    Jun 2003
    Posts
    3,073
    Thanks
    2
    Thanked 22 Times in 22 Posts
    These SQL queries run just fine for me when I run them from phpMyAdmin. Are you sure you're not missing a step in whatever you're trying to do?
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more
    SNAP to it!

  • #4
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    That error message does strike me as being a phpmyadmin one, rather than anything to do with the SQL itself...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •