Ouverture impossible erreur 1000 SQL HY000

Fichier corrompu, impossible à ouvrir ou avec affichage du filtre ASCII. Venez déposer ici votre document.

Modérateur : Vilains modOOs

Règles du forum
:alerte: Règles spécifiques à cette section du forum :
Les demandes de récupération par messages privés ne sont pas admises et n'obtiendront pas de réponse. Veuillez créer un sujet dans cette section.
Les fichiers récupérés seront supprimés du forum dès que possible par un modérateur lorsque que vous en ferez la demande dans votre dernier message.
JohanMarkus
Fraîchement OOthentifié
Messages : 2
Inscription : 05 août 2010 15:12

Ouverture impossible erreur 1000 SQL HY000

Message par JohanMarkus »

Bonjour,
alors, j ai OO.ord 321 sur un mac intel avec Mac OSX 10.4.11,

J ai créée une base, j'étais en train de remplir un formulaire.
J ai copié le formulaire (dans le but de me servir de l un pour le remplissage de la base, et de l autre, après, pour la consultation)

Et après... du fait du nombre de fenêtres ouvertes, je ne suis pas sorti très proprement
d abord un ou 2 cliks sur le bouton rouge, puis, pendant qu'il fermait, click droit sur le dock, quitter openoffice.

Depuis, impossible de ré-ouvrir mon fichier de base de données :
monfichier.ODB : OO.o me demande un filtre,
et, quoi que je mette (base ODF, base ODB), celà me créée des erreurs :

Code : Tout sélectionner

impossible d'établir une connexion avec la source de donnée "MaBase".

La classe de pilote " n'a pu être chargée
------------------------
code erreur : 1000
La classe de pilote " n'a pu être chargée
------------------------
Statut SQL : HY000
 La classe de pilote " n'a pu être chargée
(J ai installé NeoOffice 3.1.1. patch 1, mais il ne réussit pas plus à ouvrir le fichier, et me demande aussi un filtre de type de fichier (celà donne "erreur générale" lorsque je valide un type de fichier))

Peut-être peut-on ouvrir malgré tout en consultation, pour débuguer, en allant se retrouvant à l'endroit qui pose problème, pour pouvoir le modifier ?
(p.s. je n ai bien sûr pas de sauvegarde antérieure de ma base ^^)

merci à vous

p.s. j'ai réussis à accéder à la fenêtre Base ( "Tables Requêtes Formulaires Rapports"),
mais, dès que je clique sur "Tables", l'erreur

Code : Tout sélectionner

impossible d'établir une connexion avec la source de donnée "MaBase".

La classe de pilote " n'a pu être chargée
revient
OpenOffice 3.2.1 sur mac intel avec OSX 10.4.11
Avatar de l’utilisateur
Dude
IdOOle de la suite
IdOOle de la suite
Messages : 26023
Inscription : 03 mars 2006 07:45
Localisation : 127.0.0.1

Re: ouverture impossible erreur 1000 SQL HY000

Message par Dude »

Salut,
JohanMarkus a écrit :je ne suis pas sorti très proprement
:roll:
JohanMarkus a écrit :je n ai bien sûr pas de sauvegarde antérieure de ma base
:aie:

Quelques pistes : Il va s'en dire que lorsque OOo demande un filtre pour lire son propre format, cela sent plutôt le sapin.
Poser une question, c'est bien. Répondre aux autres, c'est encore mieux.
Améliorez AOO et votez pour les issues
JohanMarkus
Fraîchement OOthentifié
Messages : 2
Inscription : 05 août 2010 15:12

Re: ouverture impossible erreur 1000 SQL HY000

Message par JohanMarkus »

Merci

alors,
1-Etape 1 : le dézippage (pour les plus impatients : celà marche :) merci Dude)

- BOMarchiveHelper -> bug : le fichier est en cours de décompression indéfiniment
- Stuffit Expander 10.0.2 : arrêt de la décompression : "An error occured attempting to expand 'MaBase'. The archive may be damaged. Error #17537"
- Stuffit Expander 14.0.1 : un rapport par chez apple, et un dossier temporaire vide MaBase.zip123456789.tmp est créée
le rapport envoyé :

Code : Tout sélectionner

Date/Time:      2010-08-06 16:43:11.795 +0200
OS Version:     10.4.11 (Build 8S2167)
Report Version: 4

Command: StuffIt Expander
Path:    /Applications/StuffIt/StuffIt Expander.app/Contents/MacOS/StuffIt Expander
Parent:  WindowServer [59]

Version: 14.0.1 (14.0.1)

PID:    234
Thread: 1

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000000

