Ask Your Question
0

How to solve 'undefined reference to `sqlite3_step'?

asked 2012-10-03 23:53:40 -0600

sam gravatar image

updated 2012-10-05 05:29:04 -0600

When I rosmake rein:

  sam@sam:/media/Data/code/ros/recognition/bigg_detector$ rosmake
  [ rosmake ] rosmake starting...                                                                                                                          
  [ rosmake ] No package specified.  Building ['bigg_detector']                                                                                            
  [ rosmake ] Packages requested are: ['bigg_detector']                                                                                                    
  [ rosmake ] Logging to directory /home/sam/.ros/rosmake/rosmake_output-20121004-174214                                                                   
  [ rosmake ] Expanded args ['bigg_detector'] to:
  ['bigg_detector']                                                                                        
  [rosmake-0] Starting >>> rosbuild [ make ]                                                                                                               
  [rosmake-0] Finished <<< rosbuild  No Makefile in package rosbuild                                                                                       
  [rosmake-0] Starting >>> roslib [ make ]                                                                                                                 
  [rosmake-1] Starting >>> rosconsole [ make ]                                                                                                             
  [rosmake-0] Finished <<< roslib  No Makefile in package roslib                                                                                           
  [rosmake-2] Starting >>> roslang [ make ]                                                                                                                
  [rosmake-1] Finished <<< rosconsole  No Makefile in package rosconsole                                                                                   
  [rosmake-0] Starting >>> bond [ make ]                                                                                                                   
  [rosmake-3] Starting >>> smclib [ make ]                                                                                                                 
  [rosmake-3] Finished <<< smclib ROS_NOBUILD in package smclib                                                                                            
  [rosmake-1] Starting >>> pluginlib [ make ]                                                                                                              
  [rosmake-2] Finished <<< roslang  No Makefile in package roslang                                                                                         
  [rosmake-4] Starting >>> opencv2 [ make ]                                                                                                                
  [rosmake-0] Finished <<< bond ROS_NOBUILD in package bond                                                                                                
  [rosmake-4] Finished <<< opencv2 ROS_NOBUILD in package opencv2                                                                                          
  [rosmake-1] Finished <<< pluginlib ROS_NOBUILD in package pluginlib                                                                                      
  [rosmake-3] Starting >>> geometry_msgs [ make ]                                                                                                          
  [rosmake-0] Starting >>> rosservice [ make ]                                                                                                             
  [rosmake-3] Finished <<< geometry_msgs  No Makefile in package geometry_msgs                                                                             
  [rosmake-5] Starting >>> roscpp [ make ]                                                                                                                 
  [rosmake-4] Starting >>> rospy [ make ]                                                                                                                  
  [rosmake-4] Finished <<< rospy  No Makefile in package rospy                                                                                             
  [rosmake-0] Finished <<< rosservice  No Makefile in package rosservice                                                                                   
  [rosmake-2] Starting >>> sensor_msgs [ make ]                                                                                                            
  [rosmake-5] Finished <<< roscpp  No Makefile in package roscpp                                                                                           
  [rosmake-6] Starting >>> bullet [ make ]                                                                                                                 
  [rosmake-4] Starting >>> angles [ make ]                                                                                                                 
  [rosmake-1] Starting >>> bondcpp [ make ]                                                                                                                
  [rosmake-7] Starting >>> dynamic_reconfigure [ make ]                                                                                                    
  [rosmake-3] Starting >>> rostest [ make ]                                                                                                                
  [rosmake-6] Finished <<< bullet ROS_NOBUILD in package bullet                                                                                            
  [rosmake-5] Starting >>> roswtf [ make ]                                                                                                                 
  [rosmake-2] Finished <<< sensor_msgs  No Makefile in package sensor_msgs                                                                                 
  [rosmake-8] Starting >>> message_filters [ make ]                                                                                                        
  [rosmake-0] Starting >>> rosbag [ make ]                                                                                                                 
  [rosmake-9] Starting >>> std_msgs [ make ]                                                                                                               
  [rosmake-4] Finished <<< angles ROS_NOBUILD in package angles                                                                                            
  [rosmake-3] Finished <<< rostest  No Makefile in package rostest                                                                                         
  [rosmake-10] Starting >>> common_rosdeps [ make ]                                                                                                        
  [rosmake-6] Starting >>> image_geometry [ make ]                                                                                                         
  [rosmake-2] Starting >>> cv_bridge [ make ]                                                                                                              
  [rosmake-1] Finished <<< bondcpp ROS_NOBUILD in package bondcpp                                                                                          
  [rosmake-7] Finished <<< dynamic_reconfigure ROS_NOBUILD in package dynamic_reconfigure                                                                  
  [rosmake-11] Starting >>> flann [ make ]                                                                                                                 
  [rosmake-3] Starting >>> nodelet [ make ]                                                                                                                
  [rosmake-5] Finished <<< roswtf  No Makefile in package roswtf                                                                                           
  [rosmake-0] Finished <<< rosbag  No Makefile in package rosbag                                                                                           
  [rosmake-9] Finished <<< std_msgs  No Makefile in package std_msgs                                                                                       
  [rosmake-9] Starting >>> pcl [ make ]                                                                                                                    
  [rosmake-8] Finished <<< message_filters  No Makefile in package message_filters                                                                         
  [rosmake-2] Finished <<< cv_bridge ROS_NOBUILD in package cv_bridge                                                                                      
  [rosmake-8] Starting >>> tf [ make ]                                                                                                                     
  [rosmake-4] Starting >>> image_transport [ make ]                                                                                                        
  [rosmake-11] Finished <<< flann ROS_NOBUILD in package flann                                                                                             
  [rosmake-6] Finished <<< image_geometry ROS_NOBUILD in package image_geometry                                                                            
  [rosmake-3] Finished <<< nodelet ROS_NOBUILD in package nodelet                                                                                          
  [rosmake-10] Finished <<< common_rosdeps ROS_NOBUILD in package common_rosdeps                                                                           
  [rosmake-9] Finished <<< pcl  No Makefile in package pcl                                                                                                 
  [rosmake-4] Finished <<< image_transport ROS_NOBUILD in package image_transport                                                                          
  [rosmake-8] Finished <<< tf ROS_NOBUILD in package tf                                                                                                    
  [rosmake-2] Starting >>> nodelet_topic_tools [ make ]                                                                                                    
  [rosmake-2] Finished <<< nodelet_topic_tools ROS_NOBUILD in package nodelet_topic_tools                                                                  
  [rosmake-0] Starting >>> pcl_ros [ make ]                                                                                                                
  [rosmake-0] Finished <<< pcl_ros ROS_NOBUILD in package pcl_ros                                                                                          
  [rosmake-0] Starting >>> rein [ make ]                                                                                                                   
  [ rosmake ] Last 40 linesin: 2.8 sec ]                                                                                        [ 1 Active 32/34 Complete ]
  {-------------------------------------------------------------------------------
    /usr/lib/gcc/x86_64-linux-gnu/4.6/../../../../lib/libsoci_sqlite3-gcc-3_0.a(statement.o): In function `soci::sqlite3_statement_backend::loadRS(int)':
    (.text+0xfb5): undefined reference to `sqlite3_step'
    /usr/lib/gcc/x86_64-linux-gnu/4.6/../../../../lib/libsoci_sqlite3-gcc-3_0.a(statement.o): In function `soci::sqlite3_statement_backend::loadRS(int)':
    (.text+0x1032): undefined reference to `sqlite3_column_text'
    /usr/lib/gcc/x86_64-linux-gnu/4.6/../../../../lib/libsoci_sqlite3-gcc-3_0.a(statement.o): In function `soci::sqlite3_statement_backend::loadRS(int)':
    (.text+0x11d5): undefined reference to `sqlite3_column_count'
    /usr/lib/gcc/x86_64-linux-gnu/4.6 ...
(more)
edit retag flag offensive close merge delete

Comments

Could you please update this post with the contents of manifest.xml?

Mani gravatar imageMani ( 2012-10-04 11:24:18 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2012-10-04 12:34:14 -0600

Jakub gravatar image

updated 2012-10-07 00:31:29 -0600

Try to install libsqlite3-dev package.

sudo apt-get install libsqlite3-dev

Assuming you're on Ubuntu/Debian.


Once dev package installed, edit your CMakeLists.txt and add lines:

 # enable pkg_check_modules macro
 include(FindPkgConfig)
 pkg_check_modules(SQLITE sqlite3)

and then add the found library to your project by:

 target_link_libraries(${PROJECT_NAME} ${SQLITE__LIBRARIES})

or

 rosbuild_add_link_flags(${PROJECT_NAME} ${SQLITE_LDFLAGS})
edit flag offensive delete link more

Comments

I tried to install this lib,but still couldn't solve this problem. What to do next? Thank you~

sam gravatar imagesam ( 2012-10-05 05:29:55 -0600 )edit

Have you tried rosdep install rein?

Mani gravatar imageMani ( 2012-10-05 09:48:05 -0600 )edit

rosdep command not found.

sam gravatar imagesam ( 2012-10-17 21:01:48 -0600 )edit

I have tried to revise CMakeLists.txt but nothing recoveried. What can I do next? Thank you~

sam gravatar imagesam ( 2012-10-17 21:02:53 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

Stats

Asked: 2012-10-03 23:53:40 -0600

Seen: 1,032 times

Last updated: Oct 07 '12