Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2011
    Posts
    2

    Unanswered: Table 'WC_MESSAGE' doesn't exist

    sql file
    ---

    #
    # Struktur dari tabel `wc_advert`
    #

    DROP TABLE IF EXISTS wc_advert;
    CREATE TABLE wc_advert (
    ID tinyint(4) NOT NULL auto_increment,
    ADV_NAME varchar(16) default '',
    ADV_TYPE tinyint(1) default '0',
    ADV_ACTIVATE tinyint(1) default '0',
    ADV_WRAP tinyint(1) default '0',
    ADV_TEXT varchar(250) default '',
    COB_ID varchar(16) NOT NULL default '',
    ROOM_ID varchar(32) default '',
    CREATED_BY varchar(16) default '',
    DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (ID)
    ) TYPE=MyISAM;

    #
    # Dumping data untuk tabel `wc_advert`
    #

    INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (1, 'masterweb', 1, 1, 1, 'Visit Masterweb.or.id', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:05:20');
    INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (2, 'masterweb2', 0, 1, 1, 'Visit Masterweb.or.id', 'ITDIV', 'admin20050927095737', 'admin', '2005-09-27 11:06:28');
    INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (3, 'masterweb', 1, 1, 1, 'Visit Masterweb.or.id', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:07:58');
    INSERT INTO wc_advert (ID, ADV_NAME, ADV_TYPE, ADV_ACTIVATE, ADV_WRAP, ADV_TEXT, COB_ID, ROOM_ID, CREATED_BY, DATETIME) VALUES (4, 'masterweb2', 0, 1, 1, 'Visit Masterweb.or.id', 'HRDIV', 'admin20050927095832', 'admin', '2005-09-27 11:08:14');

    # --------------------------------------------------------

    #
    # Struktur dari tabel `wc_message`
    #

    DROP TABLE IF EXISTS wc_message;
    CREATE TABLE wc_message (
    COB_ID varchar(16) NOT NULL default '',
    USER_ID varchar(16) NOT NULL default '',
    DEST_ID varchar(16) NOT NULL default '',
    ROOM_ID varchar(32) NOT NULL default '',
    MESSAGE text NOT NULL,
    DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
    ) TYPE=MyISAM;

    #
    # Dumping data untuk tabel `wc_message`
    #


    # --------------------------------------------------------

    #
    # Struktur dari tabel `wc_room`
    #

    DROP TABLE IF EXISTS wc_room;
    CREATE TABLE wc_room (
    COB_ID varchar(16) NOT NULL default '',
    ROOM_ID varchar(32) NOT NULL default '',
    ROOM_NAME varchar(16) NOT NULL default '',
    CREATED_BY varchar(16) NOT NULL default '',
    DATETIME datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (ROOM_ID)
    ) TYPE=MyISAM;

    #
    # Dumping data untuk tabel `wc_room`
    #

    INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('ITDIV', 'admin20050927095737', 'IT Room', 'admin', '2005-09-27 09:57:37');
    INSERT INTO wc_room (COB_ID, ROOM_ID, ROOM_NAME, CREATED_BY, DATETIME) VALUES ('HRDIV', 'admin20050927095832', 'HR Room', 'admin', '2005-09-27 09:58:32');

    # --------------------------------------------------------

    #
    # Struktur dari tabel `wc_user`
    #

    DROP TABLE IF EXISTS wc_user;
    CREATE TABLE wc_user (
    COB_ID varchar(16) NOT NULL default '',
    USER_ID varchar(16) NOT NULL default '',
    PASSWORD varchar(16) NOT NULL default '',
    EMAIL varchar(32) NOT NULL default '',
    LAST_LOGIN datetime NOT NULL default '0000-00-00 00:00:00',
    DATETIME datetime NOT NULL default '0000-00-00 00:00:00'
    ) TYPE=MyISAM;

    #
    # Dumping data untuk tabel `wc_user`
    #

    i import it via phpmyadmin, but it shows error?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so check the table does exist
    run a query in PHPMyAdmin iof yoiu must and see if the table is defiend

    if it is check tghe spelling
    checdk the capitalisaion (depedning on where you are running your MySQL server it can be case sensitive
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2011
    Posts
    2
    if i send u scrpit can u help me? i dont have a idea, how make queries etc

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    no
    the problem is on your computer, not mine
    your script shoudl have created the table, yet subsequent actiosn are saying its not there
    so you need to do some steps to find out if it is there (ie something is lying).
    so do a quick check, if you are using PHPMyAdmin there is a page which tells ou what tables are there.
    if the table exists, cherk its spelling

    if it doesnt' exists then rerun the fragemnt of script that created the missign table and wathc for any errors being reported.

    so first off
    see if the table is there, if so check the spelling if exists and the spellign is corrrect theen I suspect its going to be c capitalisation issue. forget the precise details but on some installation TableName isnt the same as tablename or TABLENAME, even though it may be displayed as Tablename.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Perhaps I am missing something from the post, you have provided us with a script. I have run this script in a test database and get no errors. When do you get the errors and what is the error message?
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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