Thread 0:
0   libSystem.B.dylib              	0x90009817 mach_msg_trap + 7
1   com.apple.CoreFoundation       	0x9082d227 CFRunLoopRunSpecific + 2014
2   com.apple.CoreFoundation       	0x9082ca42 CFRunLoopRunInMode + 61
3   com.apple.HIToolbox            	0x92e01878 RunCurrentEventLoopInMode + 285
4   com.apple.HIToolbox            	0x92e00f82 ReceiveNextEventCommon + 385
5   com.apple.HIToolbox            	0x92e00dd9 BlockUntilNextEventMatchingListInMode + 81
6   com.apple.AppKit               	0x932a6f45 _DPSNextEvent + 572
7   com.apple.AppKit               	0x932a6b37 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 137
8   com.apple.AppKit               	0x93371c01 -[NSApplication _realDoModalLoop:peek:] + 439
9   com.apple.AppKit               	0x93370a98 -[NSApplication runModalForWindow:] + 171
10  com.stuffit.Expander           	0x0001b419 ACL::ThrowIfNot(bool) + 6827
11  com.stuffit.Expander           	0x0000792d void ACL::ThrowIfNull<__CFString const*>(__CFString const*) + 1487
12  com.stuffit.Expander           	0x00006b92 ExpandThread<OpaqueArcObjectRef*, ExpandArchiveItem, CopyArchiveObjectRef, DisposeArchiveObjectRef>::Run() + 1086
13  com.stuffit.Expander           	0x00004e42 ACL::CF::CFAutoPtr<__CFString const*>::CFAutoPtr[not-in-charge](__CFString const*) + 6094
14  com.stuffit.Expander           	0x000041cd ACL::CF::CFAutoPtr<__CFString const*>::CFAutoPtr[not-in-charge](__CFString const*) + 2905
15  com.stuffit.Expander           	0x00004a38 ACL::CF::CFAutoPtr<__CFString const*>::CFAutoPtr[not-in-charge](__CFString const*) + 5060
16  com.stuffit.Expander           	0x000047dd ACL::CF::CFAutoPtr<__CFString const*>::CFAutoPtr[not-in-charge](__CFString const*) + 4457
17  com.apple.Foundation           	0x928189cf __NSFireDelayedPerform + 403
18  com.apple.CoreFoundation       	0x9082d756 CFRunLoopRunSpecific + 3341
19  com.apple.CoreFoundation       	0x9082ca42 CFRunLoopRunInMode + 61
20  com.apple.HIToolbox            	0x92e01878 RunCurrentEventLoopInMode + 285
21  com.apple.HIToolbox            	0x92e00f82 ReceiveNextEventCommon + 385
22  com.apple.HIToolbox            	0x92e00dd9 BlockUntilNextEventMatchingListInMode + 81
23  com.apple.AppKit               	0x932a6f45 _DPSNextEvent + 572
24  com.apple.AppKit               	0x932a6b37 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 137
25  com.apple.AppKit               	0x932a08c4 -[NSApplication run] + 512
26  com.apple.AppKit               	0x93294820 NSApplicationMain + 573
27  com.stuffit.Expander           	0x00002972 0x1000 + 6514
28  com.stuffit.Expander           	0x00002899 0x1000 + 6297

