[Help] Spawning GameObjects Ascent 

Newbie Spellweaver
Joined
May 18, 2008
Messages
9
Reaction score
0
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'
 
Back