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:

Where are the experts when you need them? :rolleyes:

I'm not sure, but could your table prefix actually be ostatespnotostatesp_forum (it just seems like a rather odd prefix to me, butI'm no expert). If you go into your phpMyadmin, and look at the list oftables on the left, you'll see the name of the table you need to use inthequeries. For example, my test forum has the table prefix tvb3. So myphrase table is actually tvb3_phrase. Therefore, in the queries itwould look like:

Am I making sense? Sobasically, in phpmyadmin, look for the phrase table, make a note ofwhat it's called and do a search replace on the insert.sql filereplacing phrase with yourprefix_phrase, (do the same for thesettingtable and the settinggroup table) save and re-run. (sorry I'mterrible at explaining things)

ostatesp_forum is the name of my database.

tables in that database are user_guestbook and user_webpage

all the other ones are vb_

that's all I know. I know nothing :disappointed:

help!

i am upgrading from 3.0.6 to 3.0.7 and when i try to run upgrade.sql i get the following error:

everything worked fine in 306. any reason i am getting this error?

thanks

do i have to re-install (run insert.sql) this and if so, will the previous data(webapges and guestbooks) remain?

I just upgraded to 3.0.7 and after the upgrade I just run the following queries and saved any guestbook phrases and now it is working again.

Working with 3.0.7

If you didn't delete all guesbook and webpages data from your database then you dont have to re run the install.sql. Just make all the file edits and then run the queries I paste the previous post save any guestbook phrase , check your usergroup permissions and save them. After that you shall have the mod working again.

cool, thanks! up and running again in 3.0.7 :)

any know when comes new version with installer?

Is there anyway that I could make the webpage show up standalone? Such as the profile having a link to their webpage, then webpage.php?memberid=x would display their webpage and guestbook? That would make it much cleaner on their profile, then members could use the webpage as their "homepage" on the web :) If it hasn't been done yet, I'm sure I could do it. It would just take me a while, no its not that I'm lazy its just that I'm checking to see if its been done yet. ;)

That is something I am looking for if you will code it I may want to make some of the tests ;)

Okay........then your table prefix is vb. It looks like the first part of theinstall.sql worked fine (create table user_guestbook and user_webpage)as they are present, so now you just need to insert the phrases andsettings. Try running the following query:

If it works without giving you anerror run the rest of the remaining queries (which I've attached tothis post).

You ROCK Snow

I've got it pretty much the way I like it, haven't found any problems yet.

I've attached it with instructions to this post :)

You are so quick :)

Let me know if you have any problems, or ideas for it.

Glad I could help :smoke:

I've made an additional file edit, so that the new webpages.php shows up on the Who's Online section of the forums :) Its been added to the zip and updated in my previous post.

MAN, I STILL can't get this to work. I followed the directions after finally getting the sql command done, but it doesn't show up anywhere.

In the options section, I didn't find any "update" button or whatever, but I clicked "edit" and saved.

There is no webpage/guestbook permissions section in the user permissions thing...

I have NO IDEA what I've done wrong. I've gone all the way to step one several times and worked through it, but I can't seem to figure it out...

No there isn't any "update"button, I think Swedie meant, click on edit and save to update. You have to do this with most hacks/mods for them to work.

I've attached a screenshot of where the webpage/guestbookpermissions shouldbe. So basically, this is the page Usergroups > Usergroupsmanager > Edit usergroup [group you wish to edit e.g.administrators]. Scroll down a bit till you find GeneralPermissions. If you see some blank rows, you haven't "updated"the phrases (!!IMPORTANT PART!! #1 from the installationinstructions). If there are no blank rows and nowebpage/guestbook permissions there at all, then go back and check thatyou edited the admincp/usergroup.php correctly. If you editedusergroup.php you should at least be getting the blank rows.

I'll give it a try within the end of the week. I am right now having a problem with my hosting company and before the edit I must find a good dedicated machine.

I checked that file and reuploaded it, and still it doens't show up.

I'm thinking, "MAN, it can't be THAT freaking hard" but I STILL can't get this.

I HATE SUCKING AT THIS!

Sorry to hear that, good luck!

If you've followed all the stepscorrectly it should be working. I've installed this hacksuccesfully on version 3.0.3, 3.0.5 and 3.0.6 (what version are youusing btw?). I'm running out of ideas as to what might have gone wrong.:( I don't know if anyone else can help.

I'm just curious have all the bugs been worked out now?
I know somebody brought up that the admins can't edit guestbook or the webpages? Has this been fixed?

I really want to install this (and my members do too) but I want to make sure all the bugs have been worked out.

Thanks

Nice idea, but the coding must be optimized -

Nice idea, but actually too many non-working threads ..

Whats the status, will be there an update etc. ?

If you follow the instrucions it is pretty easy to get this mod working.

nope. some people say this isnt a bug. TRUST me its there...
if that is a issue dont install.

Can I BEG you to have access so the admin can edit users pages.
and that fix for the undeleteable guestbook? I BEG OF YOU.
has something to do with secondary usergroups and or reputations.... new users I can delte... older no go.

Heh, I don't know about that, but I wouldn't mind giving it a shot ;)