EDIT: I have seen afterwards that my topic was not in codoforum part but in general discussion (and no possibility to move it), so I create a new one here, in hope you guys can help me :-)
Hello,
I've just discovered codoforum and it's the promising forum i was searching for, thanks for your work!
I've tried to install the last version (3.0.2) on my web server (Raspberry pi, Arch linux, Nginx, SQlite), however the install process stucks right after creating the database:
I choose SQLite, give the full path of the file and click on "Submit", then white screen on step 3.
In the logs I found there is a problem with the number of variables given to SQlite:
2015/02/04 22:03:54 [error] 25895#0: *734 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[HY000]: General error: 1 too many SQL variables (SQL: insert into "codo_permissions" ("cid", "granted", "inherited", "permission", "pid", "rid", "tid") select 0 as "cid", 1 as "granted", -1 as "inherited", view user profiles as "permission", 296 as "pid", 1 as "rid", 0 as "tid" union select 0 as "cid", 1 as "granted", -1 as "inherited", use search as "permission", 297 as "pid", 1 as "rid", 0 as "tid" union select 0 as "cid", 1 as "granted", -1 as "inherited", view all topics as "permission", 298 as "pid", 1 as "rid", 0 as "tid" union select 0 as "cid", 0 as "granted", -1 as "inherited", view my topics as "permission", 299 as "pid", 1 as "rid", 0 as "tid" union select 0 as "cid", 0 as "granted", -1 as "inherited", create new topic as "permission", 300 as "pid", 1 as "rid", 0 as "tid" union select 0 as "cid", 0 as "granted", -1 as "inherited", reply to all topics as "permission", 301 as "pid", 1 as" while reading response header from upstream, client: 192.168.0.85, server: mywebsite.fr, request: "POST /forum/install/index.php?u=/index.php&step=3 HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/php-fpm.sock:", host: "mywebsite.fr", referrer: "https://mywebsite.fr/forum/install/index.php?u=/index.php&step=2"
Could you please help to solve this SQLSTATE[HY000]: General error: 1 too many SQL variables issue?
Thanks a lot!
Note: several days after, I tried again on a WAMP server on local computer: Same error with sqlite, but install proceed correctly with mysql; so this is clearly a problem associated with sqlite.
For info, the complementary stacktrace given by wamp:
Call Stack
# Time Memory Function Location
1 0.0007 260312 {main}( ) ..\index.php:0
2 0.0262 2545264
require( 'C:\wamp
\www\codoforum\install
\step3.php' )
..\index.php:36
3 0.0262 2545520 Step3->install( ) ..\step3.php:209
4 0.0359 3200624 Step3->create_tables( ) ..\step3.php:130
5 6.5038 3990264
codoforumInstallDatabase->fill(
)
..\step3.php:119
6 7.4009 5565920
Illuminate\Database\Query
\Builder->insert( )
..\2014_10_02_074430_create_codoforum_database.php:1040
7 7.4206 6438920
Illuminate\Database
\Connection->insert( )
..\Builder.php:1840
8 7.4206 6438920
Illuminate\Database
\Connection->statement( )
..\Connection.php:295
9 7.4207 6439272
Illuminate\Database
\Connection->run( )
..\Connection.php:338
EDIT:
It seems linked to a limitation of SQLite:
"Too many SQL variables" SQLite error
Maybe there is a behavior to change in the code?