PDA

View Full Version : newbie needs help with sql error


yashmack
10-13-2009, 02:05 AM
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: 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.