newbie needs help with old db

joejr · Post by **joejr** » Mon Dec 28, 2009 12:39 am

What version of guestbook went from using entries.db to enteries.txt?
Is there an easy way of converting the file?

Assistance in this matter would be greatly appreciated,

Joe

Henrie · Post by **Henrie** » Mon Dec 28, 2009 5:13 am

Are you sure you were using the phpjunkyard GBook?
I have been using it since version 1.33 (july 2005) and there it was already called entries.txt

Greetings,
Henrie

joejr · Post by **joejr** » Mon Dec 28, 2009 5:22 am

Henrie wrote:Are you sure you were using the phpjunkyard GBook?
I have been using it since version 1.33 (july 2005) and there it was already called entries.txt

Greetings,
Henrie

It had the phpjunkyard branding on the bottom of the page. I think it might be a custom job.
all well.
Joe

Henrie · Post by **Henrie** » Mon Dec 28, 2009 8:38 am

That is possible. But it could also be the normal guestbook. You could make the filename anything you want. The name of the plain text database is set/stored in the file settings.php in your GBook folder.
In the settings.php file you can also see which version it is.

The newer version of GBook's plain text file datatabase is compatible with the older versions (except when it has indeed been modified to store extra fields as some of the older XHTML-mods/HL-mods made by me had).
Just make sure the setting $settings['logfile']='entries.txt'; is pointing to the right file, in your case $settings['logfile']='entries.db';

Greetings,
Henrie

joejr · Post by **joejr** » Mon Dec 28, 2009 8:54 am

Henrie wrote:That is possible. But it could also be the normal guestbook. You could make the filename anything you want. The name of the plain text database is set/stored in the file settings.php in your GBook folder.
In the settings.php file you can also see which version it is.

The newer version of GBook's plain text file datatabase is compatible with the older versions (except when it has indeed been modified to store extra fields as some of the older XHTML-mods/HL-mods made by me had).
Just make sure the setting $settings['logfile']='entries.txt'; is pointing to the right file, in your case $settings['logfile']='entries.db';

Greetings,
Henrie

I must have a custom database because i set $settings['logfile']='entries.db' and I got partial good info and some upper ansi characters.
I used notepad++ to view entries.db and it is not just plain text.

Joe

Henrie · Post by **Henrie** » Mon Dec 28, 2009 9:18 am

I don't know if your guestbook is available on the internet. If it is, and you post a link here, i can take a look. Maybe it is just a changed charachter set of the guestbook (for example 'utf-8' instead of 'windows-1250').

Greetings,
Henrie

joejr · Post by **joejr** » Mon Dec 28, 2009 11:20 pm

I suppose I should give you the whole story. I was hired to recreate a website which had the PHP Junkyard guestbook on it. Thanks to your previous post, I learned that this guestbook was version 1.2.

Now, at the time I started this project, version 1.7 hadn't been released so I installed 1.6. I then replaced the 1.6 database with the 1.2 database knowing that the databases are backwards compatible. Since this is a live site and I saw it wasn't working I restored the 1.6 database. So what I have done is setup a temp guestbook so that you could see if it is something to do with the character set.

This brings us current. The url to the temp guestbook is http://www.menofassurance.com/gb/gbook.php
the good stuff doesn't start until page 8

Any help in this matter would be greatly appreciated,:D
Joe

Henrie · Post by **Henrie** » Mon Dec 28, 2009 11:43 pm

the link points to a guestbook (version 1.6) with only one entry. Could you place a link where i can find the entries.db file that is giving you the errors?

joejr · Post by **joejr** » Mon Dec 28, 2009 11:51 pm

I am so sorry try that link again

Joe

Henrie · Post by **Henrie** » Tue Dec 29, 2009 12:59 am

Hello Joe,

From what i read, i can say it is an SQlite database file so it must have been a heavily modified GBook.

I have no experience with databases in any way, so i can not help you on how to convert it to a plain text database that can be used with GBook 1.6 or 1.7

Greetings,
Henrie

Post by **Klemen** » Tue Dec 29, 2009 6:52 pm

My opinion is that you have the database file from some other guestbook, not the GBook from phpjunkyard.com