SQL error in my mangos wow page

Hi!

When i am at my wow registration site, i am getting this error..



http://img111.imageshack.us/img111/6792/errorae3.jpg


Please Help! :punch:

You have eroor when reg connet to MySQl. Check your Config files
PS: SHare plz this site!

Ok... There u go.. :) But can u please explain a bit better.. :S
Beware! The site!

If you use a passwprd on your MySQL in Donfig File of YOUR website yuo must whrite your paswrod
ex. mysqlpass=*
#* - your password from Mysql server

In File CONFIG.PHP :

Code:

---

<?php
$config = array(
'template'      => 'offlike',
'lang'          => 'en',        // Default lang
'db_type'        => 'mysql',
'db_host'        => '127.0.0.1',<<<===== THERE IP WHERE MYSQL STANDS : WAN IP\LAN IP\127.0.0.1
'db_port'        => '3306',
'db_username'    => 'root',
'db_password'    => 'pass', <<<<==== THERE PUT YOUR MySQL Password
'db_name'        => 'wow_realm',
'db_encoding'    => 'CP1251'    // Very important, check your mysql "my.ini"
);

$news_forum_id = 0;            // forum id for frontpage news
$bugs_forum_id = 0;            // forum id for "bugtracker"

$templates = array('offlike');
$languages = array(
    'en' => 'English',
    'ru' => 'Russian',
    'de' => 'German',
    'hu' => 'Hungarian',
    'es' => 'Spanish'
);
?>

---

Exactly, that's where alot of your database configs take place. Make sure that's all setup properly and it should eliminate a lot of your SQL errors on the webpage.

NO WAI!!!!!!!!!! Getting a new error.. :@

SQL Error: Table 'realmd.site_settings' doesn't exist at d:\program\easyphp1-8\www\mwf_w3\core\common.php line 38

Array
(
[code] => 1146
[message] => Table 'realmd.site_settings' doesn't exist
[query] => SELECT * FROM site_settings
[context] => d:\program\easyphp1-8\www\mwf_w3\core\common.php line 38
)

What to do :S:S:S:S

Quote:

---

Originally Posted by blade.tri

NO WAI!!!!!!!!!! Getting a new error.. :@

SQL Error: Table 'realmd.site_settings' doesn't exist at d:\program\easyphp1-8\www\mwf_w3\core\common.php line 38

Array
(
[code] => 1146
[message] => Table 'realmd.site_settings' doesn't exist
[query] => SELECT * FROM site_settings
[context] => d:\program\easyphp1-8\www\mwf_w3\core\common.php line 38
)

What to do :S:S:S:S

---

Try replacing realmd.site_settings with your realmd database name.

hey ppl...
i have a question.
i think im almost done with config my mangos server but i have a problem.
every time i try to start my mangos it says this.

2007-04-01 16:53:57 MaNGOS daemon /0.6-SVN (Win32)
2007-04-01 16:53:57 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM MaNGOS community forums (Powered by Invision Power Board)
MMMMMM


2007-04-01 16:53:57 World Database: 127.0.0.1;3306;ROOT;PASS;mangos
2007-04-01 16:53:57 Connected to MySQL database at 127.0.0.1

2007-04-01 16:53:57 Login Database: 127.0.0.1;3306;ROOT;PASS;realmd
2007-04-01 16:53:57 Connected to MySQL database at 127.0.0.1

2007-04-01 16:53:57 Realm running as realm ID 1
2007-04-01 16:53:57 Using DataDir @I:\Program Files\MANGOS\MAPS\0004331.map@/ ...
2007-04-01 16:53:57 Check existing of map file '@MANGOS_MAP@/maps/0004331.map': not exist!
2007-04-01 16:53:57 ERROR:Correct *.map files not found by path '@MANGOS_MAP@/map'. Please place *.map files in directory by this path or correct DataDir value in mangosd.conf file.


i hope someone can help me.
ps, my realmd works.

The "server" cant find your maps (should be in your folder) try look in your server folder and see if "maps" are in right place...

uhh the map named MAPS is on the right place, but i guess i have a problem with the MANGOS configuration,
what do i need to place at the "DataDir" my stuff is installed on I:/Programfiles/MANGOS/MAPS. but if i type it at DataDir it wont work and i have the same error.
pls help me

i've guess i found the problem but i dont know what to do with it,
DataDir = "@What Do I Need To Type Here?@"
hope someone can help me?

just DataDir = "."

ok thnx but now i get another error thingy...

Some required *.dbc files (6 from 18) not found or not compatible:
./dbc/CreatureFamily.dbc
./dbc/ItemRandomProperties.dbc
./dbc/ItemSet.dbc (exist, but have 0 fields instead 84) Wrong client version DBC file?
./dbc/Lock.dbc
./dbc/SkillLine.dbc
./dbc/Spell.dbc (exist, but have 0 fields instead 170) Wrong client version DBC file?

redownload dbcs.
maybe these are working for you Filebeam - Free Fast File Hosting

woah that helped a lot... but im not yet done... now i need 4 files more,named:

Some required *.dbc files (4 from 18) not found or not compatible:
./dbc/AreaTable.dbc (exist, but have 0 fields instead 21) Wrong client version DBC file?
./dbc/ItemSet.dbc (exist, but have 0 fields instead 84) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 0 fields instead 170) Wrong client version DBC file?
./dbc/SpellItemEnchantment.dbc (exist, but have 0 fields instead 24) Wrong client version DBC file?

hope someone can help me?

Which Server are you using? (Rev., where downloaded,...)

uhh im trying to use 1.10.2 but i guess its not working very well :P
i used the guide at Build Your Own WoW Server
got all the stuff from there...

This Guide and its Mangos files are very outdated. Try this Guide
http://forum.ragezone.com/world-warc...-220319-2.html

Its for WoW 1.12.x.

Uhh i redowloaded the DBC Files but now i get another error...

2007-04-02 15:25:31 Realm running as realm ID 1
2007-04-02 15:25:31 Using DataDir ./ ...
2007-04-02 15:25:31 Check existing of map file './maps/0004331.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0004832.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0004832.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0013339.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0002828.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0011230.map': exist.
2007-04-02 15:25:31 Check existing of map file './maps/0013732.map': exist.
2007-04-02 15:25:31 Initialize data stores...
2007-04-02 15:25:31 ERROR:
Some required *.dbc files (3 from 18) not found or not compatible:
./dbc/AreaTable.dbc (exist, but have 0 fields instead 21) Wrong client version DBC file?
./dbc/ItemSet.dbc (exist, but have 0 fields instead 84) Wrong client version DBC file?
./dbc/Spell.dbc (exist, but have 0 fields instead 170) Wrong client version DBC file?

can someone help me?

emr i wanna make a wow 1.10.2 version just to play with friends...
and i dont understand that guide...
c ya

ok i made a 1.12.1 Server and it is working,but i have a problem, my gm commands are not working.
and nobuddy can join my server..
can i fix that?

PS. if im in the game and try to change my lvl it says this "Creature (GUID: 0) not found

pls help

Quote:

---

Originally Posted by iNViSiGOD

Try replacing realmd.site_settings with your realmd database name.

---

Where am I supposed to change to the realmd database name? I can

Error: Unable to connect to MySQL server. MySQL reported: Host 'Wow' is not allowed to connect to this MySQL server

this is my error,anyone know?
:toung:

thnx

Quote:

---

Originally Posted by Sounddead

Mine is saying SQL Error: Client does not support authentication protocol requested by server; consider upgrading MySQL client at c:\program files\easyphp1-8\www\mwf_w3\index.php line 37

Array
(
[code] => 1251
[message] => Client does not support authentication protocol requested by server; consider upgrading MySQL client
[query] => mysql_connect()
[context] => c:\program files\easyphp1-8\www\mwf_w3\index.php line 37
)

Im using Easyphp andwhen it starts up it sais that port 3306 is already inuse, then it just dosent start. could someone help me?

---

Fixed