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?

___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](http://www.trash-factor.com/content/too-many-sql-variables-sqlite-error) Maybe there is a behavior to change in the code?
edited Feb 6 '15 at 11:07 am
 
0
reply

I can confirm that this problem is also reproducible on Mac - installation with SQLite fails on version 3.1.

I can confirm that this problem is also reproducible on Mac - installation with SQLite fails on version 3.1.
 
0
reply

@adesh Is SQLite installation supposed to be working, or is it still in alpha?

Looking through my past notes, I see that I've never actually done an SQLite instal with Codoforum (even though I would much prefer that over MySQL).

@adesh Is SQLite installation supposed to be working, or is it still in alpha? Looking through my past notes, I see that I've never actually done an SQLite instal with Codoforum (even though I would much prefer that over MySQL).
 
0
reply

Hello @luxlogica !

Thanks for your reply, good to know the problem is also reproducible elsewhere!

I've seen you managed to get a reply from the developpers in another discussion, you're luckier than me :-)

I will follow the news and test the next version of codoforum to see if this SQLite problem has been solved.

Hello @luxlogica ! Thanks for your reply, good to know the problem is also reproducible elsewhere! I've seen you managed to get a reply from the developpers in [another discussion](http://codologic.com/forum/index.php?u=/topic/1247/support-for-databases-other-than-mysql), you're luckier than me :-) I will follow the news and test the next version of codoforum to see if this SQLite problem has been solved.
edited Feb 27 '15 at 7:42 pm
 
0
reply
292
views
3
replies
2
followers
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft