vb.org Archive

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)

AndrewD 03-27-2009 08:34 AM

Quote:

Originally Posted by pooslokka (Post 1774367)
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 03-28-2009 06:16 PM

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:

Code:

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 03-29-2009 06:34 AM

Quote:

Originally Posted by sparklywater (Post 1779150)
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:

Code:

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 03-29-2009 06:53 AM

Quote:

Originally Posted by sparklywater (Post 1779150)
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 03-29-2009 08:52 AM

Quote:

Originally Posted by Simon Lloyd (Post 1779557)
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 03-29-2009 11:39 AM

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

sparklywater 03-29-2009 12:43 PM

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.

Quote:

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 03-29-2009 02:16 PM

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 03-30-2009 09:09 PM

Hi andrew,

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

Code:

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 03-31-2009 04:36 AM

Quote:

Originally Posted by sparklywater (Post 1779669)
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.


All times are GMT. The time now is 11:25 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.02871 seconds
  • Memory Usage 1,766KB
  • 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
  • (6)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