I tried that (this method worked for the Webpage / Guestbook hack), but I'm getting mysql errors
Did you do something with the "table prefix" comment? Take it out? (I don't have prefixes in my database, as I was an upgrade from vb 2.xx)

OK, maybe someone can figure this out.

My phrases and templates are all in there. However, when I add a quote directly to the quotes.php page, I get this response:
It's trying to call to $vboptions[moderatequotes], which is in quotes.php.

The quotes are all still in the database; the upgrade did not affect them.



Should we reinsert the sql queries like this:
instead of what's called for in the instructions:
Anyone have any idea?

well ok, I tried this once on a new install of 3.0.5 and it didn't work so I tried running the sql queries again. didn't change anything

so I completely removed my test forum and database

new install and fresh database.

same thing. any ideas? I"d really like this on my site.

has everyone given up on this?

you mean this mod dosn't work on 3.0.6 ? :(

It stopped working on 3.05, and we can't figure out how to get it to function. It's a shame, because it was one of the more popular hacks that I have on my site. I really wish someone would figure this out.

same here, i had it on my old site, upgraded to 3.0.5 after server failure,

i wish it was compatable :(

I tried it on a fresh install of 3.0.5 twice with no luck.

I figured it out.

For some reason the VB 3.0.5/6 upgrade somewhere along the line kills the 'Forum Home Page Settings' database table...or at least nukes the entry needed for the quotes thing. So basically, nothing is broken, but its just like you check the 'off' button for the quotes.

You need to rerun this query.
and this one

If your table has a prefix, put that on there.

Then go into your home page options and re-enable the settings.

Everything should be back to normal now.

YOU ARE THE MAN!

Impressive...

(but the "add to quotes" funcition, in each postbit, draws a white page of death).

OOPS. Forgot this:
https://vborg.vbsupport.ru/showpost....&postcount=212

Now it works.

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry 'showquote' for key 1

SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1

mysql error: Table 'dvdb.quotes' doesn't exist

I removed 'showquote' from vb3_setting ..
now it says this

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'dvdb.setting' doesn't exist

but it's still there... vb3_setting I mean .. lol
cause the forums n everything is working fine..

1. edit button is your friend
2. mysql error: Table 'dvdb.quotes' doesn't exist, would tend make me believe there is an issue with your quotes table.

My bad guys, you need to rerun both queries, one for displaying and one for entering.
You will then need to go to your admincp, and resave the settings even though they may appear set already.

https://vborg.vbsupport.ru/showpost....&postcount=249

Whats the command to deinstall this from the database so I can reinstall it.

open the install_quoteit.php in a text editor
scroll down to the bottom where all the INSERT statements are, change them to correct delete statements, or manually go through the database and find those with phpmyadmin.

need more help, let me know.

Lost already M8, dont know bugger all about DB's.

Follow instructions man thats me.

Do you have a command I can run?

Thanks, manually removed and re-run install file.

Still not working in version 3.0.5

Ran this but it says duplicate entries.

go into you admincp and make sure you check the two settings for the quotes, save them, and then check.

and what part exactly isnt working?

I have checked the boxes in options. The quotebox is showing on the homepage but its not looking correct.

See picture attached.

Laters

approve your quotes
edit a phrase and save, so the phrases work

Thanks.

Edited a phase and saved it and now its working, strange?

Also have you any ideas how I can get thetop right tab to blend into my template (see pic)

Thanks.

So much for progress. When adding a quote, I get this error:
Otherwise, it all seems to work. Any ideas?

rich
http://x.russbo.com/vb/index.php

reread my fix, and run the second query
then updated your admin settings and you will be fine

as for The Realist's problems...thats your template just acting odd, just change the template to look like you other boxes and you will be good to go.

Thanks. Think that did it. Impressive how you took command of this hack, you should really think about improving it, since you seem to be the only one that understands it.

Great feature, my members love it. Thanks for helping me get it back online.
rich

maybe I"m lost mine looks like realist's does with the marks but empty (image attached a page or two back)

the boxes are checked I"ve tried running the queries again with no luck, it just says they already exsist.

Also I noticed I don't have a line in the moderate box in admincp to approve quotes like is shown on the initial post.
maybe that's the problem with mine?

you need to edit a phrase and save, to update the phrases database

how do I do that if I can't click on anything? sorry if I'm slow on this. my box is just the lines w/o any kind of clickable linkes or moderation abilities.

https://vborg.vbsupport.ru/attachmen...chmentid=23103

I'm running 3.0.5 with the patch. I tried running the two queries that do the fix but I get duplicate errors. I have the moderate quotes coming up on admincp but nothing shows up on forumhome.

have you checked the boxes in forum home settings in your admincp?

Yes. Quotes is on and moderation is enabled.

did you go into the moderation and try to do anything? like save a quote? I think that's what he was saying to do on page 18 of this thing.

Looks like you need to go into your admincp, select phrases, click on edit (anyone) and then save.

I have no options under Moderate Quotes as it only says no quotes to moderate.

what did you mean by anyone?

the first phrase you see (doesn't matter what it is), just click edit and then saved.

P.S. got mine working. My fault

sweet it works, but how do I get the moderate quotes stuff into my admincp?