[Oscailt] Upgrade

[Arne Johansson]

Hello Terence

Sorry I can't explain good enough, I'm attaching some images to explain
the minor problems:

1. An image for imc-topics in MySQL database. From the beginning the 
INDEX key pointed
at the field topics_id. After the building of the new Primary key, 
"topics_id, language_id", both
index and primary keys pointed at the field topics_id and that doesn't 
work though it's impossible to
add new topics from Oscailt Admin screen. Therefore I changed INDEX key 
to point at
topics_name instead and that seems to work, at least are there no 
problem with adding new topics in
Oscailt.

2. This is an image showing the front page before upgrading. You can see 
that there are no article
numbers in the title row.

3. This is an image after upgrading. You can see that there are article 
numbers before the title in the
title row. As far as I remember there is a setting for this but I can't 
figure out where.

Hope this is a better explanation.

Best regards
Arne Johansson




Terence skrev 2012-01-29 01:09:
> Hi Arne,
> I would be interested to know more details about the problems around the topics, regions and types tables. For the v3.5 release, the field language_id was added to these so that you could have different names in the different languages. So for example topic_id = 1 could have say a transation for 3 different languages and these could be say language_id =1, 2 and 3. So it would look like this:
> topic_id, language_id,  topic_name
> 1      ,  1   ,  Environment (say in English)
> 1      ,  2   , Umwelt (Environment in German)
> 1      ,  3   , omgivning  (Environment in Swedish)
>
> With the v3.5 release this is what happens. If you have say 3 languages defined on your site (as above), then when you go to update the topic (topic_id=1), you need to provide some text for all 3 language versions of it, otherwise there is some unresolved problem.
>
> This might be the problem that you had. I am not sure what changing the index would do, but changing the primary key could break it.
>
> For the problem about the article number and title on the front page, I would need more information about this.
>
>
> rgds
> Terence
>
>
>
> ----- Original Message -----
> From: Arne Johansson<arne at knared.biz>
> To: Oscailt Mailing List<oscailt at lists.indymedia.org>
> Cc:
> Sent: Saturday, 28 January 2012, 12:56
> Subject: [Oscailt] Upgrade
>
> Hello everyone out there!
>
> I have succesfully upgrade knared.biz from 3.4 to 3.5 thanks to very
> good upgrade instructions.
> The only minor problem I had was when adding the "language_id" for
> topics, regions and types
> in the database, I did that manually:
>
> After deleting the primary key and adding the new one including
> "language_id" are both the primary key
> and the index key pointing at topics_id, region_id and types_id. And
> that don't work at all when one is
> trying to create new topics, regions or types. Therefore I changed the
> index keys in the database to point
> to the names instead. And that seems to be working.
>
> Another problem is that after the upgrade the article number i shown
> together with the title at the front
> page. I know there is a setting for that but I can't find it, please help.
>
> Best regards
> Arne Johansson
>
>
>
>
>
> _______________________________________________
> Oscailt mailing list
> Oscailt at lists.indymedia.org
> http://lists.indymedia.org/mailman/listinfo/oscailt
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: topicsdb.jpg
Type: image/jpeg
Size: 11826 bytes
Desc: not available
Url : http://lists.indymedia.org/pipermail/oscailt/attachments/20120129/0bd596e6/attachment-0003.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: frontpage- 111118.jpg
Type: image/jpeg
Size: 106107 bytes
Desc: not available
Url : http://lists.indymedia.org/pipermail/oscailt/attachments/20120129/0bd596e6/attachment-0004.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: articlenumber.jpg
Type: image/jpeg
Size: 16496 bytes
Desc: not available
Url : http://lists.indymedia.org/pipermail/oscailt/attachments/20120129/0bd596e6/attachment-0005.jpg