Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2009, 02:05 AM
yashmack
Fire Beetle
 
Join Date: Oct 2009
Posts: 2
Default 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!
Reply With Quote
  #2  
Old 10-13-2009, 02:15 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

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;
Reply With Quote
  #3  
Old 10-13-2009, 07:18 PM
yashmack
Fire Beetle
 
Join Date: Oct 2009
Posts: 2
Default

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
Reply With Quote
  #4  
Old 10-13-2009, 11:56 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 656
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:37 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3