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.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.