Error 1064

Hi there,

I've just upgraded our guestbook to the 2.4 version and everything went fine wit the exception that when I try to sign the guestbook I get the following error:

Query Error
--------------------------------------------------------------------------------

MySQL Error : Query Error
Error Number: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET session_id='f99cdb290e754aef62f1af7445ea6a17', validate_key
Date : Mon, March 13, 2006 08:28:23
IP : 82.154.142.147
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Referer : http://escorpioes.com/gb/index.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a
Server Name : www.escorpioes.com

Can anyone tell me what I did wrong and what I have to do now to correct this?

Thanks in advance for your help.

Best regards,
almarofe

I had the same problem as you...

You need to copy paste the db info of old admin/config.inc.php to the new one !! then ftp it over to your server...

After that launch (via your browser) http://www.yourdomain.com/guestbook/misc/update_db.php

It worked with me !

Hi there tasari,

Thanks for your reply but, since I'm totally a beginner in this things, could you just confirm if I just have to copy the file admin/config.inc.php to the new guestbook?

Thanks again for your help

Best regards,
Álvaro

tasari wrote:I had the same problem as you...

You need to copy paste the db info of old admin/config.inc.php to the new one !! then ftp it over to your server...

After that launch (via your browser) http://www.yourdomain.com/guestbook/misc/update_db.php

It worked with me !

No you don't copy the file ! You have to use the config.inc.php of the new version and copy/paste the DB INFO in it !

Little bit different !

Hi again,

I think I got it now

I did what you told and the guestbook is now working.

Thanks a lot.

Regards,
Álvaro

Do you get the image ? Is it shown ? I still don't have the image...
I did all the update AND have GD and Freetype installed (even reinstalled completely)..

Just my 2 cents...

PHP has to be installed with GD + FreeType Support

gd

GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
T1Lib Support enabled
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled

This is what I get in the admin of Advanced Guestbook :

GD Support enabled
GD Version bundled (2.0.28 compatible)
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled

I also looked in my vps...
gd + gd-devl + gd-progs is installed
freetype + freetype-devel + freetype-utils is installed

I even re-installed gd and freetype...

I was updating from Advanced Guestbook 2.3.1 to immediately 2.4, maybe there was a problem in it... I think I will try to install from scratch