vb.org Archive - QuoteIt! Quote Management System v1.2

Page 27 of 38

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - QuoteIt! Quote Management System v1.2 (https://vborg.vbsupport.ru/showthread.php?t=62470)

The Realist

01-23-2005 05:13 PM

Ran this but it says duplicate entries.

Quote:

Originally Posted by CtrlAltDel

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.

Code:

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1);

and this one

Code:

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)

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.

CtrlAltDel

01-23-2005 05:37 PM

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?

The Realist

01-23-2005 06:11 PM

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

See picture attached.

Laters

CtrlAltDel

01-24-2005 02:23 AM

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

The Realist

01-24-2005 08:38 AM

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.

Quote:

Originally Posted by CtrlAltDel

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

docvader

01-24-2005 05:29 PM

So much for progress. When adding a quote, I get this error:

Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('When losing a battle, whether it be of the body, the mind or the heart, it is only a set up to win the next battle in which the reward is much greater.', 'Tsu Chin', 1, )

mysql error: You have an error in your SQL syntax near ')
' at line 2

mysql error number: 1064

Date: Monday 24th of January 2005 11:31:37 AM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxx
IP Address: xxxxx

Otherwise, it all seems to work. Any ideas?

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

CtrlAltDel

01-24-2005 08:23 PM

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.

docvader

01-24-2005 08:41 PM

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

LKJR	01-26-2005 05:42 PM

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?

CtrlAltDel

01-27-2005 04:17 AM

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

All times are GMT. The time now is 01:51 PM.

Page 27 of 38

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03548 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: