If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Transferring entries from older version (2.3.1) to NEW one?  XML
Forum Index » Advanced Guestbook Forum
Author Message
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

Hi everyone,

I lost the ability to log into the old version of AG 2.3.1 and so it's useless.

What can I do to transfer all the old entries from a previous installation (which is still there in a different folder) to a new installation of the most recent version?

Thanks,
Erik
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Just update it keeping the same database information.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

That's the obvious answer, of course. But the new installation didn't recognize that an older one was there. And I can't install in the old folder. I could select the old database during the installation process (of the new one), but it didn't USE the old database. It ignored it.

The root path to the old database is different than the root path to all the templates, etc. of the new guestbook. If I change the path in the config.inc.php file (from the admin folder) toward the old database...the old messages show up in the new book, but then the feature that allows people to enter a code (such as "f2pgh" or something like that) to post new entries doesn't show up. I also get header alerts at the top of the control panel in the administration area.
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

If you copy the database information from the old config.inc.php file to the new one then the entries will be there.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

How, specifically? I want to know if how I've tried doing that is the right way or the wrong way.

Erik
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

copy database information from old config.inc.php to the 2.4.1 config.inc.php file. Upload the entrie 2.4.1 folder. Visit misc/update_db.php in your web browser.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

Okay... let's see. The 2.3.1 version doesn't have a misc folder. So when I installed the NEW version, I tried running the update script... "no update necessary"

So then I copy the Misc folder to the old version installation...and tried running the script. NOthing happened.

Line by line, what info should I be copying from the old config.inc.php to the new version config file? Obviously I'm not copying the right lines, or it should work as you say...
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

No you copy the database information from the 2.3.1 config file to the 2.4.1 config file then upload the 2.4.1 folder to replace everything in the old one or to a new folder THEN run the 2.4.1 file called update_db.php found in the 2.4.1 misc folder.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

Here's the database info from the old file:


/* database settings */



$GB_DB["dbName"] = "name_agbook1";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "name_agbook1";
$GB_DB["pass"] = "EDITED";


/* tables */



$GB_TBL["data"] = "book_data";

$GB_TBL["auth"] = "book_auth";

$GB_TBL["cfg"] = "book_config";

$GB_TBL["com"] = "book_com";

$GB_TBL["ip"] = "book_ip";

$GB_TBL["words"] = "book_words";

$GB_TBL["ban"] = "book_ban";

$GB_TBL["priv"] = "book_private";

$GB_TBL["smile"] = "book_smilies";

$GB_TBL["pics"] = "book_pics";



And here's the database info from the new file (unaltered yet)


/* database settings */



$GB_DB["dbName"] = "name_agbook1";

$GB_DB["host"] = "localhost";

$GB_DB["user"] = "name_agbook10";

$GB_DB["pass"] = "EDITED";



/* tables */



$GB_TBL["data"] = "gb_book_data";

$GB_TBL["auth"] = "gb_book_auth";

$GB_TBL["cfg"] = "gb_book_config";

$GB_TBL["com"] = "gb_book_com";

$GB_TBL["ip"] = "gb_book_ip";

$GB_TBL["words"] = "gb_book_words";

$GB_TBL["ban"] = "gb_book_ban";

$GB_TBL["priv"] = "gb_book_private";

$GB_TBL["smile"] = "gb_book_smilies";

$GB_TBL["pics"] = "gb_book_pics";

$GB_TBL["cap"] = "gb_book_captcha";



What needs to change in the new file? The database name is the same...

thanks for your patience, btw...
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

nothing else needs changing. Save the 2.4.1 file in the 2.4.1 admin folder. Upload the whole 2.4.1 folder then run the update_db.php file.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
AutismMedia
Beginner

Joined: 28/09/2006 14:16:05
Messages: 10
Location: http://www.autismmedia.org/
Offline

I disagree.

It wouldn't read the datafiles for the guestbook or the private messages in the OLD database until I removed the prefix "gb" from "book_data" and "book_private" from the new config file.

That works now...but I'm getting weird header alert messages appearing above the top of my administration area control panel... Nothing's perfect, I guess.

Erik
[WWW]
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Hmm wonder when he changed the table prexfix. What error messages you getting?

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum