vb.org Archive
Page 4 of 19 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=135297)

zetetic 01-13-2007 12:45 PM
Quote:
Originally Posted by Cap'n Steve
zetetic - Yes, I figured there were enough options to give it its own section.
That makes sense. I just think the option to turn the hack on/off should be at the top to be consistent with vBulletin. Anyway it's a minor point. Thanks for all your work on this great add-on!

Mum 01-13-2007 08:23 PM
Don't have permissionsl, followed the instructions 'NOTE: If you get errors stating that you don't have permission to view the page on either the "Moderate Quotes" page or the main quotes page, you should rebuild the bitfields by going to www.yourdomain.com/admincp/index.php?do=buildbitfields' but didn't change anything, still can't moderate comments. Have uninstalled. Running 3.6.4

BaconDelight 01-13-2007 09:07 PM
Quote:
Originally Posted by Cap'n Steve (Post 1157570)
BaconDelight - If it helps, clientscript/vbulletin_css/quoteit_main.css is used by all browsers, quoteit_ie_all.css is used by all versions of Internet Explorer, and quoteit_ie_lt_7.css is used by Internet Explorer 6 and below.
Yeah, I've got it very nearly presentable. Good enough that I've gone live.

Another little issue - if you put in a search term that it can't find, the redirect is wrong. Instead of pointing to http://www.[domain].com/[forum]/quotes.php, it redirects to http://www.[domain].com/quotes.php

zetetic 01-14-2007 12:05 AM
I discovered that today too, BaconDelight. I spent an hour or two trying to track down the root of that problem with no success - even changing every

$vbulletin->url = 'quotes.php?'

to

$vbulletin->url = $vbulletin->options['bburl'] . '/quotes.php?'

in both the quotes.php and functions_quoteit.php files. That didn't break anything (that I noticed), but it didn't fix the problem either.

Cap'n Steve 01-14-2007 01:23 AM
Hmm. It used to be like that, until I discovered it was redirecting to domain.com/domain.com/forums/quotes.php. Maybe they changed something again, I'll take a look.

yonglvnv 01-14-2007 01:49 AM
Quote:
Originally Posted by Cap'n Steve (Post 1157828)
yonglvnv - For some reason, all the external files aren't getting included. Does $headinclude show up in your adv_portal template? Anyway, this should work for a temporary fix; in adv_portal find this:
HTML Code:
</head>
Above that, add:
HTML Code:
        <if condition="$quoteitoptions['ratings'] OR $quoteitpermissions['canmoderatequotes'] OR $quoteitoptions['enablecategories'] OR $quoteitpermissions['canreportquotes']">
                <script type="text/javascript" src="clientscript/quoteit_common.js"></script>
        </if>
        <if condition="$quoteitoptions['ratings'] AND $quoteitpermissions['canratequotes']">
                <script type="text/javascript" src="clientscript/quoteit_voting.js"></script>
        </if>
        <if condition="$quoteitpermissions['canmoderatequotes']">
                <script type="text/javascript" src="clientscript/quoteit_moderation.js"></script>
        </if>

        <!--[if lt IE 7]>
                <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/quoteit_ie_lt7.css" />
                <style type="text/css">
                .openquote {
                        filter: progid:DXImageTransform.Microsoft.AlphaImageLoader (src="{$stylevar['imgdir_misc']}/quotation-open.png", sizingMethod="image");
                }

                .closequote {
                        filter: progid:DXImageTransform.Microsoft.AlphaImageLoader (src="{$stylevar['imgdir_misc']}/quotation-close.png", sizingMethod="image");
                }
                </style>
        <![endif]-->
        <!--[if IE]>
                <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/quoteit_ie_all.css" />
        <![endif]-->
Thanks Cap'n Steve, above code addition made it a look lot better. I did need to put the full url path to java scripts to make it work, but collapse and close quote graphics are still way off. See attachment. When this is corrected, $showrandomquote will work perfectly in vba block. Also, I checked and $headinclude was in the vba_portal template. Thanks again!

jluerken 01-14-2007 10:04 AM
Hi,

I wanted to upgrade from 3.0 to 3.07 and I am getting this error message:

Database error in vBulletin 3.6.4:
Quote:
Invalid SQL:

ALTER TABLE vb3_quotes
MODIFY COLUMN date INT (10) UNSIGNED NOT NULL DEFAULT;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Error Number : 1064

zetetic 01-14-2007 06:59 PM
The 'delete' function seems to behave strangely. When I click delete on a quote an empty confirmation box pops up, and when I click "ok" the quote disappears, but the quote-box header remains. I have to refresh to get a new random quote.

zetetic 01-14-2007 09:54 PM
Sorry to keep piling them on, but I found another one Cap'n.

