What errors do you see in the PHP Error Log on the server?

Sorry, I'm not sure where to find that info.

I would suggest you contact your host and see if they can help you find it. That would certainly give you a clue as to what is going wrong.

The only error log I could find says this:

[Tue Jan 03 13:03:57.179779 2017] [:error] [pid 1043356:tid 140672923305728] [client 206.51.238.159:40432] File does not exist: /home/anflawzt/public_html/license.php.suspected

Well that's certainly an odd error since there is no license.php in Concrete5, did you have another site hosted in this location previously?

Just my current static html site. I'm trying to put the Concrete5 site on a subdomain I use for testing so I don't understand why the error doesn't originate from the test subfolder.

Files with a .suspected extension would usually be files that your web hosts had identified as possibly being malicious and renamed so they can not be run. The web host may also change the permissions so that they can not accessed by you or software running on the website. Have you contacted your web host to see if they know anything about them?

I just submitted a support ticket with them.

I also found an error log file in my test subfolder and this is what it says:

[03-Jan-2017 15:29:32 America/New_York] PHP Warning: require(/home/anflawzt/public_html/test/updates/concrete5-8.0.3/concrete/dispatcher.php): failed to open stream: No such file or directory in /home/anflawzt/public_html/test/concrete/bootstrap/configure.php on line 52
[03-Jan-2017 15:29:32 America/New_York] PHP Fatal error: require(): Failed opening required '/home/anflawzt/public_html/test/updates/concrete5-8.0.3/concrete/dispatcher.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/anflawzt/public_html/test/concrete/bootstrap/configure.php on line 52
[03-Jan-2017 15:29:34 America/New_York] PHP Warning: require(/home/anflawzt/public_html/test/updates/concrete5-8.0.3/concrete/dispatcher.php): failed to open stream: No such file or directory in /home/anflawzt/public_html/test/concrete/bootstrap/configure.php on line 52
[03-Jan-2017 15:29:34 America/New_York] PHP Fatal error: require(): Failed opening required '/home/anflawzt/public_html/test/updates/concrete5-8.0.3/concrete/dispatcher.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/anflawzt/public_html/test/concrete/bootstrap/configure.php on line 52

Does this file exist on your server? /home/anflawzt/public_html/test/updates/concrete5-8.0.3/concrete/dispatcher.php

Looks like a few things were missing there. I uploaded all the missing files.

Now when I try to visit the test site I get this:

Third party libraries not installed. Make sure that composer has required libraries in the concrete/ directory.

nvm, fixed that and I actually get a bit of the Concrete UI showing up now but with this error:

An unexpected error occurred.
Creating default object from empty value

I would strongly suggest you turn on the debugging information so that you can see the full error messages.

I was able to get the site up and working for the most part but when I try to upload files, I get this error message:

An unexpected error occurred. An exception occurred while executing 'INSERT INTO FileVersions (fvID, fvFilename, fvPrefix, fvDateAdded, fvActivateDateTime, fvIsApproved, fvAuthorUID, fvSize, fvApproverUID, fvTitle, fvDescription, fvExtension, fvType, fvTags, fvHasListingThumbnail, fvHasDetailThumbnail, fID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [2, "lpmn.png", "281480014711", "2017-01-04 11:44:31", "2016-11-24 20:11:52", 0, 1, "288034", 1, "Collin Daugherty", "", "png", 1, "", 1, 0, 1]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`anflawzt_conc986`.`FileVersions`, CONSTRAINT `FK_D7B5A13AE3111F45` FOREIGN KEY (`fID`) REFERENCES `files` (`fID`)) < Back to Home


And I get this error when I try to edit the SEO settings for a page:

An exception occurred while executing 'INSERT INTO CollectionAttributeValues (cID, cvID, akID, avID) VALUES (?, ?, ?, ?)' with params ["167", "3", 1, null]: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`anflawzt_conc986`.`CollectionAttributeValues`, CONSTRAINT `FK_BB9995FCB6561A7E` FOREIGN KEY (`akID`) REFERENCES `attributekeys` (`akID`))

Thanks so much for your help so far!

It sounds to me like your database dump/restore didn't work properly and you're missing rows in some of your tables. Or there are different settings on your live server than there were on your development server.

okay, looks like the easiest way to fix this is to start with a clean db and just recreate what I had which thankfully won't take much time.

Thanks again for the help!

Hi,

maybe the topic is closed ... but I had the similiar error and found this thread with a search engine.

After copying files of concrete5 8.2 to my hoster and importng the sql dump I had 2 effects:

(1)
The admin gui does not work - some pages were white (http response code 200 (OK); but 0 byte in body). With enabled debug I saw the include directories poited to my local pathes. --> Clear the cache helped. I made it in my local environment and reimported the new mysql dump.

(2)
Changing content in pages has shown:


This is a same problem like above. The problem here is in the tablename

It is the wrong table - it has no capital letter: the right table name is "AttributeKeys".

I remember I changed the tablenames from lowercase to camelcase in Mysql (there are a few threads about it) ... but now I see the constraints are still wrong.
In my mysql dump I see these 2 wrong constraints ...



I rewrite the dump and import it again to fix it.

regards,
Axel

The above comment helped me perfectly... Simple find/replace in text editor fixed this issue for me.