gbook MySQL Query Error?

hai, ive had this guestbook for nearly 2 years now, & never had any problems with it, but since yesterday i get this error when im trying to access it:

i haven't changed a thing so i have no idea what happened..

anyway, i've made a backup of the SQL tables & i also tried installing the newest advanced guestbook version (in different tables & different folders, so not an upgrade) wich doesnt work either.. i run the install.php, it creates the tables successfully, but i cant login (for admin) nomatter what password i use (test 123 doesnt work)
posting as a guest is no problem, i just cant login
ive read some posts of people with the same problem, but none had a decent solution (reinstalling doesnt help, also the default username test & its encrypted password is correct in the database..)

so.. any ideas?

the börked guestbook can be found here: http://thewax.thepact.net/guestbook/

the new guestbook i tried to install can be found here: http://thewax.thepact.net/gbok/

thx in advance

Looks like your hosts have just updated to PHP 4.3.10 which has only just come out due to a major security risk. Hasn't affected mine though. Try redownloading the guestbook and reuploading the files. Failing that speak to your hosts as they must of done something. Be nice if it told you to which file it was refering when it says line 1. From your post I assume you are using 2.2?

btw glad to see you use Firefox.

yeah, seems the PHP is upgraded
its solved now.. kinda

i tried updating the script: overwriting everything i had (v 2.2) with the newest version except the config file, & then creating the new tables it needs with the install.php from your zip file that i found somewhere on this forum.. didnt work, said i already had a book_img table or something..
anyways, i just deleted the whole thing, installed from scratch & replaced the book_data with the one i had backupped
so now ive got a working guestbook, but i still cant login as admin.. i guess i can work arround this & adjust my settings in the book_config table, but still.. would be nice if it could be fixed

damn.. theres no edit button.. could someone with admin power delete that link to my guestbook??(first post) i fear spam..

There is no admin nor mods here. That is one reason carb is redoing the whole guestbook. The original creator does not seem to care about any of his scripts any longer.

Anonymous wrote:damn.. theres no edit button.. could someone with admin power delete that link to my guestbook??(first post) i fear spam..

A good reason why you should register... Registered users can edit their posts.

No need to fear spam. We have a nice image verification mod to deal with spammers

. Oh and since you have updated from 2.2 to 2.3.1 could yo uplease try www.carbonize.co.uk/install.php for me. It's an upgrade script I'm working on for updating from 2.2 to 2.3.1 and fixes the admin login loop problem.

cant be arsed to register on every forum

Carbonize wrote:No need to fear spam. We have a nice image verification mod to deal with spammers . Oh and since you have updated from 2.2 to 2.3.1 could yo uplease try www.carbonize.co.uk/install.php for me. It's an upgrade script I'm working on for updating from 2.2 to 2.3.1 and fixes the admin login loop problem.

umm, i already have 2.3.1, why would i upgrade

& i didnt really upgrade, just deleted the old one, installed the new one & overwrited the book_data table

& if you're referring to this: http://proxy2.de/forum/viewtopic.php?t=4010&highlight=update+guestbook
it didnt work for me when trying to upgrade from 2.2 to 2.3.1 (mysql errors)

also, this doesnt work (changing last_visit to type INT, its already type INT here):
http://proxy2.de/forum/viewtopic.php?p=11334&highlight=#11334

I've updated the update install script since it was last tested. I need it testing.

Do you know what file is causing the error?

so: i still have a working guestbook without admin login possibilities.. ideas?

no errors