vb.org Archive

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)

Cap'n Steve 01-06-2007 03:53 AM

The database error should be fixed, as well as the Quick Language Chooser (I mean it this time). The Quote Filtering Options currently gets squeezed to the side in Firefox with some styles. If anyone good with CSS knows how to fix it, I'd appreciate the help because I can't seem to get it right without messing up the search box.

efil - What do you mean some options won't save? To arrange everything right to left, try editing the css files and switching left and right in those.

MaestroX - Do you have any quotes in the database? Make sure you download the latest version. If it still doesn't work then your server might have a problem with redirects.

Amiga Harrison - Thanks for catching that, it should be there now. It appears at the bottom of this list, though, and make sure you give yourself permission to approve quotes.

TwinsForMe - It uses the table width for whatever style you're using. You could adjust that or edit one of the css files.

everyone with problems editing quotes - Make absolutely sure you have the latest .js files on your server. If it still doesn't work, please post the exact error. In Firefox, it'll be under Tools -> Javascript Console; in Internet Explorer, there's probably an icon that you have to double-click on the bottom-left of the window.

Quote:

Originally Posted by jluerken
I have the same error like efil is posting above

Which error is that?

jluerken 01-06-2007 07:38 AM

Quote:

Originally Posted by Cap'n Steve (Post 1151770)
Which error is that?

The templates on quotes.php are not shown correctly. There is a column missing of the filter setting and I still have the problem that the product messes up my language chooser.

MaestroX 01-06-2007 08:20 AM

Thanks for your help so far Cap'n Steve. 'm still having trouble, I just installed your latest version and still the same problem. I've checked the DB and the field are there. There wasn't any quotes in there so I inserted one but still no luck. (also my server handles redirects fine)

Any ideas?

Also if possible, would it be possible to add quotes from the admincp? That would be great for my needs :)

Just thought of something nifty, you have the $showrandomquote function, how about showing a random quote from a certain category?

Amiga Harrison 01-07-2007 12:06 AM

Quote:

Originally Posted by Cap'n Steve (Post 1151770)
everyone with problems editing quotes - Make absolutely sure you have the latest .js files on your server. If it still doesn't work, please post the exact error.

I have the latest QuoteIt files on my server including the .js files but am still getting an error for the editing quotes button. The javascript error it returns when clicked is:

Code:

Error: agent.handler.responseXML has no properties
Source File: http://url/clientscript/quoteit_moderation.js
Line: 282

I also still have a problem when selecting a category without any quotes in it. I am not getting the DB error any longer so thank you for fixing that problem, it does now show the correct"No quotes matched your search" message. But then after this the auto redirect gets the url wrong. Instead of redirecting to http://siteurl/quotes.php it is trying to go to http://siteurl/siteurl/quotes.php

And one final small error. When adding a new quote the context text box is very small and aligned to the left of the page.

Cap'n Steve 01-07-2007 08:07 AM

The bad redirect should be fixed and several things should look better in Firefox.

MaestroX - Have you approved the quote you added? Try going to quotes.php?do=view&quoteid=1 and tell me if the quote shows up. You can import a file full of quotes through the admincp if you'd like. Good idea about the categories, I'll put that in 3.1.

Amiga Harrison - What version of Firefox are you using? Have you changed any of the default settings regarding timeouts or something similar? Try holding shift and hitting refresh before editing a quote. I know that editing quotes works on Firefox 1.5 and 2, so I'm not sure what problem you're having. :/

zetetic 01-07-2007 11:28 AM

Hey Cap'n Steve.

I've been using this hack for a long time. Great work. I'm having trouble upgrading, though. I recently upgraded my forum from 3.0.6 -> 3.6.4 and upgraded to the 3.5.x version of QuoteIt 2.0 at the same time. However, when I just tried to upgrade to QuoteIt 3.0 (downloaded just now) I got this db error when attempting to import the product:

Code:

Invalid SQL:

                DELETE ratings.* FROM quoteratings AS ratings
                LEFT JOIN quotes AS quotes ON quotes.quoteid = ratings.quoteid
                        WHERE quotes.quote IS NULL;

MySQL Error  : Not unique table/alias: 'ratings'

That seemed to be just a clean-up operation, so I decided to remark it out. However when I tried the import again I got the same db error TwinsForMe mentions above:

Code:

Invalid SQL:

                INSERT INTO datastore
                (title, data) VALUES
                ("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"0\";s:14:\"moderatequotes\";s:1:\"0\";s:16:\"numbertomoderate\";s:1:\"5\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcode\";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimages\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"continuousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"upgradedate\";i:1168175936;s:16:\"enablecategories\";i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemails\";s:0:\"\";}");

MySQL Error  : Duplicate entry 'quote_settings' for key 1


GrabAssGirl 01-07-2007 12:22 PM

What the heck is going on with the quotation images? They don't line up with the quote. Is there anyway to fix it? It's doing it on your "demo site" forums.monkeycrap.com as well.

Bubble #5 01-07-2007 02:03 PM

Thank you for all of your hard work Steve, Looks like a very promising hack. A+ :)

Defkalion 01-07-2007 03:58 PM

Hi,

I installed the module on my 3.6.4 version, and immediately after the import in the Plugins admin cp, I refreshed the page and now my whole portal does not display! Instead I get the following error when I type the URL for the admincp:

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3553

And the main portal page is just blank.

Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

Calash 01-07-2007 05:37 PM

Here is the Java Error I am getting

CtrlAltDel 01-07-2007 06:08 PM

nice upgrade steve

thepub 01-08-2007 12:39 AM

not working and I just typed a long post explaining what the heck was going on and somehow lost it *grrr* I am having trouble installing this and there is no Quote it maintenance thing in my admin cp. Also, if I revert my templates (as suggested) to upgrade the quoter then I lose all of my other hacks and addins, is this the only way to do it?

thepub 01-08-2007 12:44 AM

I tried to import the product and got an error message saying:

Quote:

Database error in vBulletin 3.6.2:

Invalid SQL:

INSERT INTO datastore
(title, data) VALUES
("quote_settings", "a:14:{s:13:\"enablecontext\";s:1:\"0\";s:14:\"mod eratequotes\";s:1:\"1\";s:16:\"numbertomoderate\"; s:1:\"0\";s:9:\"allowhtml\";i:0;s:11:\"allowbbcode \";i:1;s:12:\"allowsmilies\";i:1;s:11:\"allowimage s\";i:0;s:15:\"allowlinebreaks\";i:1;s:13:\"contin uousids\";i:1;s:12:\"saveascookie\";i:0;s:11:\"upg radedate\";i:1168224147;s:16:\"enablecategories\"; i:1;s:14:\"showunapproved\";i:1;s:12:\"reportemail s\";s:0:\"\";}");

MySQL Error : Duplicate entry 'quote_settings' for key 1
Error Number : 1062
Date : Sunday, January 7th 2007 @ 09:42:28 PM
Script : http://www.theneighborhoodpub.com/ad...=productimport
Referrer : http://www.theneighborhoodpub.com/ad...?do=productadd
IP Address : (deleted by thepub)
Username : (deleted by thepub)
Classname : vb_database
can you tell me what this means and why it's happening?

Cap'n Steve 01-08-2007 12:52 AM

Quote:

Originally Posted by Defkalion (Post 1152716)
Is there a way to disable the module now that I do not have access to the admin cp? Any help would be appreciated. Thanks.

Add this to includes/config.php:
PHP Code:

define('DISABLE_HOOKS'1); 


Cap'n Steve 01-08-2007 03:12 AM

All installation database errors should be fixed. The closing quotation mark is hidden in Internet Explorer on the random quote and the quote bbcodes until it learns to stop wandering off.

thepub - You should only revert the QuoteIt! templates, and you only need to do that if you customized them in an earlier version.

