Help - Search - Members - Calendar
Full Version: Edit project wont open
RV Products Forums > RVSiteBuilder > General Support
Lehel
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
Lehel
QUOTE(Lehel @ Nov 24 2009, 03:21 PM) *
Hello,
(...)


Ok, now appears:

nov 26 08:54:03 IP [error] SGL_Task_SetupPearErrorCallback->pearErrorHandler: PEAR :: DB_DataObject Error: autoload:Could not find class DataObjects_ using class_location value :
nov 26 08:54:03 IP [error] SGL_Task_SetupPearErrorCallback->pearErrorHandler: PEAR :: DB_DataObject Error: factory could not find class from :

After editing any of the pages: Fatal error: Call to undefined method DB_DataObject_Error::fetch() in /var/cpanel/rvglobalsoft/rvsitebuilder/modules/sitebuilder/classes/SitebuilderDao/ProjectPageDao.php on line 1035 with the above error message in the log.
Exporting the project is also not possible, with the same error.
I just run a force upgrade; no change.

I mention that the PEAR package: DB_DataObject it's installed.
# Ignoring installed package pear/DB_DataObject
Version 1.8.8

Any advice please,

Thanks,
Lehel
Lehel
Ok, seems like removing these to files and upgrade made the difference:

rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/var/INSTALL_COMPLETE.php
rm -f /var/cpanel/rvglobalsoft/rvsitebuilder/rvsitebuilderversion.txt

Cheers.
Lehel
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.