I don't know about the first error, but it sounds like at least some of the queries were run succesfully as it's now erroring when you try to re-run the INSERT queries. Use the attached delete.txt (rename it to delete.sql before using phpmyadmin to run it) and this will remove all the phrases and settings that the install.sql inserted then you can try again from scratch.

Edit: Actually I've just had a thought, do you use a table prefix? Maybe the first error was table phrase didn't exist or something like that?

yes, here is the error I got when I deleted:

SQL-query:

DELETE FROM `phrase` WHERE varname = 'setting_allowguestbook_desc'

MySQL said: Documentation
#1146 - Table 'ostatesp_forum.phrase' doesn't exist
-----------------------

so, what should I do now? Thanks for the help Snow.

I'm no expert when it comes to MySQL, but I don't think that full stop should be there :speechless: I thought it's supposed to be tableprefix_table e.g. if your prefix is vb then it would be vb_phrase Maybe someone more experienced with MySQL can shed some light on the matter.

well, that's the first sql query I've done in my life, so I have absolutely no idea :). Thanks for the help. Hopefully someone else can pitch in and help.

You are probably using a table prefix. Edit the query sa follows:
[sql]DELETE FROM TABLE_PREFIXphrase WHERE varname = 'setting_allowguestbook_desc'[/sql]
replacing TABLE_PREFIX with your prefix.

I'm lost.

I don't see table_prefix anywhere in there...

in the delete file SNOW posted I there is, "delete from 'phrase' where VARNAME = yadda yadda yadda.

Sorry I don't understand, I'm just learning.

What is your table prefix?

Think this could possibly be a bit of a bug that i've found, not sure if anyone else is suffering it or it could be confirmed that i've either gone mad or it is actually happening.

Basically:

Write a message in a guestbook and confirm it, then basically refresh and it is duplicated, if a user refreshes over and over, the message can be duplicated sever times in quick succession, which also sends a pm every time too.

I can delete guestbook messages no problem, but i;ve had to disable the guestbook featur for the moment, until I can either get a fix for this or until I am told I have gone mad.

Besides that, super hack. :)

the prefix is ostatesp_forum

You're lucky, you can deleteguestbook entries. I guess since the 'post guestbook entry' partis a form it would make sense that refreshing the page would repost theentry.... I suppose. The other day, some of my users told me theywere getting duplicate entries in the guestbooks and they swore theyweren't clicking the submit button twice (I assumed they were not alsorefreshing the page). I don't know, maybe this is a bug. :ermm: