Topics

Tribe Support

Tribe Support's Topics

Apoorv Singh

Apoorv Singh

August 30 2015

Upgrade to 4.1.4 issue

Hello Tribe,

We have started our efforts to migrate to 4.1.4 from 3.x.x Anahita release. So far some success. Here is what I have done so far. Server is Apache.

- Installed fresh 4.1.4 release and instaled all apps successfully. logged in and etc..

- Point to my 3.x.x db in the new instance config file and then run below command for db migrate up

  • php anahita db:migrate:up

But I see [AnDomainPropertyException] for coverfilename. Now opeing url says "Property coverFilename is mapped to an invalid column for entity com://site/actors.domain.entity.actor"

What am I missing?

Thanks

************************************LOG******************

There are no migrations to run for photos

There are no migrations to run for connect

Migrating up anahita version 4

QUERY: ALTER TABLE jos_users ADD UNIQUE (`username`) (0.0645909309387)

QUERY: ALTER TABLE jos_users ADD UNIQUE (`email`) (0.00417399406433)

Migrating up anahita version 5

QUERY: DROP TABLE IF EXISTS jos_categories (0.000247001647949)

QUERY: DROP TABLE IF EXISTS jos_content (0.00011682510376)

QUERY: DROP TABLE IF EXISTS jos_content_frontpage (0.000108957290649)

QUERY: DROP TABLE IF EXISTS jos_core_log_items (0.000108003616333)

QUERY: DROP TABLE IF EXISTS jos_migration_backlinks (0.000106811523438)

QUERY: DROP TABLE IF EXISTS jos_migrations (0.000105142593384)

QUERY: DROP TABLE IF EXISTS jos_sections (0.000102043151855)

QUERY: DROP TABLE IF EXISTS jos_stats_agents (0.000102996826172)

QUERY: DROP TABLE IF EXISTS jos_tagmeta (0.000102043151855)

QUERY: DROP TABLE IF EXISTS jos_core_log_searches (0.000105142593384)

QUERY: DELETE FROM jos_components WHERE `option` = 'com_mailto'  (0.00977206230164)

QUERY: INSERT INTO jos_plugins (name,element,folder,iscore) VALUES ('Hashtag', 'hashtag','contentfilter',1) (0.000357151031494)

QUERY: ALTER TABLE jos_anahita_nodes DROP COLUMN `tag_count` (1.59505081177)

QUERY: ALTER TABLE jos_anahita_nodes DROP COLUMN `tag_ids` (1.11315989494)

QUERY: INSERT INTO jos_components (`name`,`link`,`option`,`iscore`,`enabled`) VALUES ('Hashtags','option=com_hashtags','com_hashtags',1,1) (0.00753593444824)

Actors' Hashtags

QUERY: SELECT id FROM jos_anahita_nodes WHERE type LIKE 'ComActorsDomainEntityActor%' AND body REGEXP '#([^0-9_\s\W].{2,})' (0.017877)

#upgrade #4.1.4

  • 6 Comments
  • Last Comment by Apoorv Singh
Apoorv Singh
Apoorv Singh
August 30 2015 Permalink
@Scott thanks for providing the info and related links.

I am bit confused..since I am migrating from 3.x.x version. I guess this is needed for all before cover was introduced.

Let me try executing provided sql manually first and see if I hit the photo issue..ideally shouldn't for 3.x.x.
Apoorv Singh
Apoorv Singh
August 30 2015 Permalink
After running the query in 10.php as suggested, I was able to pass that coverfilename exception error. Then after hashtag it got stuck with below exception some column in topic...
@scott @rastin do we need to add some columns in there too? Please suggest.

QUERY: SELECT id FROM jos_anahita_nodes WHERE body REGEXP '#([^0-9_\s\W].{2,})' AND ( type LIKE '%com:notes.domain.entity.note' OR type LIKE '%com:topics.domain.entity.topic' OR type LIKE '%com:photos.domain.entity.photo' OR type LIKE '%com:photos.domain.entity.set' OR type LIKE '%com:pages.domain.entity.page' OR type LIKE '%com:todos.domain.entity.todo' ) (0.061763)

[AnDomainPropertyException]
Property pinned is mapped to an invalid column for entity com://site/topics.domain.entity.topic
Rastin Mehr
Rastin Mehr
August 30 2015 Permalink
Loading ...
Unknown Person liked this
Apoorv Singh
Apoorv Singh
August 31 2015 Permalink
Thanks @rastin @scott I am able to get through the database upgrade issue. Greatly appreciated.

However I am yet to lot of stuff, themes, settings, apps and more. Currently I am facing some caching issue, where my default page is showing contents form my production env..Both share same main folder but under different subfolders.I am currently looking into it. will keep posted on our upgrade.

Once our migration is complete, I will list down all the steps that worked for me for this upgrade for our tribe.
Rastin Mehr liked this
Rastin Mehr
Rastin Mehr
August 31 2015 Permalink
perhaps some of the queries need to be added to the previous migrations too. We never came across this issue, but this happens to people who waited longer to upgrade their installations.
Apoorv Singh
Apoorv Singh
August 31 2015 Permalink
@rastin. Our current production install is 3.x.x..just one major release behind.

That was a minor issue we found later. Issue was we had updated the html content folder to a specific folder under admin settings>extension>html. Since this was saved in database so when migrating to old database, it was still fetching content from that location. So simply removing that fixed this issue.. :)

Powered by Anahita