EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   newbie needs help with sql error (https://www.eqemulator.org/forums/showthread.php?t=29784)

yashmack 10-13-2009 02:05 AM

newbie needs help with sql error
 
I am currently using the stickied windows server install guide here and im stuck, i try to import the load_player.sql with source c:/eqemu/peqdatabase/load_player.sql; and i get an error that it failed to open any of the sql files from the player_tables folder, error: 2

not sure what im doing wrong, it worked fine with the peqdb_rev1008.sql file so im at a loss now

thanks in advance!

blackdragonsdg 10-13-2009 02:15 AM

Before you sourced the load_player.sql did you open the file and set the correct file paths?

By default it will look something like this:

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;
source player_tables/account_rewards.sql;


But in order for it to work it should look similar to this:

source C:/Temp/player_tables/aa_timers.sql;
source C:/Temp/player_tables/account.sql;
source C:/Temp/player_tables/account_ip.sql;
source C:/Temp/player_tables/account_rewards.sql;

yashmack 10-13-2009 07:18 PM

i did that and it is working correctly now, thank you :)

im down to an error that says:
MYSQL CONNECT FAILED:
localhost
(server admin username removed)
(server admin password removed)
eqlogin (my server name)
Query failed:_

I also get a perl error that says the procedure entry point Perl_hv_common_key_len could not be located in the dynamic link library perl58.dll

Ive updated to perl 5.8 build 822 and I still get this error

ive done a search for this error and cant seem to find any soultions

again, thanks in advance :)

blackdragonsdg 10-13-2009 11:56 PM

Well your perl error is just a case of using the wrong version which is a very common problem. Use Perl v5.8.9.826 found here:
Code:

https://www.activestate.com/activeperl/downloads/
I am not an sql guru by any means but it looks like a configuration issue or it did not install properly. You can try removing your current config and entering it again but I don't know if that will fix the issue.


All times are GMT -4. The time now is 08:19 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.