Advanced Guestbook problem with geocites

When trying to submit a post, the following error is displayed:
MySQL Error : Query Error
Error Number: 1 Can't create/write to file '/var/tmp/#sql17d10_13_0.MYI' (Errcode: 2)

I am guessing this is because I can't changer permissions to the var directories on a geocities server. I was wondering if anyone knows where I would look in the code to have it post in a different directory? Thanks

Geocities ?
Do they support MySQL

Yes.....just recently.

You can't change the location of the tables where MySQL stores the files with PHP. I'm sure you will find more help on their board.