SQL error in my mangos wow page

Newbie Spellweaver
Joined
Mar 3, 2007
Messages
48
Reaction score
0
Hi!

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



blade.tri - SQL error in my mangos wow page - RaGEZONE Forums



Please Help! :punch:
 
In File CONFIG.PHP :
Code:
<?php
$config = array(
'template'       => 'offlike',
'lang'           => 'en',        // Default lang
'db_type'        => 'mysql',
[I][B][COLOR="#ff0000"]'db_host'        => '127.0.0.1',<<<===== THERE IP WHERE MYSQL STANDS : WAN IP\LAN IP\127.0.0.1[/COLOR][/B][/I]
'db_port'        => '3306',
'db_username'    => 'root',
[B][I][COLOR="Red"]'db_password'    => 'pass', <<<<==== THERE PUT YOUR MySQL Password[/COLOR][/I][/B]
'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
 
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]

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
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?
 
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?
 
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?
 
uhh im trying to use 1.10.2 but i guess its not working very well :P
i used the guide at
got all the stuff from there...
 
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?
 
Back