Hello,
We've just upgraded the latest version of RVS
You are running version : PRO 3.86
Latest RVSiteBuilder version : PRO 3.86
Before this we had some problems opening RVS through WHM, so upgraded [3.4* < i'm not sure] > 3.85 all fine, until this client has no more acces to edit his projects "Nu are Structura Paginii!" < meaning something about the /structure page does not exist/. I activated the error in logs:
nov 24 13:10:08 IP [error] SGL_Task_SetupPearErrorCallback->pearErrorHandler: PEAR :: DB Error: no such field :
SELECT
DISTINCT lp.project_id
, pp.rvs_usr_id
, lp.project_page_id
, lp.parent_project_page_id
, lp.priority
, pp.page_name
, pp.custom_page_name
, pp.page_title
, pp.meta_keyword
, pp.meta_description
, pp.rvs_component_id
, pp.rvs_link_id
, pp.target
, pp.effect_page_enter
, pp.duration_page_enter
, pp.meta_page_effect
, pp.last_modifier
FROM
rvs_project_layout_page lp
, rvs_project_page pp
WHERE
lp.project_id = 'f4c388cecd122bef46c54cb87989d1ec'
AND pp.rvs_usr_id = '8f5ae9ccace9524b327e496fae83a27a'
AND lp.parent_project_page_id = '0'
AND lp.project_page_id = pp.project_page_id
ORDER BY
priority
[nativecode=1054 ** Unknown column 'pp.last_modifier' in 'field list']
nov 24 13:10:08 IP [error] SGL_Task_SetupPearErrorCallback->pearErrorHandler: PEAR :: DB Error: no such field :
SELECT
DISTINCT lp.project_id
, pp.rvs_usr_id
, lp.project_page_id
, lp.parent_project_page_id
, lp.priority
, pp.page_name
, pp.custom_page_name
, pp.page_title
, pp.meta_keyword
, pp.meta_description
, pp.rvs_component_id
, pp.rvs_link_id
, pp.target
, pp.effect_page_enter
, pp.duration_page_enter
, pp.meta_page_effect
, pp.last_modifier
FROM
rvs_project_layout_page lp
, rvs_project_page pp
WHERE
lp.project_id = 'f4c388cecd122bef46c54cb87989d1ec'
AND pp.rvs_usr_id = '8f5ae9ccace9524b327e496fae83a27a'
AND lp.parent_project_page_id <> '0'
AND lp.project_page_id = pp.project_page_id
ORDER BY
priority
[nativecode=1054 ** Unknown column 'pp.last_modifier' in 'field list']
[24-Nov-2009 15:10:08] ########## Req type: SGL_Request_Browser
What can we do?
Do you suggest a rollback to an older version?
Thank you,
Lehel
