more on books, some not uploading and giving errors

[Turath]

this is a bug that was in the old collector too, I shoulda reported it back then.

well, here's the deal, I only noticed this happening with a few books in PoK. Now while it's collecting it gives no type of error, just shows the text that's being logged as usual, but durring upload I get this error

Error uploading text #Mujaki2: You have an error in your SQL syntax near 'p' at line 1

I'd get that with a few other books too, can't remember offhand which ones it was, but after that error it just stops uploading texts and packetcollector stops and goes to the command prompt.

Still got my logged texts file that collector makes, it's 165k can lemme know if ya want it to look through it, am sure if you can make the collector jump past any "bad" books instead of just closing then you can find the others that don't upload right either and find what is causing it easier.

And, just incase you want to see all of what it did before the error...

Uploading texts to table: 'texts_dump'
Unchanged: AKHBook1
Unchanged: AKHBook2
Unchanged: Ardathium1
Unchanged: Ardathium2
Unchanged: Ardathium3
Unchanged: Ardathium4
Unchanged: Ardathium5
Unchanged: Ardathium6
Unchanged: Bin1Cok
Unchanged: Bin2Cok
Unchanged: CHRMPoPAccess
Unchanged: CeteltVol1
Unchanged: CeteltVol2
Unchanged: ClericResearch1
Unchanged: ClericResearch2
Unchanged: DruidResearch1
Unchanged: DruidResearch2
Unchanged: DyingStain
Unchanged: ErudJourn1
Unchanged: ErudJourn2
Unchanged: ErudJourn3
Unchanged: ErudJourn4
Unchanged: FoHateV1
Unchanged: FoHateV2
Unchanged: FoHateV3
Unchanged: FoHateV4
Unchanged: FoHateV5
Unchanged: FoHateV6
Unchanged: FoHateV7
Unchanged: FoHateV8
Unchanged: FoHateV9
Unchanged: GhumCok1
Unchanged: GhumCok2
Unchanged: GromokVol1
Unchanged: GromokVol2
Unchanged: GromokVol3
Unchanged: GromokVol4
Unchanged: HowToSewLg
Unchanged: HowToSewMd
Unchanged: HowToSewSm
Unchanged: JewelCrft1
Updated: LLDAugText
Unchanged: Lxanvon1
Unchanged: Lxanvon2
Unchanged: Mujaki1
Error uploading text #Mujaki2: You have an error in your SQL syntax near 'p' at line 1

ok, well if ya need more info, or my file or anything just let me know.

[Edgar1898]

Could you email me your file if you dont mind so I can test a solution?

My email addy is LethalEncounter@eqemulator.net

[Edgar1898]

Thanks for the email, packetcollector is now updated, please get Packet Collector v0.8.2b before you collect more texts
Its downloadable from:

http://osdn.dl.sourceforge.net/sourc...tCollector.zip