Calash - What version of IE is that? Check under Help -> About. Also, try shift + refresh and see if that changes anything.

Defkalion - Do you have any other mods installed? If you could post the code on and around that line number, that might help, since it seems to be different in older versions.

The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?

Defkalion 01-08-2007 08:28 AM

Ok I did a rebuild of the bitfields and now everything seems to be ok.

Many thanks for your quick reply Steve.

GrabAssGirl 01-08-2007 09:22 AM

Can you tell me why the quotations are located so far apart. The image on the right is located almost outside the quoteIt box. It's even doing this on your "live demo" site. Is there any way for me fix this? (don't know if this will work, but here's an image of what I am talking about...

https://vborg.vbsupport.ru/external/2007/01/17.gif

GrabAssGirl 01-08-2007 09:24 AM

or, is there anyway to just do away with the images and have nothing but the quote there?

Calash 01-08-2007 10:53 AM

Both IE6 and IE7. Firefox does not throw a visible error but the edit button does not work.

I am also having the issue with the quotes being spaced way too much, but that appears to be a skin issue so I am going to work to resolve that via editing the templates.

I am also having a problem getting the vBadvanced module to work. The block just will not show up no matter what I do and I am not sure how to get any error messages to help diagnose the problem.

zetetic 01-08-2007 10:55 AM

Quote:

Originally Posted by Cap'n Steve (Post 1153267)
All installation database errors should be fixed.

Doh! I got impatient yesterday so I dumped the quotes table to a flat file, then uninstalled and reinstalled QuoteIt. Unfortunately I can't seem to get the QuoteIt file import to work. I keep getting this error: "Invalid Query: Column Count Doesn't Match Value Count At Row 1".

Exactly what format does a file have to be in? I'm trying just quote, author, userid, context separated by semicolons. Sorry, I know just enough to be dangerous!

Quote:

The latest version I can download is 3.6.1, can anyone confirm that this works on newer versions?
The clean install went fine on 3.6.4, but I can't be sure it worked until I get the import done.

thepub 01-08-2007 11:58 AM

can you help me about the error message I got when I tried to import the product? I posted it above. Thanks!

thepub 01-08-2007 12:14 PM

ok I was able to install and the big error message went away, but now I get this error message
Quote:

Warning: Invalid argument supplied for foreach() in /includes/functions.php on line 3542
and my board disappeared. I disabled the quoter and it came back. :confused:

thepub 01-08-2007 12:19 PM

Quote:

Warning: Unknown(/home/theneigh/public_html/includes/functions_quoteit.php): failed to open stream: No such file or directory in /index.php(63) : eval()'d code on line 2
Fatal error: (null)() [function.require]: Failed opening required '/home/theneigh/public_html/includes/functions_quoteit.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/theneigh/public_html/index.php(63) : eval()'d code on line 2

this is what I get when I go to board

BaconDelight 01-08-2007 05:12 PM

This is mostly working, but when I enable editing/deleting for a user group, the random quotes display fails to parse BBCode.

MaestroX 01-08-2007 06:10 PM

Quote:

MaestroX - Have you approved the quote you added? Try going to quotes.php?do=view&quoteid=1 and tell me if the quote shows up. You can import a file full of quotes through the admincp if you'd like. Good idea about the categories, I'll put that in 3.1.
My quote I put in the database came up, yay! From there I tried to add a quote and was successful but then redirected to my forum home. Anytime I try to access quotes.php I get redirect to my forum home. I get the message ""Your quote has been submitted.".

Hope you can help,

Thanks

BaconDelight 01-08-2007 09:33 PM

Quote:

Originally Posted by BaconDelight (Post 1153801)
This is mostly working, but when I enable editing/deleting for a user group, the random quotes display fails to parse BBCode.

Sorry to poke again, but I'm hoping to pop this into my live board tonight and would like this to be working.

Thanks!

Amiga Harrison 01-09-2007 12:02 AM

The page redirect is now working correctly for me and returning back to the correct page. So thanks for fixing that.

I am still getting the edit quote error. I tested it in IE and Opera and it doesn't work in those either.

In IE7 the page returns the same error as someone else posted above.

Code:

Line: 283
Char: 5
Error: 'agent.handler.respondeXML.documentElement' is null or not an object
Code: 0
URL: http://forum.classicamiga.com/quote.php

And in Opera I get the following errors:

Code:

JavaScript - http://forum.classicamiga.com/quotes.php
Unknown thread
Error:
name: TypeError
message: Statement on line 282: Could not convert undefined or null to object
Backtrace:
  Line 282 of linked script http://forum.classicamiga.com/clientscript/quoteit_moderation.js
    var author = (agent.handler.responseXML.documentElement.getElementsByTagName("author"))[0].firstChild.data;
  At unknown location
    [statement source code not available]

The edit foes however work in all three browsers if I select to open the edit link in a new window or tab. Therefore is this an AJAX error?

There are also a lot of layout problems:

When submitting a new quote (in IE, Firefox or Opera) all of the text entry fields are justified to the right and the titles and information about each field is bunched up on the left. This leaves a huge space between the two. Are you just using float left and float right css for this? I much preferred the way it was laid out before this change with the information text above the entry fields.

Also the text entry field for the context field is only set to a size of 25 which is way too small to even display the default information automatically entered into the field. Where is this fields size set?

And finally IE7 has a lot of bad layout problems. When viewing the list of existing quotes the list expands futher to the right than the browser window and goes beyond the right hand edge of the forum template. This makes everything on the right of the quotes hidden off the right of the page including the voting and editing buttons. This doesn't happen in Firefox or Opera where the page looks fine and works as expected.

thepub 01-09-2007 01:29 AM

Quote:

Originally Posted by BaconDelight (Post 1154013)
Sorry to poke again, but I'm hoping to pop this into my live board tonight and would like this to be working.

Thanks!


ditto for me too.

Cap'n Steve 01-09-2007 03:45 AM

GrabAssGirl - The closing quote is now hidden in Internet Explorer on the random quote. It seems to want to start in the top right corner no matter what I do. :o The images are in the quote_listbit template if you want to remove them completely.

Calash - I've enabled editing quotes on my forum. Register on monkeycrap.com, add a quote and then try editing it. I've tested editing with all those browsers, so it must be either a server or browser setting that's causing problems.

Amiga Harrison - Try the thing I posted above about editing. If the labels were above the fields before, then that was an error. If you want to change this or the size of the inputs, it's set in the quote_manager template. I don't get any of the other errors you're seeing. Do you have a link or a screenshot?

zetetic - When you say you dumped them to a flat file, do you mean through phpMyAdmin? The quote importing just takes a text file with each field separated by whatever character you specify. If you could post the options you filled in at the quote importing screen and at least the first line of the file, that might help.

thepub - Is your functions_quoteit.php in the directory it says? It seems to be having trouble finding it. If you could post a few lines from includes/functions.php from around line 3542 I could get a better idea of what the issue is.

MaestroX - Is this page on the Internet, a link would be helpful. You can also try reuploading all the files and reinstalling the product.

Cap'n Steve 01-09-2007 04:35 AM

BBcode in the random quote should be fixed now, also.

MaestroX 01-09-2007 07:27 AM

Quote:

Originally Posted by Cap'n Steve (Post 1154273)
MaestroX - Is this page on the Internet, a link would be helpful. You can also try reuploading all the files and reinstalling the product.

Yeah, my test forum are http://area51.music-web.org/forum/index.php. I'll also try reuploading all the files and reinstalling the product :)

Edit: All problems seem to be fixed, thanks for the great support :)

p.s. Also I'm waiting for the random quote by category and this mod will be perfect!

thepub 01-09-2007 01:06 PM

double post.

thepub 01-09-2007 01:29 PM

