Subject: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:01pm
By: thedude

Hi gang.

I'm having difficulty trying to upgrade my geeklog. I have version 1.3.9 and somehow when I ran the installation upgrade, it gave me an error and I couldn't run the upgrade again after that. So what I need to do is restore the old backup dbase and try to upgrade it again. The problem is it's not letting me restore the dbase.

Here is the command I executed:

mysqldump --user=username --password=password --host=hostname databasename < backup.sql


and it kept giving me this message and never completed the restore.


-- MySQL dump 10.11
--
-- Host: hostname Database: database name
-- ------------------------------------------------------
-- Server version 4.0.27-standard-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-05-19 18:54:43


Of course I replace the hostname and database name to hide the identity but I still couldn't figure out what's wrong with it. Please help. I'm desperatedly need help as the website I managed has been down for couple of days and this is not good. Thanks everyone..

The Dude

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:09pm
By: Dirk

mysqldump is for creating database backups. But you said you wanted to restore one ...

:rtfm: Restoring a database backup

bye, Dirk

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:28pm
By: thedude

Dirk.

That was a very fast response. Thanks man. :banana:

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:33pm
By: thedude

ok. restrore succesful but upgrade failed with this error.

Unfortunately, an error has occurred rendering this page. Please try again later.


got to be something simple that i missed but not sure what. any other thought?

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:37pm
By: Dirk

:rtfm: Unfortunately, an error has occurred rendering this page. Please try again

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:42pm
By: 1000ideen

Please check out the FAQ:
http://www.geeklog.net/faqman/index.php?op=view&amp;t=65

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:43pm
By: thedude

ok I deserved that.

Having a Doohhh moment. Oops! Haven't been administering geeklog for quite a while and coming back to it prove to be too many doohh moment. Thanks again Dirk. :-)

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 03:56pm
By: thedude

thanks 1000ideen. :-)

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 05:43pm
By: thedude

ok. I guess I'm really getting rusty at this whole upgrade things. Now I have this new problem on top of other problem that i have slowly resolved it. This one, I'm scratching my head. Any thought?

Fatal error: Call to undefined function: display_calendar() in /geeklogdir/system/lib-custom.php on line 542


and this is line 542

$retval = display_calendar();



This is the calendar that comes with the gl 1.4.1 and I really haven't changed anything on it but I can't figure out where to look for the function to try to debug it. :-( Please help? Thanks everyone.


Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 06:14pm
By: 1000ideen

Are you sure you updated all the files? I think the position of the calendar changed within the last versions. Might indicate that you have something mixed up. Idea

Re: Can't restore Dbase for upgrade

Posted on: 19/05/08 06:18pm
By: thedude

yeah I think so. I didn't touch anything from the tar ball other than the one suggested from installation/upgrade manual such as the config.php and lib-custom.php.

I installed all the new version of the plugins because earlier during upgrade, it kept on erroring on me telling me that it can find functions.inc. So after couple of minor hacks, it actually completed the upgrade and show me the login page. Of course as soon as I click login, the calendar problem started to show up. :banghead:

Re: Can't restore Dbase for upgrade

Posted on: 20/05/08 01:52am
By: Dirk

Quote by: thedude

Fatal error: Call to undefined function: display_calendar() in /geeklogdir/system/lib-custom.php on line 542


So you have some custom code in your lib-custom.php that calls up this function. Comment it out then.

bye, Dirk

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=82735