error when click files

Permalink
Hi,
I have upgraded from 7.3 up to 8.03, and i seem to be having image errors when trying to edit or change an image. but not all images, just some.
Also, when i go to system then files, i get this error..

The identifier fID is missing for a query of Concrete\Core\Entity\File\File

here is my environmental info, I am using the theme calyx 5.7

# concrete5 Version
Core Version - 8.0.3
Version Installed - 8.0.3
Database Version - 20161216000000

# concrete5 Packages
Calyx 5.7 (1.0.1), Fruitful (1.2), Honest Websites Back To Top (0.9.4), Quick Tabs (1.0), Share Me (0.9.1)

# concrete5 Overrides
languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/pl_PL/LC_MESSAGES/messages.mo, languages/pl_PL/LC_MESSAGES, languages/pl_PL, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - On - In all cases.
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.10 (Debian)

# Server API
cgi-fcgi

# PHP Version
5.6.29-0+deb8u1

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json, libxml, mbstring, mcrypt, memcache, memcached, mhash, mysql, mysqli, openssl, pcntl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, pspell, readline, recode, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, XCache, XCache Cacher, XCache Coverager, XCache Optimizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
memcache.max_failover_attempts - 20
memcached.sess_lock_max_wait - 0
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5
xcache.var_maxttl - 0
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

 
HarryVienna replied on at Permalink Reply
HarryVienna
Hello!

Did you find a solution? I just wanted to upgrade an get exactly the same error message when clicking on files. Everything else seems to work..

Cheers
Harald
davetl replied on at Permalink Reply
Hi Harry,
No, I tried lots of things. i originally thought it was a permissions thing, but its not as i changes 755 then 777, and kept getting same error. Then i thought it was a theme issue.
I tried to install concrete5 in a new sub directory but the installer for some reason kept throwing up an error relating to the root upgrades folder.. but i was installing to a sub directory called /crete and not the web root..
I have also tried completely replacing the concrete, application and packages folder. but no joy
so, (sorry - balls to it) i have now moved existing concrete5 (broke) site which i cannot files to work and moved it to a temp folder. Installed a fresh 8.10 concrete5 and now going through making all pages again. what is making it easier is i am editing the /application/config/database.php and changing back and forth from old database to new database to get at the page names and content. but taking content from page source. I did look in to extracting page's from sql database but thought if the problem is with the database then it would possibly bring the issue in to new build.

It all stems (i think) from my original version 5.6.something, everytime i went to upgrade it bitched a moaned, maybe because i had a addon it didnt like - i dont know.
I had to do a manual upgrade and things were never the same. I have also noticed on experimenting, the re install and fresh all moan about the upgrades being a set version, so thats why i opted to do a complete fresh install and i had to do it off the server and then import new database and copy files over.

final solution = fresh install in another environment (server) then upload all files and import new database. moved old site to a folder called /orig/ now changing back and forth editing /application/config/database.php to get at old content.
images solution = downloaded /orig/ and will go through the files directory looking for my images.
but now the site runs a lot quicker.....
hope this helps
HarryVienna replied on at Permalink Reply
HarryVienna
Hello,

Thanks for your quick response!

Unfortunatly a fresh install is no option for me. It was already a LOT of work to migrate from 5.6 to 5.7 (https://www.concrete5.org/community/forums/chat/successfully-ported-... ), so i surely will not do that again :-)

I finally found a "solution", even I could not find a reason for the problem. Here is what I did:

I installed XAMPP (1.8.3) on my PC. Then I copied all files from my server to the XAMPP installation. I made a database backup and also imported it into the XAMPP installation. At the end, I changed some config files a little bit until i had a working copy of my website. Then I made the ugrade process to version 8.0.3 and... It worked!!

Then I exported the database and imported it on my server. And now everything works fine. One importand thing is, to configure mysql on windows to use case sensitive table names.

I have no idea what the problem was on my server. But at the end, only the result counts :-)

Cheers
Harald