Error on Salix 'clean' installation - C5 Version 8.0.3

Permalink Browser Info Environment
Attempting to install 'clean' and allow Salix to overwrite the existing dev content results in the error:
An exception occurred while executing 'delete from Files where fID = ?' with params [7]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`omnicomd_dev`.`atFile`, CONSTRAINT `FK_73D17D61E3111F45` FOREIGN KEY (`fID`) REFERENCES `Files` (`fID`))


uninstalled Salix and tried again with the same result.

thank you.

Type: Pre-Sale
Status: Resolved
jgaryt
View Replies:
pilipala replied on at Permalink Reply
pilipala
Hi,

We have tested this using concrete5 v 8.0.3 and Salix v 1.1.0, first using Elemental theme without sample content and then with Elemental theme sample content. We have not been able to replicate this error. Possibly it is something to do with your development content in version 8?

Version 8 is still fairly new, possibly there could be a bug to do with this issue. For example:
https://www.concrete5.org/developers/bugs/8-0-3/error-deleting-expre...
I'm not sure if this is related or not to your error.

In any case, if you don't need your development content, and are going to overwrite it with Salix sample content, I would suggest that you try again with a clean install of concrete5 without the development content (delete the files and database and start from scratch). Before you do this, you should save your files and database in case you want to use them again.

If you want to keep your development content, you may need to look at your SQL and manually delete what it is complaining about. Make sure you save your original site's database and files first before you attempt to delete anything in SQL.

Thanks,

Jennifer
jgaryt replied on at Permalink Reply
jgaryt
Thank you for your response. I thought those two answers would be the case, but I'll also look into the entities issue.

Love the Salix theme thus far.
jgaryt replied on at Permalink Reply
jgaryt
Finally did get it to install cleanly, but I had to go into SQL and delete the content of three Attribute Tables first: AttributeValues, AttributeKeys, and CollectionAttributeValues (I think that's right - the errors will lead you through the sequence).

I also removed any custom entities before I tried any of this, and it made no difference.

This was specifically tied to the Attributes structure - possibly the items are being removed in the wrong order by the installation of the theme. I had a lot of Attributes and values in my dev site.

Hope this helps.
pilipala replied on at Permalink Reply
pilipala
Great, glad you are liking the theme.

Thank you for describing how you solved the problem. It may help other people if they encounter the same issue.

concrete5 Environment Information

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

# concrete5 Packages
Salix (1.1.0)

# concrete5 Overrides
languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, 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/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/es_PE/LC_MESSAGES/messages.mo, languages/es_PE/LC_MESSAGES, languages/es_PE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/es_PY/LC_MESSAGES/messages.mo, languages/es_PY/LC_MESSAGES, languages/es_PY, 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/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/cs_CZ/LC_MESSAGES/messages.mo, languages/cs_CZ/LC_MESSAGES, languages/cs_CZ, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/en_GB/LC_MESSAGES/messages.mo, languages/en_GB/LC_MESSAGES, languages/en_GB, languages/pt_BR/LC_MESSAGES/messages.mo, languages/pt_BR/LC_MESSAGES, languages/pt_BR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/es_PE/LC_MESSAGES/messages.mo, languages/es_PE/LC_MESSAGES, languages/es_PE, languages/nb_NO/LC_MESSAGES/messages.mo, languages/nb_NO/LC_MESSAGES, languages/nb_NO, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache

# Server API
cgi-fcgi

# PHP Version
7.0.14

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, session, SimpleXML, snmp, soap, sockets, SPL, sqlite3, standard, tidy, timezonedb, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, yaml, zip, zlib

# PHP Settings
max_execution_time - 300
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 300
max_input_vars - 1000
memory_limit - 256M
post_max_size - 1024M
sql.safe_mode - Off
upload_max_filesize - 1024M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.3; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.