vb.org Archive
Page 203 of 205 « First 103153193201202 203 204205
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - Links and Downloads Manager (https://vborg.vbsupport.ru/showthread.php?t=166094)

Ipuck 12-03-2009 01:15 AM
Quote:
I have bought licences for the new forum + CMs software and am currently trying to get me head around how things work.
They didn't give you a free copy!!! After all your hard work and all the customer that you got for them. I personally bought vB just for your hack and I may be willing to upgrade only if it possible to make LDM work with vB 4.0.

Thanks again for LDM AndrewD and I hope you are feeling better now.

Alfa1 12-03-2009 02:05 PM
I'm getting a lot of these errors:
Code:
Database error in vBulletin 3.8.3:

Invalid SQL:

                SELECT
                        link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
                        link.linkuserid AS linkuserid, link.linkusername AS linkusername,
                        link.linkurl AS linkurl, link.linkimg AS linkimg,
                        link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize,
link.linkforum AS linkforum,
                        link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
link.numcomment AS numcomment,
                        link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
                        link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS
linkmoddate,
                        link.linkreviewfreq AS linkreviewfreq,
                        ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
                        , user.userid AS userid, user.avatarid AS avatarid, user.avatarrevision AS
avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid)
AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight
                        , ltoc2.catid AS linkcatid2
                       
                        , lkeys.keyid AS linkkeyid, lkeys.keyword AS linkkey
                        FROM vb6_linkslink AS link
                        LEFT JOIN vb6_linksltoc AS ltoc ON link.linkid = ltoc.linkid
                        LEFT JOIN vb6_user AS user ON (user.userid = link.linkuserid)
                        LEFT JOIN vb6_avatar AS avatar ON (avatar.avatarid = user.avatarid)
                        LEFT JOIN vb6_customavatar AS customavatar ON (customavatar.userid = user.userid)
       
                        LEFT JOIN vb6_linksltoc AS ltoc2
                        ON link.linkid = ltoc2.linkid
               
                        LEFT JOIN vb6_linksltok AS ltok
                        ON link.linkid = ltok.linkid
                        LEFT JOIN vb6_linkskeys AS lkeys
                        ON ltok.keyid = lkeys.keyid
                WHERE link.linkforum NOT IN
(0,69,191,127,209,68,57,129,152,368,153,130,164,369,167,154,165,370,168,155,166,371,169,128,156,372,163,171,170,274,180,146,341,54,55,143,304,305,302,83,122)
 AND (link.linkid IN (-1) OR link.linkid IN
(-1,2267,355,417,928,1326,1332,1701,1752,1867,2105,2185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5068,5362,5905,6030,6197,7050,7057,7561)
OR link.linkid IN (-1))  AND link.linkstatus != -3  AND (link.linkmoderate = 0 OR
                                (link.linkmoderate = -2 AND link.linkuserid = 57101))
                          AND ltoc.catid IN
(158%2C58%2C84%2C132%2C55%2C64%2C135%2C26%2C7%2C76%2C80%2C71%2C47%2C53%2C129%2C102%2C93%2C120%2C140%2C114%2C52%2C51%2C23%2C116%2C77%2C5%2C75%2C6%2C96%2C74%2C104%2C25%2C131%2C110%2C240%2C90%2C59%2C94%2C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68%2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C154%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109%2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2C152%2C38%2C46%2C67%2C1)

                        ORDER BY  linkdate DESC, linkname ASC, linkcatid ASC;

MySQL Error  : Unknown column '2C58' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, December 2nd 2009 @ 10:27:35 PM
Error Date    : Wednesday, December 2nd 2009 @ 10:27:36 PM
Script        :
http://www.mysite.com/forum/local_links_search.php?s=&action=show&page=1&pp=40&search=academic%2Bscience%2Binternational&literal=2&desc=1&ents=1&keys=1&catlist=158%252C58%252C84%252C132%252C55%252C64%252C135%252C26%252C7%252C76%252C80%252C71%252C47%252C53%252C129%252C102%252C93%252C120%252C140%252C114%252C52%252C51%252C23%252C116%252C77%252C5%252C75%252C6%252C96%252C74%252C104%252C25%252C131%252C110%252C240%252C90%252C59%252C94%252C241%252C37%252C73%252C41%252C159%252C27%252C66%252C178%252C117%252C105%252C145%252C113%252C115%252C137%252C50%252C36%252C87%252C99%252C91%252C81%252C119%252C97%252C78%252C54%252C28%252C118%252C20%252C68%252C128%252C139%252C107%252C153%252C82%252C179%252C101%252C29%252C154%252C9%252C32%252C49%252C89%252C155%252C147%252C57%252C108%252C12%252C242%252C95%252C134%252C56%252C31%252C103%252C133%252C4%252C243%252C72%252C79%252C85%252C86%252C60%252C138%252C30%252C11%252C69%252C2%252C35%252C83%252C33%252C92%252C88%252C65%252C18%252C10%252C112%252C109%252C70%252C151%252C177%252C98%252C106%252C3%252C34%252C148%252C130%252C21%252C239%252C8%252C16%252C17%252C22%252C19%252C40%252C15%252C24%252C152%252C38%252C46%252C67%252C1&childcats=1&beforeafter=1&sort=d
Referrer      : http://www.mysite.com/forum/local_links_search.php
IP Address    : xx.xx.xx.xx
Username      :
Classname    : vB_Database
MySQL Version :
Do you have any idea what could cause this?

