Ok after reading up on everything, I'm trying to import SoF spells_us.txt file Deleted the Spells_New table.  Sourced in the 230_spells_table.sql then ran perl import_spells.pl and I get a grand total of 28 spells in the db and a ton of errors in the cmd screen like the following:
	Quote:
	
	
		
			
				Error loading "Corruption DoT Bonus 5" (15925) 
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r 
ow 1 at import_spells.pl line 115, <SPELLS> line 14797. 
Error loading "Corruption DoT Bonus 7" (15926) 
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r 
ow 1 at import_spells.pl line 115, <SPELLS> line 14798. 
Error loading "Corruption DoT Bonus 9" (15927) 
DBD::mysql::db do failed: Incorrect integer value: '' for column 'aoerange' at r 
ow 1 at import_spells.pl line 115, <SPELLS> line 14799. 
Error loading "Place Banner" (1592  
Spells Loaded: 28 of 14799 
Highest ID: 15928
			
		 | 
	
	
 Using SoF client
spells_us.txt from the SoF Client
sourced in the 230_spells_table.sql
copy the import_spells.pl from a fresh download of the Trunk
perl import_spells.pl and get the above errors (more than it listed of course)
Import_spells working for SoF spells_us.txt ? or am I missing something that if it was a snake it would have bit me twice?
I even sourced in a fresh DB and copied the Structure only from it to my DB and still get the same errors as I did when I sourced in the 230_spells_table.sql.