vb.org Archive
Page 25 of 38 « First 152324 25 262735 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)

docvader 01-16-2005 06:00 PM
I tried that (this method worked for the Webpage / Guestbook hack), but I'm getting mysql errors
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near '" . TABLE_PREFIX . "phrase (languageid, varname, text, phrasetypeid) VALUES (0, ' at line 1
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)

docvader 01-16-2005 06:25 PM
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:
Quote:
Database error in vBulletin 3.0.5:

Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('this is a test submission to get this working again.', 'xxxxx', 1, )

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

mysql error number: 1064

Date: Sunday 16th of January 2005 12:15:45 PM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxxx
IP Address:xxxxxxxxxxx
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:
Quote:
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)
instead of what's called for in the instructions:
Quote:
INSERT INTO " . TABLE_PREFIX . "setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)
Anyone have any idea?

LKJR 01-18-2005 03:27 AM
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.

LKJR 01-21-2005 02:48 PM
has everyone given up on this?

Deviant++ 01-21-2005 06:32 PM
you mean this mod dosn't work on 3.0.6 ? :(

docvader 01-21-2005 09:54 PM
Quote:
Originally Posted by Deviant++
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.

TurboTwoLiter 01-21-2005 10:50 PM
same here, i had it on my old site, upgraded to 3.0.5 after server failure,

i wish it was compatable :(

LKJR 01-22-2005 04:01 AM
I tried it on a fresh install of 3.0.5 twice with no luck.

CtrlAltDel 01-22-2005 04:51 AM
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.

docvader 01-22-2005 05:45 AM
YOU ARE THE MAN!

Impressive...

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


All times are GMT. The time now is 06:59 AM.
Page 25 of 38 « First 152324 25 262735 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.01421 seconds
  • Memory Usage 1,741KB
  • 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
  • (5)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