Thread 1 Crashed:
0   com.stuffit.sdk                	0x0023c7b7 NewOpaqueArcObjectRef(StuffItEngineSDK::EngineInstance&, engine6::Item*, OpaqueArchiveRef*) + 25
1   com.stuffit.sdk                	0x00215b18 StuffItEngineSDK::NotifyClientAboutWarning(StuffItEngineSDK::EngineInstance&, engine6::Item const&, bool&) + 202
2   com.stuffit.sdk                	0x002117dc StuffItEngineSDK::BaseExpansionClient::warn(StuffItEngineSDK::SDKClient const&, unsigned short, engine6::Item const*, engine6::Item*, bool&) + 38
3   com.stuffit.sdk                	0x002135ed StuffItEngineSDK::SDKClient::warn(unsigned short, engine6::Item const*, engine6::Item*) + 115
4   com.stuffit.format.zip         	0x0e11e56d engine6::zip::Archive::expandSequentially(engine6::Folder&, engine6::ContainerAdaptor*) const + 845
5   com.stuffit.stuffitcore        	0x0028b425 engine6::mac::FolderItem::_addContent(engine6::Container const&, engine6::ContainerAdaptor*) + 35
6   com.stuffit.stuffitcore        	0x002a7f89 engine6::Folder::acquireAddedContent(engine6::Container const&) + 311
7   com.stuffit.stuffitcore        	0x002a6f3a engine6::Folder::addContent(engine6::Container const&) + 24
8   com.stuffit.sdk                	0x0021e6ce StuffItEngineSDK::ExpandContent(StuffItEngineSDK::EngineInstance&, engine6::Archive&, StuffItEngineSDK::ArchiveAccess&, engine6::Folder&, bool, std::vector<pattern::AcquiredPtr<engine6::Item>, std::allocator<pattern::AcquiredPtr<engine6::Item> > >&) + 420
9   com.stuffit.sdk                	0x0021eb29 StuffItEngineSDK::ExpandArchive(StuffItEngineSDK::EngineInstance&, pattern::AcquiredPtr<engine6::Archive>&, engine6::File const&, engine6::Format const&, fs::Spec&, std::basic_string<char, std::char_traits<char>, std::allocator<char> >&, bool, std::vector<pattern::AcquiredPtr<engine6::Item>, std::allocator<pattern::AcquiredPtr<engine6::Item> > >&, std::vector<pattern::AcquiredPtr<engine6::Item>, std::allocator<pattern::AcquiredPtr<engine6::Item> > >) + 371
10  com.stuffit.sdk                	0x0021efb5 StuffItEngineSDK::ExpandFile(OpaqueEngineObject*, OpaqueFSObject*, OpaqueFSObject*, OpaqueFileList**, OpaqueStringObject*, StuffItEngineSDK::EngineStatus::EngineAction) + 931
11  com.stuffit.sdk                	0x0022eeb9 ExpandOrDecodeFile + 53
12  com.stuffit.Expander           	0x00006474 ExpandThread<OpaqueFSObject*, ExpandWholeArchive, CopyFSObjectRef, DisposeFSObjectRef>::Run() + 60
13  com.stuffit.Expander           	0x00007873 void ACL::ThrowIfNull<__CFString const*>(__CFString const*) + 1301
14  ...ple.CoreServices.CarbonCore 	0x90cb8ce0 PrivateMPEntryPoint + 51
15  libSystem.B.dylib              	0x90023d67 _pthread_body + 84

Thread 2:
0   libSystem.B.dylib              	0x9003f21f syscall_thread_switch + 7
1   com.apple.AppKit               	0x9337e0b2 -[NSUIHeartBeat _heartBeatThread:] + 1399
2   com.apple.Foundation           	0x92802cfc forkThreadForFunction + 123
3   libSystem.B.dylib              	0x90023d67 _pthread_body + 84

Thread 3:
0   libSystem.B.dylib              	0x90019d0c select + 12
1   libSystem.B.dylib              	0x90023d67 _pthread_body + 84

Thread 1 crashed with X86 Thread State (32-bit):
  eax: 0x00000000  ebx: 0x00215a59  ecx: 0x02182dcc  edx: 0x02182db0
  edi: 0x0216ad00  esi: 0x00000000  ebp: 0xb011e988  esp: 0xb011e970
   ss: 0x0000001f  efl: 0x00010246  eip: 0x0023c7b7   cs: 0x00000017
   ds: 0x0000001f   es: 0x0000001f   fs: 0x00000000   gs: 0x00000037

Binary Images Description:
    0x1000 -    0x29fff com.stuffit.Expander 14.0.1	/Applications/StuffIt/StuffIt Expander.app/Contents/MacOS/StuffIt Expander
   0x82000 -    0x8efff org.andymatuschak.Sparkle ??? (1.1)	/Applications/StuffIt/StuffIt Expander.app/Contents/Frameworks/Sparkle.framework/Versions/A/Sparkle
  0x205000 -   0x24efff com.stuffit.sdk 14.0.1	/Applications/StuffIt/StuffIt Expander.app/Contents/Frameworks/StuffIt.framework/Versions/B/StuffIt
  0x287000 -   0x319fff com.stuffit.stuffitcore 14.0.1	/Applications/StuffIt/StuffIt Expander.app/Contents/Frameworks/StuffItCore.framework/Versions/A/StuffItCore
  0x415000 -   0x502fff com.apple.WebKit 4533 (4533.16)	/System/Library/Frameworks/WebKit.framework/Versions/A/WebKit
  0x5a7000 -   0x77cfff com.apple.JavaScriptCore 4533 (4533.13)	/System/Library/Frameworks/JavaScriptCore.framework/Versions/A/JavaScriptCore
 0x1008000 -  0x1ac6fff com.apple.WebCore 4533 (4533.16)	/System/Library/Frameworks/WebKit.framework/Versions/A/Frameworks/WebCore.framework/Versions/A/WebCore
 0xe11a000 -  0xe17bfff com.stuffit.format.zip 902.894.2370	/Applications/StuffIt/StuffIt Expander.app/Contents/Frameworks/StuffItCore.framework/Versions/A/Plug-Ins/zip.bundle/Contents/MacOS/zip
