Where do you define the location of your SQLite files in the
config.php file? I see where you can define the default DB but not a
directory path to a repository/db store.
SQL Buddy only lets you work with a single SQLite file at a time. So there is no preference for a directory, but you can put the a path to a single file here:
On Thu, Feb 2, 2012 at 7:20 AM, BxGeek <carl_lindg...@bizotd.com> wrote: > Where do you define the location of your SQLite files in the > config.php file? I see where you can define the default DB but not a > directory path to a repository/db store.
> SQL Buddy only lets you work with a single SQLite file at a time. So
> there is no preference for a directory, but you can put the a path to
> a single file here:
> On Thu, Feb 2, 2012 at 7:20 AM, BxGeek <carl_lindg...@bizotd.com> wrote:
> > Where do you define the location of your SQLite files in the
> > config.php file? I see where you can define the default DB but not a
> > directory path to a repository/db store.
The SQLite functionality is honestly not very well tested. I've actually considered removing SQLite support. There must be better software out there for working with SQLite, I just haven't done any research so I can't help you out.
On Thu, Feb 2, 2012 at 9:32 PM, BxGeek <carl_lindg...@bizotd.com> wrote: > Can you specify a directory out side of your www\sqlbuddy\ directory?
> Like: > C:\Program Files\WAMP\sqlite_directory > *** > I've done that and I get an error message as follows...
> <<< ERROR > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C: > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43 > Call Stack > # Time Memory Function Location > 1 0.0033 437296 {main}( ) ..\login.php:0 > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51 > ERROR>>>
> I get the error message even when I have the sqlite3 database in the > www\sqlbuddy\ directory?
> Like: > C:\Program Files\WAMP\sqlite_directory > *** > I've done that and I get an error message as follows...
> <<< ERROR > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C: > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43 > Call Stack > # Time Memory Function Location > 1 0.0033 437296 {main}( ) ..\login.php:0 > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51 > ERROR>>> > --- > On Feb 2, 7:42 pm, Calvin Lough <calvinlo...@gmail.com> wrote: >> SQL Buddy only lets you work with a single SQLite file at a time. So >> there is no preference for a directory, but you can put the a path to >> a single file here:
>> On Thu, Feb 2, 2012 at 7:20 AM, BxGeek <carl_lindg...@bizotd.com> wrote: >> > Where do you define the location of your SQLite files in the >> > config.php file? I see where you can define the default DB but not a >> > directory path to a repository/db store.
I would like to see you cuntinue to work on to work with SQLite. There
are other solutions out there (phpSQLiteAdmin) but none with the
functionality of SQLbuddy (at least from what I see on the MySQL
side).
I like the interface.
Thanks Again!
On Feb 2, 10:01 pm, Calvin Lough <calvinlo...@gmail.com> wrote:
> The SQLite functionality is honestly not very well tested. I've
> actually considered removing SQLite support. There must be better
> software out there for working with SQLite, I just haven't done any
> research so I can't help you out.
> On Thu, Feb 2, 2012 at 9:32 PM, BxGeek <carl_lindg...@bizotd.com> wrote:
> > Can you specify a directory out side of your www\sqlbuddy\ directory?
> > Like:
> > C:\Program Files\WAMP\sqlite_directory
> > ***
> > I've done that and I get an error message as follows...
> > <<< ERROR
> > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C:
> > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43
> > Call Stack
> > # Time Memory Function Location
> > 1 0.0033 437296 {main}( ) ..\login.php:0
> > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51
> > ERROR>>>
> > I get the error message even when I have the sqlite3 database in the
> > www\sqlbuddy\ directory?
> > Like:
> > C:\Program Files\WAMP\sqlite_directory
> > ***
> > I've done that and I get an error message as follows...
> > <<< ERROR
> > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C:
> > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43
> > Call Stack
> > # Time Memory Function Location
> > 1 0.0033 437296 {main}( ) ..\login.php:0
> > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51
> > ERROR>>>
> > ---
> > On Feb 2, 7:42 pm, Calvin Lough <calvinlo...@gmail.com> wrote:
> >> SQL Buddy only lets you work with a single SQLite file at a time. So
> >> there is no preference for a directory, but you can put the a path to
> >> a single file here:
> >> On Thu, Feb 2, 2012 at 7:20 AM, BxGeek <carl_lindg...@bizotd.com> wrote:
> >> > Where do you define the location of your SQLite files in the
> >> > config.php file? I see where you can define the default DB but not a
> >> > directory path to a repository/db store.
> Can you specify a directory out side of your www\sqlbuddy\ directory?
> Like: > C:\Program Files\WAMP\sqlite_directory > *** > I've done that and I get an error message as follows...
> <<< ERROR > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C: > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43 > Call Stack > # Time Memory Function Location > 1 0.0033 437296 {main}( ) ..\login.php:0 > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51 > ERROR>>>
> I get the error message even when I have the sqlite3 database in the > www\sqlbuddy\ directory?
> Like: > C:\Program Files\WAMP\sqlite_directory > *** > I've done that and I get an error message as follows...
> <<< ERROR > ( ! ) Fatal error: Call to undefined function sqlite_libversion() in C: > \Program Files\WAMP\www\sqlbuddy\includes\class\Sql.php on line 43 > Call Stack > # Time Memory Function Location > 1 0.0033 437296 {main}( ) ..\login.php:0 > 2 0.0414 796840 SQL->SQL( ) ..\login.php:51 > ERROR>>> > --- > On Feb 2, 7:42 pm, Calvin Lough <calvinlo...@gmail.com> wrote: >> SQL Buddy only lets you work with a single SQLite file at a time. So >> there is no preference for a directory, but you can put the a path to >> a single file here:
>> On Thu, Feb 2, 2012 at 7:20 AM, BxGeek <carl_lindg...@bizotd.com> wrote: >>> Where do you define the location of your SQLite files in the >>> config.php file? I see where you can define the default DB but not a >>> directory path to a repository/db store.