[apostrophe] Sqlite and the "SQLSTATE[HY000]: General error: 1 near "FALSE": syntax error" with blank page error

[gnushell]

Hi,

We're aware that you wish for us to use MySQL if possible, but we're
attempting to build automation code and MySQL connection strings are
not helping. We're wondering if going back to an earlier sqlite
version might help with the above error? We're running on Ubuntu
server and the sqlite version info is as follows:

$ sqlite -version
2.8.17

If the version isn't the issue, are there any hints for getting sqlite
to work? With what version did you guys test successfully? Any ideas
are very appreciated.

I have full stack trace information but since it's long, I didn't want
to include it in my initial post.

Thanks,

Sheila (aka gnushell)

[Dan Ordille]

It would help if you could include the trace.  And what you did when the error occurred.  The version of sqllite you are using shouldn't be an issue.  It is possible that someone added some non sqllite friendly code since our last test on sqllite.

Dan

[gnushell]

Thanks Dan!

Expanded trace included below:

500 | Internal Server Error | PDOException
SQLSTATE[HY000]: General error: 1 near "FALSE": syntax error
stack trace
at ()
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/model/doctrine/
PluginaPage.class.php line 863 ...
860. $query .= "WHERE " . implode(' AND ', $whereClauses);
861. $query .= " ORDER BY p.lft";
862. //$resultSet = $pdo->query($query);
863. $resultSet = $pdo->query($pdo->prepare($query));
864. // Turn it into an actual array (what would happen if we
didn't bother?)
865. $results = array();
866. foreach ($resultSet as $result)
1.
at PDO->prepare('SELECT p.id, p.slug, p.view_is_secure, p.archived,
p.lft, p.rgt, p.level, p.engine, s.value AS title FROM a_page p
LEFT JOIN a_area a ON a.page_id = p.id AND a.name = 'title' AND
a.culture = 'en' LEFT JOIN a_area_version v ON v.area_id = a.id
AND a.latest_version = v.version LEFT JOIN a_area_version_slot avs ON
avs.area_version_id = v.id LEFT JOIN a_slot s ON s.id =
avs.slot_id WHERE (p.admin IS FALSE OR p.admin IS NULL) AND ( p.lft >
1 AND p.rgt < 10 ) ORDER BY p.lft')
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/model/doctrine/
PluginaPage.class.php line 863 ...
2.
at PluginaPage->getPagesInfo(, '( p.lft > 1 AND p.rgt < 10 )')
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/model/doctrine/
PluginaPage.class.php line 825 ...
3.
at PluginaPage->getDescendantsInfo(, null)
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/model/doctrine/
PluginaPage.class.php line 624 ...
4.
at PluginaPage->getTreeInfo()
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/navigation/
aNavigation.class.php line 34 ...
5.
at aNavigation->initializeTree()
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/navigation/
aNavigation.class.php line 61 ...
6.
at aNavigation->__construct('/', '/', array('depth' => 1))
in SF_ROOT_DIR/plugins/apostrophePlugin/lib/action/
BaseaNavigationComponents.class.php line 46 ...
7.
at BaseaNavigationComponents->executeTabs(object('sfWebRequest'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/helper/PartialHelper.php line
386 ...
8.
at _call_component('aNavigation', 'tabs', array('root' => '/',
'active' => '/', 'name' => 'main', 'draggable' => 1, 'dragIcon' => ))
in SF_ROOT_DIR/lib/vendor/symfony/lib/helper/PartialHelper.php line
148 ...
9.
at get_component('aNavigation', 'tabs', array('root' => '/', 'active'
=> '/', 'name' => 'main', 'draggable' => 1, 'dragIcon' => ))
in SF_ROOT_DIR/lib/vendor/symfony/lib/helper/PartialHelper.php line
115 ...
10.
at include_component('aNavigation', 'tabs', array('root' => '/',
'active' => '/', 'name' => 'main', 'draggable' => 1, 'dragIcon' => ))
in SF_ROOT_DIR/plugins/apostrophePlugin/modules/a/templates/layout.php
line 82 ...
11.
at require('/home/geoffrey/apostrophe/plugins/apostrophePlugin/modules/
a/templates/layout.php')
in SF_ROOT_DIR/apps/frontend/templates/layout.php line 7 ...
12.
at require('/home/geoffrey/apostrophe/apps/frontend/templates/
layout.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line
75 ...
13.
at sfPHPView->renderFile('/home/geoffrey/apostrophe/apps/frontend/
templates/layout.php')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line
146 ...
14.
at sfPHPView->decorate(' <div id="a-area-1-body" class="a-area a-area-
body"> <div id="a-slots-1-body" class="a-slots"> <div
class="a-slot aRichText " id="a-slot-1-body-1"> <div class="a-slot-
content" id="a-slot-content-1-body-1"> <h3>Welcome to
aSandbox, a sample site built using <a href="http://
www.apostrophenow.com" target="_new">Apostrophe</a>.</h3> <p>You can
edit this text by clicking the Edit button. You can also add
additional slots to this area, such as video and slideshow slots, via
the Add
Slot button.</p> </div> </div> </div> </div> <!-- END SLOT --> <div
id="a-area-1-sidebar" class="a-area a-area-sidebar"> <div
id="a-slots-1-sidebar" class="a-slots"> </div> </div> <!-- END SLOT --
>')
in SF_ROOT_DIR/lib/vendor/symfony/lib/view/sfPHPView.class.php line
196 ...
15.
at sfPHPView->render()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/
sfExecutionFilter.class.php line 155 ...
16.
at sfExecutionFilter->executeView('a', 'show', 'Template',
array('page' => object('aPage')))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/
sfExecutionFilter.class.php line 116 ...
17.
at sfExecutionFilter->handleView(object('sfFilterChain'),
object('aActions'), 'Template')
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/
sfExecutionFilter.class.php line 54 ...
18.
at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php
line 53 ...
19.
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/
sfRenderingFilter.class.php line 33 ...
20.
at sfRenderingFilter->execute(object('sfFilterChain'))
21.
PDOException:
SQLSTATE[HY000]:
General
error:
1
near
"... http://demo1.ucp.org/
1
of
5 5/13/10
12:24
PM
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php
line 53 ...
at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/
sfController.class.php line 233 ...
22.
at sfController->forward('a', 'show')
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/
sfFrontWebController.class.php line 48 ...
23.
at sfFrontWebController->dispatch()
in SF_ROOT_DIR/lib/vendor/symfony/lib/util/sfContext.class.php line
170 ...
24.
at sfContext->dispatch()
in SF_ROOT_DIR/web/index.php line 7 ...
25.
symfony settings ...
PDOException:
SQLSTATE[HY000]:
General
error:
1
near
"... http://demo1.ucp.org/
2
of
5 5/13/10
12:24
PM
app_aMedia_admin_credential: media_admin
app_aMedia_apikeys:
- dummy
app_aMedia_apipublic: false
app_aMedia_client_apikey: dummy
app_aMedia_embed_codes: true
app_aMedia_upload_credential: media_upload
app_aMedia_use_bundled_layout: false
app_aToolkit_indexes:
- aPage
- aMediaItem
app_a_default_on: true
app_a_edit_candidate_group: editor
app_a_edit_sufficient_group: admin
app_a_engines:
'': Template-Based
aMedia: Media
app_a_home_as_tab: false
app_a_i18n_languages:
- en
- fr
- de
- es
app_a_i18n_switch: true
app_a_manage_candidate_group: editor
app_a_manage_sufficient_group: admin
app_a_routes_register: false
app_a_slot_types: null
app_a_slot_variants:
aButton: { normal: { label: Normal }, useTitleAsButtonText: { label:
'Text Over' } }
aSlideshow: { normal: { label: Normal, options: { title: false,
arrows: true } }, compact: { label: Compact, options: { title: true,
app_a_templates:
home: 'Home Page'
default: 'Default Page'
app_a_use_bundled_layout: false
app_aimageconverter_path: /opt/local/bin
app_sfSyncContent_content:
- web/uploads
- data/a_writable
app_sf_guard_plugin_signin_form: aFormSignin
mod_a_enabled: true
mod_a_view_class: sfPHP
mod_abuttonslot_enabled: true
mod_abuttonslot_view_class: sfPHP
mod_anavigation_enabled: true
mod_anavigation_view_class: sfPHP
mod_arichtextslot_enabled: true
mod_arichtextslot_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /home/geoffrey/apostrophe/cache/frontend
sf_app_cache_dir: /home/geoffrey/apostrophe/cache/frontend/prod
sf_app_config_dir: /home/geoffrey/apostrophe/apps/frontend/config
sf_app_dir: /home/geoffrey/apostrophe/apps/frontend
sf_app_i18n_dir: /home/geoffrey/apostrophe/apps/frontend/i18n
sf_app_lib_dir: /home/geoffrey/apostrophe/apps/frontend/lib
sf_app_module_dir: /home/geoffrey/apostrophe/apps/frontend/modules
sf_app_template_dir: /home/geoffrey/apostrophe/apps/frontend/
templates
sf_apps_dir: /home/geoffrey/apostrophe/apps
sf_cache: false
sf_cache_dir: /home/geoffrey/apostrophe/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /home/geoffrey/apostrophe/cache/frontend/prod/
config
sf_config_dir: /home/geoffrey/apostrophe/config
sf_csrf_secret: CHANGEME
sf_data_dir: /home/geoffrey/apostrophe/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
- a
- aSync
- aNavigation
- aMedia
- aMediaBackend
- aRichTextSlot
- aTextSlot
- aRawHTMLSlot
- aSlideshowSlot
- aVideoSlot
- aImageSlot
- aButtonSlot
- aPDFSlot
- aFeedSlot
- sfGuardAuth
- aUserAdmin
- aGroupAdmin
- aPermissionAdmin
- sfGuardPermission
- taggableComplete
- aNavigation
- default
PDOException:
SQLSTATE[HY000]:
General
error:
1
near
"... http://demo1.ucp.org/
3
of
5 5/13/10
12:24
PM
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
default_format: null
logging: ''
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/
x-javascript, text/javascript], css: text/css, json: [applicati
no_script_name: true
parameterHolder:
action: show
module: a
slug: /
attributeHolder:
sf_route: 'sfRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/1.1
logging: ''
charset: utf-8
send_http_headers: true
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts:
/sfJqueryReloadedPlugin/js/jquery-1.3.2.min.js: { }
/sfJqueryReloadedPlugin/js/plugins/jquery-ui-1.7.2.custom.min.js:
{ }
/apostrophePlugin/js/aUI.js: { }
/apostrophePlugin/js/aControls.js: { }
/apostrophePlugin/js/jquery.autogrow.js: { }
/apostrophePlugin/js/jquery.keycodes-0.2.js: { }
/apostrophePlugin/js/jquery.timer-1.2.js: { }
/apostrophePlugin/js/a.js: { }
stylesheets:
/apostrophePlugin/css/a.css: { }
main.css: { }
metas:
title: Home
httpMetas:
Content-Type: 'text/html; charset=utf-8'
user ...
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: ''
timeout: 1800
attributeHolder:
apostrophe: { area-options-1-body: { allowed_types: [aRichText,
aSlideshow, aVideo, aImage, aFeed, aButton, aText, aRawHTML], type_o
culture: en
global vars ...
PDOException:
SQLSTATE[HY000]:
General
error:
1
near
"... http://demo1.ucp.org/
4
of
5 5/13/10
12:24
PM
cookie:
__utma: 200922410.1719430080.1271772532.1273525546.1273684170.4
__utmc: '200922410'
__utmz: 200922410.1271772532.1.1.utmccn=(direct)|utmcsr=(direct)|
utmcmd=(none)
symfony: 82f102e3f239d06fe1cd3a8794503f78
env:
APACHE_PID_FILE: /var/run/apache2.pid
APACHE_RUN_GROUP: www-data
APACHE_RUN_USER: www-data
LANG: C
PATH: '/usr/local/bin:/usr/bin:/bin'
PWD: /
files: { }
get: { }
post: { }
server:
DOCUMENT_ROOT: /var/www/demo1.ucp.org
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: 'text/html,application/xhtml+xml,application/
xml;q=0.9,*/*;q=0.8'
HTTP_ACCEPT_CHARSET: 'ISO-8859-1,utf-8;q=0.7,*;q=0.7'
HTTP_ACCEPT_ENCODING: 'gzip,deflate'
HTTP_ACCEPT_LANGUAGE: 'en-us,en;q=0.5'
HTTP_CONNECTION: keep-alive
HTTP_COOKIE: '__utmz=200922410.1271772532.1.1.utmccn=(direct)|
utmcsr=(direct)|utmcmd=(none);
__utma=200922410.1719430080.1271772532.
HTTP_HOST: demo1.ucp.org
HTTP_KEEP_ALIVE: '115'
HTTP_USER_AGENT: 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-
US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3'
PATH: '/usr/local/bin:/usr/bin:/bin'
PHP_SELF: /index.php
QUERY_STRING: ''
REDIRECT_STATUS: '200'
REDIRECT_URL: /
REMOTE_ADDR: 216.200.101.151
REMOTE_PORT: '13541'
REQUEST_METHOD: GET
REQUEST_TIME: 1273765722
REQUEST_URI: /
SCRIPT_FILENAME: /var/www/demo1.ucp.org/index.php
SCRIPT_NAME: /index.php
SERVER_ADDR: 173.203.102.226
SERVER_ADMIN: '[no address given]'
SERVER_NAME: demo1.ucp.org
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache/2.2.12 (Ubuntu) Server at
demo1.ucp.org Port 80</address>\n"
SERVER_SOFTWARE: 'Apache/2.2.12 (Ubuntu)'
argc: 0
argv: { }
session: { }
symfony v.1.4.5-DEV - php 5.2.10-2ubuntu6
for help resolving this issue, please visit http://www.symfony-project.org/.
PDOException:
SQLSTATE[HY000]:
General
error:
1
near
"... http://demo1.ucp.org/
5
of
5 5/13/10
12:24
PM

[gnushell]

Dan,

I forgot to add that this is from a virgin install and is the first
page load.

On May 13, 12:51 pm, Dan Ordille <d...@punkave.com> wrote:
> It would help if you could include the trace.  And what you did when the
> error occurred.  The version of sqllite you are using shouldn't be an
> issue.  It is possible that someone added some non sqllite friendly code
> since our last test on sqllite.
>
> Dan
>

[gnushell]

Hi Dan,

Any updates on this issue? Did the stack trace help?

Thanks,

Sheila

On May 13, 12:51 pm, Dan Ordille <d...@punkave.com> wrote:

[David Clark]

There is no need to switch to sqllite for the role purpose of
automation. One can run mysql commands from the command line just as
easy as sqllite

--
dc

David Clark
dcl...@ucp.org
Skype: dmclark

[Tom Boutell]

We did our testing against sqlite 3.x, which aims to be SQL92
compliant and, as I recall, supports IS FALSE which we used expressly
to be compatible.

--
Tom Boutell
P'unk Avenue
215 755 1330
punkave.com
window.punkave.com

[gnushell]

Sorry for the time delay, but it appears that working with sqlite3
isn't doing the trick wrt the IS FALSE error. Before I either beat
myself over the head or give up completely, do you have any last ditch
suggestions? Something tells me we'll do as everyone else and just
use MySQL.

Thanks!

On May 19, 5:03 pm, Tom Boutell <t...@punkave.com> wrote:
> We did our testing againstsqlite3.x, which aims to be SQL92

[Tom Boutell]

I have two responses:

1. What error are you getting with sqlite3? Any different from
sqlite2? I can take a peek at least.

2. We really don't use anything but MySQL in-house, and we're keenly
aware that Wordpress has conquered the world without supporting
anything but MySQL, so keep in mind that we're not likely to spend
many moons on the issue.