Warmup fail

[makesewdo]

On install, goes all the way, doesn't create database.

When database manually created, doesn't install tables.

Error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'idno.config' doesn't exist

(issue actually filed by @mapkyca)

[mapkyca]

Had to manually source the schema file, I'm guessing the installation code hasn't been written yet.

[benwerd]

The installation code is there. Likely a permissions issue, which we need to do a better check for.

[mapkyca]

User/PW for mysql were the root user.

It wouldn't be so bad if the forward to begin/register?set_name= didn't die with the error and instead gave some hints as to fixing it.

Infact, I wonder whether

if (file_exists('../config.ini')) {
        header('Location: ../begin/register?set_name=' . urlencode($site_title));
        exit;
}```

should be *after* the PDO database stuff...

[benwerd]

(The speculative fix seems to have improved this.)

[Asherehsa]

I just tried to install Known for the first time and ran into this same issue. I uploaded the config.ini file and get forwarded to /begin/register?set_name= but just get a 404 page. When I go to the root of the site I get this database error.

It doesn't look like the tables were even created, when I run SHOW TABLES; I get back:
Empty set (0.00 sec)

Update: I created the tables manually and now get forwarded to /begin/ and get another 404 page

[benwerd]

@Asherehsa Sounds like you have an .htaccess issue. Did your .htaccess file get written / is it present?

[Asherehsa]

@benwerd You were right, I had thought it might be a problem with the .htaccess so deleted it. Re-uploaded it and got the welcome page! Thank you.

[benwerd]

Whew! Let me know how it goes.

On Monday, October 5, 2015, Asher [email protected] wrote:

@benwerd https://github.com/benwerd You were right, I had thought it
might be a problem with the .htaccess so deleted it. Re-uploaded it and got
the welcome page! Thank you.

—
Reply to this email directly or view it on GitHub
#563 (comment).

Ben Werdmuller
http://goog_1933028737
benwerd.com | werd.io

+1 (312) 488-9373

[davidmead]

I'm running into a similar issue with install.

• Downloaded Known 0.8.4 "Giotto"
• Unzipped and FTP'd across to davidjohnmead.com/blog
• Got the setup page
• Filled in the MySQL db information (created the db before hand)
• Get the error "Ruh roh This resource doesn't exist. We're sorry." on http://davidjohnmead.com/blog/

The htaccess.dist is in the folder, and the config.ini has the correct db info in it. Don't see any other .htaccess files though.

This is on a shared Media Temple GRID server.

[danito]

Shouldn't you not rename the htaccess.dist to .htaccess?

On Tue, Oct 6, 2015 at 2:50 PM, David Mead [email protected] wrote:

I'm running into a similar issue with install.

• Downloaded Known 0.8.4 "Giotto"
• Unzipped and FTP'd across to davidjohnmead.com/blog
• Got the setup page
• Filled in the MySQL db information (created the db before hand)
• Get the error "Ruh roh This resource doesn't exist. We're sorry." on
  http://davidjohnmead.com/blog/

[image: screen shot 2015-10-06 at 8 48 09 am]
https://cloud.githubusercontent.com/assets/1266930/10308882/fef8d33a-6c06-11e5-9e20-215794143361.png

The htaccess.dist is in the folder, and the config.ini has the correct db
info in it. Don't see any other .htaccess files though.

This is on a shared Media Temple GRID server.

—
Reply to this email directly or view it on GitHub
#563 (comment).

Daniel Nix

[davidmead]

@danito I wouldn't have thought so. I thought Known created those when it's setting up.

[danito]

in some cases you don't want this.
@benwerd I think #969 can be closed.

[Asherehsa]

@davidmead I saw in the documentation that you need to run Known from a subdomain (not directory).

[davidmead]

I did check with @benwerd in IRC yesterday @Asherehsa, and he said you could do that now. I do have a version running on a sub-domain, but I want to move it over.

[benwerd]

To confirm, @Asherehsa and @davidmead, you can run it in a subdirectory. If .htaccess hasn't been created, you definitely want to copy htaccess.dist to .htaccess.

[davidmead]

Thanks @benwerd. I couldn't rename the htaccess.dist to .htaccess in my FTP client. Says there already one there, though it's not showing up.

Using the file manager on the server I can see it and it looks exactly the same as the htaccess.dist - Any ideas?

[davidmead]

Just an idea @benwerd, but does the subdirectory need to have Group Write settings enabled?

[benwerd]

If .htaccess is there, I wouldn't worry about it. Perhaps try adding the URL explicitly to config.ini?

url = "http://davidjohnmead.com/blog"

[davidmead]

Uhm. Nope. @benwerd

That just seems to have nixed the CSS. Adding a backslash url = "http://davidjohnmead.com/blog/" returns the CSS but doesn't help.

[benwerd]

Fascinating.

Would you mind adding a little debugging? In /index.php, underneath this:

if(substr($path, -1) == '/') {
    $path = substr($path, 0, -1);
}

Could you add

echo "Path is $path"; exit;

temporarily, and let me know what it says?

[davidmead]

I get the following:

Path is /blog

[benwerd]

So that's exactly correct. I wonder if, for some reason, CGI mode is preventing Known from getting the correct variables to construct the page routes. Hmm.

[davidmead]

My only other PHP setting option is 5.3.29 FastCGI or 5.3.29 CGI (Stable) on that domain.

I can send you a link to the phpinfo.php if you want.

[danito]

Can you post your .htaccess here? Also the one from the root if any. I had the problem that both outruled each other.

[davidmead]

@danito

Here's the one from the sub-directory
https://gist.github.com/davidmead/27a656ba40d62100f094

and here's the one from the root
https://gist.github.com/davidmead/29f44cbf9fb239205f6f

[danito]

Maybe you should except your /blog (known) subdirectory from the root rules.
Add

RewriteCond %{REQUEST_FILENAME} !blog

After the !-d rule in the root .htaccess

It helped on my installation with other application on it.

[davidmead]

I'll try that @danito.

Should I blow away the config.ini in /blog after putting that in the root .htaccess and try the install again?

[danito]

I don't think so, I think I had luck and after that the rewrite rules wheren't applied on my known subdirectory I had full access to it. But I don't know how it will behave in your case.

[davidmead]

@danito No luck. Tried just adding that to the root .htaccess, then tried creating the config.ini again - Nothing. In the end I deleted virtually everything on the root, apart from /blog/ and another folder.

Still doesn't work.

[benwerd]

I'm absolutely 100% convinced that this has something to do with routes not working in CGI mode. Does anyone have access to a CGI mode setup to test?

[mapkyca]

Only fastcgi, but I'm not sure that's the same (but that's what travis is using)

[benwerd]

We found and fixed the bug with FastCGI. It does work now.