Status: New Owner: ---- Labels: Version3.8 Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any Desktop-Any GUI-Any
New issue 632 by isaf...@gmail.com: Unable to retrive blob data from MySQL https://code.google.com/p/gambas/issues/detail?id=632 1) Unable to retrive blob data from MySQL in version 3.8. However it was working well in version 3.7.1 2) [System] Gambas=3.8.0 OperatingSystem=Linux Kernel=3.16.0-45-generic Architecture=x86 Distribution=Ubuntu 14.04.3 LTS Desktop=GNOME Theme=Gtk Language=en_US.UTF-8 Memory=1948M [Libraries] Cairo=libcairo.so.2.11301.0 Curl=libcurl.so.4.3.0 DBus=libdbus-1.so.3.7.6 GStreamer=libgstreamer-0.10.so.0.30.0 GStreamer=libgstreamer-1.0.so.0.204.0 GTK+3=libgtk-3.so.0.1000.8 GTK+=libgtk-x11-2.0.so.0.2400.23 OpenGL=libGL.so.1.2.0 Poppler=libpoppler.so.44.0.0 Qt4=libQtCore.so.4.8.6 Qt5=libQt5Core.so.5.2.1 SDL=libSDL-1.2.so.0.11.4 [Environment] CLUTTER_IM_MODULE=xim COMPIZ_BIN_PATH=/usr/bin/ COMPIZ_CONFIG_PROFILE=ubuntu DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-ACXg2O8PxE DEFAULTS_PATH=/usr/share/gconf/ubuntu.default.path DESKTOP_SESSION=ubuntu DISPLAY=:0 GB_GUI=gb.qt4 GDMSESSION=ubuntu GDM_LANG=en_US GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop GIO_LAUNCHED_DESKTOP_FILE_PID=6895 GNOME_DESKTOP_SESSION_ID=this-is-deprecated GNOME_KEYRING_CONTROL=/run/user/1000/keyring-kGuAZu GNOME_KEYRING_PID=2183 GPG_AGENT_INFO=/run/user/1000/keyring-kGuAZu/gpg:0:1 GTK_IM_MODULE=ibus GTK_MODULES=overlay-scrollbar:unity-gtk-module HOME=/home/safiur IM_CONFIG_PHASE=1 INSTANCE= JOB=dbus LANG=en_US.UTF-8 LANGUAGE=en_US LC_ADDRESS=ne_NP LC_IDENTIFICATION=ne_NP LC_MEASUREMENT=ne_NP LC_MONETARY=ne_NP LC_NAME=ne_NP LC_NUMERIC=ne_NP LC_PAPER=ne_NP LC_TELEPHONE=ne_NP LC_TIME=ne_NP LOGNAME=safiur MANDATORY_PATH=/usr/share/gconf/ubuntu.mandatory.path PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games PWD=/home/safiur QT4_IM_MODULE=xim QT_IM_MODULE=ibus QT_QPA_PLATFORMTHEME=appmenu-qt5 SELINUX_INIT=YES SESSION=ubuntu SESSIONTYPE=gnome-session SESSION_MANAGER=local/safiur-HP-Compaq:@/tmp/.ICE-unix/2387,unix/safiur-HP-Compaq:/tmp/.ICE-unix/2387 SHELL=/bin/bash SHLVL=0 SSH_AUTH_SOCK=/run/user/1000/keyring-kGuAZu/ssh TEXTDOMAIN=im-config TEXTDOMAINDIR=/usr/share/locale/ TZ=:/etc/localtime UPSTART_SESSION=unix:abstract=/com/ubuntu/upstart-session/1000/2186 USER=safiur XAUTHORITY=/home/safiur/.Xauthority XDG_CONFIG_DIRS=/etc/xdg/xdg-ubuntu:/usr/share/upstart/xdg:/etc/xdg XDG_CURRENT_DESKTOP=Unity XDG_DATA_DIRS=/usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/ XDG_GREETER_DATA_DIR=/var/lib/lightdm-data/safiur XDG_MENU_PREFIX=gnome- XDG_RUNTIME_DIR=/run/user/1000 XDG_SEAT=seat0 XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0 XDG_SESSION_ID=c2 XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0 XDG_VTNR=7 XMODIFIERS=@im=ibus 3) I use gambas method to create a table with blob field in MySQL table. Dim hTable As Table hTable = $newCon.Tables.Add("tblimage") hTable.Fields.Add("fldid", db.Serial) hTable.Fields.Add("fldpic", db.Blob) hTable.PrimaryKey = ["fldid"] hTable.Update I use gambas method to insert image file in the above table. Dim res As Result res = $newCon.Create("tblimage") res["fldpic"] = File.Load("/home/safiur/picture.png") res.Update I use gambas method to retrive the image file from database and load onto ImageViewer. Dim res As Result Dim tempFile As String Dim hFile As Blob res = $newCon.Exec("select fldpic from tblimage") res.MoveFirst tempFile = Temp() & ".png" hFile = res["fldpic"] File.Save(tempFile, hFile.Data) ImageView1.Image = Image.Load(tempFile) -insert image works well. -retriving image is not working. 4) Attached 5) If your project needs a database, try to provide it, or part of it. 6) Explain clearly how to reproduce the bug or the crash. ____________________________________________________________ / \ | IMPORTANT NOTE #3 | | | | By doing that carefully, you have done 50% of the bug fix | | job. Often even more! | \____________________________________________________________/ ____________________________________________________________ / \ | IMPORTANT NOTE #4 | | | | Google automatically replaces references to Gambas | | development revision with links to its own source code | | repository, which Gambas does not use at all. So ignore | | these links with disdain. | \____________________________________________________________/ Attachments: imagedatabase.tar.gz 5.1 KB -- You received this message because this project is configured to send all issue notifications to this address. You may adjust your notification preferences at: https://code.google.com/hosting/settings ------------------------------------------------------------------------------ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user