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)

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?


All times are GMT. The time now is 11:34 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.01332 seconds
  • Memory Usage 1,746KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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