[Help] Spawning GameObjects

Results 1 to 1 of 1
  1. #1
    Apprentice knutrh is offline
    MemberRank
    May 2008 Join Date
    23Posts

    [Help] Spawning GameObjects

    When i try to spawn gameobjects, i cant see them. When i try .go select, it says that it is there, and i can delete it. How can i fix this? I havent done anything with the db, except pressing the 'show all' button.

    EDIT: I got one error when i try to execute:
    Query:
    INSERT INTO b_users (username,status) VALUES ('Guest', '0')

    Error occured at:2008-07-19 11:44:30
    Line no.:312
    Error Code: 1364 - Field 'sig' doesn't have a default value

    Query:
    CREATE TABLE b_banemails (
    emailid bigint(20) NOT NULL auto_increment,
    email varchar(255) NOT NULL default '',
    PRIMARY KEY (emailid)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2008-07-19 11:44:44
    Line no.:21
    Error Code: 1050 - Table 'b_banemails' already exists

    Query:
    CREATE TABLE b_banemails (
    emailid bigint(20) NOT NULL auto_increment,
    email varchar(255) NOT NULL default '',
    PRIMARY KEY (emailid)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2008-07-19 11:44:47
    Line no.:21
    Error Code: 1050 - Table 'b_banemails' already exists

    Query:
    INSERT INTO `b_users` VALUES ('43', '', '', '0', '0', '', '0', '0', null, 'No',


    Error occured at:2008-07-23 12:32:27
    Line no.:248
    Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

    Query:
    CREATE TABLE `b_banemails` (
    `emailid` bigint(20) NOT NULL auto_increment,
    `email` varchar(255) NOT NULL default '',
    PRIMARY KEY (`emailid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2008-07-23 12:32:53
    Line no.:18
    Error Code: 1050 - Table 'b_banemails' already exists

    Query:
    CREATE TABLE `b_banemails` (
    `emailid` bigint(20) NOT NULL auto_increment,
    `email` varchar(255) NOT NULL default '',
    PRIMARY KEY (`emailid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2008-07-23 12:32:55
    Line no.:18
    Error Code: 1050 - Table 'b_banemails' already exists

    Query:
    CREATE TABLE `b_banemails` (
    `emailid` bigint(20) NOT NULL auto_increment,
    `email` varchar(255) NOT NULL default '',
    PRIMARY KEY (`emailid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1

    Error occured at:2008-07-23 12:32:56
    Line no.:18
    Error Code: 1050 - Table 'b_banemails' already exists

    Query:
    alter table `creature_proto` add column `spell_flags` int(30) DEFAULT '0' NOT NULL after `spell4`

    Error occured at:2008-07-23 14:31:11
    Line no.:1
    Error Code: 1054 - Unknown column 'spell4' in 'creature_proto'

    Query:
    alter table `creature_proto` add column `spell_flags` int(30) DEFAULT '0' NOT NULL after `spell4`

    Error occured at:2008-07-23 14:31:29
    Line no.:1
    Error Code: 1054 - Unknown column 'spell4' in 'creature_proto'

    Query:
    alter table `creature_proto` add column `spell_flags` int(30) DEFAULT '0' NOT NULL after `spell4`

    Error occured at:2008-07-23 14:32:20
    Line no.:1
    Error Code: 1054 - Unknown column 'spell4' in 'creature_proto'

    Query:
    alter table `creature_proto` add column `spell_flags` int(30) DEFAULT '0' NOT NULL after `spell4`

    Error occured at:2008-07-23 14:32:58
    Line no.:1
    Error Code: 1054 - Unknown column 'spell4' in 'creature_proto'




Advertisement