1054 Unknown column 'thumbnail' in 'field list'

Hello. I recently upgraded my guestbook. When I try to change my general settings, I recieve this message:

MySQL Error : Query Error
Error Number: 1054 Unknown column 'thumbnail' in 'field list'
Date : Wed, September 15, 2004 08:50:28
IP : 63.150.xx.xxx
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Referer : http://www.xxxxxxxxxx.com/guestbook/admin.php?action=settings&panel=general&session=84ad1e94e7282da07e254ee2899b1177&uid=1
PHP Version : 4.3.8
OS : Linux
Server : Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.8 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.xxxxxxxxxx.com

Does anyone know of a solution to this problem? I am having problems with "international" spammers with broken english posting bogus messages. I need to block IP's and I can't without logging in and saving my general settings message.

Thank you. Thank you. Thank you.

The problem appears to be that you upgraded the files but didn't upgrade the SQL tables. If you do a search of this forum you will find more advice on this. Also banning IP's will not stop spammers. The best method is the image verification script which is available from www.carboniz.co.uk/verification.zip

I hope thats the right link anyway.

Carbonize, thank you for the quick reply. I also did a search here for "upgrade SQL tables" and upgrade + "SQL tables" (and even on google) and I could not find any information. Could you or anyone be so kind to point me in the right direction?

I did setup that image verification script, thank you for that. How ever my addentry.php page is a little screwed up (the name box is on the right side on the screen now). I went to the addentry.php page and tried to make additions, but it didn't work, so any ideas on how to fix that would be helpful as well.

Thanks!

I worte a script for upgrading from 2.2 to 2.3.1. If you do a search you will fin dit and other advice on the subject.

In this thread (8th post down), Jam'n has good instructions with pictures for upgrading the database tables from PhpMyAdmin: http://proxy2.de/forum/viewtopic.php?t=2595

When you get to the part that says:

Now select on the right window SQL and browse to the file with the upgrade or paste it into the window and press GO

This is the doc/db_update_v22-23.sql file

The 3rd post down in this thread you can find the link to Carbonize's upgrade file: http://proxy2.de/forum/viewtopic.php?t=3037&start=15

This post tells where the original upgrade sql file is found and the tables it does not fix: http://proxy2.de/forum/viewtopic.php?t=1981&start=17

If, after upgrading, you get the "admin Loop" taking you back to the login whenever you make a selection, this post offers some solutions: http://proxy2.de/forum/viewtopic.php?t=3462