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)

Forgott3n 10-12-2008 04:19 AM

Ok a moderator informed me that, after deleted a spam quote entry, he was redirected do this empty quote:

http://www.avrilbandaids.com/forums/...ew&quoteid=874

Once he tried to delete it, he got this database error:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                SELECT * FROM quotes
                        WHERE quoteid IN ();

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
Request Date  : Sunday, October 12th 2008 @ 01:16:46 AM
Error Date    : Sunday, October 12th 2008 @ 01:16:46 AM
Script        : http://www.avrilbandaids.com/forums/quotes.php
Referrer      : http://www.avrilbandaids.com/forums/quotes.php?page=&do=delquote&quoteid=
IP Address    : 24.87.85.233
Username      : Forgott3n
Classname    : vB_Database_MySQLi
MySQL Version : 5.0.51a-community


Cap'n Steve 10-12-2008 04:36 AM

That's really strange. Try going to this page (while logged in as a moderator or administrator).

Forgott3n 10-12-2008 05:03 AM

Quote:

Originally Posted by Cap'n Steve (Post 1643074)
That's really strange. Try going to this page (while logged in as a moderator or administrator).

Once I navigate there, it brings me to the "quotes.php?" page. Also, I tried putting in a bogus quote id:

http://www.avrilbandaids.com/forums/...quoteid=999999

seems to give the blank one. Perhaps its the default null result?

Cap'n Steve 10-14-2008 03:01 AM

Yes, the blank page is what happens if it gets sent an invalid id. I don't know what happened originally, but as long as it's not showing up when you list quotes, I guess it's safely deleted.

ArnyVee 10-17-2008 12:37 PM

I'm going to start to search for the answer through the 44 pages of info, but is there a way to simply have the quotes appear as an added 'touch' to the site rather than having the ratings and self-submission piece of the mod?

My site is Disney related and I'll have mainly quotes from Walt Disney that I already have typed up. So, I'll be preloading them into the system and just have them display. Is that possible?

Cap'n Steve 10-17-2008 03:33 PM

Yes, you can disable the ratings system in the options and set up the usergroup permissions so that only you have permission to add quotes.

ArnyVee 10-17-2008 04:23 PM

Thanks for the quick response Cap'n Steve! :D

I'll look into adding this tonight or tomorrow to my site.

Forgott3n 10-26-2008 02:40 AM

It appears we have another bug, it may have been from the sql edit we made.

For some reason, the AdminCP option of Moderate Quotes remains No, no matter how many times we set it to Yes. Once we set it to Yes and hit Save, it refreshes back to No.

Also, we're now running vBulletin 3.7.3 PL1 so that could also be a factor.

Thanks for the help!

Cap'n Steve 10-27-2008 06:41 AM

Run this query and tell me what the output is (replace $TP with your table prefix):

[sql]SELECT * FROM $TPdatastore
WHERE title = "quote_settings"[/sql]

shane greer 10-27-2008 02:48 PM

As soon as I installed it I got this.

Now my whole forum is down. HELP!!

Warning: require_once([path]/includes/functions_quoteit.php) [function.require-once]: failed to open stream: No such file or directory in [path]\includes\class_bbcode.php(2428) : eval()'d code on line 3

Fatal error: require_once() [function.require]: Failed opening required 'C:\Inetpub\vhosts\thefewgoodmen.ieasysite.com\htt pdocs\forum/includes/functions_quoteit.php' (include_path='.;./includes;./pear') in C:\Inetpub\vhosts\thefewgoodmen.ieasysite.com\http docs\forum\includes\class_bbco de.php(2428) : eval()'d code on line 3


All times are GMT. The time now is 10:45 PM.

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.01655 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
  • (1)bbcode_code_printable
  • (1)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