Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin 

Post new topic Reply to topic
Author Message
PostPosted: Tue May 31, 2011 11:24 am 
Offline
Senior Newbie

Joined: Wed Apr 27, 2011 7:54 am
Posts: 11
Hi,

I'm trying to get SQLite working on my server but I'm not having much luck.

I'm a knew to managing my own server and I'm stuck.

I followed these instructions from a post on Stackoverflow...

Code:
$ sudo apt-get install php5-cli php5-dev make
$ sudo apt-get install libsqlite3-0 libsqlite3-dev
$ sudo apt-get install php5-sqlite3
$ sudo apt-get remove php5-sqlite3
$ cd ~
$ wget http://pecl.php.net/get/sqlite3-0.6.tgz
$ tar -zxf sqlite3-0.6.tgz
$ cd sqlite3-0.6/
$ sudo phpize
$ sudo ./configure
$ sudo make
$ sudo make install
$ sudo apache2ctl restart


But when I get to
Code:
sudo make
I get the following error...
Code:
/root/sqlite3-0.6/sqlite3.c:607: error: ‘zend_fcall_info’ has no member named ‘object_pp’
/root/sqlite3-0.6/sqlite3.c: At top level:
/root/sqlite3-0.6/sqlite3.c:1446: error: duplicate ‘static’
...


Any thoughts on where I'm going wrong?

Many thanks.


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 31, 2011 12:27 pm 
Offline
Senior Member

Joined: Fri Jan 09, 2009 5:32 pm
Posts: 592
why are you compiling instead of installing?


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 31, 2011 2:33 pm 
Offline
Senior Member

Joined: Fri May 02, 2008 8:44 pm
Posts: 1071
That page on StackOverflow is almost 2 years old. Always check the date when taking PHP advice.

With recent versions of Ubuntu, you just do apt-get install php5-sqlite and you're all set. Not sqlite3, just sqlite. This automatically enables both the old SQLite functions and the new SQLite3 class, as well as the SQLite PDO driver.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 03, 2011 5:16 am 
Offline
Senior Newbie

Joined: Wed Apr 27, 2011 7:54 am
Posts: 11
glg wrote:
why are you compiling instead of installing?


I'm new to managing my own server, and using the command line is still new to me, so I hadn't realised that those commands meant I was compiling it.

hybinet wrote:
why are you compiling instead of installing?
With recent versions of Ubuntu, you just do apt-get install php5-sqlite and you're all set. Not sqlite3, just sqlite. This automatically enables both the old SQLite functions and the new SQLite3 class, as well as the SQLite PDO driver.


No wonder apt-get install php5-sqlite3 didn't work. Do I need to do anything to get my install of PHP to start using SQLite?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jun 03, 2011 10:58 am 
Offline
Senior Member

Joined: Fri May 02, 2008 8:44 pm
Posts: 1071
sevenupcan wrote:
No wonder apt-get install php5-sqlite3 didn't work. Do I need to do anything to get my install of PHP to start using SQLite?

Just install php5-sqlite and restart Apache. No further configuration should be necessary, unless your previous attempt to compile SQLite somehow ends up conflicting with the official package. It probably won't, because the compile failed anyway.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS
Powered by phpBB® Forum Software © phpBB Group

Home | Manager | Contact Us | Jobs | Terms of Service | Privacy Policy | ™ © 2003-2012 Linode, LLC. All rights reserved.