0x8fe00000 - 0x8fe4afff dyld 46.16	/usr/lib/dyld
0x90000000 - 0x90171fff libSystem.B.dylib 	/usr/lib/libSystem.B.dylib
0x901c1000 - 0x901c3fff libmathCommon.A.dylib 	/usr/lib/system/libmathCommon.A.dylib
0x901c5000 - 0x90202fff com.apple.CoreText 1.1.3 (???)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreText.framework/Versions/A/CoreText
0x90229000 - 0x902fffff ATS 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ATS.framework/Versions/A/ATS
0x9031f000 - 0x90774fff com.apple.CoreGraphics 1.258.85 (???)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/CoreGraphics
0x9080b000 - 0x908d3fff com.apple.CoreFoundation 6.4.11 (368.35)	/System/Library/Frameworks/CoreFoundation.framework/Versions/A/CoreFoundation
0x90911000 - 0x90911fff com.apple.CoreServices 10.4 (???)	/System/Library/Frameworks/CoreServices.framework/Versions/A/CoreServices
0x90913000 - 0x90a07fff libicucore.A.dylib 	/usr/lib/libicucore.A.dylib
0x90a57000 - 0x90ad6fff libobjc.A.dylib 	/usr/lib/libobjc.A.dylib
0x90aff000 - 0x90b63fff libstdc++.6.dylib 	/usr/lib/libstdc++.6.dylib
0x90bd2000 - 0x90bd9fff libgcc_s.1.dylib 	/usr/lib/libgcc_s.1.dylib
0x90bde000 - 0x90c51fff com.apple.framework.IOKit 1.4.8 (???)	/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit
0x90c66000 - 0x90c78fff libauto.dylib 	/usr/lib/libauto.dylib
0x90c7e000 - 0x90f24fff com.apple.CoreServices.CarbonCore 682.31 (682.32)	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CarbonCore.framework/Versions/A/CarbonCore
0x90f67000 - 0x90fcffff com.apple.CoreServices.OSServices 4.1	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/OSServices.framework/Versions/A/OSServices
0x91008000 - 0x91047fff com.apple.CFNetwork 129.24	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/CFNetwork.framework/Versions/A/CFNetwork
0x9105a000 - 0x9106afff com.apple.WebServices 1.1.3 (1.1.0)	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/WebServicesCore.framework/Versions/A/WebServicesCore
0x91075000 - 0x910f4fff com.apple.SearchKit 1.0.8	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/SearchKit.framework/Versions/A/SearchKit
0x9112e000 - 0x9114cfff com.apple.Metadata 10.4.4 (121.36)	/System/Library/Frameworks/CoreServices.framework/Versions/A/Frameworks/Metadata.framework/Versions/A/Metadata
0x91158000 - 0x91166fff libz.1.dylib 	/usr/lib/libz.1.dylib
0x91169000 - 0x91308fff com.apple.security 4.5.2 (29774)	/System/Library/Frameworks/Security.framework/Versions/A/Security
0x91406000 - 0x9140efff com.apple.DiskArbitration 2.1.2	/System/Library/Frameworks/DiskArbitration.framework/Versions/A/DiskArbitration
0x91415000 - 0x9141cfff libbsm.dylib 	/usr/lib/libbsm.dylib
0x91420000 - 0x91446fff com.apple.SystemConfiguration 1.8.6	/System/Library/Frameworks/SystemConfiguration.framework/Versions/A/SystemConfiguration
0x91458000 - 0x914cefff com.apple.audio.CoreAudio 3.0.5	/System/Library/Frameworks/CoreAudio.framework/Versions/A/CoreAudio
0x9151f000 - 0x9151ffff com.apple.ApplicationServices 10.4 (???)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/ApplicationServices
0x91521000 - 0x9154dfff com.apple.AE 316.3	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/AE.framework/Versions/A/AE
0x91560000 - 0x91634fff com.apple.ColorSync 4.4.13	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ColorSync.framework/Versions/A/ColorSync
0x9166f000 - 0x916ecfff com.apple.print.framework.PrintCore 4.6 (177.13)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/PrintCore.framework/Versions/A/PrintCore
0x91719000 - 0x917c2fff com.apple.QD 3.10.28 (???)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/QD.framework/Versions/A/QD
0x917e8000 - 0x91833fff com.apple.HIServices 1.5.2 (???)	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/HIServices.framework/Versions/A/HIServices
0x91852000 - 0x91868fff com.apple.LangAnalysis 1.6.3	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/LangAnalysis.framework/Versions/A/LangAnalysis
0x91874000 - 0x9188efff com.apple.FindByContent 1.5	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/FindByContent.framework/Versions/A/FindByContent
0x91898000 - 0x918d5fff com.apple.LaunchServices 183.1	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/LaunchServices.framework/Versions/A/LaunchServices
0x918e9000 - 0x918f5fff com.apple.speech.synthesis.framework 3.5	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/SpeechSynthesis.framework/Versions/A/SpeechSynthesis
0x918fc000 - 0x9193cfff com.apple.ImageIO.framework 1.5.9	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/ImageIO
0x9194f000 - 0x91a01fff libcrypto.0.9.7.dylib 	/usr/lib/libcrypto.0.9.7.dylib
0x91a47000 - 0x91a5dfff libcups.2.dylib 	/usr/lib/libcups.2.dylib
0x91a62000 - 0x91a80fff libJPEG.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libJPEG.dylib
0x91a85000 - 0x91ae4fff libJP2.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libJP2.dylib
0x91af6000 - 0x91afafff libGIF.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libGIF.dylib
0x91afc000 - 0x91b84fff libRaw.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libRaw.dylib
0x91b88000 - 0x91ba3fff libPng.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
0x91ba8000 - 0x91baafff libRadiance.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libRadiance.dylib
0x91bac000 - 0x91c8afff libxml2.2.dylib 	/usr/lib/libxml2.2.dylib
0x91ca7000 - 0x91ce6fff libTIFF.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/libTIFF.dylib
0x91cec000 - 0x91cecfff com.apple.Accelerate 1.3.1 (Accelerate 1.3.1)	/System/Library/Frameworks/Accelerate.framework/Versions/A/Accelerate
0x91cee000 - 0x91d7cfff com.apple.vImage 2.5	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vImage.framework/Versions/A/vImage
0x91d83000 - 0x91d83fff com.apple.Accelerate.vecLib 3.3.1 (vecLib 3.3.1)	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/vecLib
0x91d85000 - 0x91ddefff libvMisc.dylib 	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libvMisc.dylib
0x91de7000 - 0x91e0bfff libvDSP.dylib 	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libvDSP.dylib
0x91e13000 - 0x9221cfff libBLAS.dylib 	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib
0x92256000 - 0x9260afff libLAPACK.dylib 	/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libLAPACK.dylib
0x92637000 - 0x92724fff libiconv.2.dylib 	/usr/lib/libiconv.2.dylib
0x92726000 - 0x927a4fff com.apple.DesktopServices 1.3.7	/System/Library/PrivateFrameworks/DesktopServicesPriv.framework/Versions/A/DesktopServicesPriv
0x927e5000 - 0x92a1dfff com.apple.Foundation 6.4.12 (567.42)	/System/Library/Frameworks/Foundation.framework/Versions/C/Foundation
0x92b3d000 - 0x92b54fff libGL.dylib 	/System/Library/Frameworks/OpenGL.framework/Versions/A/Libraries/libGL.dylib
0x92b5f000 - 0x92bb7fff libGLU.dylib 	/System/Library/Frameworks/OpenGL.framework/Versions/A/Libraries/libGLU.dylib
0x92bcb000 - 0x92bcbfff com.apple.Carbon 10.4 (???)	/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon
0x92bcd000 - 0x92bddfff com.apple.ImageCapture 3.0.4	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/ImageCapture.framework/Versions/A/ImageCapture
0x92beb000 - 0x92bf3fff com.apple.speech.recognition.framework 3.6	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/SpeechRecognition.framework/Versions/A/SpeechRecognition
0x92bf9000 - 0x92bfefff com.apple.securityhi 2.0.1 (24742)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/SecurityHI.framework/Versions/A/SecurityHI
0x92c04000 - 0x92c95fff com.apple.ink.framework 101.2.1 (71)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Ink.framework/Versions/A/Ink
0x92ca9000 - 0x92cacfff com.apple.help 1.0.3 (32.1)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Help.framework/Versions/A/Help
0x92caf000 - 0x92ccdfff com.apple.openscripting 1.2.7 (???)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/OpenScripting.framework/Versions/A/OpenScripting
0x92cdf000 - 0x92ce5fff com.apple.print.framework.Print 5.1 (192.3)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/Print.framework/Versions/A/Print
0x92ceb000 - 0x92d4efff com.apple.htmlrendering 66.1 (1.1.3)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/HTMLRendering.framework/Versions/A/HTMLRendering
0x92d72000 - 0x92db3fff com.apple.NavigationServices 3.4.4 (3.4.3)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/NavigationServices.framework/Versions/A/NavigationServices
0x92dda000 - 0x92de7fff com.apple.audio.SoundManager 3.9.1	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/CarbonSound.framework/Versions/A/CarbonSound
0x92dee000 - 0x92df3fff com.apple.CommonPanels 1.2.3 (73)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/CommonPanels.framework/Versions/A/CommonPanels
0x92df8000 - 0x930edfff com.apple.HIToolbox 1.4.10 (???)	/System/Library/Frameworks/Carbon.framework/Versions/A/Frameworks/HIToolbox.framework/Versions/A/HIToolbox
0x931f3000 - 0x931fefff com.apple.opengl 1.4.16	/System/Library/Frameworks/OpenGL.framework/Versions/A/OpenGL
0x9328e000 - 0x9328efff com.apple.Cocoa 6.4 (???)	/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa
0x93290000 - 0x93946fff com.apple.AppKit 6.4.10 (824.48)	/System/Library/Frameworks/AppKit.framework/Versions/C/AppKit
0x93cc7000 - 0x93d42fff com.apple.CoreData 91 (92.1)	/System/Library/Frameworks/CoreData.framework/Versions/A/CoreData
0x93d7b000 - 0x93e34fff com.apple.audio.toolbox.AudioToolbox 1.4.7	/System/Library/Frameworks/AudioToolbox.framework/Versions/A/AudioToolbox
0x93e77000 - 0x93e77fff com.apple.audio.units.AudioUnit 1.4.2	/System/Library/Frameworks/AudioUnit.framework/Versions/A/AudioUnit
0x93e79000 - 0x9403afff com.apple.QuartzCore 1.4.12	/System/Library/Frameworks/QuartzCore.framework/Versions/A/QuartzCore
0x94080000 - 0x940c1fff libsqlite3.0.dylib 	/usr/lib/libsqlite3.0.dylib
0x940c9000 - 0x94103fff libGLImage.dylib 	/System/Library/Frameworks/OpenGL.framework/Versions/A/Libraries/libGLImage.dylib
0x94108000 - 0x9411efff com.apple.CoreVideo 1.4.2	/System/Library/Frameworks/CoreVideo.framework/Versions/A/CoreVideo
0x942b0000 - 0x942bffff libCGATS.A.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libCGATS.A.dylib
0x942c6000 - 0x942d1fff libCSync.A.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libCSync.A.dylib
0x9431d000 - 0x94337fff libRIP.A.dylib 	/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/CoreGraphics.framework/Versions/A/Resources/libRIP.A.dylib
0x9433d000 - 0x9465cfff com.apple.QuickTime 7.6.4 (1327.73)	/System/Library/Frameworks/QuickTime.framework/Versions/A/QuickTime
0xc0000000 - 0xc0008fff com.growl.growlframework 0.7.6	/Applications/StuffIt/StuffIt Expander.app/Contents/Frameworks/Growl.framework/Versions/A/Growl

Model: iMac4,1, BootROM IM41.0055.B08, 2 processors, Intel Core Duo, 1.83 GHz, 1 GB
Graphics: ATI Radeon X1600, ATY,RadeonX1600, PCIe, 128 MB
Memory Module: BANK 0/DIMM0, 512 MB, DDR2 SDRAM, 667 MHz
Memory Module: BANK 1/DIMM1, 512 MB, DDR2 SDRAM, 667 MHz
AirPort: spairport_wireless_card_type_airport_extreme (0x14E4, 0x89), Broadcom BCM43xx 1.0 (4.170.46.9)
Bluetooth: Version 1.9.5f4, 2 service, 0 devices, 1 incoming serial ports
Network Service: AirPort, AirPort, en1
Serial ATA Device: ST3160023AS, 149.05 GB
Parallel ATA Device: MATSHITADVD-R   UJ-846
USB Device: Built-in iSight, Micron, Up to 480 Mb/sec, 500 mA
USB Device: USB Mouse, Logitech, Up to 1.5 Mb/sec, 500 mA
USB Device: Bluetooth USB Host Controller, Apple, Inc., Up to 12 Mb/sec, 500 mA
USB Device: IR Receiver, Apple Computer, Inc., Up to 12 Mb/sec, 500 mA
USB Device: Hub in Apple Pro Keyboard, Mitsumi Electric, Up to 12 Mb/sec, 500 mA
USB Device: Apple Pro Keyboard, Mitsumi Electric, Up to 12 Mb/sec, 250 mA
- The Unarchiver 2.4 : là, celà marche, le fichier est dézippé.


