vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] vBDownloads v2 (vB4) [AJAX] (https://vborg.vbsupport.ru/showthread.php?t=252497)

karkey 10-24-2010 03:40 PM

As soon as the downloads II import is running A O K i will give this a bash :P

Tagged for now

DragonByte Tech 10-24-2010 03:49 PM

Quote:

Originally Posted by DragonByte Tech (Post 2113629)
You can turn that on/off per usergroup by selecting/unselecting them from the global module permissions. Thumbnails are generated for each image. If you right click on the thumbnail in a download and copy the url to it you will see this.


Could you PM me your FTP details and an admin account so I can install this for you.

- David

This problem has been fixed at the members site.

Quote:

Originally Posted by karkey (Post 2113652)
As soon as the downloads II import is running A O K i will give this a bash :P

Tagged for now

We should have it fully ready for you in the coming days!

- David

DragonByte Tech 10-24-2010 03:56 PM

Updated the zip:

No version change at this time, just some minor bug fixed.

- Module configuration warning should only should up in vbdownloads.php now.
- Fixed a CSS bug
- Fixed a bug in vBShout Integration that caused it to link to the wrong file.

To upgrade just reupload all the files and reimport the product file setting overwrite to yes.

- David

PS: For your patience, a preview of the next version! http://www.screencast-o-matic.com/watch/c66ZDx6VH

Montecristo 10-24-2010 07:47 PM

Import product... DATABASE ERROR


Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO phrasetype (fieldname, title, editrows, product)
VALUES ('dbtech_downloads', 'Dragonbyte-Tech: Downloads', 3, 'dbtech_downloads');

MySQL Error : Duplicate entry 'dbtech_downloads' for key 1
Error Number : 1062
Request Date : Sunday, October 24th 2010 @ 05:47:29 PM
Error Date : Sunday, October 24th 2010 @ 05:47:29 PM
Script : http://www.actors-studio.org/Foros/a...=productimport
Referrer : http://www.actors-studio.org/Foros/a...?do=productadd
IP Address : 190.177.225.98
Username : Actors
Classname : vB_Database
MySQL Version : 4.1.13a-log

DragonByte Tech 10-24-2010 09:00 PM

Quote:

Originally Posted by Montecristo (Post 2113705)
Import product... DATABASE ERROR


Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO phrasetype (fieldname, title, editrows, product)
VALUES ('dbtech_downloads', 'Dragonbyte-Tech: Downloads', 3, 'dbtech_downloads');

MySQL Error : Duplicate entry 'dbtech_downloads' for key 1
Error Number : 1062
Request Date : Sunday, October 24th 2010 @ 05:47:29 PM
Error Date : Sunday, October 24th 2010 @ 05:47:29 PM
Script : http://www.actors-studio.org/Foros/a...=productimport
Referrer : http://www.actors-studio.org/Foros/a...?do=productadd
IP Address : 190.177.225.98
Username : Actors
Classname : vB_Database
MySQL Version : 4.1.13a-log

Run the following query and reinstall.

[SQL]DELETE FROM phrasetype WHERE fieldname = 'dbtech_downloads'[/SQL]

- David

Montecristo 10-24-2010 09:14 PM

Thanks....

and now...:

Database error in vBulletin 4.0.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `dbtech_downloads_filegroup` (
`groupid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`userid` INT(20) UNSIGNED NOT NULL DEFAULT '0',
`groupname` VARCHAR(1000) NOT NULL,
`groupdesc` MEDIUMTEXT NULL,
`downloads` INT(15) UNSIGNED NOT NULL DEFAULT '0',
`files` MEDIUMTEXT NULL,
`filecount` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`image` SMALLINT(10) NULL DEFAULT '0',
`rating` INT(11) NOT NULL DEFAULT '0',
`updated` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`categoryid` INT(20) NOT NULL,
`moderation` ENUM('0','1') NOT NULL DEFAULT '0',
`password` CHAR(250) NULL DEFAULT NULL,
`private` MEDIUMTEXT NULL,
`favourites` INT(10) NULL DEFAULT '0',
`mirrors` MEDIUMTEXT NULL DEFAULT NULL,
PRIMARY KEY (`groupid`),
INDEX `groupname` (`groupname`),
INDEX `userid` (`userid`)
);

MySQL Error : BLOB/TEXT column 'groupname' used in key specification without a key length
Error Number : 1170
Request Date : Sunday, October 24th 2010 @ 07:12:38 PM
Error Date : Sunday, October 24th 2010 @ 07:12:38 PM
Script : http://www.actors-studio.org/Foros/a...=productimport
Referrer : http://www.actors-studio.org/Foros/a...?do=productadd
IP Address : 190.177.225.98
Username : Actors
Classname : vB_Database
MySQL Version : 4.1.13a-log

DragonByte Tech 10-24-2010 09:21 PM

Quote:

Originally Posted by Montecristo (Post 2113735)
Thanks....

and now...:

Database error in vBulletin 4.0.8:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `dbtech_downloads_filegroup` (
`groupid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`userid` INT(20) UNSIGNED NOT NULL DEFAULT '0',
`groupname` VARCHAR(1000) NOT NULL,
`groupdesc` MEDIUMTEXT NULL,
`downloads` INT(15) UNSIGNED NOT NULL DEFAULT '0',
`files` MEDIUMTEXT NULL,
`filecount` INT(5) UNSIGNED NOT NULL DEFAULT '0',
`image` SMALLINT(10) NULL DEFAULT '0',
`rating` INT(11) NOT NULL DEFAULT '0',
`updated` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`categoryid` INT(20) NOT NULL,
`moderation` ENUM('0','1') NOT NULL DEFAULT '0',
`password` CHAR(250) NULL DEFAULT NULL,
`private` MEDIUMTEXT NULL,
`favourites` INT(10) NULL DEFAULT '0',
`mirrors` MEDIUMTEXT NULL DEFAULT NULL,
PRIMARY KEY (`groupid`),
INDEX `groupname` (`groupname`),
INDEX `userid` (`userid`)
);

MySQL Error : BLOB/TEXT column 'groupname' used in key specification without a key length
Error Number : 1170
Request Date : Sunday, October 24th 2010 @ 07:12:38 PM
Error Date : Sunday, October 24th 2010 @ 07:12:38 PM
Script : http://www.actors-studio.org/Foros/a...=productimport
Referrer : http://www.actors-studio.org/Foros/a...?do=productadd
IP Address : 190.177.225.98
Username : Actors
Classname : vB_Database
MySQL Version : 4.1.13a-log

I'll have a fix up soon.

- David

Montecristo 10-24-2010 09:22 PM

no groupname(varchar1000)

yes groupname(varhcar250)

How can edit the install variable?

DragonByte Tech 10-24-2010 09:31 PM

Quote:

Originally Posted by Montecristo (Post 2113740)
no groupname(varchar1000)

yes groupname(varhcar250)

How can edit the install variable?

Redownload the files and try the installer again. Should work for you this time.

- David

Montecristo 10-24-2010 09:42 PM

Ok, thanks dragon I edit 100.php and replace all varchar(1000) for varchar(250) and works for me.

Thanks....

Suggestion:

One could add a field to place who is the author of this file? Which is not automatic.

and

add sub-categorie

Excellent Work!!!!!


All times are GMT. The time now is 04:48 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.01365 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
  • (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