Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

All other Modules

Discuss all other Modules here.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

SQLite3 + [User Error] Couldn't run query: VACUUM | not authorized POST /install.php


Reply

6 Posts   2441 Views

Avatar
astate

18 April 2010 at 5:18am Community Member, 35 Posts

Hello, I want use SQLite but i can't install it.

all right are ok

# Setting up 'mysite/_config.php'...
# Setting up /srv/http/mysite/_config.php
# Setting up '.htaccess' file...
# Setting up /srv/http/.htaccess
# Building database schema...

[User Error] Couldn't run query: VACUUM | not authorized
POST /install.php

619    function databaseError($msg, $errorLevel = E_USER_ERROR) {
620       user_error($msg, $errorLevel);
621    }
622    
623    /**
624     * Enable supression of database messages.
625     */
626    function quiet() {

Avatar
apiening

26 April 2010 at 11:28am Community Member, 60 Posts

hi astate,

this is a sqlite level error: http://www.sqlite.org/tclsqlite.html#authorizer

something registered an authorizer callback function which returns a SQLITE_DENY for VACUUM. your options are:

1. check the registered callback to see if you can aquire authorization
2. overide the callback (e.g. with a NULL callback or with one that returns SQLITE_IGNORE instead of SQLITE_DENY)
3. comment the VACUUM command in SQLite3Database.php

the last option is a hack and not recommended. it's not absolutely neccessary to vacuum. can you find out why there is authorization required? is there any other command that gets a SQLITE_DENY? if there is a good reason for the denial i can make vacuuming optional.

cheers

andy

Avatar
damnmab

20 May 2010 at 10:48am Community Member, 2 Posts

Hi,
Silverstripe seems interesting and I would really like to get it running to play around with it some, but I keep having this error message during installation (see attached image).
I added the sqlite trunk module before installation and it showed as green in the list.
Did I miss something? Is sqlite3 broken or not and why is it failing to install?

Attached Files
Avatar
apiening

20 May 2010 at 11:27am (Last edited: 20 May 2010 11:58am), Community Member, 60 Posts

hi damnmab,

1) what sqlite version are you using?
2) are you on a shared host?
3) can you try commenting:

// $this->query('VACUUM');


in sqlite3/code/SQLite3Database.php? (for testing only)

if (3) fixes the issue let me know. i will make the execution of VACUUM configurable then.

cheers

andy

Avatar
damnmab

20 May 2010 at 8:21pm Community Member, 2 Posts

Hi andy,

Thanks for your quick reply.

1) phpinfo() shows under pdo_sqlite that SQLite Library version is 3.3.7
2) Yes, I am.
3) When commenting that line the installation runs with no errors!

Thanks,
damnmab

Avatar
apiening

21 May 2010 at 9:48am Community Member, 60 Posts

Hi damnmab,

thanks for the update. I made the vacuuming configurable and updated trunk. After updating your local sqlite3 module you can add:

SQLite3Database::$vacuum = false;

anywhere in your mysite/_config.php to turn off vacuuming.

Cheers

Andy