Page 1 of 1
newbie needs help with old db
Posted: Mon Dec 28, 2009 12:39 am
by joejr
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
Posted: Mon Dec 28, 2009 5:13 am
by Henrie
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
Posted: Mon Dec 28, 2009 5:22 am
by joejr
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
Posted: Mon Dec 28, 2009 8:38 am
by Henrie
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
Posted: Mon Dec 28, 2009 8:54 am
by joejr
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
Posted: Mon Dec 28, 2009 9:18 am
by Henrie
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
Posted: Mon Dec 28, 2009 11:20 pm
by joejr
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
Posted: Mon Dec 28, 2009 11:43 pm
by Henrie
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?
Posted: Mon Dec 28, 2009 11:51 pm
by joejr
I am so sorry try that link again
Joe
Posted: Tue Dec 29, 2009 12:59 am
by Henrie
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
Posted: Tue Dec 29, 2009 6:52 pm
by Klemen
My opinion is that you have the database file from some other guestbook, not the GBook from phpjunkyard.com