(si je détaille l'étape 1, c est pour 2 choses :
que ceux qui ont un problème de décompression sous mac sache que the unarchiver2.4 peut les aider,
et pour garder trace du rapport de stuffit, pour peut-etre en tirer une info sur la localisation du problème)

2- Etape 2 : l'éditeur XML
(pré-étape 2, DL plusieurs editeurs XML (Jaxe, Mex, exchanger-editor/xngr-editor)
utilisation de Mex, celà donne :

Code : Tout sélectionner

<office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:db="urn:oasis:names:tc:opendocument:xmlns:database:1.0" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" office:version="1.2" grddl:transformation="http://docs.oasis-open.org/office/1.2/xslt/odf2rdf.xsl"><office:scripts/><office:font-face-decls><style:font-face style:name="F" svg:font-family=""/></office:font-face-decls><office:automatic-styles><style:style style:name="co1" style:family="table-column" style:data-style-name="N0"/><style:style style:name="co2" style:family="table-column" style:data-style-name="N0"><style:table-column-properties style:column-width="3.23cm"/></style:style><style:style style:name="co3" style:family="table-column"/><style:style style:name="co4" style:family="table-column" style:data-style-name="N106"/><style:style style:name="ce1" style:family="table-cell"><style:paragraph-properties fo:text-align="start"/></style:style><number:number-style style:name="N0" number:language="fr" number:country="FR"><number:number number:min-integer-digits="1"/></number:number-style><number:date-style style:name="N106" number:language="fr" number:country="FR"><number:text>fil</number:text><number:year/><number:text>:///U</number:text><number:seconds number:decimal-places="91"/><number:year number:style="long"/><number:year/><number:seconds number:decimal-places="91"/></number:date-style></office:automatic-styles><office:body><office:database><db:data-source><db:connection-data><db:connection-resource xlink:href="sdbc:embedded:hsqldb"/><db:login db:is-password-required="false"/></db:connection-data><db:driver-settings db:system-driver-settings="" db:base-dn="" db:parameter-name-substitution="false"/><db:application-connection-settings db:is-table-name-length-limited="false" db:append-table-alias-name="false" db:max-row-count="100"><db:table-filter><db:table-include-filter><db:table-filter-pattern>%</db:table-filter-pattern></db:table-include-filter></db:table-filter></db:application-connection-settings></db:data-source><db:forms><db:component db:name="RemplirPageDossier" xlink:href="forms/Obj11" db:as-template="false"/></db:forms><db:table-representations><db:table-representation db:name="PageDossier"><db:columns><db:column db:name="Année" db:help-message="Année, valeur prise dans l&apos;ID" db:style-name="co1" db:default-cell-style-name="ce1"/><db:column db:name="Cahier" db:help-message="Lettre du cahier/dossier" db:type-name="string" db:default-value="O" db:style-name="co1" db:default-cell-style-name="ce1"/><db:column db:name="ID" db:style-name="co2" db:default-cell-style-name="ce1"/><db:column db:name="Image" db:help-message="image file:///Users/scanhisto/Sites/images/scan/" db:style-name="co3" db:default-cell-style-name="ce1"/><db:column db:name="Lien image" db:help-message="URL relative vers l&apos;image file:///Users/scanhisto/Sites/images/scan/" db:style-name="co4" db:default-cell-style-name="ce1"/><db:column db:name="Page" db:help-message="numero de page" db:style-name="co1" db:default-cell-style-name="ce1"/><db:column db:name="ScanCahier" db:help-message="image file:///Users/scanhisto/Sites/images/scan" db:style-name="co3" db:default-cell-style-name="ce1"/><db:column db:name="URLCahier" db:help-message="URL file:///Users/scanhisto/Sites/images/scan" db:style-name="co3" db:default-cell-style-name="ce1"/></db:columns></db:table-representation><db:table-representation db:name="TitreHisto"><db:columns><db:column db:name="Date" db:help-message="Date"/><db:column db:name="FouH" db:help-message="Oui pour F et Non pour H (+ 1a aaa nnnn)"/><db:column db:name="ID" db:help-message="Numero d echantillon dans le cahier histo (F-1234-98 -> 1998[2x1234]   H-21-08 -> 2008[00 2x21]"/><db:column db:name="IDHisto" db:help-message="Numero d echantillon dans le cahier histo"/><db:column db:name="Manip" db:help-message="Nom de la manip"/><db:column db:name="NPers1" db:help-message="Nom prenom 1ere personne (ordre alphabetique)"/><db:column db:name="NPers2" db:help-message="Nom prenom 2eme personne"/></db:columns><db:order-statement db:command=""TitreHisto"."ID""/></db:table-representation></db:table-representations></office:database></office:body></office:document-content>
avec, en particulier, 2 lignes qui se suivent, qui ont une couleur différente (gris-bleue la 1ere, et noire la 2eme, à chaque fois, les seules dans cette couleur)
la premiere :
%</db:table-filter-pattern></db:table-include-filter></db:table-filter></db:application-connection-settings></db:data-source><db:forms><db:component
la 2ème :
db:name="RemplirPageDossier" xlink:href="forms/Obj11" db:as-template="false"/

et pleins d'erreurs trouvées :

Code : Tout sélectionner

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:office:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "office:document-content" must be declared.

Error  at line number 2: 
Element type "office:scripts" must be declared.

Error  at line number 2: 
Element type "office:font-face-decls" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:font-face" must be declared.

Error  at line number 2: 
Element type "office:automatic-styles" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:style" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:style" must be declared.

Error  at line number 2: 
Element type "style:table-column-properties" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:style" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:style" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:style:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "style:style" must be declared.

Error  at line number 2: 
Element type "style:paragraph-properties" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "number:number-style" must be declared.

Error  at line number 2: 
Element type "number:number" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "number:date-style" must be declared.

Error  at line number 2: 
Element type "number:text" must be declared.

Error  at line number 2: 
Element type "number:year" must be declared.

Error  at line number 2: 
Element type "number:text" must be declared.

Error  at line number 2: 
Element type "number:seconds" must be declared.

Error  at line number 2: 
Element type "number:year" must be declared.

Error  at line number 2: 
Element type "number:year" must be declared.

Error  at line number 2: 
Element type "number:seconds" must be declared.

Error  at line number 2: 
Element type "office:body" must be declared.

Error  at line number 2: 
Element type "office:database" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:database:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "db:data-source" must be declared.

Error  at line number 2: 
Element type "db:connection-data" must be declared.

Error  at line number 2: 
Element type "db:connection-resource" must be declared.

Error  at line number 2: 
Element type "db:login" must be declared.

Error  at line number 2: 
Element type "db:driver-settings" must be declared.

Error  at line number 2: 
Element type "db:application-connection-settings" must be declared.

Error  at line number 2: 
Element type "db:table-filter" must be declared.

Error  at line number 2: 
Element type "db:table-include-filter" must be declared.

Error  at line number 2: 
Element type "db:table-filter-pattern" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:database:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "db:forms" must be declared.

Error  at line number 2: 
Element type "db:component" must be declared.

Error  at line number 2: 
General Schema Error: Grammar with uri: urn:oasis:names:tc:opendocument:xmlns:database:1.0 , can not be found; schema namespace may be wrong:  Xerces supports schemas from the "http://www.w3.org/2001/XMLSchema" namespace or the instance document's namespace may not match the targetNamespace of the schema.

Error  at line number 2: 
Element type "db:table-representations" must be declared.

Error  at line number 2: 
Element type "db:table-representation" must be declared.

Error  at line number 2: 
Element type "db:columns" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:table-representation" must be declared.

Error  at line number 2: 
Element type "db:columns" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:column" must be declared.

Error  at line number 2: 
Element type "db:order-statement" must be declared.


p.s.
je n ai temporairement plus accès à cette base de donnée / à cet ordi (vacances) donc je poursuivrais la résolution du pb à la rentrée, et je lirais vos réponses, mais bien sûr, d'ici là, je ne pourrais pas tester vos (mes) solutions
OpenOffice 3.2.1 sur mac intel avec OSX 10.4.11
libruser
NOOuvel adepte
NOOuvel adepte
Messages : 12
Inscription : 27 janv. 2011 16:06

Re: ouverture impossible erreur 1000 SQL HY000

Message par libruser »

Dude a écrit : [*]Impossible d'ouvrir mon fichier ODB[/list]
bonjour,

Je confirme l'utilité de la réponse donnée dans le lien ci-dessus.
J'avais un .obd qui refusait de s'ouvrir : la classe de pilote '' n'a pu être chargée (voir image ci-jointe)

Un contrôle de l'archive (avec 7-zip) m'indique que "settings.xml" est corrompu... j'ai donc ouvert le .odb avec 7-zip et supprimé le fichier, ca remarche pour l'instant !
(le fichier settings n'a pas été recréé et je ne sais pas dans quel mesure il est nécessaire ?)


Ajout :
ci-joint un fichier qui plante également à cause de "settings.xml" ... alors qu'il vient d'être crée et ne contient quasiment rien...

A priori, la corruption du fichier est du à la tentative de Formatage des données sur une colonne calculée d'une requête.
Vous ne pouvez pas consulter les pièces jointes insérées à ce message.
LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

sous Windows XP SP3