vb.org Archive - Major Additions

Page 26 of 437

« First

126

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Major Additions - DownloadsII (https://vborg.vbsupport.ru/showthread.php?t=120122)

bollie

08-09-2006 04:07 AM

I get down reported along mail.
I everything have already removed.

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM dl_files WHERE `purgatory` = '0' AND `category` = '31' ORDER BY `pin` DESC, `dateline` DESC LIMIT 0,20;

MySQL Error : Unknown column 'dateline' in 'order clause'
Error Number : 1054
Date : Tuesday, August 8th 2006 @ 05:10:20 PM
Script : http://........../forum/downloads.ph...&sort=dateline
Referrer :
IP Address :
Username :
Classname : vB_Database

HappyPike

08-10-2006 05:19 PM

I don't think there is a field called "dateline". Try changing it to sort by "date" instead.

Westpointer, in a future version, think you can make it so when someone edits a file to upload a new version or deletes a file entry, the file gets deleted from the server as well? This way those old obsolete files don't take waste server space.

novelidea

08-10-2006 07:05 PM

Is it possible to make sure users post a certain number of posts on the forums to have access to the downloads? If not, that would be a nice addition.

HappyPike

08-11-2006 12:06 AM

It's posible to do that using vB's user group permissions and promotion system.

I have a question myself: Since anyone can download files on my site, would it be a problem when search bots try to index the downloads section and visit the download links, generating incorrect download count for the file?

EDIT: I added rel="nofollow" to all the download links. Hope this is enough to prevent search bots from visiting those download links.

RS_Jelle

08-11-2006 10:13 AM

Normally rel="nofollow" is enough, but you can't stop all of the bots very easily (those bots are most of the time of dubious search engines who are also providing spyware toolbars, ...) ;)

project-Buckfas

08-12-2006 11:58 AM

Perfect,

Thank You!

Quote:

Originally Posted by westpointer

I found this occurs when clicking on the on the download link located on the page that lists a summary of the files in the category but not when looking at the detailed listing for one file.

To fix it, in downloads.php around line 300 -

FIND:

PHP Code:


		
			
    if ($db->num_rows($result) > 0)

    {

        while ($file = $db->fetch_array($result))

        {

            $date = vbdate($vbulletin->options['dateformat'],$file['date'],true);        

            $downloads = vb_number_format($file['downloads']);

BELOW that ADD:

PHP Code:


		
			
            // added to open links in a new window Aug 1, 06

            if ($file['link'] == 1)

            {

                $target = 'target="_blank"';

            }

            else

            {

                $target = 'target="_self"';

            }

Mickie D

08-13-2006 03:43 PM

there is still an issue with this version and php5 which needs looking at ;)

https://vborg.vbsupport.ru/showpost....&postcount=240

Mr.T	08-13-2006 03:47 PM

Hello,
I've installed it an now I got a problem by uploading files. I got this SQL-error:

Code:

Datenbankfehler in vBulletin 3.5.3:



Invalid SQL:

INSERT INTO dl_files (`name`, `desc`, `author`, `_author`, `uploader`, `uploaderid`, `url`, `date`, `category`, `size`, `pin`, `purgatory`, `link`)

                                                                                        VALUES('test', 'dgadfg', 'sdf', 'sdf', 'TeamO', '1545', '87292-arpr.zip', 1155487292, '1', 1311486, '0', '0', 0);



MySQL-Fehler : Unknown column 'desc' in 'field list'

Fehler-Nr.   : 1054

Datum        : Sunday, August 13th 2006 @ 06:41:32 PM

Skript       : xxxxxxx

Referrer     : xxxxxxxxx

IP-Adresse   : yyy.yyy.yyy.yyy

Benutzername : test

Klassenname  : vb_database

By changing the table-name description in dl_files to desc it works fine. What should I do, so that the tablename is desciption and all works?

T

RS_Jelle

08-13-2006 06:15 PM

The name of the desc field changed to description. So it seems that your database is up-to-date, so you have imported the product file correctly. But this query is impossible, I checked it again and every query is changed to use description.

So try to reupload and overwrite all the files (you haven't uploaded the newest ones) ;)

Mr.T	08-13-2006 06:48 PM

I have dowloaded the version today, so I think it's up-to-date. But I try it once again.

hmmm. first ther is no change. but after some minutes all works.

T

All times are GMT. The time now is 07:43 PM.

Page 26 of 437

« First

126

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02355 seconds Memory Usage 1,755KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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
Messages: