143 Posts
pretobrazza
10 years ago
11
Topic
Hello everyone,

My Seblod/Joomla installation is up to date and everything is working fine EXCEPT the Seblod 'Article' content manager in the backend (Form & Content Type).

1. I can create and save new articles but I cannot save the content type 'Articles' after editing.

In the first line or the error I read:
Save failed with the following error: Duplicate entry '1-type-6' for key 'type_id_version' SQL=INSERT INTO `zwin_cck_core_versions` ect
a bit further I see: ,\"stylesheets\":\"\",\"version\":\"6\",\"checked_out\":\"71\",\"checked_out_time\":\"2014-05-19 08:05:33:
Can I change e.version of the last entry of 'e.title Article in MSQL?   

2. I installed a fresh Seblod on a fresh Joomla installation and the content type 'Article' has tabs as in Joomla. The old one doesn't have tabs even though it is running on J3.3 Seblod3.3.4.
With the content type 'Category', there are tabs in the old site.
Can I export the 'Article app folder' out of the new site and install it in the old site without breaking too much?

Your answer will be highly appreciated.
Bernard
Get a Book for SEBLOD
4229 Posts
Kadministrator
10 years ago
2
Level 1
For first problem you will probably need to go to mysql base and delete from zwin_cck_core_versions table a row that has '1-type-6' value in 'type_id_version' column. Then your type should save correctly.

For. 2 I would imagine you can export/import article type, but this will be imported as new type, it won't overwrite existing one, and since your existing articles will not open in this new interface. As always - backup before doing anything as this has not been tested.
143 Posts
pretobrazza
10 years ago
1
Level 2
Thank you Klas!

For 1.  In #_cck_core_versions I deleted the row with 'Article' where e.version had the value 6 (as was indicated in the error in my case in time).
I opened and saved the Article type and there were no errors anymore. ;)

For 2.
1. What if I delete the Article type from the old site first (backend through Seblod NOT in msql )
2. Then install a copy of the Article type from a fresh J/Seblod installation in the old site

All the names of the corresponding fields and tables will be the same. Is there a way in msql to 'make-believe' to the content that the new type is actually the old one?

What number in which column should I write down so I can change it once I install the new Article type?   

Kind regards,
Bernard


4229 Posts
Kadministrator
10 years ago
0
Level 3
Hi,

I'm not eaxactly sure about this, but I think main table to change would be #__cck_core where you would need to change cck column value from old to new content type. Deleting old article type will not change anything in my opinion. Again, please test this on a copy not on pproduction server :)
4229 Posts
Kadministrator
10 years ago
5
Level 1

Perhaps this will help you too:

when you upgrade an app (so when you install it again without deisntalling it first):

- it doesn't affect your existing content types, search types,..
- it creates new fields (those fields are available for you to assign/drag&drop)
- it updates all plug-ins,templates

143 Posts
pretobrazza
10 years ago
4
Level 2

Thank you Klas. 

I didn't export the article app yet from a fresh install in order to re-install it over the Articles app in an old site.   But I'm planning to do it.
Before I start, is there a place on your site where I can possibly download the Articles app so I'm sure I'm using 'the best of best' before proceeding?

Possibly other people who're stuck with an old Articles app in their up-to-date Seblod installations might also be interested ..

Kind regards,

Bernard

548 Posts
joomleb
10 years ago
0
Level 3

Hi petrobrazza, 

Please, let us know as you tested it. I've never tried it, but I yet encountered on my way and I expressed my opinion and wrote it as issue in the tracker.

A good feature would be have a way to decide if overwrite or not the enitre App (included content types and search types) during an App installation...

As far as I know the only way to have default Seblod Apps is to install last new fresh Seblod and export them...

548 Posts
joomleb
9 years ago
2
Level 3

Hi Pretobrazza,

about "I didn't export the article app yet from a fresh install in order to re-install it over the Articles app in an old site. But I'm planning to do it."

Please, Have you tried it ?

143 Posts
pretobrazza
9 years ago
1
Level 4

Hi Joomleb,

Just to answer you because I'm polite ... I't's been a year since that post and I can't remember what I did afterwards. The 2 sites that still run on Joomla/Seblod, are still working 100% fine. Every morning my browser still opens one tab on Seblod.com where I verify any progress;   

At the time I'm responding now, I haven't updated anything for a whilefrom older versions of Joomla/Seblod. This, because I'm too scared to run into further problems when I'll attempt an update of Joomla/Seblod and all of the associate plugins/etc etc and I'm not prepared to spend any of my leasure time on potential problems where I'll only eventually get replies with an unreasonable long delay even-though I spent many 100's of Euros on buying most of Seblod's products and even sponsoring a calendar template (€300 - Marcio Marquez) which is still not in the Seblod store.

Since, I've moved to greener grass ..  just because the Seblod community didn't give me the right answers in june/july last year to simple questions relating to things like those things.   

Kind regards,

Bernard   

548 Posts
joomleb
9 years ago
0
Level 5

Hi Bernard, thank you very much for your quick and gentle answer

143 Posts
pretobrazza
10 years ago
1
Level 1

Ok everyone, 

I successfully switched from an old Articles app (no tabs in admin and site form) to the new one in an old site 

Here are the steps (for sure some of them might be unnecessary but I preferred to make sure I didn't leave out things): 

1. Make a backup of the old site (!!) 

2. From a fresh Joomla/Seblod installation I downloaded: 

    2.1 app_cck_joomla_article 

    2.2 base - basic - publishing - images_links - metadata 

3. In the old site (through 'Upload & Install Joomla Extension') I first installed all the elements from 2.2 after which I installed 2.1 

4. I opened up the 'Form & Content Type' ARTICLE from the old site and the same page from the fresh installation in another browser window and put them next to each other

5. In the old site I put all the fields in 'admin' and 'site' in the same order as those in the new site 

Note: I only had to create one tab which didn't exist in the old site : 'Tab Publishing (Panel). I opened the field in the new site and created the same type of field in the old site (don't forget to open the lock-icon ;) ) 

6 Tested it and yes ... now I have a tabbed Article content type in Admin form and Site form. 

Kind regards, 

Bernard

PS. Don't forget to look at the labels in #1 and also #6 (markup) - Also, you might to have to configure the 3 button fields Save&close, Save&new and Close to have the Icons appear ..  

548 Posts
joomleb
10 years ago
0
Level 2

Hi pretobrazza, 

many thanks for your "how to".

Cannot updating Apps directly, a good thing would be to have changelogs each updating release. In this way we would have a small "list of changements" to follow...

Get a Book for SEBLOD