Major Additions - Links and Downloads Manager

What this is and does

LDM is a general-purpose tool for managing libraries of links and files, and handling uploads and downloads in a flexible way, while tracking and control user access. It has a range of integrated media players and a large library of 'plugin' extras.

Installation and Usage Explained in the on-line Wiki, with a brief explanation in the file instructions.txt in the release zip. The recent revision history is given in the first post of this thread.

Please use carefully and always backup your database before upgrading. Post reports of problems and suggestions for enhancements in this thread.

14.06.09 Version 2.3.0 is now the the officially-supported version. Works with 3.7 and vb 3.8. Please post comments in this thread

22.06.08 Version 2.2.9-post1 - This is the previous supported version. Works fine with all versions of vb 3.6 and vb 3.7. All standard features except profile integration and forum prefix selection work fine with vb 3.8.

[AndrewD]

Originally Posted by pooslokka

i found a bug, pls help to solve it.

i cant upload a 3325 x 2081 jpg image with 800k. The out put is a blank page.
but i can upload a 1920 x 1200 with 900k successfully.

whats wrong??? in vb cp under attachments. the max width and height for jpg images are set to unlimneted. i even try chnaging it to 10000 x 10000. no use

pls help

Blank pages are often a sign that there has been a 'system' error, but a standard vbulletin settings has prevented the error message from being displayed. A first thing to go to your vb/admin/options/Cookies and HTTP Header Options and turn off the option GZIP HTML Output. See if you then get an error message or still get a blank screen. If there is an error message, post it here.

Otherwise, it gets more difficult to debug what is happening. The file size (800K) should not be a problem. I don't know which version of LDM you are using - version 2.2.9-post 1 does not apply the size limits in the vb/cp/attachments table; 2.2.9-post 3 does check (but only the overall filesize, not the image dimensions). In any case, I cannot reproduce this problem myself with either 2.2.9-post1 or 2.3.0-beta.

[sparklywater]

Hello Andrew,

I sometimes get these database errors when trying to access LDM pages. I don't know what exactly is causing these errors. Here is an example of one of these error-messages:

Database error in vBulletin 3.7.2:
 
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.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.*, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
			
			
			, lkeys.keyword AS linkkey
			FROM local_linkslink AS link
			LEFT JOIN local_linksltoc AS ltoc ON link.linkid = ltoc.linkid
			LEFT JOIN user AS user ON (user.userid = link.linkuserid)
			LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
			LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
	
			LEFT JOIN local_linksltok AS ltok
			ON link.linkid = ltok.linkid
			LEFT JOIN local_linkskeys AS lkeys
			ON ltok.keyid = lkeys.keyid
		 WHERE link.linkforum NOT IN (0)  AND ltoc.catid = '2'  AND link.linkmoderate = 0 
			ORDER BY linkdorder ASC,   linkname ASC,  linkcatid ASC;
 
MySQL Error   : Got error -1 from storage engine
Error Number  : 1030
Request Date  : Saturday, March 28th 2009 @ 12:18:05 PM
Error Date    : Saturday, March 28th 2009 @ 12:18:06 PM
Script        : http://www.sparklywater.com/category/2.html
Referrer      : http://www.sparklywater.com/
IP Address    : 69.117.150.25
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[AndrewD]

Originally Posted by sparklywater

Hello Andrew,

I sometimes get these database errors when trying to access LDM pages. I don't know what exactly is causing these errors. Here is an example of one of these error-messages:

Database error in vBulletin 3.7.2:
 
 
MySQL Error   : Got error -1 from storage engine
Error Number  : 1030

This looks like a database problem, although I'm not certain. Try going to vb/admincp and doing a database repair.

[Simon Lloyd]

Originally Posted by sparklywater

WHERE link.linkforum NOT IN (0) AND ltoc.catid = '2' AND link.linkmoderate = 0
ORDER BY linkdorder ASC, linkname ASC, linkcatid ASC;

I don't know a great deal and especially databases, however it seems the problem lies with where the data was being checked from as in the above (link.linforum NOT IN.....etc) seems to be looking at forum id 0 i might be wrong?

[AndrewD]

Originally Posted by Simon Lloyd

I don't know a great deal and especially databases, however it seems the problem lies with where the data was being checked from as in the above (link.linforum NOT IN.....etc) seems to be looking at forum id 0 i might be wrong?

no, it's telling sql *not* to look in forum id 0. the sql statement is constructed to avoid forums that the current user does not have permission to view. Forum id 0 is added to ensure a valid sql statement - it never actually exists.

[Simon Lloyd]

Ah, thanks....didn't i say i don't know much?

[sparklywater]

I also get the following error message when trying to export my LDM database (XML file) through the LDM AdminCP. I've tried exporting the file in the zipped format but I still get the same error message.

Fatal error: Out of memory (allocated 50593792) (tried to allocate 36962281 bytes) in /home/sparklyw/public_html/includes/class_xml.php on line 571

I have spoken to my webhost about increasing the memory limit, and they've told me that the maximum memory allocated to each user on the server is 50MB. They've said that if I want to export the LDM database, I will have to reduce the amount of information in the XML file. Since I'm not able to increase my memory limit, is there any alternative to how I can backup my LDM database?

[Neutral Singh]

It would be great if there was a kind of automated playlist of various songs which could be embedded and played directly from the home page of the forum.

[abdelghani68]

Hi andrew,

I have frequently a data base error when I put a comment :

Database error in vBulletin 3.8.1:

Invalid SQL:

            UPDATE local_linksrate
            SET
                lcomment = '***:

 ***',
                linkuserid='1',
                linkusername='****'
            WHERE lrate = 3;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'autre. ?  Et ensuite. [A-Ber' at line 3
Error Number  : 1064
Request Date  : Monday, March 30th 2009 @ 11:59:57 PM
Error Date    : Monday, March 30th 2009 @ 11:59:57 PM
Script        : http://www.*****.fr/forum/local_links_actions.php
Referrer      : *******
IP Address    : **********
Username      : *******
Classname     : vB_Database
MySQL Version : 5.0.68-log

[AndrewD]

Originally Posted by sparklywater

I also get the following error message when trying to export my LDM database (XML file) through the LDM AdminCP. I've tried exporting the file in the zipped format but I still get the same error message.



I have spoken to my webhost about increasing the memory limit, and they've told me that the maximum memory allocated to each user on the server is 50MB. They've said that if I want to export the LDM database, I will have to reduce the amount of information in the XML file. Since I'm not able to increase my memory limit, is there any alternative to how I can backup my LDM database?

A possible source of this problem is that your LDM 'downloads' table has grown very large. You can prune this manually or automatically. Visit your LDM admin page and see if there is a message of this form:

There are currently NNN records in the LDM Download 'Hits' table. You are likely to see reduced performance when using the LDM show_hit_parade setting to show overall statistics, and when analysing hits with LDM/Admin/Hits. Consider setting prune_downloads or use LDM/Admin/Hits to manually delete some of these records.

If so, follow the instructions, and you should find that the xml export works ok.