[RELEASE] 3.1 Mangos Repack

[che]

@bung: Well no 3.0 or 3.1 items in yet ... look at some pages back ... someone posted some sql's for some 3.0 items.

@caca: If item is turned grey try relogging then it should be ok again

@mitchell: look on google for howto guide arcemu ... there are a lot already posted. Also on this forum i think.

[_DEFiANT]

Quick question..
What is the log on to the database?

EDIT: Nevermind, found it.

[ladycrys]

quest are broken...i try to finish them but i recive only the same quest...it's a problem about script?

The server crash when i go whith ship or elevator...

Ideas for fix?

[Godzor]

looks kinda/somewhat good but i would rather wait until there's an actual real stable 3.1

[Larsj98]

can i change this 3.1.0 to 3.1.1

[demonknight16354]

i need to fine a 3.1.1 core and all the server thing i need

[bajungadustin]

-------------------------MAPS:---------------------------
1. Download the Maps Here:
And once it is done downloading, put it in your Naxp Mangos 3.1.0 "Mangos" Folder.


where?

[GFY]

spent hours on this mess last night, for one NO northrend instances work. It's buggy as hell, and has NO 3.1.0 content. This is bullshit, I'd rather downgrade and use another client.

[Mitron]

-------------------------MAPS:---------------------------
1. Download the Maps Here:
And once it is done downloading, put it in your Naxp Mangos 3.1.0 "Mangos" Folder.


where?

just inside the folder... main folder or what we call

[lobilloxxxxx]

please help me i haave a problem tu compilate sql this is message





Query:
UPDATE `character_pet`
SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4

Error occured at:2009-05-02 20:59:09
Line no.:161
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 20:59:28
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 20:59:31
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 20:59:46
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 20:59:49
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:00:24
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:01:15
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
UPDATE `character_pet`
SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4

