Collection of themes/skins for the Fossil SCM

⌈⌋ branch:  Fossil Skins Extra

View Ticket

Ticket Hash: a6e7efa0d9f1ea8882da44a58907246dbb1973ab
Title: Error running fossil-stats-table.php
Status: Closed Type: Code_Defect
Severity: Severe Priority: Medium
Subsystem: Resolution: Workaround
Last Modified: 2018-07-05 19:12:49
Version Found In:
User Comments:
anonymous added on 2018-04-23 11:50:48:

I am trying out the SO theme which looks quite neat. I need to run the fossil-stats-table.php to populate the database. I am just trying out the script as stand-alone on the desktop and have added the full path to my repos by adjusting L28 to $repos = glob("/FULL/PATH/HERE/*.fossil") .

I am running into he following error. I am not familiar with PHP but can't see anything obvious wrong with this. Any advice?

This is the output I am getting:

&#60 li &#62Kicad2PK
PHP Warning:  PDO::query(): SQLSTATE[HY000]: General error: 11 malformed database schema (artifact) - near "(": syntax error in /Users/johnpateman/Desktop/fossil-stats-table.php on line 105

PHP Fatal error: Call to a member function fetchAll() on boolean in /Users/johnpateman/Desktop/fossil-stats-table.php on line 105

Configuration: macOS 10.12.6 / Fossil 2.5 [Built with --with-tcl=1 --with-tcl-private-stubs=1 --with-th1-hooks=1]

PHP 5.6.30 (cli) (built: Oct 29 2017 20:30:32) Copyright (c) 1997-2016 The PHP Group Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies

anonymous added on 2018-04-23 11:53:26:
I am getting
PHP warning ...

(not &#60;  &#62) - just trying to format the tags and pressed submit too soon!

mario added on 2018-05-18 16:49:13:

Sorry. Didn't see this ticket. Also not sure what is going on there.

This looks like a mishap in your Fossils database definition. Try to run the following SQL in your Fossil UI admin interface:

SELECT name,value FROM config

If it yields the same error, then a DB rebuild might be necessary.

mario added on 2018-05-18 16:49:51:
(Or it could just be your PHP version being linked against a very dated SQLite.)

mario added on 2018-06-04 06:52:55:

So, this is definitely caused by old SQLite versions. I get the same schema errors when running an old fossil versions against a current database.

Only way to fix it is updating pdo/sqlite in PHP.

mario added on 2018-07-05 19:12:49:

Btw, just ran into the same issue with Fossil-2.7~trunk; which bundles SQLite 3.24.0, but PHP-7.x was bound to SQLite- 3.8.x still.

So, other than updating the distros libsqlite, there's no workaround here.