I had installed mysql-query-browser-1.0.7a_beta and tried to upgrade to 1.1.4, but the ebuild says I need a least mysql 4.1. I'm using MySQL 4.0.22. The build instruction of mysql-query-browser says: mysql client libraries (4.0 or newer, 5.0 prefered) Therefore mysql-query-browser should work with MySQL >=4.0. Is there a problem why the ebuild requires MySQL >=4.1?
Yep same thing here. Please correct. I've created a copy of the ebuild in my overlay to correct the problem temporarly and it works perfectly.
The 1.0.7a_beta version that is, which is able to emerge for mysql 4.0. I got the ebuild from the cvs tree, since it got removed.
fixed in cvs.
Nope. Version 1.1.5 of mysql-query-browser doesn't work for me (mysql-4.0.22-r2) I get this error: make[7]: Nothing to be done for `all-am'. make[7]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview/docs' make[6]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview/docs' make[6]: Entering directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview' make[6]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview' make[5]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview' make[4]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux/gtksourceview' i686-pc-linux-gnu-g++ -march=pentium4 -O3 -pipe -fomit-frame-pointer -o mysql-query-browser-bin main.o html.o MGCellRendererBlob.o MQPreferences.o MQPreferencesEditor.o MGResultSetModel.o MQQueryDispatcher.o MQMainWindow.o MQResultSetView.o MQWorkArea.o MQBaseTab.o MQResultTab.oMQScriptEditorTab.o MQBookmarks.o MQHistory.o MQBookmarkBrowser.o MQHistoryBrowser.o MQFunctionBrowser.o MQNewBookmarkDialog.o MQIndicatorCellRenderer.o MQQueryParameters.o MQTableClauseMenu.o MGCodeEditor.o MQBaseModule.o MQSavedState.o MGCompletionList.o ../../library/source/libqb.a ../../../mysql-gui-common/source/linux/libqbcommongui.a ../../../mysql-gui-common/library/source/libmysqlx.a ../../source/linux/gtksourceview/gtksourceview/.libs/libgtksourceview-1.0.a -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib -lssl -lcrypto -Wl,--export-dynamic -pthread -L/usr/X11R6/lib -lgtkhtml-3.0 -lgnomeui-2 -lSM -lICE -lgnomeprintui-2-2 -lgal-2.0 -lgal-a11y-2.0 -lbonoboui-2 -lgnome-2 -lpopt -lgnomevfs-2 -lbonobo-2 -lgconf-2 -lbonobo-activation -lORBit-2 -lgthread-2.0 -lgnomecanvas-2 -lpangoft2-1.0 -lglade-2.0 -lgnomeprint-2-2 -lart_lgpl_2 -lxml2 -lpthread -lz -lgtkmm-2.0 -lgdkmm-2.0 -latkmm-1.0 -lgtk-x11-2.0 -lpangomm-1.0 -lglibmm-2.0 -lsigc-1.2 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lm -lpangoxft-1.0 -lpangox-1.0 -lpango-1.0 -lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0 -L/usr/lib -lpcre ../../../mysql-gui-common/library/source/libmysqlx.a(myx_recordset.o)(.text+0x4f0): In function `myx_query_execute': : undefined reference to `mysql_more_results' ../../../mysql-gui-common/library/source/libmysqlx.a(myx_recordset.o)(.text+0x5f0): In function `myx_query_execute': : undefined reference to `mysql_next_result' collect2: ld returned 1 exit status make[3]: *** [mysql-query-browser-bin] Error 1 make[3]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux' make[2]: *** [all] Error 2 make[2]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source/linux' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/var/tmp/portage/mysql-query-browser-1.1.5/work/mysql-query-browser-1.1.5/mysql-query-browser/source' make: *** [all-recursive] Error 1 !!! ERROR: dev-db/mysql-query-browser-1.1.5 failed. !!! Function src_compile, Line 34, Exitcode 2 !!! emake failed !!! If you need support, post the topmost build error, NOT this status message. emerge info: Portage 2.0.51-r15 (default-linux/x86/2005.0, gcc-3.3.5, glibc-2.3.4.20040808-r1, 2.6.10-gentoo-r6 i686) ================================================================= System uname: 2.6.10-gentoo-r6 i686 Intel(R) Pentium(R) 4 CPU 2.53GHz Gentoo Base System version 1.4.16 Python: dev-lang/python-2.3.4-r1 [2.3.4 (#1, Feb 7 2005, 19:30:18)] dev-lang/python: 2.3.4-r1 sys-devel/autoconf: 2.59-r6, 2.13 sys-devel/automake: 1.9.4, 1.5, 1.4_p6, 1.7.9-r1, 1.6.3, 1.8.5-r3 sys-devel/binutils: 2.15.92.0.2-r1 sys-devel/libtool: 1.5.10-r4 virtual/os-headers: 2.6.8.1-r2 ACCEPT_KEYWORDS="x86" AUTOCLEAN="yes" CFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer" CHOST="i686-pc-linux-gnu" CONFIG_PROTECT="/etc /opt/jetty/etc /usr/kde/2/share/config /usr/kde/3.3/env /usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/lib/fax /usr/lib/mozilla/defaults/pref /usr/share/config /usr/share/texmf/dvipdfm/config/ /usr/share/texmf/dvips/config/ /usr/share/texmf/tex/generic/config/ /usr/share/texmf/tex/platex/config/ /usr/share/texmf/xdvi/ /var/qmail/control /var/spool/fax/etc" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="autoaddcvs autoconfig ccache distlocks sandbox sfperms" GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/Linux/distributions/gentoo" LANG="de_DE@euro" LC_ALL="de_DE@euro" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/local/portage" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="x86 X X509 aac aalib accessibility acl acpi acpi4linux activefilter aim alsa ansi apache2 arts artworkextra async audiofile avi bash-completion berkdb bidi bitmap-fonts bluetooth brltty bsh bzlib cap caps cddb cdf cdparanoia cdr cdrom cgi chroot clanJavaScript clanVoice codecs commercial cpdflib crypt ctype cups curl curlwrappers dba dga dio directfb divx4linux djbfft dmx dnd doc dts dv dvb dvd dvdr dvdread emboss encode erandom esd exif expat extensions f77 faac faad fam fastcgi fax fbcon fdftk ffmpeg fftw flac flash flood font-server foomaticdb fortran fpx freetype gcj gd gdbm geoip ggi gif gimp gimpprint glade glut gnokii gnome gnutls gphoto2 gps graphviz gs gstreamer gtk gtk2 gtkhtml gui guile hal hbci hdf hub hyperwave-api iconv icq idea ieee1394 image imagemagick imap imlib inifile innodb intl iodbc ipv6 irda irmc isdn jabber jack jack-tmpfs jai java javadoc javamail javascript jbig jce jikes jimi joystick jp2 jpeg jpeg2k junit justify jython kde kerberos latex lcd lcms ldap lesstif libcaca libdsk libg++ libwww lirc lm_sensors log4j ltsp lua lzo lzw lzw-tiff mad mailbox maildir mailwrapper mbox mcal mcve md5sum mhash mikmod mime ming mixer mmap mmx mmx2 mng moneyplex monkey motif mozdevelop mozilla mozsvg mp3 mpeg mpeg4 mpi mplayer mppe-mppc msession msn mysql mysqli ncurses network nis nls nntp nptl ntlm nvidia nviz objc odbc oggvorbis opengl oscar oss pam pcntl pcre pcsc-lite pda pdfpdflib perl pfpro php physfs pic pie png posix postgres postgresql povray ppds print procmail pthreads pwdb python qt quicktime quotasreadline readline real regexp rtc ruby samba sasl scanner sdl session silc skey slang slp smartcard smime sms sndfile snmp soap sockets socks5 sox spamassassin speex spell spl sse sse2 ssl svg svga symlink sysvipc szip tcltk tcpd tetex theora threads tidy tiff timidity tokenizer transcode truetype truetype-fonts type1-fonts ucs2 unicode usb userlocales wddx wifi winbind wmf wsconvert wxwin wxwindows xalan xerces xine xinerama xmlxml-rpc xml2 xmms xosd xpm xprint xscreensaver xsl xv xvid xvmc yahoo yaz yv12 zlib video_cards_nvidia linguas_de" Unset: ASFLAGS, CBUILD, CTARGET, LDFLAGS
Well it seems, that 'mysql_next_result' and 'mysql_more_results' are features, which are added in version 4.1 (http://dev.mysql.com/doc/mysql/en/mysql-next-result.html and http://dev.mysql.com/doc/mysql/en/mysql-more-results.html). Because the documentation says MySQL client version 4.0 and no ChangeLog is delivered with MySQL Query Browser I filed a bug at the MySQL project (http://bugs.mysql.com/bug.php?id=8717), maybe they fixes this. Therefore the dependecy >=mysql-4.1 was right, because compilation is only possible, when MySQL 4.1 is used. I think it would be good to change the dependencies of mysql-query-browser 1.1.4 and 1.1.5 back to mysql-4.1.
Well according to the Bug report at MySQL (http://bugs.mysql.com/bug.php?id=8717) the error should be fixed in the next version: "[2 Mar 1:03am] Alfredo Kojima Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bugfix, yourself. More information about accessing the source trees is available at http://www.mysql.com/doc/en/Installing_source_tree.html"
I just added mysql-query-browser-1.1.6 to CVS, could you test if it compiles with mysql-4.0 as I'm already on 4.1.
From what I see it should work with 4.0, the mysql_next_result statements have been put in #ifdef blocks.
mysql-query-browser 1.1.6 compiled and running with mysql-4.0.22-r2. Thanks...