While I was working on the templates instead of disabling the hack I just made it non-viewable to the registered users usergroup, and that worked fine. However, when I went to make it non-viewable to unregistered/not logged in usergroup, I got this error upon saving the settings:

Code:
Invalid SQL:
        INSERT INTO cron
(weekday, day, hour, minute, filename, loglevel, title) VALUES
(-1, -1, -1, "a:1:{i:0;i:0;}", "./includes/cron/guestquotes.php", 1, "QuoteIt! Guest Voting Cleanup");

MySQL Error  : Unknown column 'title' in 'field list'
I went back in and selected 'no' for all the other options and it saved fine.

dcsbclan 01-14-2007 11:53 PM
Quote:
Originally Posted by Mum (Post 1158340)
Don't have permissionsl, followed the instructions 'NOTE: If you get errors stating that you don't have permission to view the page on either the "Moderate Quotes" page or the main quotes page, you should rebuild the bitfields by going to www.yourdomain.com/admincp/index.php?do=buildbitfields' but didn't change anything, still can't moderate comments. Have uninstalled. Running 3.6.4
Getting this same problem. =\

Alien 01-15-2007 02:04 AM
Hey!

It's awesome to see this updated, and so much hard work going into answering all these questions..

I have a small one of my own. I'm running 2.1 of this on 2 different sites (and it's working on vBulletin 3.6.4).. Do I have to upgrade to the vB 3.50/QuoteIt 3.05 version BEFORE upgrading to this QuoteIt 3.07+ version? I attempted to upgrade directly from QuoteIt 2.1 to THIS LATEST version and I get this error message:

Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

ALTER TABLE quotes
MODIFY COLUMN quoteid INT (10) UNSIGNED NOT NULL AUTO_INCREMENT;

MySQL Error : Duplicate column name 'quoteid'

Cap'n Steve 01-15-2007 02:11 AM
I finally gave in and renewed my license because my test server wasn't cutting it, but then my host chose that moment to go down. Never buy hosting from fuitadnet.com

yonglvnv - Don't worry, I haven't forgotten about vBadvanced, I'm still trying to sort out that weirdness.

jluerken - That'll be fixed in a little while.

zetetic - The database error should be fixed in the latest version. Make sure you upload all the 3.07 files. The delete problem means that the phrase must not be getting passed to the Javascript. Got a link?

everyone with no permission errors - If you're getting errors approving quotes, make sure you gave yourself permission in the usergroup manager. If you're getting errors viewing quotes, let me know what the QuoteIt! Permissions are for your usergroup. A link might help, too.

Cap'n Steve 01-15-2007 02:14 AM
Alien - Could you find out what version of mySQL you have? That's kind of a strange error, I don't see how modifying a column creates a duplicate.

Alien 01-15-2007 02:17 AM
Here you go: 4.1.21

yonglvnv 01-15-2007 06:03 AM
Thanks, this mod is worth the wait.

Cap'n Steve 01-15-2007 07:45 AM
I've uploaded 3.08, which should fix the database errors during installation.

Alien - Wonderful, the exact same version I have. I haven't found a workaround, but I've hidden the installer errors, so you should hopefully be able to install without a problem. Let me know if there are any further errors.

jluerken 01-15-2007 01:02 PM
Cap'n Steve,

