SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Errno: 140?

  1. #1
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Errno: 140?

    I am trying to setup a database, but for some reason it keeps giving me an error. The fault will probably be something simple, but I can't seem to find it.
    The error number is, as the title says, 140 and I am using this query:

    Code:
    CREATE TABLE `students` (
    
    `id` TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    `firstname` TEXT NOT NULL ,
    `lastname` TEXT NOT NULL ,
    `birthdate` DATE NOT NULL ,
    `house` TEXT NOT NULL ,
    `service` TEXT NOT NULL ,
    `phone` TEXT NOT NULL ,
    `adress` TEXT NOT NULL ,
    `email` TEXT NOT NULL ,
    `startingyear` TEXT NOT NULL ,
    `picture` TEXT NOT NULL ,
    FULLTEXT (
    `firstname` ,
    `lastname` ,
    `birthdate` ,
    `house` ,
    `service` ,
    `phone` ,
    `adress` ,
    `email` ,
    `startingyear` ,
    `picture` 
    )
    )
    I am however to create simpler databases with just two fields, so the fault must be in my query.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    i have no idea

    try taking the birthdate field out of the fulltext specification

    rudy

  3. #3
    We like music. weirdbeardmt's Avatar
    Join Date
    May 2001
    Location
    Channel Islands Girth: Footlong
    Posts
    5,882
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Might be wrong, but don't you need to specify a length for your tinyint?
    I swear to drunk I'm not God.
    Matt's debating is not a crime
    Hint: Don't buy a stupid dwarf Clicky

  4. #4
    blonde.... Sarah's Avatar
    Join Date
    Jul 2001
    Location
    Berkshire, UK
    Posts
    7,442
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    congrats to r937 this works for me - so just take birthdate out of fulltext
    Code:
    CREATE TABLE students (
    id TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    firstname TEXT NOT NULL ,
    lastname TEXT NOT NULL ,
    birthdate DATE NOT NULL ,
    house TEXT NOT NULL ,
    service TEXT NOT NULL ,
    phone TEXT NOT NULL ,
    adress TEXT NOT NULL ,
    email TEXT NOT NULL ,
    startingyear TEXT NOT NULL ,
    picture TEXT NOT NULL,
    FULLTEXT (
    firstname ,
    lastname ,
    house ,
    service ,
    phone ,
    adress ,
    email ,
    startingyear, 
    picture 
    )
    )
    Regular user

  5. #5
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Aah, thanks all .


Bookmarks

Posting Permissions

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