[Archon-L] 2.0 Upgrade Error

[Kyle Fox]

John,

Can you replace lines 297 through 208 of db/MySQLDatabase.php with the
following similar code?

if(trim($query))
        {
            $StartTime = microtime(true);
            $result = mysql_query($query, $this->dbLink);
            $this->dbTime += (microtime(true) - $StartTime);
        }

        if(!$result && encoding_substr(trim($query), 0, 4) != "DROP")
        {
            echo(mysql_error());
            echo($query);
        }

and then respond with what errors you are receiving?

Thanks

On 8/30/07, prom at uiuc.edu <prom at uiuc.edu> wrote:
> John,
>
> We will look into this--if you have any ideas let us know.  Can you please provide your server specifications? We have not had any problems running either the install or upgrade on the servers we tested it on.
>
> Chris
>
> ---- Original message ----
> >Date: Wed, 29 Aug 2007 09:37:57 -0400
> >From: "Lyles, John" <jlyles at cvrls.net>
> >Subject: Re: [Archon-L] 2.0 Upgrade Error
> >To: "Don Thompson" <hdthomps at uwf.edu>, <archon at archon.org>
> >
> >Don,
> >Had a similar problem here with the upgrade although not the same error message. The system became non responsive after I made the backup. I tried it a couple of more times with the same result - non responsive....on my last attempt the installation process took although I did nothing different from before. Not sure what happened but a FYI for all.
> >
> >regards
> >John
> >
> >________________________________
> >
> >From: archon-bounces at archon.org on behalf of Don Thompson
> >Sent: Wed 8/29/2007 9:05 AM
> >To: archon at archon.org
> >Subject: [Archon-L] 2.0 Upgrade Error
> >
> >
> >
> >  We have successfully installed a non-upgrade version of archon 2 on our servers but when we attempt to do an upgrade of 1.11 below is the error we are receiving.
> >
> >
> >
> >PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\archon2\db\MySQLDatabase.php on line 245 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\archon2\db\MySQLDatabase.php on line 245 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\archon2\db\MySQLDatabase.php on line 245 PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\archon2\db\MySQLDatabase.php on line 245 PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\Inetpub\wwwroot\archon2\db\MySQLDatabase.php on line 244
> >
> >
> >
> >
> >
> >Any suggestions?
> >
> >
> >
> >This error is occurring on the first step of the upgrade when we attempt the backup database section.  Just to ensure it was not a permissions problem I set the archon db user to full permissions.
> >
> >
> >
> >Thanks
> >
> >Don Thompson
> >
> >University of West Florida
> >
> >
> >
> >
> >
> >
> >_______________________________________________
> >Archon mailing list
> >Archon at archon.org
> >http://archon.org/mailman/listinfo/archon_archon.org
>
> Christopher J. Prom
> Assistant University Archivist
> University of Illinois Archives
> Room 19 Library (MC-522)
> 1408 W. Gregory Drive
> Urbana, IL 61801
>
> web:    http://www.library.uiuc.edu/ahx/
> e-mail: prom at uiuc.edu
> phone:  217 333 0798
> fax:    217 333 2868
>
> _______________________________________________
> Archon mailing list
> Archon at archon.org
> http://archon.org/mailman/listinfo/archon_archon.org
>


-- 
Kyle Jordan Fox


Senior in Computer Science
Developer - Archon Simple Archival Information System
Tour Manager/Internet Officer - Varsity Men's Glee Club
-
University of Illinois at Urbana/Champaign

<kylefox2 at uiuc.edu>