Error occured at:2009-05-02 21:03:13
Line no.:3
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:04:01
Line no.:3
Error Code: 1146 - Table 'scriptdev2.gameobject_template' doesn't exist

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-02 21:04:19
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE TABLE custom_texts (
entry bigint NOT NULL,
content_default text NOT NULL,
content_loc1 text,
content_loc2 text,
content_loc3 text,
content_loc4 text,
content_loc5 text,
content_loc6 text,
content_loc7 text,
content_loc8 text,
sound integer DEFAULT 0 NOT NULL,
type smallint DEFAULT (0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote smallint DEFAULT (0)::smallint NOT NULL,
comment text,
PRIMARY KEY(entry)
)

Error occured at:2009-05-02 21:04:47
Line no.:18
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 '(0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote ' at line 13

Query:
CREATE TABLE custom_texts (
entry bigint NOT NULL,
content_default text NOT NULL,
content_loc1 text,
content_loc2 text,
content_loc3 text,
content_loc4 text,
content_loc5 text,
content_loc6 text,
content_loc7 text,
content_loc8 text,
sound integer DEFAULT 0 NOT NULL,
type smallint DEFAULT (0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote smallint DEFAULT (0)::smallint NOT NULL,
comment text,
PRIMARY KEY(entry)
)

Error occured at:2009-05-02 21:04:56
Line no.:18
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 '(0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote ' at line 13

Query:
DELETE FROM areatrigger_scripts WHERE entry=4560

Error occured at:2009-05-02 21:05:02
Line no.:4
Error Code: 1146 - Table 'scriptdev2.areatrigger_scripts' doesn't exist

Query:
UPDATE creature_template SET ScriptName='npc_kayra_longmane' WHERE entry=17969

Error occured at:2009-05-02 21:05:19
Line no.:1
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
UPDATE creature_template SET ScriptName='npc_kayra_longmane' WHERE entry=17969

Error occured at:2009-05-02 21:05:23
Line no.:1
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
UPDATE script_texts SET content_default='Finally, my banishment ends!' WHERE entry=-1548009

Error occured at:2009-05-02 21:06:40
Line no.:1
Error Code: 1146 - Table 'realmd.script_texts' doesn't exist

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-02 21:06:56
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:08:36
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:09:23
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:09:28
Line no.:3
Error Code: 1146 - Table 'realmd.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:09:34
Line no.:3
Error Code: 1146 - Table 'scriptdev2.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:10:03
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 21:10:23
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
DELETE FROM script_texts WHERE entry BETWEEN -1000342 AND -1000340

Error occured at:2009-05-02 22:46:45
Line no.:1
Error Code: 1146 - Table 'mangos.script_texts' doesn't exist

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-02 22:47:32
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-02 22:47:35
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-02 22:56:22
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:08:47
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:08:59
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:09:15
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:09:28
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 23:09:42
Line no.:3
Error Code: 1146 - Table 'test.gameobject_template' doesn't exist

Query:
DELETE FROM areatrigger_scripts WHERE entry=4560

Error occured at:2009-05-02 23:09:50
Line no.:4
Error Code: 1146 - Table 'test.areatrigger_scripts' doesn't exist

Query:
DELETE FROM areatrigger_scripts WHERE entry=4560

Error occured at:2009-05-02 23:09:52
Line no.:4
Error Code: 1146 - Table 'test.areatrigger_scripts' doesn't exist

Query:
DELETE FROM areatrigger_scripts WHERE entry=4560

Error occured at:2009-05-02 23:10:17
Line no.:4
Error Code: 1146 - Table 'mangos.areatrigger_scripts' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-02 23:10:26
Line no.:3
Error Code: 1146 - Table 'mangos.gameobject_template' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:24:15
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:24:22
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:24:38
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:25:01
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:25:56
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
default-character-set=latin1
default-collation=latin1_swedish_ci


Error occured at:2009-05-02 23:26:42
Line no.:3
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 'default-character-set=latin1
default-collation=latin1_swedish_ci' at line 1

Query:
default-character-set=latin1
default-collation=latin1_swedish_ci


Error occured at:2009-05-02 23:26:44
Line no.:3
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 'default-character-set=latin1
default-collation=latin1_swedish_ci' at line 1

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:27:59
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:28:12
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:28:24
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:30:27
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:30:31
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:32:14
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:33:05
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:33:08
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-05-02 23:40:44
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:17:20
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:17:52
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:18:26
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:20:09
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:20:14
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:29:34
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:31:14
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:33:40
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:41:44
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:46:54
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:47:17
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:49:19
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 13:57:36
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 14:01:24
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
UPDATE creature_template SET ScriptName='npc_myranda_the_hag' WHERE entry=11872

Error occured at:2009-05-03 14:02:56
Line no.:1
Error Code: 1146 - Table 'scriptdev2.creature_template' doesn't exist

Query:
DELETE FROM script_texts WHERE entry BETWEEN -1000342 AND -1000340

Error occured at:2009-05-03 14:03:01
Line no.:1
Error Code: 1146 - Table 'scriptdev2.script_texts' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 14:04:37
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-03 14:04:50
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-03 14:04:58
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-03 14:05:05
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE TABLE custom_texts (
entry bigint NOT NULL,
content_default text NOT NULL,
content_loc1 text,
content_loc2 text,
content_loc3 text,
content_loc4 text,
content_loc5 text,
content_loc6 text,
content_loc7 text,
content_loc8 text,
sound integer DEFAULT 0 NOT NULL,
type smallint DEFAULT (0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote smallint DEFAULT (0)::smallint NOT NULL,
comment text,
PRIMARY KEY(entry)
)

Error occured at:2009-05-03 14:05:13
Line no.:18
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 '(0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote ' at line 13

Query:
DELETE FROM areatrigger_scripts WHERE entry=4560

Error occured at:2009-05-03 14:05:17
Line no.:4
Error Code: 1146 - Table 'scriptdev2.areatrigger_scripts' doesn't exist

Query:
CREATE TABLE custom_texts (
entry bigint NOT NULL,
content_default text NOT NULL,
content_loc1 text,
content_loc2 text,
content_loc3 text,
content_loc4 text,
content_loc5 text,
content_loc6 text,
content_loc7 text,
content_loc8 text,
sound integer DEFAULT 0 NOT NULL,
type smallint DEFAULT (0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote smallint DEFAULT (0)::smallint NOT NULL,
comment text,
PRIMARY KEY(entry)
)

Error occured at:2009-05-03 14:05:20
Line no.:18
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 '(0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote ' at line 13

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-03 14:05:52
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-03 14:06:08
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
DROP TABLE eventai_scripts

Error occured at:2009-05-03 14:06:27
Line no.:3
Error Code: 1051 - Unknown table 'eventai_scripts'

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-03 14:06:32
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
CREATE TABLE custom_texts (
entry bigint NOT NULL,
content_default text NOT NULL,
content_loc1 text,
content_loc2 text,
content_loc3 text,
content_loc4 text,
content_loc5 text,
content_loc6 text,
content_loc7 text,
content_loc8 text,
sound integer DEFAULT 0 NOT NULL,
type smallint DEFAULT (0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote smallint DEFAULT (0)::smallint NOT NULL,
comment text,
PRIMARY KEY(entry)
)

Error occured at:2009-05-03 14:06:35
Line no.:18
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 '(0)::smallint NOT NULL,
language smallint DEFAULT (0)::smallint NOT NULL,
emote ' at line 13

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 14:06:43
Line no.:3
Error Code: 1146 - Table 'scriptdev2.gameobject_template' doesn't exist

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 14:07:07
Line no.:3
Error Code: 1146 - Table 'characters.gameobject_template' doesn't exist

Query:
CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

Error occured at:2009-05-03 14:07:14
Line no.:1
Error Code: 1007 - Can't create database 'scriptdev2'; database exists

Query:
UPDATE `character_pet`
SET slot = 100 WHERE PetType <> 1 AND slot >= 1 AND slot <= 4

Error occured at:2009-05-03 14:08:36
Line no.:3
Error Code: 1146 - Table 'mangos.character_pet' doesn't exist

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 14:09:07
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 14:10:36
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 15:17:38
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-03 15:18:16
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:
ALTER TABLE gameobject_template
ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name

Error occured at:2009-05-03 23:02:33
Line no.:3
Error Code: 1060 - Duplicate column name 'IconName'

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 00:10:21
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 00:16:01
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 00:26:01
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 01:42:09
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 14:01:19
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

Query:

SET FOREIGN_KEY_CHECKS=0

Error occured at:2009-05-04 14:01:21
Line no.:3
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 '
SET FOREIGN_KEY_CHECKS=0' at line 1

[neteye]

Thanks for sharing!

[coldmrn]

Does Naxx-80 10/25 work?

[anasterian94]

how can i change the build to 9835 ?

[anasterian94]

can you give me a mangos emulator for 3.1.1 build 9835

[LaAevie]

please help me i haave a problem tu compilate sql this is message

Holy ... dude, it's called [code] and it is a handy way of stopping you from spamming a the forums.

Your problems look like pretty simple ones...You didn't follow the instructions on how too insert and update your database correctly.