Problem importing avatars

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bigwater
    Senior Member
    • Jan 2007
    • 592

    Problem importing avatars

    Source board: IPB 2.3.6
    Target board: Vbulletin 4.0.2 PL1
    Medium sized board, 10,300 members, 86,000 threads, 530,000 posts.
    Attachment type: file system for both
    Avatar storage: file system for both

    I'm struggling with getting avatars migrated from one to the other. If I don't tell it to import avatars, I get all of the users imported fine. If I tell it to import avatars, I get a database error on the 13th user, and exactly every 12th import after that upon doing a refresh.

    Code:
    ImpEx Database errormysql error: Invalid SQL: 
        INSERT INTO vb_customavatar
         (userid, filedata, dateline, filename, filesize, width, height,importcustomavatarid)
        VALUES
        (
         13,
         'ÿØÿà\0JFIF\0\0\0d\0d\0\0ÿì\0Ducky\0\0\0\0\0d\0\0ÿî\0&Adobe\0dÀ\0\0\0\0
    \0\0\0\0Ê\0\0*§\0\0;¼ÿÛ\0„\0ÿÂ\0\0d\0d\0ÿÄ\0\0\0\0\0\0\0\0\0\0\0\0 \0
    \0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0!\"23$1#4%\0 \0\0\0\0\0!1A\"Qaq2B#Rb3‘¡Ár’CS%±Ñ‚¢s$4ñÒ£³Td”5\0\0\0\0\0\0!1AQa\"2q‘BR ð¡±ÁÑbr#3’C$á‚¢ñ²âSc“4\0\0\0\0\0\0\0!\01AQaq‘ð¡±ÁÑáñÿÚ\0\0\0\0ŏ`;Fg-Ý¥µdþäÅéõPBVs„Ÿohúkæ—E£ Ö
    7Ÿ?š(ì­žõgíV$u@$.X`§Z•Š®ì%eE¸øë=}Sü¾ê
    ¹~8£çÏçN‘æÏZ#Âç_ A›­uûß¹uCßirÏi¸U =”§ˆš1pqë­®“4ÕZ?¶/¾kéÜ$>¹‚s–Ü˜:ÊWŒ¤>nFÐφd½q«XâÔ‰©{z²ßè8dˆlÞÑYÀø}•fålŸ.dCÇ~£ÄÄzS
    ÚŠuvkh\\¨yZ¼ÃRëà¬¤àžu\"$PxϤû? ø…¡12͵SHÿ\0;¶!^¨&£ÚncyUb3xÐís5‹}06Ê\\xß°ûÓdniñjþC ®ž0þŒÌ[—:ýãÑúW®™5¦q@Û-Ê\\¡!õY£Šmq\"ISf1]ïp­Xr+OdýÓÈߥ¦„À
    #Ù¬ý½ñœÛ)s2£Ã»·A¬”\0Ëä‹Q§Ïú9p´©º‡H®½m{ö¹s­Ì*v[«s*å¯Ô{v«¯¸t=%²745öåUån¥k…*ü_й‡{²Žã\";ywŠHeYäbŸÛ‰³È)ác€¬N‡îuðµ‡dJÝ5ŒQY´ó_ìŽíaÀC)Y\"JçìÀ:îÀùßñ
    G~à›a²hjüÑ~ôä{4\'­
    °‘=.©YcŒá$o8ýŸèóŸ$?ÿÚ\0\0֐.dÚY•ñF‰2Çc!gìVB4Ë–ªt¡ÝØN„Ÿ\\&Æ}z)—çý
    5}¯é­ÆSw a(j`êY%hH†ùd†Š¶çÚ`š–>Ç­ÔÚÚ|³üšy+¥mûíÞÓéCüYúìJ¸ÆØ›2|Šx®­6ò¾OÜt§Èfù©*Óü…HógÊF½½î÷åÿ\0‡Ê”¤of½ñº×‘‘b‰IÆã³Ú[]Âa+g€…`‰³GlÚój»›
    ê
    üµcùŸJ…¬n9]kTy[fÍS…g±l\\ÈU­ªi¾Û*õcD±r, ö$üy
    Ò%¶¿6ºF­³ÚÔÌ•‡x¬þ¨Øÿ\02øò#¢æ÷ðW¦SÁ‰^Ưb÷FÏE£ØfÖŸ·Ôouyò«ø¤ö.¥îZÞ¬ZHß+Qµ´ˆ¡8Œˆà™‘ý]Eÿ\0gLjð˹übA‰sw™Á¥¬ó_å÷£7,+Å4%%†mWâZE‰#YVî#Ép–=á–\\µIÒc…ÚMt:FüäÚ z—µ;ÄŽGtŽÄHwU0®#Ûk¶Ú]Œ]’ü°š’\\Ó#Ú
    ±$[¹¨èc¦A¢¶i­|_OûgDãZ5|{™²ì+×ܬ5ZûZ-³á¡ö:öß®(l¯´ÿ\0í7Ž¨Ó£km׍\0R6º×ÙŸâØûÆ—ønÇù¬A†,ˆ‘-.Œ¼4rë2ëIE] +óD«7!U$7­SÉeµ×c¡¦´’7öߤØԐK]®-„õ›^(ŒØ\"ÔÊ·“l[¾zZQmœcEPZ>ÃK[˜LªeÐ
    Ÿ…êòè_\'\'{§sÜüƒ~åsçû™Üåaß÷zOùî~þ7µÿÚ\0\0FõwOM†Ìp«Þ/¼
    Ñ\0@Y.\"¼nˆ\0,` hË­Y²ÆÐáqÑä
    ÇÌ=º š¤gtMs¤ÇIGŽU%â
    ¬8Ïg•
    ¦-a~“zº5‰f•îaΖ’dG¯Ÿ)Ñ5¯´º^ÓÒV©±‰ÂjFcı¢k×dÇ\'EË[~qœr.Hì5úý\\x„ÂgG±S–
    †ã&0¤sӁ
    ”iW’£Kjè&µ,
    ÈІ#Á‘q^ìkó›Ó<åk»j¹}©Á»ÁI³×g{ýg¶ìÇB·VF%{]èF?ÝZêäè¸`0‰2C!ÉÜÍü¨í›Øn{6–MœýbkY!IÅFNHÇc]éß{Ÿç¢,¹ ¬‡B×ΑÉs¶UÆ•À%|ÐÚEžª¹Ý^ƒwL\\¸Ô+ó«G›Åä‹óé‰,V|GÕíFÆ$cž `Ï‹h!«Ã‰#šýr9ø·ËôÚ·„”Ød°‚PYì²Ýøõ¿)èøíjˆEO‡p_µ‘|ìaU¹?q«–[ËÕ ^ô†vðt°l<èž-‚r+UÂz9pbêAµäqž§sNCc›È‹ÓšIDåGDÎkÛ–Å$·/G;Ó„Dò Á í§eÁi\\>(Å~B—Û}—–å^Ç&õwr¸÷›ÇÚåaãpgé›Ç>Îñzs\\›ûŒëÛþ?cÿÚ\0\0çѝSž­Hi“WA†¤wFãÜñ¨˜ÅÁ;q-dz_Ä(dý Ê°RvùŠÆµ”ÄtƒñÍ®YbÆdh,l,ZQ
    ¢+Ë&ÎÞE˜>”Žl{\0¶NÙ
    ƒ\0°älºÜ7IÝu•7ö=>;kÕ¬ UtˆòêˆlŒª¾„Å꙯jþ¶Àq³A4ù\'šuå+Þ(Çqv«´(e¯Å°K¸knG±„yû^Áì‰äÊŸ! âŠ&¦9¸©Š˜ð
    øð¼yI{aHyp+6ªÆìýÇãzÔ7G—ñ—ÑYÓ˜äΘ©Š˜ïð«ë¥8¢¡ó+3]¤öo°•írôz91ÉŠ˜©Š™)ȍÞcl®=5wéÐŽÉq£YB›ULÀ9¦j¢ãÓ1qü°Îb.§T*ámmihy‚z ù˜÷”1vÒ!L§”9¨üUGc“é†w¦µ¨yD±¯làH×h+‡ùF¹Úz¢`Q;qþ³”2Ë/N1XQN‚ô9²E•šÔjµ•Ï³C=°¤ùÑ6hC8ý¦1Š2–#Ã`Õ}£ú6…¯lVÚû™ •±Ì,|‘1NÞã*¤’¶|€¬ûr8ÕÍ’òm<héSÎêÒK1Ddf´I-ÝÍ7r}ßÇuÔwó
    ˆäGïúöìK{x¬¾[׉¹ðÿ\0G{ÇŒ~ÖßÉþ›ÿÚ\0?Š6\'²S‡ñh¦÷fWÈçSšêâš&²gÚr8Ð2ƒˆX#îåÀiÖ;\'—ñh:+Nq˜ç“P*Ø’¤ÊíÒ®
    Óß3qŠdöPŠ=“R\"S† mæó‹4—9†e:vV©îŽ¡Í×ËÄ3fc)õ!™›j¿4ýDgM!­*L¶açä ~§Ýo¥9’òå}w¦0¶ò¢K:&ÿ\0Ä#6fJxf«ô5ÅÞ„eN¿*y‡ÃÔà]7÷kÕ
    Ò¥ø|ݬ´Ó£¯G(»»éBÿ\0þ¾…‡\".t(kAs¿H‰R&pì—â”ÜJŸz‹ÖÓ®¿ú(r_ÊÎÉ—6QÒö&g¼/3‡¼qY..
    Ùp—I®‚¦0Ð]–!̍cÔà›6gÞiºz-é’ós¸ãƒÜ»!}ÖÓS[dm\'²!E!aåXÍUn&—f•]*†¨»’ ¸+³`æõ,IÒÿ\0âÀlÌh¯SÇhyˆTÀÉ—fʲ:µKN‚åolw{W»°Óþ©™x@ƒ]Û3¦Ît€o&¿&\\½üeñ…:FX^~¦:úO]×5cáMæ‚Ä\"éS2‡÷6ÛÎ׏ÓtŽg(Ø£åÎñ<Ù„‰L%MñlÜnl×<Ût›?´A£Pä¥5òÙÌuàua¨‹DBCª#ºëZ}cK`VÎHUÉ@Z€¥þ…øoú™9Û#÷&‹>Ygüáܦd‚× 07°Š•Èí/ˆªj\\VV¸AÍ;¯‚;.­§H$ÒÎЬæ|ÃÔáA°­#–V5ºJ>à„‡Pùâ·|2µf~Švš&dL5YÌ‹2ì’ÇÚ@\\gxè×UF¥­6l·9™Q=UPny—¾&WÒÏYaþÅüiŒs´TáÎӐ«¡]c¸ŒÇu•™Û£š1Ô°³“¼¯ý&×3¨7áµ´\\¼ ýà±k“rv®6ûxhF>v¡¥P¡¥CµfTÑìBü.¬)Åï”,sœæí&„D(÷!Jb $ªy½DåÃÄáÅ:P5«½¥ˆ~â2EêOJ¼Jâ+o©4³îb…A\0ðñÚA´×ÑÈoTv¥õ•ÇjÖAmnÅ7rÝ֍ÍÈž­Kb:¹Ñ¾›ê1Üô/ûŸÕÿÚ\0?-Åaä3¹‰g“µOiݐ:i:“¥v]¥5ÜŠ%õ\'^WŸ¿ÄI Æ¥%Â\'4éM\" Ž°¸©¢q‰ù¨&Œb:¬å“,Mp6Ô™ô%Ê–Ñ´á£ß©6]RØ\03™ý³2¢µBf^WݘSèâÔeOŽ ¡Lmüœç5±Â\"‡tÉl7s
    ÊNº~(¼kŠ“—Ì´H6¸ÑKµÑ×^kDì¼ê;´Ö5…Áxx
    Ïn´2òÍ¥6CÜÖËh¬ÑjÚÌ5Îø6½I“*lÙ’ÌZnÂj™SÇé÷¬GÌsÄÓëPðùò¦iƒ“]”’C±\"ç7¡;9•ú^1)—ˆ©Ä6°îõ;£›ÌœbkŒ(_BºméÔŒßs$CIóèFt÷ºm縋Ѫ4A•
    …J©E^iƒº½!p^7<Ÿx º›®çÐu¡â0b²æšÊ…Ùs›zHwù
    [URL="file://\\ŽÉeܘfôde!ù²1±ï§@X„™“o}\'¢ÆARb|š©ZZ„Ì›£&4°î»ÝΆ~C~›â~)n·ÓX«Ö"]\\ŽÉeܘfôde!ù²1±ï§@X„™“o}\'¢ÆARb|š©ZZ„Ì›£&4°î»ÝΆ~C~›â~)n·ÓX«Ö[/URL]¿
    +¿Ù¹ÞöB¸Ð§x„ǵÀì…š¯-Ú=1XR÷-×åí-k1GÓ|ãe\0zÖ\'‰Ñ|C®¨ô¬,@ösZ¥x«Ò˜0ݩ–XWt+ÃÊ…©²eÍs€æ¥#À%’Ù]6“Y×J‚¤©žšûsQ°a:Na¿V^÷Ä,˜ÝFÝbH=
    Ÿ#Bƒi:Wÿ\0AⅲɢMët¿ÝÖŽc0F+f4˦¸×wH\"ž€±®(Â6GŸ’ñÜ ´ÜÎËÜ~GKM¡›‡˜îö]­Ž´j¬(=¤;¯ÉnŅ̬vXkÍ¡º­õð³˜×卆ˆsÂlßyÀnètÂáÌ@>•øÌ~:­ÖÝÿ\0ÇíŒm­mhT å3%â,lÜ¥tÙÌl+ˆðwãÊî8ݘ9ÚéXsïÊ~‰‚NÝ+êÜ
    Óüig¾ý†zi=OÍ8f3â¨ÐÖü­öšTÌÄž¤Ùí;Du/(ó¹Çkºû:
    «ñØnâcæcݶ5&†\'Ë}!©òÆêvbVíÄ\'Çdˆ¢+h¦˜§M‘•’&ƒXhM›/qÓ!Ýæ¾5àâÏÌQ)î%Žö(>šVDm†„ÒM}i§³Q@½®¿¤\'e.j_{nKm\0ÚBˆ+‰J”×}ËÑQpÙż®æežöÅ GN„×ÉÚt¡&_ßfóm
    4ó!û›Ôu¯äèCîÆ…µÞ•µRÙª>„ì[·l[»õ!…#T«‹¹Óu|è‚ÿÚ\0?–ƒ÷ëµ)>¡ý8SLAÄW¦„çeM!nœE··À_p5SÒãíæÕ+’ÃJêõbaQ®ßÒÊ8õ§*ÿ\0V
    @+êU9^¼Em Q±Ã‡R©™Ë–#8ȪTÝJÏŸUôâR¡³k
    Z5>×3NyáÈsè¹0€q\\ÓvtôƒÕ³¦ÜûŒ¤9«D¥¥§›q$ðImÑ…ïP%»?âg¥ÌŽ¥\0‰%§\0“@:\\•pPú{å²™dsͬ‡°29ŠúpÃ)‚Ìf[´½ \0F^5c÷a(f̆kµ6Eq¼Ë¡(rN“$ûÚu+)ò»õŽ”çB3õb+0Ò¥H™’äV».õWvÜåÏ-¶B—\\Á º¾8›Ú8”É)¨9u´+ˆsÝŒâЙÍD–ÚBñžè*T„šcñZ )àô÷Øi§ÍØ«‘µÆZWLù§óãfÛ7Vìsdel8⊵¤»b.<…¥%§Q˜Ï3ô§krɱæÚÜ„ÿ\0Ó©\'\'QJ¡Ï2´&òÖY§*çÄšœhFh¢:nMÊéð¯£Á„ÊßuEÂÛjWQêR•@mÀNå¾l°Tž-?¹ÆrJ|k*¤J³†strbã}ڡ컣ÈÉrˆ0£Ýn•W¼½ŠN^
    çüØяø†.9÷n;Z¨}Õªt6þþ•1·m<Ò”üW#î-%ÔôG@§™Çâ=ª{A½¯u‹´¿flʏD=CíÚ1?~1Yuýµ¥?s€‹ÙÜ\"¦«,¿h¹+·Ù»0pG.#Ðx}IVéC‹vå$6èZîÈÒ¸p2»w¦G\\‘KUâ‚9cZPm¦›PÖ”û­ÆˆÒkÔ§¥<¦Øm>dãr{—ºlãuÜFÔ„­ö ½–ˆ*µ°Xb…€Ÿˆêj¡™9ã56Ýy-âŸÚj\0þöÜSrBÐâZ.$šV®’®#_øͺ0—uYh*¶
    7‚”\"¿
    À\0¨À}p›qH¡¡:óQNzÑY¨>‹ðÚæî¡%æSÚ;º©F\'7&× ÌÞÐÔp´Lˆà[+”8 §R¹a^ðƶÝ9Àۍ>FŒgÅ.IöTÚÁö“QÖ6Óÿ\0«“MËntš•U©€x%|<Ñ¸íÑ^mOÅgQ}Uà ’Œ¹õ`n
    Ž‰{„弍®ªRc‘ÞçpÜ
    w²Ž·„ÑO¸mQDjΔüå‚tƒ hFI$é‚ء5ä„zÎ)&IÔQÍ–k!õŸT\'ÐN[¶ýy’‹ëÓêsÞr<`Ò¢;U­Ä¥EW\0ñPåW.X %jQ´\0š’M-\0s$áˆÒ`m.颔Sî6únQ]«]¥«“w,-ø1eD} R­imÍd€+P¤þN8wEÅ%ÁT¬\0RHú®2àHÂ6­1\"‡òwÖS·ÉuC>ÁÅ\\­“rX
    GÁqT!X‹sÔV¼:ìû±oNsHMé¾Ú®¤ˆo6Zyº‘r–?ù¾ØÒ½Ç̬WËû¿Öêû4§¹í_—ž\'L2#¸£Hq
    ­EÁJ*®uQÄf:´[Ù¶&¢ŽZo¦l‡mò^à·+æœv‘rHPmÇ’äºM¤]Ä5v@sç6@î8=&‚õ+š>ãI?—ž<póKÍ0êTŸ‚G¬\\\\s-F}Ä“î¸\0_¤]Ž8C‘ß[JIF9í¿Kñ*KNʍFÚ]É%2‘ÁdŠ(+ž2æqµ6¤ûJø‚ÓúéV>bó©;Öí1
    U]i&,wœOƒnnWåÇeó=«Âîå‹­¯³[¸_îá¸Í¬¼Ð9Üš.îjË,m›¸­+šy¢$ÙÖÕ%^
    GÝ5Qÿ\0¹N,§SnÙ¯ïkOë ŠÈà<ƒs/u¡^ž(W‚Ðr#è?á;ÿ\0-XPñˆþ^¤œ¾Šã¶\'­å%e?Q¦êAWZ¸a¦ã\"ùR^jÿ\0‰!õ€…Ðz‰à á†vÈêpB…¸,‚ƒ)&‹¤ÔõJ~ç>²ñÝÓ;ëo+~®:Q^6מ$·%“*Èî™øÑd¢×’ Ç:¯q`X]P™\"’/))ks~›»Í—¿w))5eñR pgìS´4ï6¹ˆ6N=ŸMµóÇÄÛÒ²8˜3á=EŒh7TUÈI9(¯KC6Ô¾
    W«}•ZãjUWŠT28K­m’ÕpãªÓqîŠÓu~ÒAòÅÚ@ÔeÈì4ÁÁB
    ¤È]T§_VCšœRj@IÃ[÷âª+ÓZ\"
    =m´×Zöš“ºµÒØ9¢-‹“Rc<Êœ
    ap^lŠºZ¤ì/óc»±þßWK¹ÒV†¥+¥©K/õáy|6͉ð¯û1¦\0.®¡>’8á{næ•„\"ÖLÍ®Z“bäÆèu§R-}…|7Ñ‘¡ RC­†Ú×Q1–Þ¡Ú·FÓBU·H4q‡À=q]øÍׂ“CŠM‰*4„ä§\"éÉM~Ò›yÒœGLtI,Çl¡+uµ%kRÕz¹Ú1’\\ý…VbK3«®Å4ÍÉZYs«QMÚ¤•`¦3IaºÙ¯%aÕ\\MºŽ«’n©8Nñ¿ÅZÜn×ãlòR’êÖš)¹{ãi\"ÃÔÜ!Ï7¾¡uí
    râop¬TjT»ë[°ÔÊfé:Z1§KyQÒ¡‰MùŒñòŸ“£äšz:]—ò¼4téNxhT—†|ü³ð8aF´Kˆ*¯jÈáB”Iª¿[*Œ½¡ÈÍ>™ Å•öüYZc\"ã*Êä×¥B‹IÍ$/åR»7mAÝVúÙ’aoM¡ÉLJCÀcüÓ[”VªmyÀd@]?…¹ÂT¨JÒ|°ÝR¹$%¿$!’ãŽ@ÂœTWq¼kÇÔM.¬]©?ÌeÔp*µö°‰[t7§Í?9˜†õã&¹¶@ÇÚAT’·ñ)– í’­½`:µž=}&ÿ\0ž%Äl›RòŠ~ÓkêJ‡‘Þ6²÷m¼C};®Úý*š†íu•§ŠšVU¦xÿ\0æ~Y#æÚÚZV+NÛ©ÜêÒÎ֙ߞx’\\¢€P·…:Aáàªâ+͝3\"ô-+ÉIsÞêÄGÔ›BÝè*Þï¬Sˆð¤™Ev~¸é#Ƹr£Q.©ª{À“jrçžos¿j6µ\"Ä+‚M§‰®%¤±D¦‚—&<X±¤½º¹L2ÛîzÕ‰1ßMγ
    R5WĪŠ¯QÌáæV››~\"ä ì[Ƹ{uC¶ˆÌ餧­)Y%9‘ǷݵIr\\H¨D¸É5qi@UÑGôav^ÊšfÕRकPžtÏ0±¾çJ—S:Vú]õnåˆÈ=oH]Æ¿´j=xS(×¤{vz°èmöTÊNlÈrܼS\\ºNÜŒ–‘)Šgª€ž=5 ù`~ iþòCá-†óa§Ó’–UÌ’8`!M{T”ê4åŸåµme1®&¹¶“_iÞIŒÛ}¢E.¡5¶£
    9ñ>\\¸–R–¸ªóã™Ã£nÜRÞä–œ¿mxè¸ébâ¤2£ÒâˆO°!ÌV’Ú¹(qUµB¦­»õHó$&«Q`êeÞ* ½5£ÃÕ¯ñnV•þŒGÑ¥n:uám:鍿¸ö~%÷qÓ´ß~?–Öš‡îë}µû>Xs»ÿ\0C ®æë¸{¼3Ô¯|-NÆåëëû4÷)ÊïFÞi;«mÙþœIï­Õøý­~÷¹ê¶Ï<DÑ×î4‡u}ß}AêÁÖ¿Rÿ\0r·_v_Ù®Ûêw‹¯j§Ø¦$YÇ]ë«JûJ¯çÄku~WÞš{Z]弫•lá{Vϳ«ÜÓòSôcÿÚ\0?!NÔ[AÛ,UJÐ\\Êz¼:¡«„bR’Ù#¼½È„ZC¦\"’eK™ M<¶òž80]ŽÀªÚ‘·¬ŒïT I€är¢%I{ƒ²xË¥YãÆ%·ë¢˜E
    µãêÖ
    °»d{a”Iiøï5(r ۏoð°%™£ÔÅÈSÔO/L ¨8éj9…öÂ2\'é¤f¾˜çK„ ”…
    cQŽdƒê¤úçt=¸D‚šÌ¹élЉ2âÍP}&yvØð ìEÖ FÐÏr6¡;Þ*À2Pá_|Ž…6%@Â^`Ái2Ù)é58jÑ—ö×vI©3e4®Û¥ódÌ6†IW›$zT¤b\'…¾PïU¦#[Èö]É”©Ttj,öcݺHrhLTAj·ÆE§Ôµ¬‘¥‡®@/#ã0*\'+¬à+߁8ÅK¸­õxDKà†DlL‚(0ñIùčº¸m÷@‘˜Ö%ä”ß1óqG¬6¶)Žx—™Šü½Y(EÙ„DÀ[!\0‘uÇÒ3Ł`&„gï7*b9&U‘œÂ{œÆTÑžÒðÌ\"HÓ³^#LœBDåɼîMB©o¼”h(A2ËÅ ¼e<8c-¡zÁ
    –2&þRÓ€-&Ú\"·!ŒCŒ#\0þzPø0XY÷ŸOèô˜Ø¤µiAOœŸÍ\0¥n5ùNÖ(8UÄ@t¡¥ôÉì€W‚×퍁Wk?÷0÷èNz0xLˆ‹p@U8xrU)ï`C¬tƒfLœjQ/£“„Ai(A¦4,ÜàÚÙ±
    ±\"Ê•sŸõúÿ\0 òã*„r÷À¤QÆs¦ÃÊS^¶n,µ<´N;Áá_6‰‡!¿\\ùµð]8|Ážuξ1ÿ\0œ+læ§öân7õ/TrúuÒíԜ꟔eE$Îù3î{És!&BãFi:m”¬Þ¶±„V“Æ…kB`™!lž
    ¢ê©ˆä1¶4½N3p­ÜÄ»cTÞMᘭ‚åPÒ8ƒ-°ä—ÃXÚI=‘=ÃÓçW£k,Ç÷ÁÞj)džCƁÀ¤,¥èçÛâQçE±~â`E-I¸Y«j˜Ú—äáµR
    ^ð@¤^59 ZKÒ¥Y§Ðq©1i$x\0™ç!čÕûaL¥qc‘2Ð\\²ˆÆ/ȇ+¤âaèd*2uS½Y™Â{¬ðÙ„gœø×ÜOÎZ›Œ+<ÓÜÊʩӏ\\lò9E°ŽÜšÈ„ç\0àëã#Ø2¹â\\‚Š[\\ê,×Wnkè¶2å–§éÎ[ƒ@v*ÜääÏm¾×‚ÌØ4ÈæB`Ïdåï$à=RŠºS‹?çm›Sf³ïGû¬¦K“³QKäeçI\0b‘N±’D1Jt>VçÜ»Q!0â¤ÀÉy5ŒG
    ²x·#Œ…°ì+×”$æ½D•èQðÌ·T2A$˜M´\0i@ß9ôÿ\042°nq+Ê\\E
    )ÙÆ|oJg’щ,ÓÀdk™rÚ„iKxYÈÂ%e|/°§JÐØyÁŸ@‚MÊ›ÆKzÊ&4ÞVø(€†ºÁ3÷Ѿx´å<q€$NSÙJÁ*‘+\0+†ÑÙB϶Ø
    ;ã&}.Dï¤gÈÑòÄç§Ù25–ÿ\0ߣ£Ë•×O÷}“Xžÿ\0°žÜbž{ýi¾£>ÛJW]ÍÎyzŸp\"û8Ïlöþèû¼û~´â£öÏ}#Œù%=óïOêXÿÚ\0?!€Z:p«P ØÙñTaK‡ÇUŽæ߬ПÉÍ^2‘Eö?¯8!4éO¯XsðŒþP‡ÉÖ?Eñ&Âùãùɪ©þ’ÎR›þè‰ÄL¶A—\'Äãä8Öjüo)RzÒêlÇq01‡ÆëÅäÃBg±á+ÓXý™:¾¼9¦‘?ÇÆY$†sä\0¡àñazH{c€ÔL|¿|)VþCó…QïûgX9ÑŽø1Ÿ&AÝô~}œvA$tôi(î2¿ ÀB\'b$ŽçY<ºß«“ÎH³š®cÁ“Ê€‰k1•üÅ—«øþØN>ÃûÉ?áýc ¿ñ†,•<Ì£ÙÉ}ƒ°,°\0Ôxg×Ä’ëp9„|æõ3ÕºÓ˜ÏÐÈREžãÞÀåɐ` l[-_éä•eRÝ]á;—†zĦ’çŠÂHg-²‰M}Ó÷YŽ#esÂÙ,ÛEäÉ1j™Dq°qž–ÇÙ¿HÚ0¤æ\'¡@ùÔhxŒ—ê(=dxë c‘“™BaÙàp}Q}“&:8³h{/ÆtÍŸ1þDbHIW5•{ãz„îã!ù0€}~™Kèi–\'9Mg˜\'[f x͈ØÈX9D
    ñdXUƒÀŽ–©ˆ›)KÉž^£)“Ú‰– ƒyÉ0i <dô8t&ð›\\:ãÚ-<âpgõ‘£¤ÌB°´9Å«1Ìza3É“
    ôÁT„Ç%¦*k•Šk
    ÐIDnŒKxÆOXZ`MO¦*mÒƒ¾±ÅØH
    )Æ€ÑÉ`B\"WO‡X÷]Ûz²¦z—Yû눈úN×yVyaXÏY–ð5ØЩֱÓ
    ¨=N“Ü‚èeÖà‡ òC³XbÓ©E5¶žRŽžtÑ*çŽJt¥!…(”XëÛbÑZ¬
    e|€;<8áÖ|Ü¿é¹Ã.¡ç«z¯ 3ŒP”“û¿x÷Řö~G·9\0Ó°aéç ”E\"¶)DÆ#Fm4’NrlÂ|N\0&ˆ~à\0­Ã³×>ø~¹Çþc01~ç‰D‹˜³Rä¼ï¾&´Ï¦‚@ß„õùÀR/X
    >Úrq’\\·Æ(ˆßýÉ1—Íú“^Ó>¸[4Câ/Û&øG§Üf§ë¿è¥ÿ\0í.¿Ì·mVzK·ûÆzvÌýÒ7ÚP¯Ø3£ÔˆäOé¬÷ñIû9àŠï%Ô‡¦r?³ó÷¼ôï㎿ÿÚ\0?!!‹w‘hy`FîÝkà3¼Dts=ßÆ3$ÇŽ2•CƒØÉsQ÷ÖI‘‘¼£;‰^®r`˜Pòac”—0$„•ÍŸ¤©tgש¼œ€‘@ß·\\0\0øã,ƒ5á%O‚W—ï6‰hþqL¹T}ð‚ú\'“îøÁ ®\"M²™!ÿ\0šÃÁ´ø]ÐÏrs_Cîâÿ\0±ÙùŠÄVB+/w—„¹8¶{”P”2¯vK—4DøgByÉRæë =<Ò
    €BiÃùJžì=W
    U%…“ÆI)jT˜‡yúN[h”§Ï|#PxT¹ìeËiQ/Ùù`m¤\'ïBÁÑE?ojÈ®Lá9~rŒ8 ¡ÓhôC÷‰\"ÆþzàæQã/!¤i’Êk‡±õÈÑ2ÉzÞ˜PÁ‘Ý%š¢mj©g¬^u|ŽŸƒmvç/œ¾“Dfôÿ\0¹ü¿s%JÛϱ¤ðnbdÊæ½xõÉ•ëô²í‹}…g\"v²«jóÇï·Ø¤ñ%ë€
    Ën_Ÿî«¶úÜ%ÇïœWÌǯûœ´`“AsýŠµËÅË6Ó¶`ùoYû“ò%Æmv¤ò}ï~¯gÖ;ˆÀr‘ù>á›LÑ^ 3ä\'
    ØDAyœXåÛªq§Äxt>+þv¾ÿ\09Á^/Ó.Ô÷Ž$ç_ÁÞ[ZŒí!ÔÃél5810xÊ;RVCÙQÆ)[ËÒ6f°æ2lYúC¦šÚSûCe™í SøOs/
    }HeÖ\"V¿˜~EèÔ˜ƒ\\ªœD¡O¬˜”®ú®ä…ˆÝçŽ4ÿ\0Ï¿a›V\'!29:>8ǘ*o9½ÁÂ5ŽB¤N¼zå{ŒK?“Ô)>Xaô†ðâ=ñ“ɈÙ]¤ËäzcEdǁɕô9ðS†ih
    œ½ÃØ“ú!DT|Tå¥Î<‘²°q¨‘¤â± †¬i\'ýÄ-*é¼ÑáþNH¥5¶øÄiòÈüdç€EÕpb
    ~g\'ð6Mõޏ
    þû†Jw÷ñ“
    ×GÈÜ7•üN|Ûñ’=5þ)Èl>ùŽð¾g¿»réÎ0Öãïœ)•<äGÊŸm¸¥KÁºP<c‹Ýäbaæ´;Ç%nÓÅ0ððäÿ\0†¼C#¿OÉQ”ë0Þ§8/[óíÞ}Ëø~s¡½ån”ƽyë®±¬¡î]g§ˆç#ãQ›Þî·yé}ÏŸ÷?ÿÚ\0\0\0\0nvÅd€ªâæƒ¸úb¼—ØÀÿ\0wÝ:So
    ­<¹á´^\"SÅÎEÒ윇Ö\"±[‰\'È°Âh‚³8åöO$±ÿÚ\0?H&d…ÂÂ)$%ïFT¡.ûa2µôÏmÈÔ\"ÊèIŽMÑS¸&L·ö]¦\\„Ìï¥Nó@‡„Õ‘®òp­Ä)ƒ­`¼hEÁÀ¢T…á1¾‹DJ¶¹…Fsc$~D
    +¡ÀXª›{¬Ûꎊæ2冤àƒ5^ý‚%`½[†S‰\'<«ÂƦü›“¶ØŠÅAq »1Ö
    ŒÓMÝ14xÁÂò$€:ˆ¨Þˆ†,°$cÎ^³+êP
    êrÞ~ézYX™/!ÉIfŝl C ú©¶¡A“©æ†]Ý2Ä´Rg¬m@T,õÆJÒ£nMߺ®J~˜@%ŒNÚhÉ´ëRÍñ:Ö6¶(Ë\"µ5mêrŸ¤H$Z–ó<à^ä›$«Ðn‰b‡”Q¼Óeà[…‚„ÒìEzŸH*ҍŒ¶Àò˶=È®Ps™‘œö7ÛSLƒY³ût1˜a)¢oÈ}o¶(îg
    ¯Ý#^–Ȑ%ÅfSáŠ^[›4‰©Ï­Ò¢€V¸µo¼éG+*¯#0OKilTpaqúʇZBB‹Žs¸ÎDøÎd†Ôa­Å©M+”G[BnIkFe\\SûE› x:Ɍִ¿ÚÞ±Š¬¡Œ<  áR‘˜¢4 Æ
    ¤¬ŒÍ6R\"XWKI1,^H¶°’\\ÞÞÜq$«fðšø€fªñ²•/:fAJ›ý5×ü62]
    I¤3æ–ÑtâB º’Á£|˜”Á0ª.§Y\"Œ³h2Ì™`L‘P
    ÄmI×k,>¯\\RdD2Â3#9Ì\0M”„\\<¥JªÚÏœœì6ÂQE8•`ÂÕŽ½Q#‡0Ì)q~“±X²cÐœo³Ôo׳òsâÆÜcE…a
    CŒ¤£
    [URL="file://\\Tk"]\\Tk[/URL]# dæCã|€kxjÓ/zLe¶¤G¥¥W†œ8htò,ÀRÚŒâè;1•Ùý9×yp†
    Éà¿lŸ8NtjðJ2§ õE\"°;“§pogâ±õJO‹´Ec®æCT„Àî-Ö..Ť$! l×@åÄ\0PÖ\0„ €±\0€ƒJÙÔñÞ(t±šwÉ„§!êD(d4(µLŒžX¸ÎàF”,UŽ+ɈHm1¨6#ŸbmIµqÖE™-h^!†œA?ŽôÈA¨ö¦ê|,b-©R€\"AÄ¿*K›ä€+26w„â»N·?3•·¢øŸJ»JlÒÊ‹Ò®iÅ‚ù„íÂT,
    QH$¢¬íÒ8ï“XÞ\0`3Ö±£\"x”j
    XƒR!QAF2Rqâ
    !ST«‰¼½þBÖ&Ý}¤òÛŸ¹/ [URL="file://\\2hŒÑH“)8Q8©Id—n|bЄ9”啃I§9Ñ­}SF†>SÊÝ€øR!pcF¡ô"]\\2hŒÑH“)8Q8©Id—n|bЄ9”啃I§9Ñ­}SF†>SÊÝ€øR!pcF¡ô[/URL] ôd(F¤F‰oÑ7¨¼9G\"
    ¤2P\"à&eñ@¡*@¡Q…TŠ`’IÚrÜ,ëdÃF[ʼnY)G%DV6 ûʈý]âÆ2”±œ\"Ó<㌋$ÐE1o˜ÀBì„pÉ.©`ÈÆ€apÖþƒ ¸•%ï¬-/•
    cD‚(ž0Õ‡7”$UI–MáwQ4Ôi€yÜ!š±åõã5KÈôœ}ÏBXd¬2z{5:°à¿SŸ~&§Øƒ“n%o+¡¼YŒ¡3R$ñˆ;yn©( ±$áÄ—ÕŠ 0I+\'¼CÅ\"œ;g\'› bN±Â.Ä#[$2o${Z¢%‚IΆ™dÐÓ<aü[QJd’Uá²ùà¦I‰’&Þ
    -–[E9÷,úyû&âsþö‚yˆ¼û\0Ù<[¶£.ÉXšŒþGþó9ðéþÈÖâk>áá&–˜ãUŸÔ‘þöf§? »àÿ\0!üw÷fšÏŒþàü½¼Î™÷(¯Ñ×hã>õz¿¼“Ó>þû“ûgÿÚ\0?w˜óÞqæ|\"ÇqÑŽ™æšf†S$¤Y5„À F0vE¬ÜÆ:J§Og¡ë‰l|Jùýâ‘ }…5°¹ç/ÙG~ÕpdpïLèH…Ø™d$kQîCq\"$‘’ ]IUÄ€$!H•acꢴª€Ný‰Ö1`Næèvµ^؆qrÒ™á‰çT#Ñ#1
      öÃ\'’jcœX5‚ äž¡¿9Ͻ$°š‚:<`JìÁŠÂ4‘H!ÞòH›Ð$³4*T…ÄÆ^æ-<˜€aÎ,Ä!hû€Ð@Aõ\\\0IØd7§Ç™
    [@ª“F;Ë-¨
    m&ïÛÜÞKP…¯ªÀb.ÀÂgH=böå]|ì
    H8Š Å9{­^#îŒyJÑ!„àñ‡ŒIn\0AC·‹OÀI‰Db‚ªEãQ³Héjl%2t#.ˆ¶²8ÄÐ# 
    e¡šÈ©á!JE¹w­8¸&$D<d° ìÆBY¤&9´³,‹\'^Õø ùaTG™“ÙxÊ¡È5aCr•§{ˆÆuân)HnpZ±t…\"ôQºÀq4¾šˆ
    \0öaë–B—B4АI‚2.9íö K$PPÑaPà˜¸1¹9œÈ,&YU„“.†$»ÙoiÔûû`BoWŒ\" ˆ<à3V Ð 
    áÇ\0@»/¾±€+%:©Äð`\0yPd sârüÒRaðYŠxvkžËsù1‘¨« †—Ѝd0¤bY€rñV!«QÑ׫ÎC,<Þ¼?yçÀ폿ç
    ™üet4:É ,NÀü
    ŒÏ=0>vˆ_$KÈÞ°€ƒ9+)ÍÖÕŸŸÿ\0÷ÌTô#Œj€ƒ¡Å³p^E‰Ð¶|¥K§»Ã÷gŒboœÕuœ—/Ös7ë$Œ”£;$7Åîð\'¡¢v
    ÀŸÂDÈ¡ Ènrý´ˆñ[1ÄDãmÌ7RFe%F!3+€Å1p2w@mÂ}ñ³Ìþ/\"ŒÍÍ)ãùqã‚ɇ;ör îòÇëç%‘?mSHmš©¼™cR“#H\0pµL“ ÌlíbçÉTn‰åÌo&¥›cÓ×lí
    ¯?8Ö-p™A€F¾K0„ˆDÎX;WNŸÜ?9*üøÈÎYFS\"8ný0÷ìŸÕ »c¼rºÎ%Bø°Å”9„@a€NùÃ( ÕŒ…ÑQãŒÿ\0?¯V‚V° \"&¼ÕÙãЍÌ/p=—
    üW8–Œ3
    :E.TIÜœƒÊr\0;:t…L4-&P£ºAÚ±øÂe‚«!ž%+HÅBª„V‹2±b¸1TÑ1²8˜Íš6  7@æR¬ÜK€T’\'Àˆ‰¦úW‚\')5ËÑ^@”ÕW¹!À¯%lJ”N´ã™‡PXˆàöXœB-X·qÀ0Ô\0„äÂ6•RpìèÒÌ´p›!§GäÑÆ°ï…((5 C:\"\'œ¨;lÃ]-Ò—˜ÐÊ$¾Œo倴(.t„¥Ö=0Ñ¤ÞO¶z¥mì&:RxÖC’C›„òÞC !‚œîcœ`¼À\"& È@O³† ÍP5„yT±eÅ£Vz¹jC³6!R\"ÛS½zâÞO7±g°¶«FPgIG0ÄDÊe¾­ [ˆÑfJ1F{)à
    ¥ª°2]SÖ‹C…æu¼mÊ0@Âi¹ö–ì×î®^g9=ÜÎÙË­+DÜFÙ㜚˜çŸNr·ÅMû9ûë?³ÑÌú·>Ùõ=ƒ\\ë,õ$Ò$ÍcöÇ ßðk(QTß1¾s—Qnw¹½kñŸ‡y¤Ÿ¸ŽsÐì{ ŽkïgÙ‡ØyõgÿÚ\0?€8ˆó¬J’D&5(
    Åwˆq Ök%H]BÑ(³:!QÉž%ƒ°Ÿ¯D¨mÃa[\"[URL="file://\\yAÉÖŽhwó8%$0[4)Ó\"fLÔÔ"]\\yAÉÖŽhwó8%$0[4)Ó\"fLÔÔ[/URL] –bˆÝèR±ôʈ‚Ôž
    ¸Âo¡©¥E˜¾¼ HU‚ ‰#FäàÂ%=. ˜fw”с8Žt€íAW—[px“i…²:b°Z™­ƒ²£‚&ñÓѯD\"-F]ÌåZ€DUÔInåÉùŒÛ0…0õ†«´‡%e\'`r‹ŒI|¬äØÂ:
     º‹ƒ`\"ƒ©–¯ÛÈD“b©Â“˜ @$\"ʼnÝ%¢*.áfäŠ_Ô€l‰%Ù4“ll“°°úäL­À@¢¬X$¼•BR%ªxkc\' ¢nf’u&ˆ7D¾Hû„¤·ˆ@PïNo0Ž6
    Æéõ7ô—¥,,_NÖÕyQ̈U
    „V$0Šñ„‘`€îÓ†A0tÜ2\0z‹ðòã@ HŠIòå¥>¿ë_,]Õ<&B™`V²0»ÞkñyW\'.ƒ1·–AÃ#
    1ƒ¾\'-Æ×-1‰qÊ\\7ÀÕíÉ
    ¥ÛÑȘ+uQ¹””•AONn»/×î82Ôó-øÖN°ÁUþ}Æ Åàè#|Î?€pàŒZÀ¬y‚XÇÂBàE0TèÉ€¢!B(M-—:ÂäVü$ŸéNo¸87È;TQ‰R\0f¢e[œ™HPÒn[‹</$€F6ÛÉÇÂLä†RB%6#îø‹=%KBŠ“§¡sÚÎåPvr¦Ã‹¤ 3-e>SüK½œ4+HŠ€”R4>#DË
    ¡K:
    €J7Hšç¯Cû,øÀk%>OI¤út$VCƒ÷É—#÷W°3/®¾^3CÓ
    ¤  äQ¥Ò\"h2Ũg=[gŸùYÁ‹H‰ƒî°ËB«Ëb)qE­&Iî›ó8
    à|ÇâèãÉ2<4ÿ\09`„Ç=sˆ/Çù’‚ï%G‚\0üá\'“ÀôYŽ²(±
    È
    š$’R“[ZdGÀ(æ´ÅÆ c= ÷©ÆgÂ}¯~pª¢JÂB(ŠÐ† ¬Ò“n¤”²bÅ=ÔÌ“~Q‹Ûê#ñƒy\0ÿ\0ð`;Víè%Æ9@$ìl3Å&B;°ªE\0”$2Őä.b†@–IÏÓÙuߐò0èKtêczñèb‡%C´bR÷‘Í ­rOÑï‘ÿ\0ÇÝÄeCÆKC<½uà œ¸ú|DÜ\0<‘øÄ#þ™\'àa5È’¦ÁâqšpùÈ2)¥# S`Ý­€qñ€1
    <d†Grû9O/™d¶1–o2|•®ßº…–rRÔ(_(0JÎ÷òOaí#.Ìéìä)ãP}£Ô“%¹¹}²Sr§\0‡áÆ!IÅ·¤îs¬”Pƒ¸‚°f+’ó§×%³p&KjÚ%˜¾±Õ}*Í«ÂÆœdrðF ™T©›S]g¾†Î—’^ó¥U·(e§3®Fø¶ÑY*„ôé Z{{à¶æ%Û)ÖIáTÜ0q…פa³Ý½´ ™;jq¼@»\",EŽŸ77Ús(CCÞ½2îyeTŽ5F¿¼’Ä`
    È$-cAbuJ!)ÒdÍ)6Q2]ƒ1žEæ¬ÆãSÌûç¥ÄF™ˆâg=‘ª?&óõ½ÑçÎùϺ¦
    ü2·¢8qð·ÎTô6â½ÿ\0Üá}?eÛó8øwè,ùÜÄTyÏ
    b·âc\\ç¶ÔÄQʾȼå>K¢<ëñ¼ð¹ê(˜¸åíÿ\0Eþ©ÇÿÙ',
         NOW(),
         'OI_Logo_avitar.jpg',
         0,
         100,
         100,
         '1'
        )
     
    mysql error: MySQL server has gone away
    mysql error number: 2006
    Date: Friday 12th 2010f March 2010 06:33:15 PM
    Database: signforu_forumvb
    MySQL error:
    It's on exactly the 12th user import after the first error, IE the first value listed as 13 in the above error will progress to 25, 37, 49, 61, 73, etc. I haven't been through the entire user list, but all it took was a couple of hundred errors for a repeatable pattern to make itself visible.

    I don't understand why the binary data should be presented to the database anyway. All that should be written to the avatars field is the reference to the file which is being stored in the file system.

    All files in the source directory are chmodded 777 to be readable. I've even cp'd all the files to the target directory and ensured chownership and chmod access.

    Everything else... the threads, posts, thumbnails, etc are all migrating smoothly... I just can't get over this avatar hurdle.
    Last edited by bigwater; Sat 13 Mar '10, 5:13am.
    Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.
  • bogley
    Member
    • Dec 2009
    • 95
    • 3.8.x

    #2
    I'm getting the same error when importing attachments from phpbb2

    Comment

    • vbkev
      New Member
      • Mar 2010
      • 6
      • 4.0.0

      #3
      Had this same problem, but at the bottom, you would have an exact error code & description. Should have something to do with packetsize or something. You should check your my.conf file in /etc and check for a line like "set-variable=max_allowed_packet=yM"

      Where "y" is a numerical value for Megabytes. I had to add this line to mine and increase it to 3M, since some attachments were quite big. You're probably still going to get many failed imported attachments, but at least 40-50% will import. My experience with Impex has not been a very pleasant one, but this is one issue that I had somewhat resolved...

      Next issue is avatars, since I manually fixed smilies... after import. Can't figure out the avatars, though. And now, my userlist is screwed up somehow. Gotta' figure that out, too. Fun times. ;/

      Comment

      • bigwater
        Senior Member
        • Jan 2007
        • 592

        #4
        I gave up on that issue about two days after the OP. I went ahead and pulled the final change over to the live site and made an announcement telling everybody to re-upload their avatars. Nobody seemed to be terribly inconvenienced by it, and almost two months later i think everybody has pretty much forgotten about the inconveniences of the change over. I'm still experiencing a few administrative headaches, but nothing much that the users are having to deal with. The most inconvenience the users have had is getting used to the difference in the interface between IPB and VB... but most comments have been positive. They seem to like the new look, even if they've had to struggle to get used to the new layout.
        Anybody who says "it can't be done" will usually be interrupted by somebody who is already doing it.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...