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)

Sadie Frost 02-12-2007 12:33 AM

Quote:

Originally Posted by Alien (Post 1161429)
Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL

I upgraded from the 3.5 version (version 2.1 it says in the Product Manager?) on 5 boards (lol), and it worked fine on 4 of them. The fifth though I seem to be having the same problem as Alien did above (page 9/10 of this thread).

I tried to add the missing fields to the tables but I get this error in phpmyadmin:

Quote:

ALTER TABLE `quotes` ADD `date` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `views` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `categoryid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
ADD `postid` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'

MySQL said:

#1060 - Duplicate column name 'quoteid'
I am using MySql version 4.1.21 there. I also get the same errors if I try to use the latest version from the 3.5 version thread. I also did choose the allow overwrite.

Does anyone have any ideas for me? Is it jsut a MySQL version problem?

Also I know that I read this somewhere but I just read through the thread again and couldn't find it, so I'm sorry. But all my dates on my quotes are "12-31-1969"? Is that just because I've just installed the new version?

Thanks :)

Cap'n Steve 02-12-2007 03:35 AM

ubblite - I'm not sure if you saw the post in the other thread, but could you tell me how many languages you normally have, or even better, give me a link? I can't really test the Photopost problem, but I'll take another look.

Sadie Frost - Try adding each column individually. Try using the phpMyAdmin interface instead of typing it in manually ("add new field" at the bottom of the page when viewing table structure). The date problem is because of the incomplete install, but it will default to the date you installed it when the quote doesn't have a date stored (which is all of the ones added before this version).

I'd love to know what's causing that problem, but I have no clues so far.

Sadie Frost 02-12-2007 07:25 PM

Hi Cap'n :) Thanks for the response :) I really do love this hack, and have been using it for a while. It's so odd that out of five upgrades done exactly the same at the same time that only one would have a problem when the rest were fine.

The one with the problems is on a different server than the other four, but both are using MySql 4.1.21.

The way I tried to add the new fields before was through the phpmyadmin interface. I tried doing them one by one and trying to do it by just running a query for it, but I still get that duplicate quoteid column message.

Weird! lol

Cap'n Steve 02-13-2007 04:46 AM

Well, the only thing I can think of is to make a backup of your quotes and quoteratings tables, delete them, reimport the product, and then restore the backup (making sure you don't have it add any drop table statements when you export).

Cap'n Steve 02-13-2007 07:18 AM

I just uploaded a new version with a few small improvements, including improving the style, especially on vBadvanced pages and especially in Internet Explorer.

turiel 02-13-2007 12:33 PM

There seems to be a problem with installing it - the Importing Product progress bar seems to go on 'forever' (by forever I mean 15 minutes before I stopped it). Maybe it normally takes that long, I just haven't seen a mod do that before. I'm using the latest vBB and mod.

BaconDelight 02-13-2007 10:59 PM

Quote:

Originally Posted by Cap'n Steve (Post 1181326)
I just uploaded a new version with a few small improvements, including improving the style, especially on vBadvanced pages and especially in Internet Explorer.

It's certainly an improvement. Thanks!

BTW, I'm working on adding a feature to this, if I get it working I'll pass my code on to you if you want to include it in a future release. I'm trying to add a redirect link back to the thread after you've submitted a post to quotes. A couple users have said they're annoyed that it kinda dead-ends at the page displaying the submitted quote.

jw00dy 02-13-2007 11:28 PM

Thanks, upgrade worked flawless.

Looks a lot better now too.

Cap'n Steve 02-14-2007 01:02 AM

turiel - Just try importing it again. Do you have a lot of styles? Updating those seems to take the longest.

BaconDelight - Good idea.

confus 02-14-2007 06:17 AM

eep installed it without testing thinking its just a small quick simple hack and it killed stuff :(
trying to access admincp or the vbadvanced index page gave php errors (attached)

its possible it was the same problem as mamashid had heh

I had to go to /admincp/plugin.php and untick all the boxes for this hack, then everything ran again and I uninstalled the hack

While it was my fault it was bad consequences for a minor error, in my rush of getting it done so I could do something else I uploaded the files to the main dir, not the forums dir, then installed the xml file
xml files couldn't find the files and gave me those errors


All times are GMT. The time now is 02:26 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.01759 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
  • (3)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