PDA

View Full Version : impex error


raagaswaram
Wed 15th Mar '06, 12:15am
ImpEx Database errormysql error: Invalid SQL:
INSERT INTO customavatar
(userid, filedata, dateline, filename, filesize, width, height,importcustomavatarid)
VALUES
(
3615,
'GIF89a\0\0\0\0\0\0\0 |=i­yY뀤ᒵ ϲѢ£ȩccԸ~}HbGxw pnھjg%6#!0RmNWrS\\xXb~]+=\'*9&7J2;O6E[?NfH0@+χ~ɧѯ *AU9Ÿ׷$0\'%23D+K`Aj_zn ,;$7H.[qOsfu!.%20@\'/>&+9# )7 $0cyU%\'
)(5)/=%<L1 +8!3A(HY;

$0(4VgGCR5\')%*5!*#,2>%9G+!(
.8#%\'!##,% \'\'/
\'!)%./: ##%.%\'0 \')2%,#!)!\'%  \'#*#)# %%,-5!\'  
 # % 
&# \', 
 #&, #
 % #(#\'    

 
# %\' 


      
 
&!  \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 H c
vl@Q3jȱǏ/\"ő P !EƄ
JL\0aG?F`ȟ@
A.[2L`1B.ȈBJQ@P0b CӪ]PHAA5wVeSwFB
9bD<ꂣJ-[
%RTg)vȈc`؂e X\'UYDG`8ղk.^0­ $Rxh bLHaS0OG^¯jJ,U\"2!cTR%JM­j.LJ+\"K+YhA
D@D\'ȰACUT (D@D\'ȰACUT) в,H +X3.`3
`. &4v )6XK60-\0 0y . ppg
I@blA (I@blA) /
5B,4K041*@L*I\'PbH`\"*؜
$A
5\02?P3xA
BHT=!ai>;Vl!5H\'Bo|0:F:ԇI-dIYd \'ТG`(\\1 (file://\\1)
$
b`A
0P\0.3F|)0W
0xҊ Ҋ­‹+1 B #Y4r!PI&r AAr<4邏N # (\\C.UBZx! (file://\\C.UBZx!) - .\0s$x +&js1L6\0C%)$ۜQB<0i0HJRq 7A\03\0A _#
0xB4GB\0B#\'!wM­ E:S­6H h;=ܜq 0ED\0B&S
c\0 HHR9-J+!8
0,\'%  9Lß\"!6R0Ѻy \'Hެ 6r8Db<i$XcMj
^X8!B M@\"_\01 (http://www.vbulletin.com/forum/)
WP @0t \\
-J M\'§y`Y p-j\05\'fA:~$. lt D\"C\"BAC\0CM 3A r`PxMԂBR\" #&
ZEG *|@ .i< 8.PX!\'60=0+F `>(OHk-ґ
A^ 8`8\0u!Z@\"HW:-m\0\0 0+Tb*G
rYb 9H䰈UX
u ! 0ށ NȄ*i9!D!8
|`
{P(,9TB؃-p!
ghD DAZp.*y# &bMD(Q<12O?,D 2h \0FD$h\'< l
Y\0\0P &4 
Ȥ!a0
.P
[Xl$ъwx  ]B 8Q%|b+Vb\"z\"<A href="mailto:@Ιa\"p!B<\0">@Ιa\"p!B<\0 \0aZ̐^ C \'\\Y@C * `H$AX Ec @ڐHlVcuV
\\ (file://\\) E{
0l.{`$6AA qH%0X1
n07\0@H5%C! \\N`8 OI D =BNaD$爯0<\0΋BCqq;D!$a/}yٛc!Q!#2QO09Ia(
r\0{6
Ou
aur7zS0! T~D-d 9+\'P!f0WfPA~%Qy
p5,\"bCExpgJ!`%pp\0t­6Bt]  bW An.24>D\"`C>
4$
KVOXcUՓ7es0\'$-( af!2l@9 Wn^׃%.I. 8ͩ{D\'Q4(T5#d8A$J wȦ\'a+X(F T D&:3$0D%ybF6d1
W !␇KxR٤OЅM 7б/ HJ \0 `,\0cR
PF Z]3!` 3pp,U3pES\0&HR
@l)<eF­DL̳}YC\"ys9Z@-*8 =,~5d0C (ys9Z@-*8 =,~5d0C) vp%D\\@ 1pj*ZZ­Z&Úy9Z$Aq+ytY
ٴ
CĶpe2&%
wJqNaI,E`Up=Z`8F
D 40rBNFӅh\0
ezR;! pBCE *!HW0RgXur55-\0%  }4
C d\'ZlPїyPTyVGd#x^]q0
5nP Q<1@ .US`+ e@ c
ʶ}apH ńuΔ| PQP\\ USk P2 \00ؐ
?B;ENā!v5@ dr~Z   pg%1/\\lJ~ u?@9B HMU`E­Z:`PÄ PMwND?u \0 \0!p8,0# j
\0
N6w^IWSOg@N8 [@q0
\0)av`8N ts$/@ \07] (ts$/@ \07])
\0exP
M­l`(-O@ Bj@jM4- (-O@ Bj@jM4- ) -0^@ߐ
0\0 5ZD6`ayHzD4p2/I
)m@ ؐ\0SpE V a#M\\V&
P`y c
F4-2K fPRcP pCW` (|\'Bwr 6q yh`Dh\"\0\0}QGv& 0  6
:e:0x?­ \"E `­
q9{,PRw]yykRv
p(%Đ `/H|gBbr^H+.n&Ra2Mp}n6
6

ZoI 8 \0 dfFuIWgPBC@v@ s
=
^ a\0 @@:hܖz
=W P0\0/Kcs b@l
C 0
@ 0
P
`ENp
sp
IYwlpNF j[jg1PO o@c@c0R w[q`rE *8W`B`|p@8C1\0i, 0 t
7॒
^uC 80p ?=4{8ty5a0ũy= i@\'A0
˰
8ez#­@
H @%\0c (@%\0c) 31`. j­O5a62 )D@Sqs4 ؐ 
 Z
YpD0!0EWaBH
GC \'p ߀.\0<P)Bpt09 c
4
0 0\'Ã*`\"r@9SsN @ 0A (@ 0A)  Q  pM1\0Kl`H0{XcSGu_Ԃ
.P^ Q`b@@ ;\0B@


0;  0
3T *P@PP Pja­\'@[[s0 { 
7@GrD (7@GrD)
[ FpO9\" PTHCuUhHG5]
~ 1G  π
iHl#X`m`
6րx
؀
^ ͱo@#`p0~AV w` X P, + ; /@VfEP1@0)$T&Iŕy@\0 (http://www.vbulletin.com/forum/) Z
/&p<qP  
E+@l0,1$p/O
]@i
1 {l P=B`
!
_u\" p
gPulGT M/ s P  0ƙ
рP\" \0,\0P3 j \0U@Z=pKj \08 |9:nXH 
­R,@pg


BԔRp PXu)e ;
o\05G\0{0 l %($Ɵ
2stzt@9VP \" i@Pl9n (i@Pl9n) R m [B+\"p­g p 6df0R{­E:CC9w@F@0 @<U rl 
T# `i
=1rSmoB \0lqHpp UPWpx t#B
$j A
!  dW Hܓ\'E:9\0 @xT[ j\0374ﴯ P9
/\0@P |Zp/ Za~l -?f
\'PO` 5m@a` l8D tSG @­jiim­-`nM >Ѣ( vNiO#0UPQI-\0o]e,O q 0W?P; |
\'@
\" z 0[U`֩@|i hZ G]R ۤs zB W00Fe` V>s7\0n (j9  *­NQuX5nXLbV]3[Vf/
80l 0Vgti\0mPrpYOtMuӉaa\'(Vp MP~9N C1KpY}N\02p%(F\0
h@_Yz`
R&e89 aPёG$ۍ 8b )@a 0]\0z^
WN@
BU@1PP`}_ !2@)j0 ){c @@ =Ҳ\'ex{R­ 
UXjDYn?Ӱ
c`pIM\\QDJ֣/ZD ` 9P:=1k}:m\\-0!jphAN^q`7@`FÄ
P\"<­mʁW8\05 Ugu]9CE$c 12Qzi\'­nI$GOVu*UTɑ WM9uj\0f.\\Pq˖\'
0`S;\\y\'!IZIJą(LPLJrh9O\"9xC=ШPB K@@O+u橓F$=9BD j\'j8i!%:e϶)!*Up .LŠ* A$0X #E>]J+0FDɄ\'DZ -AF%U:F<CD $@A\"b\0O (K@@O+u橓F$=9BD j\'j8i!%:e )!*Up .LŠ*ـA$0X #E>]J+0FDɄ\'DZ -AF%U:F<CD $@A\&quot;b\0O)
M<ey(x \"H!bB J) ڀJã\0MCF.[!a!
B]\"pŒRIK8#8 *
6.1$ 8aZ@i3B+ba.\0\0
PBvp; ZL&&C$D 1$<|`L$K@f @ c6`N,X*npAL\"DBQ=-ΣL.A76c*Z; 0x:-0! x(H\0!ȡ
Z\0DĨM tC )2,JpŐKZHQ O2#I$F*$XFILϐm +nVO6DW6zaP$؁*\"d%eA2nI 5: aR1J&$LE9 XR>qD\\K/r C
\0ÕVXEuUD*ȁ6Z
:T# b \0(aH.\"H`@>6 \"3. 1tӗ=#n #\0F(<32B8K%[Aq$` 4FAwD0Ұ0 %%p!x?h3 h\'$
O\0+؀ x
L0+L!: C)8@~ I\"z0D[u) q`T28 D#>AT<Aӈ7 C윐 @@s #X8O` e2h-! 4X@
-K!@$ щNPB\" { ^8Aُ
C†-})(Bu*ܥA
;1n
 Pp2P98 T&9Đ<PL X<@[*\0`a$$CR \05\0&>FhAdHrІ4l!7P_B@
2QX$
]@ -`B<! \"D ĉ@\"|8GBf RPd)<ds $^
i*4
Ҵ(0aK dȴ((a
[ E0S S`<D]@A
: `؂J
՚Pxj `\0 <Ay.fFBj\0GT]`l@C:`nKl%4șJ&ECͶRK!pф0!˜9ȡoz Z$ :@kd딢8kC\"r:֤;( p+,$+Kj!hh M rs$},4wi!>!%BLG3X)P iHÎ怿 xA0 N)pI8
p70%\00)Ix# 86p\01`m$Ly_:
{)H Im(&K/AR.fAqQT4r
cq\\Axgao@&=YDe4 NC* &8hD)`\0!5)b\"0
V Q؅(,BdqD= XND <4yaBsbC<
\\ûK؆5h[We0pz\' (file://\\ûK؆5h[We0pz\') &\"!
GYGdB0P]\\=E N׼ k$1`D\'EXR\"y(U^\"@*
䐆:)AZp&
޻VPB\"P(0 }Q&т[T C,!(\\\0 (file://\\\0) $BıfO#2ՈAtoSƒ emD(B
<B!ī
B<H %rJ&!N ()JwBt|mpZ q Oxꁋ:!4 СD= ݣ ­HCCPma\\<ZPHY$H4QUPVP& 4J3 `96CpWuP \0,Q DX=O)E OMhK\"\\
%P(C*\0\"ӂ0OhXi!Wk8QO@N01ZzapM <DAQ,ȀA`*Ie X\0
`P;8JX<46Z zB\0D@&<Y‹2Jg](c8h!Jhmj VXyеTHXL\"_\0&[7KP < \"x%\0(cT(+VsP\05؀9b FЃ\05H r\0[$,.^ݸ*d96dDV ϚH­xNHRl {Mw ?hs* :i(\"0b+SUL <Wh]]h\\p鑼\"\"D@Hf.ЂEl.\0`P:0ki\0PPQZ JXN`i jeP\\Xh*`-P\0`\0\0\'`Z\0)hERC(K0I U#M؅]U!\\#3KP@`7LiJPU
h]PIbȦn:wYI>؝\'qЀi \0)hh8E`iO=N( 1`ZHNUPL\0SiH0Ȃq7p6S) V=hh hc)pG]pll\00̌] V0t-
h|:K1\' -VLXXjc
H6Yh+\\(\\x#\0H۫F`\0O&Ii\"KeSp\'3 F@\"\"t8l lYU\']X}<8  0 Ѐ(\0
\0:hOZPC-AP4 MJ!\"TO+%۳M#j5H.DxV!mq(<@s0( (+H|{`9 a\0#x?R-؝&W@P\0$8P= ­4pH(R QH Z ]H
j]PNhQ;]1&2a5N
%psHC[9&؀+\0G H&`8\01`VsNh\0
\0&#PIJ\'`x(Pd*L LjMWP ؀#пNYAHNN8Iȃ,880٨\'XR x1 CG\0=cH,{ 96IAx \0u:0;LH M \0
@h|00&@-0R8*NX=H\0V=ZЂAh<8\\锯`3x\'L؆3ȁ]p8Z(Gh0oh2ЀH=JAa Bu5\0,`XP6x~
5(X$­
\0`# ĵSP/ =h,OW刵BDO\0לnNҚ: _w o^ k^e+@U/B\0H)`a?
\"`9\\WV#fP?Z(ʫz8ȟ*8YGFN  l mІX ;>m@慃 #m r؁6]Cp
 PdI.9`ŕ!OFY\0|<YWpLQ<

< ЊY\"hi09j88{ {h wHl6Xh#gbG/X7-pI\\i.0h `GzNj0x%Ё8ȄKXMH&mp\"PXXhiR*\"cn&| h%ɗ\'p(TiRX>9xqRx ;(/5Ѐ
\0)S]%K2Ff*p7H`L3cf`]If
l3x  \0lZh3!FWxD\0.tF`lTY hXU  a`(FH?@!قhm \0\0(n\'\0gy`­0!
\"h h!\'!\0&.(ayD(oPw9<XYP]QL\0Umh V\0fW9DDj\"S7P:Aԡm\0z8p1­Lx \"p@e\0}pv܃LpaJpENo؆YxhU ­ΖBȌϻա\\(5NI~\0\0pKw^09 ;h \0
l&\"`\"p H`f;F@F؄άbW؆ehqNe\0N0`W\0fm؅葘u cf #MU5l0s0_K?pu  lPЁr FI)VHa1pPP\"@>J\06g#X!ԶgE/AX|bjhWPdc5Y HAVA]_|Xyrw^\0p(apOGw ִq 0JTHVSJyiW(K%C9ILe `W N\07MpTM f>ti^
OH p­ p`)~( 39C6\0N _R X `ÐЖhNP FPHCLPL6c`op^sExgU؃!a8؀ |PH
HI­0JM|^ʂDxOh\'`# ?@&0Q\0Ljᨔ
oΝwlɰeu*M\"O6h3,i$ʔ*SZ$ߓ RlcD,H%Zje mZEL(S&H0-j[+kъ٬V25͟J: M5(bSۼy r-J7paCǜPFXi BhQˆB&0aB\0,[tRՉ/_5Fm2PmFI$J414pHYMf\":!=ju-4iDNE[EuCG1J8pTa&G 59^?$9D}Ƃ,PI,F% BmIs25\"HrTQB #g*h#M6l.B R
#\".NN4̢<l9|#J-ljAcnqLJET0\0GH1Fh) D1XN4Xs+0G -x 0H2!|B$sҨc
&DCX\'@*P: B.d7MҳKDGUت9t @;p8 Jo:ҋ7z٬BK3B 5nCR $eR $YBMVRJ6K&C /Pj؃P쒍*.TD||n\\!
z\\`JiJ-CMKu4ӌ6Tkb,ZQM8C}#O : 0Ӣ.dB
:xK-TFxdD & qL+@d,d D1сԬ4- W,ȢCBCt< u5CT1$:̂\'K/3vRINiB*K%P\0 X@\0R*}#B5.5[#4 00 /rPL9Tj)lw>x= &coKW:aA$^2\0qx Ӱ@GB$!#UBGx,
OЂs̤
­2xD`E4TYllH 1G%Έ12Cy)2Hh/ R \0slKB\0P\0~ I|\"~l\"|
X1XĂhʹAmb7d :H,p⁵D)H l\"D-S ER ;h#f,0@3\0a#J#@0(bR\' WB#sCV
Rqz([3FѢo/ـO2RY
OC& ULh /\0jP\" !pNi
Qo$1/ \0,c)!OL\"S:V,P :AiĢ5:фaj\" FF0 L A 6鈃 J\0 VE <6 ;R\0\0:Lb@\"<`\\QCiXA\' u Rh0.Z# `4\00BXLQB* g5>H @\040(TT&@i!`iѸXH\"l6W–LP,lDRdĄsg \02$6TA` \\ >8
fU|@>ƌ*\0Lp48 J0J\06AXC`$Qp  H6 w)*wy \0@H:3
؂f6P>WzGV`xH\0DL_-T8+:4 \"IJ5$ٌ@,:Het`A>6lD/vQsd E%V2FSQ.xC\'J:x.]\0˺r>0%\0b\"+T0AXqHBh:Y$\"11/
p@
&8FBl4*j!B*\0Q,jX 6F7> :*/f4Qk1YcPȃ <
sɄ[D]]cv{ 0\"j1D
PL,
^`*L\0 1B&a9[\"0&1ᅌ<ŋI`]m9e;؜ !D#U;LPt6lA
8p
x9lAhS![4 md#@ 6|H/q ZctC\\+FRP.5#%G
B ir=^@f{Hmlp#K<!կ XV­xSY98{O Odw86L,6! 1{``4t
1B/BIu`3\"lGuZ$Q|}dD@H\0 hIH\0]8Ȁ.Ly +C7t,tf<Hét&p(\\1B\'Ry^l)y;WAA=\0 (file://\\1B\'Ry^l)y;WAA=\0), Il@
n\08A$A#t/0\'lB#ؓPB-4B ꅃ:ee½Xv(bh .X!Q`E\'Q1LB @L@\0b>X@UlY;+}BfdVM@E1H )lB1B-ZL\0M4,cd\\-l$\'A HzH\\܀ W;X:}1&E\0 \01C0$.,}B#dBlw(EГ6X2K2H! `&\0 h;@@$pBÂ$bE/)YkTeIE\\IaA6>-1B\0 \08d;ƀ a :R6zD6Ȃ(Q&tR$PA P 6,@I-Pd„P<_`%VJ ț DFY\0 @[V,\0T$̂1:{BՎf\\@D4$\0 4f/z;aa=}Fހ@%h@ 쀼TV?B8B6`@:,pD\' 8D&T*BeZfn{\0 \\A<T\' (file://\\A<T\') \0t\'0A/@@8:\'66j\"[$A=,0&4&<!tVa9a1lL#)P Ȁ\\@(0Y@ , `E-$H(`_D: `9 T6<M8^U>90肍4!#)Vv:0@0C,P X/_$PJT0X8OIBX\0B pK4􂚦 .O&dIɁtvC4:P:`1A,\0\0\0< ̛\\ 8¦B+@L=@%Ap;,``&C-,c$`)$ç_<nB_<(\0 DH\\^Lj@
xA
dTHUA;ܞBE:@h,rKCFB<.x<)zDM`X&9>\0pB%U@ P\0X+b+0W
THzF\\=+_,/,].Q&T.Ӿ;l`|:CֈB|~U\0 H\0e-09Ё*l6Y-=1ĵ^\0U/uTdxC08=. :`/<C\'B%@Q T* pAn97C\\þ~\\\0*{|EmbdB|.4DB/,UBL\0 7ؓf­B=\0+/<C:,B\\\0\0A *9A6tAH1띦Cb;Ax3(| M[*D8aY=Co0H#6 @@
t \0 \0 @kL G9DZR.4A4*$.|!}B1/h)DqH1BDĪ`$*#6<DTk~\0,
4xVǡͅD P@\0DA;<cBxb\\-SX\\œ;&@7B˒3@ (http://www.vbulletin.com/forum/)_ &!I L̈(|b |E)nH=<9A Dߡ\0 Q4)C4D:\0:t\'+4@ dN\0*2³x
)x%B@B\\S6@4=`:
f83[AĬM(2C7\'CB@d@IA|\0+ $:aSB\'D_%E!98Aݧ)$dt\' @ @A\"݃ XA \\`A8N\\:<&@>Tk v8Z)1` HH\0 XA:1 T Xg:|0@dg\0 @DlL^)H\0kI,

-6`l(,1$QxgB<,a7CUdX P@\0I\\gp*@\0/`cE&:\0\0h&hC^3/B@\0x
EWzri TT@@ \0 \0Y\"jZ[\\>X\0T\0x@]ɜ\"A\' ,WBcudcS\0 \0T,J0r xH
@ h,$r (@ h,$r) DlA)^u< }`vj ᖪJ8 \0O
 D0t#^M6@plnR\'(;B쌑P\0Ĺ ygme$)#:dZ@Y]A&\09`CaDB@e\\W@>&T (D*Ȁ`n
 `\0{ 7\"T(`m BO\\=<?*u{C88FJ |@
\0W<:RA%Ú\\l@ X/<M0@&>ټx>,BA (M0@&>ټx>,BA) L_FT@
_I@c=ɄO\0\0\0 كڟ\0;',
NOW(),
'sindol.gif',
0,
152,
153,
'1'
)

mysql error: Duplicate entry '3615' for key 1
mysql error number: 1062
Date: Wednesday 15th 2006f March 2006 10:51:12 AM
Database: forums
MySQL error:

and also it freezes after inserting couple of users

Steve Machol
Wed 15th Mar '06, 2:33am
What is the script info from this error?

Colin F
Wed 15th Mar '06, 5:03am
That error says that it's trying to add an avatar, although an avatar for that user is already there.

If you're doing an import into an empty vBulletin forum, run this query and rerun that module:
TRUNCATE TABLE customavatar;

Jerry
Wed 15th Mar '06, 2:22pm
Most likely from a re-run import, or a crashed session, the user module attempts to clean the customavatar table.