v 3.08 still contains the language Chooser bug.
Enabling the random quote options now does not make wrong entries in the language chooser, it simply turns it off :(

Editing a language makes the language chooser visible again but turns off the random quote option. This can be reproduced at any time :D

Can you please take a look at this again?

Alien 01-15-2007 01:27 PM
Hay Cap'n!

v3.08 allowed the upgrade to go through without error.

Right after install I edited the QuoteIt options but left things as they were.

Then, I clicked on "Moderate Quotes" to take a look (I know we were up to date and there were no quotes to moderate), and I get this error:
Quote:
Invalid SQL:

SELECT quotes.*, user.username, categories.title AS category FROM quotes AS quotes
LEFT JOIN user AS user ON user.userid = quotes.userid
LEFT JOIN quotecategories AS categories ON quotes.categoryid = categories.categoryid
WHERE quotes.approved = 0 LIMIT 5;

MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054
I also clicked on "Manage Categories" (i know we haven't made any categories yet, as 2.1 didn't have this correct?" and I get this error:
Quote:
Invalid SQL:

SELECT category.*, COUNT(quotes.quoteid) AS count FROM quotecategories AS category
LEFT JOIN quotes AS quotes ON quotes.categoryid = category.categoryid
GROUP BY category.categoryid ORDER BY category.displayorder ASC;

MySQL Error : Unknown column 'quotes.categoryid' in 'on clause'
Error Number : 1054
Help! :)

soulface 01-15-2007 06:19 PM
Quote:
Originally Posted by jluerken (Post 1159759)
Cap'n Steve,

v 3.08 still contains the language Chooser bug.
Enabling the random quote options now does not make wrong entries in the language chooser, it simply turns it off :(

Editing a language makes the language chooser visible again but turns off the random quote option. This can be reproduced at any time :D

Can you please take a look at this again?
Yes this bug still exists. also..

after many testing on my test forum, today i install this on my live forum. which had the old version from vb3.5. so after the update, all quotes add dates showing todays date (January 16th, 2007) screenshot attached bellow...

yonglvnv 01-15-2007 07:06 PM
Cap'n Steve,
had a weird situation. After upgrading to 3.8, QuoteIt disappeared from vba cmps page. Completely uninstalled the 3.8 and reinstalled QuoteIt and was locked out of my admincp. The error on blank admin page and top of all my website pages were "Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3553" which is "foreach ($_FIELDNAMES AS $field => $bitvalue)" in functions.php file. Ended up disabling all hooks through my config.php file so I can sign back in to admincp page to disable this mod. I'm also seeing some error messages when doing a fresh install of QuoteIt. Trying to install 3.7 gave me the same error. Do you think uninstall didn't clean up everything?

Cap'n Steve 01-16-2007 07:26 AM
Still looking at the language chooser and vBadvanced bugs.

yonglvnv - It's not reading the permissions for some reason. Did you still have includes/xml/bitfield_quoteit.xml on the server?

soulface - That's right. The date wasn't stored in earlier versions so it uses the date you installed it as the default date.

Alien - I was afraid of that. I have no idea what your problem is, but it's not modifying or adding columns. I'll keep searching for the reason behind that, but until then you have two options: Try and get your host to upgrade MySQL (I'm not sure if that will help) or modify the tables yourself through phpMyAdmin. Here's the structure for each table (column name is on the left, definition after the =>):

quotes
Code:
quoteid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
quote => MEDIUMTEXT NOT NULL
author => VARCHAR (100) DEFAULT NULL
userid => INT (10) UNSIGNED NOT NULL DEFAULT 0
approved => TINYINT (1) UNSIGNED NOT NULL DEFAULT 0
votes => INT (10) UNSIGNED NOT NULL DEFAULT 0
rating => INT (10) NOT NULL DEFAULT 0
average => FLOAT (3, 2) NOT NULL DEFAULT 0.00
context => VARCHAR (250) DEFAULT NULL
date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL
quoteratings
Code:
userid => INT (10) UNSIGNED NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
guestquoteratings
Code:
ip => VARCHAR (15) NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
date => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
quotecategories
Code:
categoryid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
title => VARCHAR (64) NOT NULL
description => VARCHAR (250) DEFAULT NULL
public => TINYINT (1) NOT NULL DEFAULT 1
displayorder => SMALLINT (5) SIGNED NOT NULL DEFAULT 0
Here are the keys (table name on the left, keys after the =>):
Code:
quotes => PRIMARY KEY (quoteid), KEY (approved), KEY (rating), KEY (average)
quoteratings => PRIMARY KEY (quoteid, userid)
guestquoteratings => PRIMARY KEY (quoteid, ip)
quotecategories => PRIMARY KEY (categoryid)
And finally, these columns need to be added to other tables:

user
Code:
quoteitoptions => INT(10) UNSIGNED NOT NULL DEFAULT 0
lastquotesvisit => INT(10) UNSIGNED NOT NULL DEFAULT 0
quotecount => INT(10) UNSIGNED NOT NULL DEFAULT 0
usergroup
Code:
quoteitpermissions => INT(10) UNSIGNED NOT NULL DEFAULT 2567

Calash 01-16-2007 05:12 PM
The latest download has resolved the issue with the edit button, it now does an AJAX edit.

I still have the language bar issue. Normally I only have 1 language (English) and the drop down selection is not visible. When I install QuoteIT the drop-down shows up and has a random selection (I have seen A, E, and blank). I will leave it up so you can take a look.

I am also having issues with the vBadvanced module. I set it up per the instructions but it does not show up. I have not had time to trouble shoot yet, but if you can give me some common problem areas to look at it would help :)

Thank you for making the mod...it is something I thought I was going to lose when I moved to vB.

Alien 01-17-2007 01:44 PM
Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL

Calash 01-17-2007 01:58 PM
The vBadvamced module problem seems to be related to permisisions. If I edit the get_random_quote() function and remove the "canviewquote" check it works fine. I need to fix the layout but that is a skin issue and not a QuoteIT issue.

May be off on the names, I am at work ATM.

Alien 01-17-2007 02:04 PM
Okay, added the entries above and so far so good without mysql errors in the admincp..

I'll also upgrade to the latest version you posted shortly.

zetetic 01-17-2007 02:08 PM
Sorry Cap'n, I haven't had a chance to work on this for the last couple days so I can't give any feedback about the current revision. However, would you mind updating the filename or OP with the current rev number when you release new revisions? I'd like to make sure I grab the latest.

Thanks again for all your work on this.

thepub 01-17-2007 03:04 PM
so I have to reinstall in order to get the edit button to look normal? I finally got it installed and showing, but it's very large on the forum index and the edit button looks like an edit button on the board.

thepub 01-17-2007 03:38 PM
this may be the dumbest question ever but where exactly is the modules/moderate.php at so I can edit the file according to the vbadvanced installation instructions?

zetetic 01-18-2007 12:30 AM
The modules directory should be in your forum root. So like yoursite.com/forum/modules/

Cap'n Steve 01-18-2007 04:58 AM
zetetic - It's at the top, right under the title, but the easiest way to check is to go to "Manage Products" in your admincp and then there'll be a "Check Version" option in the list next to QuoteIt!

thepub - That module and the directory itself come with vBadvanced. I'm not sure what you mean about the edit button. The actual image is too large? You'll have to edit the quote_listbit template to change the size.

yonglvnv 01-18-2007 06:35 AM
Quote:
Originally Posted by Cap'n Steve (Post 1160418)
Still looking at the language chooser and vBadvanced bugs.

yonglvnv - It's not reading the permissions for some reason. Did you still have includes/xml/bitfield_quoteit.xml on the server?
Just checked, yes it was. Will delete and reinstall again. Thanks!

UPDATE: Quote IT 3.08 still doesn't show on my vba module, but it shows again when I downgrade to 3.07. Some parts of formatting is still off as I posted before, otherwise, I'm happy with 3.07. Could you help?

Firen 01-18-2007 07:40 AM
I've reinstalled the latest version, but I still can't seem to get the edit button to work.

yonglvnv 01-18-2007 07:47 AM
Cap'n Steve, played around with it a bit with 3.07, I finally got the formatting thing kind of figured out and everything looks like where they are supposed to be. Anyway to get rid of blank lines over and below the quotes and make the actual quotes a bit wider to take up less lines? Basically want to compact the height as much as possible.

Cap'n Steve 01-18-2007 08:32 AM
The new version is up. vBadvanced problems should be fixed, although it's still ugly in some styles, so I recommend you use quotesideblock.php as the module even if it's going to be used in the center block. Quick Language Chooser should also be fixed, but you must save your QuoteIt! Options first.

Firen - Did you redo that edit to clientscript/quoteit_moderation.js that I posted a while ago? Does it say anything?

yonglvnv - The margins are set in clientscript/vbulletin_css/quoteit_main.css, look for the .quote and .quotetext lines. If you're using Internet Explorer, the spacing is one of the things I couldn't quite get right, that's set in the other css files.

soulface 01-18-2007 10:15 AM
YES! Quick Language Chooser bug is fixed! also the CMPS module. working fine...

one question, i want to use tahoma as the font of Quotes, Auther name & context text. how do i do that ?

thepub 01-18-2007 12:47 PM
I mean the size of the quoter is very large on my board in comparison to the demo you posted.

www.theneighborhoodpub.com take a look for yourself. I cannot get tit to show on the main page so you will have to click on forums to view it.

Firen 01-18-2007 07:46 PM
Quote:
Firen - Did you redo that edit to clientscript/quoteit_moderation.js that I posted a while ago? Does it say anything?
Nope. It doesn't do anything. Not even an error message. Very weird.

thepub 01-18-2007 09:49 PM
edit button is working and quoter is working except it still is not showing up on the main page of my forum and I set it up to do so according to the module and instructions. I'm getting there lol!

Cap'n Steve 01-19-2007 02:24 AM
Firen - Could you give registered users permission to edit their own quotes for a minute on your site? I'll take a look at it.

thepub - It looks normal to me. It should be using the width used by the style. You are missing the images though, you might want to upload those to whatever images directory the style uses. To get it working in vBadvanced, there's one extra instruction in the latest version. You should also make sure the random quote is enabled. If it still won't work, you can post a screenshot of the module settings and your QuoteIt! options.

soulface - In quoteit_main.css, find these three lines:
Code:
.quotetext {
Code:
.author {
Code:
.context {
below each one, add this:
Code:
        font-family: Tahoma;

Firen 01-19-2007 02:30 AM
Quote:
Firen - Could you give registered users permission to edit their own quotes for a minute on your site? I'll take a look at it.
All set up. Thank you for checking it out for me. :)


All times are GMT. The time now is 04:54 PM.
Page 4 of 19 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01852 seconds
  • Memory Usage 1,864KB
  • 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
  • (12)bbcode_code_printable
  • (2)bbcode_html_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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