Humans.txt

[sg-modlab]

Read the docs a few times. Reads as if you generate the humans.txt file on server ... is that correct?

If so the following is what is getting rendered however the humans.txt href results in a 404.

<!-- Humans.txt authorship http://humanstxt.org -->

<link type="text/plain" rel="author" href="humans.txt" />

If I am viewing a blog for example at http://site.dev/blog/is-it-possible-to I am seeing this as the url for the file http://site.dev/blog/humans.txt which does not exist.

Am I missing something?

[khalwat]

Nope, it's an error... it should be: <link type="text/plain" rel="author" href="/humans.txt" />

I pushed a fix for you:

https://github.com/khalwat/seomatic

It doesn't actually generate a file, it just handles requests for /humans.txt and renders the template for you.

[kerns]

Possibly related, I get this on installation of 1.0.5

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'genericCreatorHumansTxt' can't have a default value. The SQL statement executed was: CREATE TABLE `craft_seomatic_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`siteSeoImageId` INT(11) NULL,
`genericOwnerImageId` INT(11) NULL,
`genericCreatorImageId` INT(11) NULL,
`locale` VARCHAR(255) NULL DEFAULT "",
`siteSeoName` VARCHAR(255) NULL DEFAULT "",
`siteSeoTitle` VARCHAR(255) NULL DEFAULT "",
`siteSeoDescription` VARCHAR(255) NULL DEFAULT "",
`siteSeoKeywords` VARCHAR(255) NULL DEFAULT "",
`siteTwitterCardType` VARCHAR(255) NULL DEFAULT "",
`siteOpenGraphType` VARCHAR(255) NULL DEFAULT "",
`googleSiteVerification` VARCHAR(255) NULL DEFAULT "",
`siteOwnerType` VARCHAR(255) NULL DEFAULT "",
`genericOwnerName` VARCHAR(255) NULL DEFAULT "",
`genericOwnerAlternateName` VARCHAR(255) NULL DEFAULT "",
`genericOwnerDescription` VARCHAR(255) NULL DEFAULT "",
`genericOwnerUrl` VARCHAR(255) NULL DEFAULT "",
`genericOwnerTelephone` VARCHAR(255) NULL DEFAULT "",
`genericOwnerEmail` VARCHAR(255) NULL DEFAULT "",
`genericOwnerStreetAddress` VARCHAR(255) NULL DEFAULT "",
`genericOwnerAddressLocality` VARCHAR(255) NULL DEFAULT "",
`genericOwnerAddressRegion` VARCHAR(255) NULL DEFAULT "",
`genericOwnerPostalCode` VARCHAR(255) NULL DEFAULT "",
`genericOwnerAddressCountry` VARCHAR(255) NULL DEFAULT "",
`genericOwnerGeoLatitude` VARCHAR(255) NULL DEFAULT "",
`genericOwnerGeoLongitude` VARCHAR(255) NULL DEFAULT "",
`organizationOwnerDuns` VARCHAR(255) NULL DEFAULT "",
`organizationOwnerFounder` VARCHAR(255) NULL DEFAULT "",
`organizationOwnerFoundingDate` VARCHAR(255) NULL DEFAULT "",
`organizationOwnerFoundingLocation` VARCHAR(255) NULL DEFAULT "",
`corporationOwnerTickerSymbol` VARCHAR(255) NULL DEFAULT "",
`restaurantOwnerServesCuisine` VARCHAR(255) NULL DEFAULT "",
`personOwnerGender` VARCHAR(255) NULL DEFAULT "",
`personOwnerBirthPlace` VARCHAR(255) NULL DEFAULT "",
`twitterHandle` VARCHAR(255) NULL DEFAULT "",
`facebookHandle` VARCHAR(255) NULL DEFAULT "",
`facebookProfileId` VARCHAR(255) NULL DEFAULT "",
`linkedInHandle` VARCHAR(255) NULL DEFAULT "",
`googlePlusHandle` VARCHAR(255) NULL DEFAULT "",
`youtubeHandle` VARCHAR(255) NULL DEFAULT "",
`instagramHandle` VARCHAR(255) NULL DEFAULT "",
`pinterestHandle` VARCHAR(255) NULL DEFAULT "",
`siteCreatorType` VARCHAR(255) NULL DEFAULT "",
`genericCreatorName` VARCHAR(255) NULL DEFAULT "",
`genericCreatorAlternateName` VARCHAR(255) NULL DEFAULT "",
`genericCreatorDescription` VARCHAR(255) NULL DEFAULT "",
`genericCreatorUrl` VARCHAR(255) NULL DEFAULT "",
`genericCreatorTelephone` VARCHAR(255) NULL DEFAULT "",
`genericCreatorEmail` VARCHAR(255) NULL DEFAULT "",
`genericCreatorStreetAddress` VARCHAR(255) NULL DEFAULT "",
`genericCreatorAddressLocality` VARCHAR(255) NULL DEFAULT "",
`genericCreatorAddressRegion` VARCHAR(255) NULL DEFAULT "",
`genericCreatorPostalCode` VARCHAR(255) NULL DEFAULT "",
`genericCreatorAddressCountry` VARCHAR(255) NULL DEFAULT "",
`genericCreatorGeoLatitude` VARCHAR(255) NULL DEFAULT "",
`genericCreatorGeoLongitude` VARCHAR(255) NULL DEFAULT "",
`organizationCreatorDuns` VARCHAR(255) NULL DEFAULT "",
`organizationCreatorFounder` VARCHAR(255) NULL DEFAULT "",
`organizationCreatorFoundingDate` VARCHAR(255) NULL DEFAULT "",
`organizationCreatorFoundingLocation` VARCHAR(255) NULL DEFAULT "",
`corporationCreatorTickerSymbol` VARCHAR(255) NULL DEFAULT "",
`personCreatorGender` VARCHAR(255) NULL DEFAULT "",
`personCreatorBirthPlace` VARCHAR(255) NULL DEFAULT "",
`genericCreatorHumansTxt` text NULL DEFAULT "",
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` CHAR(36) NOT NULL DEFAULT 0
) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

[sg-modlab]

@khalwat Installed the latest and that corrected the issue. Thanks.

[khalwat]

@kerns I pushed a change that should fix this for you. Can you attempt to reproduce it?

https://github.com/khalwat/seomatic

[kerns]

@khalwat Confirmed – issue resolved. Thank you.

[khalwat]

@kerns Great, thanks! I did some searching around, and apparently there is different behavior from MySQL on Windows (which throws the error you found) vs. everything else it runs on. But either way, what I was doing was not correct.