ok, I went through and out everything in again and paid close attention to where what was going and figured out a couple of my mistakes along the way. I now have the quoter on my forum index, but there is nothing in it. When I submit a test quote it doesn't show up, all there are is some ""'s

It looks nothing like the one you posted on your demo site.

dcsbclan 01-09-2007 02:07 PM

First off great mod Steve! :D Clicked installed and nominated.

The public part i all working fine, but setting options in the admin panel isnt working. For example when i go to the parsing option I set all to yes then hit save, and the page reloads with all no and it doesnt save the settings. Have tried it in both IE7 and Opera to check it wasnt opera's cookies settings showing it wrong or something and it happens on both. I went through trying to chmod some of the files to 777 instead of 644 just to test, and when i change quoteadmin.php to anything other than 644 I get an error in teh admin cp.

Any suggestions?

Edit: Im running vb3.6.4

BaconDelight 01-09-2007 03:38 PM

Quote:

Originally Posted by Cap'n Steve (Post 1154304)
BBcode in the random quote should be fixed now, also.

Nope, same issue. BBcode works if a user does not have edit/delete permission. And it works on the show all quotes list, even with edit/delete permission. But in the random quote display, if a user has edit/delete permission, BBCode is not parsed.

I completely uninstalled 3.01 and installed 3.02. All templates are unedited.


EDITED TO ADD: I stand corrected. Now, with 3.02, BBCode doesn't work at all in the random quote display, whether the user has editing permission or not.

BaconDelight 01-09-2007 08:04 PM

I don't know if this is helpful or not, but I compared the resulting html source code for the random quote display (where BBCode fails) to the same for the full quote list (where BBCode works)

I noticed this difference. In the random display, you see this right before the text of the quote:

Code:

<span class="quotetext" id="quotetext1-">
Whereas in the full quote list, it's:
Code:

<span class="quotetext" id="quotetext1-0">
Again, I have no idea if that's relevant, but perhaps it points to where the BBCode parsing is breaking down.

Cap'n, if you'd like to look at my installation, PM me and I'll point you to it.

thepub 01-09-2007 08:17 PM

Quote:

Originally Posted by BaconDelight (Post 1154894)

Cap'n, if you'd like to look at my installation, PM me and I'll point you to it.

mine too! mine too! *jumping up and down* My members are snippy about the quoter not working lol!

Amiga Harrison 01-09-2007 09:03 PM

I've taken a look at the templates and sorted out the text field sizes so that's sorted.

I still have the layout issues in IE, and have now tested it using both IE6 and 7 and get the same results. I've PM'd you the details to look at my site.

zetetic 01-09-2007 11:41 PM

Quote:

Originally Posted by Cap'n Steve
zetetic - When you say you dumped them to a flat file, do you mean through phpMyAdmin? The quote importing just takes a text file with each field separated by whatever character you specify. If you could post the options you filled in at the quote importing screen and at least the first line of the file, that might help.

Yes, dumping from phpmyadmin. I still have a copy of my old db running on my test server, so I can export another copy of the quotes table as necessary. I tried numerous combinations of export format, separator and field order but can't seem to get anything to import.

Cap'n Steve 01-10-2007 02:40 AM

thepub - Did you approve the quote? Does it show up when you go to the main quotes.php page? Have you changed either the total threshold or average threshold?

dcsbclan - Try reuploading all the files and reimporting the product.

Amiga Harrison - It's definitely caused by using the [quote] bbcode in a quote. I'm probably just going to end up disabling that bbcode, since I'm not sure how useful that is within a quote anyway.

zetetic - If the backup was created with phpMyAdmin, you should use phpMyAdmin to restore it. You could also run the queries through your admincp, but using phpMyAdmin would be the easiest option.

Still working on the bbcode in the random quote...


All times are GMT. The time now is 05:16 AM.

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.01777 seconds
  • Memory Usage 1,865KB
  • 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
  • (7)bbcode_code_printable
  • (1)bbcode_php_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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