Bug#492414: xmoto: Another segfault...

[Stephen Kitt]

Package: xmoto
Version: 0.4.2-2
Followup-For: Bug #492414


Hi,

Unfortunately there's still a segfault in xmoto, apparently not fixed
upstream either. Attached is a patch; I had a backtrace of the crash but
lost it - I can reproduce it if necessary. The segfault occurred at the
start of some levels.

Regards,

Stephen

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable'), (300, 'stable'), (200, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.26-1-686 (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages xmoto depends on:
ii  libbz2-1.0             1.0.5-1           high-quality block-sorting file co
ii  libc6                  2.7-13            GNU C Library: Shared libraries
ii  libcurl3-gnutls        7.18.2-5          Multi-protocol file transfer libra
ii  libgcc1                1:4.3.1-9         GCC support library
ii  libgl1-mesa-glx [libgl 7.0.3-5           A free implementation of the OpenG
ii  libglu1-mesa [libglu1] 7.0.3-5           The OpenGL utility library (GLU)
ii  libjpeg62              6b-14             The Independent JPEG Group's JPEG 
ii  liblua5.1-0            5.1.3-1           Simple, extensible, embeddable pro
ii  libode0debian1         2:0.9-1           Open Dynamics Engine - runtime lib
ii  libpng12-0             1.2.27-1          PNG library - runtime
ii  libsdl-mixer1.2        1.2.8-4           mixer library for Simple DirectMed
ii  libsdl-ttf2.0-0        2.0.9-1           ttf library for Simple DirectMedia
ii  libsdl1.2debian        1.2.13-2          Simple DirectMedia Layer
ii  libsqlite3-0           3.5.9-3           SQLite 3 shared library
ii  libstdc++6             4.3.1-9           The GNU Standard C++ Library v3
ii  xlibmesa-gl            1:7.3+15          transitional package for Debian et
ii  xmoto-data             0.4.2-2.1         2D motocross platform game - data 
ii  zlib1g                 1:1.2.3.3.dfsg-12 compression library - runtime

xmoto recommends no packages.

Versions of packages xmoto suggests:
pn  xmoto-edit                    <none>     (no description available)

-- no debconf information
-------------- next part --------------
--- xmoto-0.4.2.orig/src/states/StateScene.cpp
+++ xmoto-0.4.2/src/states/StateScene.cpp
@@ -540,7 +540,7 @@
       int v_nbPlayed, v_nbDied, v_nbCompleted, v_nbRestart, v_playedTime;
       std::string v_idLevel = m_universe->getScenes()[0]->getLevelSrc()->Id();
       
-      v_result = v_pDb->readDB("SELECT nbPlayed, nbDied, nbCompleted, nbRestarted, playedTime "
+      v_result = v_pDb->readDB("SELECT IFNULL(nbPlayed,0), IFNULL(nbDied,0), IFNULL(nbCompleted,0), IFNULL(nbRestarted,0), IFNULL(playedTime,0) "
 			       "FROM stats_profiles_levels "
 			       "WHERE id_profile=\"" + xmDatabase::protectString(XMSession::instance()->profile()) + "\" "
 			       "AND id_level=\""     + xmDatabase::protectString(v_idLevel) + "\";",