Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

SQL error in my mangos wow page

Initiate Mage
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:
 
Skilled Illusionist
Joined
Jan 13, 2007
Messages
316
Reaction score
0
You have eroor when reg connet to MySQl. Check your Config files
PS: SHare plz this site!
 
Initiate Mage
Joined
Mar 3, 2007
Messages
48
Reaction score
0
Ok... There u go.. :) But can u please explain a bit better.. :S
 
Skilled Illusionist
Joined
Jan 13, 2007
Messages
316
Reaction score
0
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
 
Skilled Illusionist
Joined
Jan 13, 2007
Messages
316
Reaction score
0
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'
);
?>
 
Initiate Mage
Joined
Apr 23, 2006
Messages
98
Reaction score
0
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.
 
Initiate Mage
Joined
Mar 3, 2007
Messages
48
Reaction score
0
NO WAI!!!!!!!!!! Getting a new error.. :mad:

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
 
Initiate Mage
Joined
Apr 23, 2006
Messages
98
Reaction score
0
NO WAI!!!!!!!!!! Getting a new error.. :mad:

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.
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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.
 
Initiate Mage
Joined
Jan 28, 2007
Messages
62
Reaction score
0
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...
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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?
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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?
 
Initiate Mage
Joined
Dec 11, 2006
Messages
29
Reaction score
0
redownload dbcs.
maybe these are working for you
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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?
 
Initiate Mage
Joined
Dec 11, 2006
Messages
29
Reaction score
0
Which Server are you using? (Rev., where downloaded,...)
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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...
 
Initiate Mage
Joined
Apr 1, 2007
Messages
12
Reaction score
0
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
Top