Frustrating importing issue.

[Reynin123]

Hello all, for whatever every pet in the game was missing from my database, so I went through and created a bunch. there working fine now I tried to make a custom spell for certain classes (an item with a pet clicky rk 1,2,3 etc) And when I load the importer check SoF and click Import im getting this

Loaded DB.INI
Connected to Database OK

SPELL TABLE contains: 0 spells
SPELL TABLE contains: 215 FIELDS!

spells_us.txt contains: 21031 SPELLS
spells_us.txt contains: 172 FIELDS!

Everything Appears OK!

Importing File:Wiping Table...Done
Importing text file...FAIL!
ERROR: IMPORT ERROR!!

Any ideas whats going on? Now every spell is missing from my game -_- im about to call it quits im tired of beating my head into this. The file im trying to import is named, spells_us.txt

thanks in advance for any advice.

-Rey

[Reynin123]

note I just tried to copy n paste the entire file into a Query n run it and im getting

[Err] 2006 - MySQL server has gone away

where did it go?! grrr -.-

[trevius]

I guess you are using a custom tool for importing/exporting the spell file? Probably the one GeorgeS made? If you can't get that working, you can always use the scripts that come included with the EQEmu source. They are in the utils/scripts/ folder and are named export_spells.pl and import_spells.pl. To run them, move them into your server folder (they use the config file to get your DB info so they can connect to it), and then just run "perl import_spells.pl". They also have multiple arguments you can set to specify the table name, overwrite existing files, and so on.

[kimura]

I tried this and I am getting this

C:\EQ\EQEmuServer>perl import_spells.pl
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 5) line 3, <F> line 87.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL
ite, Sponge.
at import_spells.pl line 61

any clues?

then when I run

ppm install DBD-MySQL

C:\EQ\EQEmuServer>ppm install DBD-Mysql
Downloading DBD-mysql-4.022...redirect
Downloading DBD-mysql-4.022...failed 401 Authorization Required
ppm install failed: 401 Authorization Required

....

[rencro]

You are probably using perl 5.12 which is more than 2 releases behind Activestates current release. Activestate requires a subscription to any revisions beyond the last two releases...

You could try:

ppm gui

Edit--->Preferences-->Repositories

and a repository that may still have this package available. Try from the "suggested" list, or search google.

[HnathBST]

Originally Posted by rencro

You are probably using perl 5.12 which is more than 2 releases behind Activestates current release. Activestate requires a subscription to any revisions beyond the last two releases...

You could try:

ppm gui

Edit--->Preferences-->Repositories

and a repository that may still have this package available. Try from the "suggested" list, or search google.

**cough cough** or you could upgrade perl. I believe it'll still work with the server.


Also:
DBM-mysql is part of the DBI package so try
>ppm install DBI

[rencro]

**cough cough** or you could upgrade perl. I believe it'll still work with the server.

eqemu tried using 5.14 on windows builds but there were too many issues, and it was reverted to 5.12. 5.14 is setup for the linux builds, but 5.12 default for windows (at this time)

I believe this was part of the motivation to moving to Lua...

But you can certainly try....

[Secrets]

Originally Posted by rencro

eqemu tried using 5.14 on windows builds but there were too many issues, and it was reverted to 5.12. 5.14 is setup for the linux builds, but 5.12 default for windows (at this time)

I believe this was part of the motivation to moving to Lua...

But you can certainly try....

I fixed (hopefully) the issue with later versions of perl crashing on initializing for x64 systems. It's in latest git. Fix *may* work on x86 but I don't have an x86 environment set up.

All I know is ActivePerl 5.18.1 is working fine on x64 Windows now if you wish to compile that.

[kimura]

awesome Secrets! thanks

[kimura]

RENCRO! your suggestion worked like a charm! thanks!!