The secure CMS.

Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 02:41 am EST

Geeklog Forums

Can't restore Dbase for upgrade

 New Topic  Post Reply
 05/19/08 03:01pm (Read 3,813 times)  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
blank
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
 Quote
 05/19/08 03:09pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
mysqldump is for creating database backups. But you said you wanted to restore one ...

:rtfm: Restoring a database backup

bye, Dirk
 Quote
 05/19/08 03:28pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
Dirk.

That was a very fast response. Thanks man. :banana:
 Quote
 05/19/08 03:33pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
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?
 Quote
 05/19/08 03:37pm  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
:rtfm: Unfortunately, an error has occurred rendering this page. Please try again
 Quote
 05/19/08 03:42pm  
Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Please check out the FAQ:
http://www.geeklog.net/faqman/index.php?op=view&amp;t=65
 Quote
 05/19/08 03:43pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
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. :-)
 Quote
 05/19/08 03:56pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
thanks 1000ideen. :-)
 Quote
 05/19/08 05:43pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
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.

 Quote
 05/19/08 06:14pm  
Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
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
 Quote
 05/19/08 06:18pm  
Status: offline

thedude

Forum User
Regular Poster
Registered: 12/28/02
Posts: 90
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:
 Quote
 05/20/08 01:52am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote
 New Topic  Post Reply
All times are EST. The time is now 02:41 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content