setup.php

[bet0x]

Tried to install, Ubuntu 14, Apache (also nginx) and setup always return to the same page.

[zenbi]

All entry points go through index.php file in the root of the www folder. In nginx this is from the "try_files $uri $uri/ /index.php;" line. If you try to use apache, you will need to create quite inclusive set of mod_rewrite rules (that I have not created.)

If the URL in your browser is ever "setup.php" then you likely have the docroot set incorrectly. The docroot of the webserver should be the www subfolder in the pipecode source. An example screenshot is here: http://pipecode.org/images/screenshot-setup.png

The setup script requires write access to the root of the pipecode source directory in order to create the conf.php that contains the main configuration (like the SQL connection strings.) Make sure the fpm php worker process are running under a user account that has sufficient rights to the directory.

[bet0x]

Can't install it on Apache, no success. Can you create the rules for mod_rewrite or some kind of tutorial please?

[bet0x]

Finally i managed to get it working, but during the setup i get this:

error: invalid value - method [post] type [string] name [sql_user] value [barrahom_pipedot]

[bet0x]

Fixed, DB can't have a _ as prefix or suffix, now here:

error: sql [insert into captcha_challenge (remote_ip, captcha_id) values (?, ?)] arg [189.132.153.113, ] msg [SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'captcha_id' cannot be null]

I made the rewrite rules:

RewriteEngine on
RewriteCond $1 !^(index\.php|images|robots\.txt)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L,QSA]

Also setup didn't insert my user data i think.

[bet0x]

Also captcha is not working.

[bet0x]

Well, i did all the setup by hand due a bug on setup.php, i figured it how it works, etcetara, now i have an issue, i created a topic and make a example story, approbed that story and i get this:

error: sql [select count(*) as item_count from article where match (title) against (? in boolean mode) and publish_time > ? and publish_time < ? and article.feed_id <> ] arg [lorem ipsum dolor sit amet, 1444603211, 1447195211] msg [SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]

[bet0x]

Also, uploading or deleting an avatar gives the next error:

error: sql [insert into drive_data (hash, server_id, size) values (?, ?, ?)] arg [f46dd12cbf618c7427ebaf0c9ddcae30eb039aa063c1541756226c271b946da5, , 191] msg [SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'server_id' cannot be null]

[zenbi]

for the drive_data error add the following line to your conf.php:

$server_id = 1;

at some point, you'll also want to insert a corresponding record into the "drive_server" table with the dns name of your server:

insert into drive_server (server_name) values ('nameofserver.example.com')

[bet0x]

Regarding the data on drive_server, must be the server_name wich i'm using for the website?

[zenbi]

The server name of the computer.

The "drive" is a simple "object storage" system that will eventually span multiple computers. For example, if the hard drive fills up on server1, then files should still be writable on server2, etc. At the moment, however, everything is still expecting a single server.

[bet0x]

Great, and the error related to the story? you can check barrahome.org

[zenbi]

The "item_count from article" sql error above is from the "Similar Articles" feature. Add a RSS news feed to the site (http://barrahome.org/atom) to create a record in the feed table. The code should then automatically figure out the $server_feed_id variable that is currently blank and messing things up.

[bet0x]

I'm lost there dunno how to do the last part.