Go Back   EQEmulator Home > EQEmulator Forums > Support > Spell Support
Reload this Page Importing/Exporting Spell File?

Spell Support Broken Spells? Want them Fixed? Request it here.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 01-02-2011, 04:15 PM
Hateborne
Hill Giant
  
Join Date: May 2010
Posts: 125
Default
Wow, hateful.

Code:
[Msg] [Imp] Import start
[Msg] [Imp] Import type - Text file
[Msg] [Imp] Import from - C:\eqemu\spells_us.txt
[Err] [Imp] Cannot create table [spells_us]: 1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs
[Err] [Imp] CREATE TABLE `spells_us` (`0` varchar(255),`f2` varchar(255),`BLUE_TRAIL` varchar(255),`f4` varchar(255),`f5` varchar(255),`f6` varchar(255),`f7` varchar(255),`f8` varchar(255),`f9` varchar(255),`01` varchar(255),`02` varchar(255),`03` varchar(255),`04` varchar(255),`05` varchar(255),`06` varchar(255),`07` varchar(255),`7` varchar(255),`65` varchar(255),`08` varchar(255),`09` varchar(255),`010` varchar(255),`011` varchar(255),`012` varchar(255),`013` varchar(255),`014` varchar(255),`015` varchar(255),`016` varchar(255),`017` varchar(255),`018` varchar(255),`019` varchar(255),`020` varchar(255),`021` varchar(255),`022` varchar(255),`023` varchar(255),`024` varchar(255),`025` varchar(255),`026` varchar(255),`027` varchar(255),`028` varchar(255),`029` varchar(255),`030` varchar(255),`031` varchar(255),`032` varchar(255),`033` varchar(255),`034` varchar(255),`035` varchar(255),`036` varchar(255),`037` varchar(255),`038` varchar(255),`039` varchar(255),`040` varchar(255),`041` varchar(255),`042` varchar(255),`043` varchar(255),`044` varchar(255),`045` varchar(255),`046` varchar(255),`047` varchar(255),`-1` varchar(255),`-11` varchar(255),`-12` varchar(255),`-13` varchar(255),`1` varchar(255),`11` varchar(255),`12` varchar(255),`13` varchar(255),`-14` varchar(255),`-15` varchar(255),`-16` varchar(255),`-17` varchar(255),`100` varchar(255),`1001` varchar(255),`1002` varchar(255),`1003` varchar(255),`1004` varchar(255),`1005` varchar(255),`1006` varchar(255),`1007` varchar(255),`1008` varchar(255),`1009` varchar(255),`10010` varchar(255),`10011` varchar(255),`048` varchar(255),`049` varchar(255),`050` varchar(255),`051` varchar(255),`254` varchar(255),`2541` varchar(255),`2542` varchar(255),`2543` varchar(255),`2544` varchar(255),`2545` varchar(255),`2546` varchar(255),`2547` varchar(255),`2548` varchar(255),`2549` varchar(255),`25410` varchar(255),`25411` varchar(255),`2` varchar(255),`052` varchar(255),`52` varchar(255),`-18` varchar(255),`053` varchar(255),`054` varchar(255),`255` varchar(255),`2551` varchar(255),`2552` varchar(255),`2553` varchar(255),`2554` varchar(255),`2555` varchar(255),`2556` varchar(255),`2557` varchar(255),`2558` varchar(255),`2559` varchar(255),`25510` varchar(255),`25511` varchar(255),`25512` varchar(255),`25513` varchar(255),`25514` varchar(255),`25515` varchar(255),`44` varchar(255),`131` varchar(255),`055` varchar(255),`-19` varchar(255),`056` varchar(255),`057` varchar(255),`058` varchar(255),`059` varchar(255),`060` varchar(255),`061` varchar(255),`062` varchar(255),`063` varchar(255),`064` varchar(255),`065` varchar(255),`066` varchar(255),`067` varchar(255),`068` varchar(255),`069` varchar(255),`070` varchar(255),`071` varchar(255),`072` varchar(255),`073` varchar(255),`10012` varchar(255),`074` varchar(255),`161` varchar(255),`075` varchar(255),`076` varchar(255),`-150` varchar(255),`077` varchar(255),`078` varchar(255),`079` varchar(255),`080` varchar(255),`081` varchar(255),`082` varchar(255),`083` varchar(255),`084` varchar(255),`085` varchar(255),`086` varchar(255),`087` varchar(255),`088` varchar(255),`089` varchar(255),`090` varchar(255),`091` varchar(255),`10013` varchar(255),`092` varchar(255),`093` varchar(255),`094` varchar(255),`095` varchar(255),`096` varchar(255),`097` varchar(255),`098` varchar(255),`099` varchar(255),`0100` varchar(255),`0101` varchar(255),`0102` varchar(255),`0103` varchar(255),`0104` varchar(255),`-1501` varchar(255),`10014` varchar(255),`-1502` varchar(255),`-99` varchar(255),`71` varchar(255),`651` varchar(255),`0105` varchar(255),`0106` varchar(255),`0107` varchar(255),`0108` varchar(255),`0109` varchar(255),`0110` varchar(255),`0111` varchar(255),`0112` varchar(255),`0113` varchar(255),`0114` varchar(255),`0115` varchar(255),`0116` varchar(255),`0117` varchar(255),`0118` varchar(255),`0119` varchar(255),`0120` varchar(255),`14` varchar(255),`0121` varchar(255),`0122` varchar(255),`0123` varchar(255))
[Msg] [Imp] Processed:0, Added:0, Updated:0, Deleted:0, Errors:0
[Msg] [Imp] Finished - Unsuccessfully
--------------------------------------------------
Code:
LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\eqemu\\spells_us.txt' INTO TABLE `peq`.`spells_new` CHARACTER SET latin1 FIELDS TERMINATED BY '^' LINES TERMINATED BY '\r\n' (`id`, `name`, `player_1`, `teleport_zone`, `you_cast`, `other_casts`, `cast_on_you`, `cast_on_other`, `spell_fades`, `range`, `aoerange`, `pushback`, `pushup`, `cast_time`, `recovery_time`, `recast_time`, `buffdurationformula`, `buffduration`, `AEDuration`, `mana`, `effect_base_value1`, `effect_base_value2`, `effect_base_value3`, `effect_base_value4`, `effect_base_value5`, `effect_base_value6`, `effect_base_value7`, `effect_base_value8`, `effect_base_value9`, `effect_base_value10`, `effect_base_value11`, `effect_base_value12`, `effect_limit_value1`, `effect_limit_value2`, `effect_limit_value3`, `effect_limit_value4`, `effect_limit_value5`, `effect_limit_value6`, `effect_limit_value7`, `effect_limit_value8`, `effect_limit_value9`, `effect_limit_value10`, `effect_limit_value11`, `effect_limit_value12`, `max1`, `max2`, `max3`, `max4`, `max5`, `max6`, `max7`, `max8`, `max9`, `max10`, `max11`, `max12`, `icon`, `memicon`, `components1`, `components2`, `components3`, `components4`, `component_counts1`, `component_counts2`, `component_counts3`, `component_counts4`, `NoexpendReagent1`, `NoexpendReagent2`, `NoexpendReagent3`, `NoexpendReagent4`, `formula1`, `formula2`, `formula3`, `formula4`, `formula5`, `formula6`, `formula7`, `formula8`, `formula9`, `formula10`, `formula11`, `formula12`, `LightType`, `goodEffect`, `Activated`, `resisttype`, `effectid1`, `effectid2`, `effectid3`, `effectid4`, `effectid5`, `effectid6`, `effectid7`, `effectid8`, `effectid9`, `effectid10`, `effectid11`, `effectid12`, `targettype`, `basediff`, `skill`, `zonetype`, `EnvironmentType`, `TimeOfDay`, `classes1`, `classes2`, `classes3`, `classes4`, `classes5`, `classes6`, `classes7`, `classes8`, `classes9`, `classes10`, `classes11`, `classes12`, `classes13`, `classes14`, `classes15`, `classes16`, `CastingAnim`, `TargetAnim`, `TravelType`/* large SQL query (3.1 KB), snipped at 2,000 characters */
/* 0 rows imported in 1.297 seconds. */
SHOW WARNINGS;
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 1 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 2 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 3 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 4 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 5 doesn't contain data for all columns */
/* Warning (1261): Row 6 doesn't contain data for all columns */
/* Warning (1261): Row 6 doesn't contain data for all columns */
/* Warning (1261): Row 6 doesn't contain data for all columns */
/* Warning (1261): Row 6 doesn't contain data for all columns */
I tried importing into Spell_new and even created one for spells_us just for the sake of ...well just ffs really.

-Hateborne
Reply With Quote
 

« Previous Thread | Next Thread »

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 09:13 PM.

EQEmulator - Archive - Top

 

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