phpwcms Support Forum

Hello!

Im upgrading from 1.4.5 to 1.5.4.1 and trying to follow the guide.
In backend, everythim seems to be ok but templates do not work.

And: editing site structure gives:

Unknown column 'acat_class' in 'field list'
UPDATE phpwcms_articlecat SET acat_name='Työsuhde',
acat_info='',
acat_alias='tyosuhde-2',
acat_aktiv=1,
acat_public=1,
acat_struct=63,
acat_template=17,
acat_sort=20,
acat_uid=2,
acat_hidden=0,
acat_ssl=0,
acat_regonly=0,
acat_topcount=-1,
acat_redirect='',
acat_order=0,
acat_cache='0',
acat_nosearch='',
acat_nositemap=0,
acat_permit='',
acat_maxlist=0,
acat_cntpart='',
acat_pagetitle='',
acat_paginate=0,
acat_overwrite='',
acat_archive=0,
acat_class='',
acat_keywords='',
acat_cpdefault=0 WHERE acat_id=65

I got an idea where is about but dont know what to do.
Somabody kindly help?

KK

check your db update. Seems this has failed and now the field acat_class is missing.

Now, this is odd.... there seems to be no acat_class and and no acat_keywords in phpwcms_articlecat in the version im upgrading from. Im puzzled.
It shows version 1.4.5 but can the database be then much older version?

KK

you missed an update step.

Do it manually.

I've tried manual update - thats how I started this. Now I see the original 1.4.5 database is missing acat_keywords and acat_class in phpwcms_articlecat, and that caused the first error.
Then I added empty acat_keywords and acat_class. It does not change template.
If I got to backend and edit stucture of on page, I get right template in browser for one time, but when I move from page, it disappears.

Could this database without missing acat_keywords and acat_class in phpwcms_articlecat be 1.39 ?

KK

don't know.

Dazu bleibt mir nur folgendes zu sagen, die damaligen Updates der Datenbanken waren nicht stabil.

Ich habe den Fehler jetzt auch bei einem Kunden gehabt und dafür eine Lösung gefunden, die zumindest "Works me" ist
http://forum.phpwcms.org/viewtopic.php? ... 53#p139953