vb.org Archive
Page 19 of 42 « First 91718 19 202129 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=97585)

docvader 12-18-2005 05:13 PM
I've been using Quoteit in vb 3.07 for quite some time, without problems. I successfully upgraded to vb 3.52, and followed your instructions to install this new version. I had the same problem that Snort had, used the upgrade xml file recently suggested, and I still get database errors. Now my index page is gone
Quote:
Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT COUNT(*) AS count FROM quotes AS quotes
WHERE approved = 1;

MySQL Error : Table 'vbtest.quotes' doesn't exist
Error Number : 1146
Date : Sunday, December 18th 2005 @ 11:16:06 AM
Script : http://x.russbo.com/vbtest/index.php
any suggestions? This certainly did not "upgrade" smoothly at all.

docvader 12-18-2005 05:20 PM
I successfully uninstalled it and got my board back. But, it won't upgrade without database errors
Quote:
Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'showquote',
'forumhome',
'1',
'0',
'boolean',
'yesno',
90,
0,
1,
'quoteit'
),
(
'ratequote',
'forumhome',
'2',
'0',
'number',
'<select name=\\\"setting[ratequote]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0, \'selected=\"selected\"\') . \">\" . $vbphrase[\'disabled\'] . \"</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1, \'selected=\"selected\"\') . \">\" . $vbphrase[\'plus_or_minus\'] . \"</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2, \'selected=\"selected\"\') . \">\" . $vbphrase[\'1_to_5\'] . \"</option>\r\n</select>',
100,
0,
1,
'quoteit'
),
(
'averagethreshold',
'forumhome',
'',
'',
'number',
'',
110,
0,
1,
'quoteit'
),
(
'totalthreshold',
'forumhome',
'',
'',
'number',
'',
120,
0,
1,
'quoteit'
);

MySQL Error : Duplicate entry 'showquote' for key 1
Error Number : 1062
Date : Sunday, December 18th 2005 @ 11:29:41 AM
Script : http://x.russbo.com/vbtest/admincp/plugin.php
Referrer : http://x.russbo.com/vbtest/admincp/p...?do=productadd
IP Address : 67.77.47.30
Username : doc
Suggestions? Should I wipe out all of my Quoteit tables (I have backups), install this fresh, and then import the tables again??? I'm not sure how to do that, by the way :)

thanks
rich

Warrior 12-18-2005 05:33 PM
Quote:
Originally Posted by Cap'n Steve
vonedaddy - try reimporting the product, be sure to check "allow overwrite". Let me know if that causes any errors.

sengerdw - the only thing changed was to allow 3.5 compatibility.

Nice work on those quotation mark images, by the way.
Nevermind my last post - I just checked my plugin manager and it shows I have 2.1... the folder says 2.0 so I got confused... :ermm:

vonedaddy 12-18-2005 05:35 PM
Quote:
Originally Posted by vonedaddy
I assume to reimport you would need to uninstall... When I try to reinstall I get the following error:

Database error in vBulletin 3.5.2:

Invalid SQL:

DROP TABLE vbquotes;

MySQL Error : Unknown table 'vbquotes'
Error Number : 1051
Date : Saturday, December 17th 2005 @ 09:32:02 PM
Script : http://hereyah.com/forum/admincp/plugin.php
Referrer : http://hereyah.com/forum/admincp/plu...tid=quoteit&s=
IP Address : 68.46.5.248
Username : savone
Classname : vb_database


By the way I just re-imported and nothing still. Checked the database and no tables. But I do see the options in the control panel now, but if I enable it my forums dont work.
Capt, some help please :)

Anyone have any ideas for me?

samu2 12-18-2005 06:09 PM
OK Installed,it is up and running,I have it set ti show on forum home,however there are no options for it in Admin CP,I cant moderat quotes or anything as their are no options for it at all.

Ive uploaded the admin cp folder and re built my bitfields,nothing. thank you in advance

Cap'n Steve 12-18-2005 09:30 PM
samu2 - try editing a plugin in the Plugin Manager and then saving it without changing anything.

vonedaddy - do NOT uninstall. Just reimport the the product and check the "allow overwrite" box. If there are any errors during installation, post them.

docvader - run these queries to make sure the quote settings get reset:

Code:
DELETE FROM $TPsetting WHERE varname IN ("showquote", "ratequote", "averagethreshold", "totalthreshold")
Code:
DELETE FROM $TPdatastore WHERE title = "quote_settings"
Just replace the $TP with your table prefix first.

samu2 12-18-2005 09:41 PM
Quote:
try editing a plugin in the Plugin Manager and then saving it without changing anything.
Did that,it saved fine,nothing happened :)

Cap'n Steve 12-18-2005 10:17 PM
That's really strange, are you sure cpnav_quoteit.xml is in your includes/xml folder? Try going to admincp/quoteadmin.php.

docvader 12-18-2005 11:02 PM
Cap'n
Running those queries "cleaned" out the database and allowed me to freshly install the system without problems, on my test board.

Now, before I do this on my real board, how would you suggest I protect the few hunded quotes we've accumulated? How do I get them out of the database and then, after instaling quoteit, get those quotes back into the database??

Thanks for you help man. As usual, you're incredible prompt and effective

rich
x.russbo.com

Cap'n Steve 12-18-2005 11:23 PM
Those queries will cause you to lose your old settings but not the quotes. It never hurts to make a backup, though.


All times are GMT. The time now is 01:13 PM.
Page 19 of 42 « First 91718 19 202129 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.01939 seconds
  • Memory Usage 1,751KB
  • 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