Update error

Hi,

I’m attempting to do a trial update from 4.7.3 to 4.8.3

Have copied my database without the views, and now when trying to login / or view the shop get the errors
2014-02-07 11:50:53exception ‘ADODB_Exception’ with message 'mysql error: [1146: Table ‘mydb.oxv_oxshops_de’ doesn’t exist] in EXECUTE("select oxv_oxshops_de.oxid, oxv_oxshops_de.oxactive, oxv_oxshops_de.oxproductive, oxv_oxshops_de.oxdefcurrency, oxv_oxshops_de.`

well no it doesn’t i have not copied the views .
Where is the sql to regenerate them ?

thanks

ok got round that problem, by copying them out of the 4.8.3 installation sql (this cannot be the correct way though)

Now have a new problem, admin - has nothing in the sidebar (appart from history and favorites - both empty), whats wrong ?

follow up - empty tmp - thought that may be the problem, now new error
[Fri Feb 07 12:04:40 2014] [error] [client 192.168.1.168] PHP Fatal error: Maximum function nesting level of ‘100’ reached, aborting! in /web/test_483/core/oxutilsobject.php on line 686

edit so resolved that problem

by putting a return false in the suspect cache function

  • now have an admin again
protected function _getFromCache( $sModuleVarName, $blSubshopSpecific = true )
{
    return false;
    $sShopId = null;
    if ( !$blSubshopSpecific ) {
        $sShopId = "all";
    }
    $sFileName = $this->_getCacheFileName($sModuleVarName, $sShopId);
    $sValue = null;
    if ( is_readable( $sFileName ) ) {
        $sValue = file_get_contents( $sFileName );
        if ( $sValue == serialize( false ) ) {
            return false;
        }
        $sValue = unserialize( $sValue );
        if ( $sValue === false ) {
            $sValue = null;
        }
    }
    return $sValue ;
}

The update process is not exactly user friendly uptil now