AndrewD 12-03-2009 03:10 PM
Quote:
Originally Posted by Alfa1 (Post 1924725)
I'm getting a lot of these errors:
Code:
Database error in vBulletin 3.8.3:

Invalid SQL:

                SELECT
                        link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
                        link.linkuserid AS linkuserid, link.linkusername AS linkusername,
                        link.linkurl AS linkurl, link.linkimg AS linkimg,
                        link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize,
link.linkforum AS linkforum,
                        link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
link.numcomment AS numcomment,
                        link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
                        link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS
linkmoddate,
                        link.linkreviewfreq AS linkreviewfreq,
                        ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
                        , user.userid AS userid, user.avatarid AS avatarid, user.avatarrevision AS
avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid)
AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight
                        , ltoc2.catid AS linkcatid2
                       
                        , lkeys.keyid AS linkkeyid, lkeys.keyword AS linkkey
                        FROM vb6_linkslink AS link
                        LEFT JOIN vb6_linksltoc AS ltoc ON link.linkid = ltoc.linkid
                        LEFT JOIN vb6_user AS user ON (user.userid = link.linkuserid)
                        LEFT JOIN vb6_avatar AS avatar ON (avatar.avatarid = user.avatarid)
                        LEFT JOIN vb6_customavatar AS customavatar ON (customavatar.userid = user.userid)
       
                        LEFT JOIN vb6_linksltoc AS ltoc2
                        ON link.linkid = ltoc2.linkid
               
                        LEFT JOIN vb6_linksltok AS ltok
                        ON link.linkid = ltok.linkid
                        LEFT JOIN vb6_linkskeys AS lkeys
                        ON ltok.keyid = lkeys.keyid
                WHERE link.linkforum NOT IN
(0,69,191,127,209,68,57,129,152,368,153,130,164,369,167,154,165,370,168,155,166,371,169,128,156,372,163,171,170,274,180,146,341,54,55,143,304,305,302,83,122)
 AND (link.linkid IN (-1) OR link.linkid IN
(-1,2267,355,417,928,1326,1332,1701,1752,1867,2105,2185,2186,3114,3798,3904,4105,4122,4303,4362,4482,5068,5362,5905,6030,6197,7050,7057,7561)
OR link.linkid IN (-1))  AND link.linkstatus != -3  AND (link.linkmoderate = 0 OR
                                (link.linkmoderate = -2 AND link.linkuserid = 57101))
                          AND ltoc.catid IN
(158%2C58%2C84%2C132%2C55%2C64%2C135%2C26%2C7%2C76%2C80%2C71%2C47%2C53%2C129%2C102%2C93%2C120%2C140%2C114%2C52%2C51%2C23%2C116%2C77%2C5%2C75%2C6%2C96%2C74%2C104%2C25%2C131%2C110%2C240%2C90%2C59%2C94%2C241%2C37%2C73%2C41%2C159%2C27%2C66%2C178%2C117%2C105%2C145%2C113%2C115%2C137%2C50%2C36%2C87%2C99%2C91%2C81%2C119%2C97%2C78%2C54%2C28%2C118%2C20%2C68%2C128%2C139%2C107%2C153%2C82%2C179%2C101%2C29%2C154%2C9%2C32%2C49%2C89%2C155%2C147%2C57%2C108%2C12%2C242%2C95%2C134%2C56%2C31%2C103%2C133%2C4%2C243%2C72%2C79%2C85%2C86%2C60%2C138%2C30%2C11%2C69%2C2%2C35%2C83%2C33%2C92%2C88%2C65%2C18%2C10%2C112%2C109%2C70%2C151%2C177%2C98%2C106%2C3%2C34%2C148%2C130%2C21%2C239%2C8%2C16%2C17%2C22%2C19%2C40%2C15%2C24%2C152%2C38%2C46%2C67%2C1)

                        ORDER BY  linkdate DESC, linkname ASC, linkcatid ASC;

MySQL Error  : Unknown column '2C58' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, December 2nd 2009 @ 10:27:35 PM
Error Date    : Wednesday, December 2nd 2009 @ 10:27:36 PM
Script        :
http://www.mysite.com/forum/local_links_search.php?s=&action=show&page=1&pp=40&search=academic%2Bscience%2Binternational&literal=2&desc=1&ents=1&keys=1&catlist=158%252C58%252C84%252C132%252C55%252C64%252C135%252C26%252C7%252C76%252C80%252C71%252C47%252C53%252C129%252C102%252C93%252C120%252C140%252C114%252C52%252C51%252C23%252C116%252C77%252C5%252C75%252C6%252C96%252C74%252C104%252C25%252C131%252C110%252C240%252C90%252C59%252C94%252C241%252C37%252C73%252C41%252C159%252C27%252C66%252C178%252C117%252C105%252C145%252C113%252C115%252C137%252C50%252C36%252C87%252C99%252C91%252C81%252C119%252C97%252C78%252C54%252C28%252C118%252C20%252C68%252C128%252C139%252C107%252C153%252C82%252C179%252C101%252C29%252C154%252C9%252C32%252C49%252C89%252C155%252C147%252C57%252C108%252C12%252C242%252C95%252C134%252C56%252C31%252C103%252C133%252C4%252C243%252C72%252C79%252C85%252C86%252C60%252C138%252C30%252C11%252C69%252C2%252C35%252C83%252C33%252C92%252C88%252C65%252C18%252C10%252C112%252C109%252C70%252C151%252C177%252C98%252C106%252C3%252C34%252C148%252C130%252C21%252C239%252C8%252C16%252C17%252C22%252C19%252C40%252C15%252C24%252C152%252C38%252C46%252C67%252C1&childcats=1&beforeafter=1&sort=d
Referrer      : http://www.mysite.com/forum/local_links_search.php
IP Address    : xx.xx.xx.xx
Username      :
Classname    : vB_Database
MySQL Version :
Do you have any idea what could cause this?
I can see that there's an obvious problem with the SQL - characters that should be commas are being transferred as %2C, which is the html escape sequence for commas. I've no idea why that should be. It looks like you are doing a search which is restricted to certain categories - I can't reproduce your problem.

Which version of LDM are you using and exactly what is the command which is triggering the error?

Alfa1 12-03-2009 11:36 PM
I'm using 2.3.0

I'm not sure what command is triggering the error. How can I find out?

AndrewD 12-04-2009 10:24 AM
Quote:
Originally Posted by Alfa1 (Post 1924968)
I'm using 2.3.0

I'm not sure what command is triggering the error. How can I find out?
I've uploaded a new version of LDM - see https://vborg.vbsupport.ru/showpost....&postcount=163

Please let me know if this resolves the problem.

Alfa1 12-06-2009 01:46 PM
I have installed the new version and can not reproduce the bug anymore.

Thank you.

archaosus 12-08-2009 11:44 PM
Quote:
Originally Posted by AndrewD (Post 1922872)
The first of these should be possible, but I will have to investigate. LDM uses two different ways of transferring downloads to the user - normally using the so-called cURL library, and alternatively using fread() calls. Although cURL itself will handle speed limits, this is not made available via the php interface, so it will be necessary to go the fread() approach.

The answer to the second question is again, 'yes'. This should be a fairly straightforward piece of coding. I will investigate.
Thanks AndrewD - I have been using the mod now for a while and have finally gotten to grips with making it look and feel the way I want so this sort of speed limitation system will really put the icing on the cake!

tamiyausa 01-26-2010 02:36 AM
I'm getting this error when trying to view local_links.php

Content Encoding Error


The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.



* Please contact the website owners to inform them of this problem.

I have uninstalled and reinstalled and reload all files for v 2.3.0

any ideas?

GearX1 02-02-2010 10:16 AM
Awesome Update thanks guys:D

chet 02-02-2010 08:32 PM
Quote:
Originally Posted by tamiyausa (Post 1966733)
I'm getting this error when trying to view local_links.php

Content Encoding Error


The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.



* Please contact the website owners to inform them of this problem.

I have uninstalled and reinstalled and reload all files for v 2.3.0

any ideas?
Same here

Code:
The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression.
Any ideas?

Ta

PS I have has this in and working for months, not sure what has changed and where


All times are GMT. The time now is 01:25 AM.
Page 203 of 205 « First 103153193201202 203 204205
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.03101 seconds
  • Memory Usage 1,804KB
  • 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_code_printable
  • (5)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