vb.org Archive

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

digital3 03-28-2007 07:09 PM

Duh..Never mind I found it.

Stop 03-28-2007 07:31 PM

Quote:

Originally Posted by AndrewD (Post 1209380)
I've taken a look at your site - you'll find that I've created a test category and put a couple of entries in it. Everything worked fine for me, once I got past some early problems with VB itself. I found that your board was continuing to give me messages about missing profile fields, even though I had entered them all.

I wonder if you are having problems with caching - messages getting trapped somewhere in the pipeline from your server to the browser.

Let me know if you are still having problems.

It was something in my laptop. I cleared the cache and deleted the cookies and it's all fine now and the hack works like a charm.
Your kind efforts are really appreciated and I thank you Sir. very much for the constant support you offer.
AndrewD Rocks ;)

digital3 03-28-2007 07:40 PM

Any ideas on why this is happening when I try to edit an entry?


Code:

Database error in vBulletin 3.6.5:

Invalid SQL:

                INSERT INTO local_linksdebug
                SET
                        userid='1',
                        settingtime='1175114301',
                        message='TRACE',
                        command='/forums/local_links_actions.php',
                        settings='a:151:{s:17:"title_data_access";s:26:"ll_settings_title_features";s:17:"close_data_access";s:0:"";s:16:"title_data_entry";s:23:"ll_settings_title_entry";s:16:"close_data_entry";s:0:"";s:13:"title_general";s:25:"ll_settings_title_general";s:13:"database_name";s:0:"";s:18:"category_jump_menu";s:1:"1";s:15:"show_hit_parade";s:1:"1";s:12:"seo_friendly";s:1:"0";s:27:"template_category_selection";s:26:"links_addnewlink_catselect";s:21:"must_comment_and_rate";s:1:"0";s:16:"monitor_template";s:14:"links_scantext";s:25:"categories_seen_on_portal";s:0:"";s:19:"days_seen_on_portal";s:2:"30";s:20:"links_seen_on_portal";s:2:"10";s:9:"word_wrap";s:1:"0";s:13:"close_general";s:0:"";s:14:"title_security";s:26:"ll_settings_title_security";s:22:"allow_remote_downloads";s:1:"1";s:15:"default_forumid";s:2:"42";s:12:"force_accept";s:1:"0";s:14:"force_redirect";s:1:"0";s:12:"force_saveas";s:1:"1";s:15:"local_file_root";s:1:"0";s:22:"local_file_root_prefix";s:0:"";s:11:"mod_rewrite";s:0:"";s:19:"profile_ldmactivity";s:1:"0";s:19:"prune_downloadtable";s:1:"0";s:15:"robots_meta_tag";s:15:"index, nofollow";s:17:"timeout_hit_allow";s:1:"0";s:21:"timeout_hit_recording";s:2:"60";s:16:"use_instructions";s:0:"";s:17:"validate_on_entry";s:1:"1";s:14:"close_security";s:0:"";s:14:"title_controls";s:26:"ll_settings_title_controls";s:12:"allow_bbcode";s:1:"1";s:10:"allow_html";s:1:"1";s:12:"allow_images";s:1:"1";s:13:"allow_smilies";s:1:"1";s:16:"allow_null_links";s:1:"0";s:16:"allow_duplicates";s:1:"1";s:14:"max_textlength";s:1:"0";s:14:"close_controls";s:0:"";s:16:"title_displayopt";s:28:"ll_settings_title_displayopt";s:13:"default_style";s:2:"-1";s:15:"template_catbit";s:12:"links_catbit";s:17:"cat_depth_display";s:1:"1";s:16:"cat_depth_indent";s:1:"3";s:15:"cat_sub_display";s:1:"0";s:23:"cat_sub_display_perline";s:1:"0";s:21:"cat_sub_display_limit";s:1:"0";s:16:"cat_cols_display";s:1:"1";s:17:"cat_name_colwidth";s:3:"20%";s:17:"cat_data_colwidth";s:3:"20%";s:11:"count_depth";s:1:"1";s:8:"cat_icon";s:0:"";s:12:"cat_icon_new";s:0:"";s:11:"subcat_icon";s:0:"";s:16:"default_cat_dseq";s:1:"1";s:14:"cat_desc_popup";s:1:"0";s:16:"close_displayopt";s:0:"";s:24:"title_displayopt_entries";s:36:"ll_settings_title_displayopt_entries";s:16:"template_linkbit";s:13:"links_linkbit";s:15:"template_altbit";s:13:"links_linkbit";s:17:"link_cols_display";s:0:"";s:14:"links_per_page";s:2:"50";s:20:"links_show_othercats";s:1:"1";s:17:"default_link_dseq";s:1:"1";s:18:"default_sort_order";s:1:"N";s:26:"open_local_links_newwindow";s:1:"1";s:27:"open_remote_links_newwindow";s:1:"1";s:14:"protected_link";s:1:"0";s:12:"show_avatars";s:1:"1";s:24:"close_displayopt_entries";s:0:"";s:14:"title_moderate";s:26:"ll_settings_title_moderate";s:14:"moderate_links";s:1:"0";s:21:"moderate_email_accept";s:1:"0";s:21:"moderate_email_submit";s:1:"0";s:17:"links_expiry_days";s:2:"-1";s:19:"links_expired_catid";s:2:"-1";s:16:"link_review_freq";s:1:"0";s:14:"close_moderate";s:0:"";s:14:"title_featured";s:26:"ll_settings_title_featured";s:23:"featured_all_categories";s:1:"1";s:18:"featured_user_favs";s:0:"";s:14:"featured_sites";s:1:"0";s:16:"featured_linkbit";s:22:"links_linkbit_featured";s:14:"close_featured";s:0:"";s:12:"title_images";s:24:"ll_settings_title_images";s:14:"link_imagesize";s:0:"";s:17:"link_imagemagsize";s:1:"0";s:14:"file_icons_dir";s:17:"images/ldm_icons/";s:10:"thumbs_dir";s:0:"";s:22:"create_thumbs_oninsert";s:1:"1";s:15:"thumbs_resample";s:1:"1";s:12:"close_images";s:0:"";s:11:"title_media";s:23:"ll_settings_title_media";s:27:"musicbox_default_sort_order";s:1:"h";s:19:"musicbox_files_seen";s:1:"5";s:26:"musicbox_standalone_height";s:3:"600";s:25:"musicbox_standalone_width";s:3:"800";s:14:"musicbox_width";s:3:"760";s:23:"open_musicbox_newwindow";s:1:"1";s:11:"close_media";s:0:"";s:12:"title_search";s:24:"ll_settings_title_search";s:18:"default_search_all";s:1:"1";s:19:"default_search_desc";s:1:"1";s:19:"default_search_keys";s:1:"1";s:10:"enable_doi";s:1:"0";s:16:"match_using_like";s:1:"0";s:19:"profile_searchfield";s:2:"-1";s:14:"search_linkbit";s:13:"links_linkbit";s:17:"search_like_favwt";s:1:"1";s:17:"search_like_hitwt";s:1:"1";s:17:"search_like_keywt";s:1:"1";s:15:"search_like_num";s:1:"5";s:15:"search_like_own";s:1:"0";s:12:"close_search";s:0:"";s:17:"title_synchronise";s:29:"ll_settings_title_synchronise";s:12:"sync_enabled";s:1:"0";s:9:"sync_freq";s:5:"86400";s:14:"sync_filetypes";s:0:"";s:24:"sync_populate_categories";s:1:"0";s:21:"sync_populate_entries";s:1:"1";s:19:"sync_maxcpu_allowed";s:1:"2";s:26:"sync_maxcpu_allowed_manual";s:2:"10";s:10:"sync_depth";s:1:"1";s:13:"sync_username";s:0:"";s:17:"close_synchronise";s:0:"";s:12:"title_upload";s:24:"ll_settings_title_upload";s:10:"upload_dir";s:12:"/attachments";s:14:"upload_enabled";s:1:"1";s:16:"upload_filetypes";s:0:"";s:15:"upload_maxspace";s:1:"0";s:12:"close_upload";s:0:"";s:11:"title_debug";s:23:"ll_settings_title_debug";s:5:"DEBUG";s:1:"0";s:5:"TRACE";s:1:"1";s:11:"close_debug";s:0:"";s:12:"title_addons";s:0:"";s:12:"links_catbit";s:101:"a:4:{s:4:"name";s:7:"Tabular";s:6:"defcol";i:1;s:6:"maxcol";i:4;s:6:"subbit";s:15:"links_subcatbit";}";s:18:"links_catbit_brief";s:99:"a:4:{s:4:"name";s:5:"Brief";s:6:"defcol";i:2;s:6:"maxcol";i:4;s:6:"subbit";s:15:"links_subcatbit";}";s:12:"this_version";s:5:"2.2.7";s:17:"version_installed";s:1:"1";s:15:"bandwidth_limit";s:2365:"a:13:{i:1;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";i:0;s:11:"bytesenable";i:0;s:10:"filesdaily";i:0;s:11:"filesenable";i:0;s:11:"uploadlimit";i:0;s:12:"uploadenable";i:0;}i:2;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:100;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:3;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";i:0;s:11:"bytesenable";i:0;s:10:"filesdaily";i:0;s:11:"filesenable";i:0;s:11:"uploadlimit";i:0;s:12:"uploadenable";i:0;}i:4;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";i:0;s:11:"bytesenable";i:0;s:10:"filesdaily";i:0;s:11:"filesenable";i:0;s:11:"uploadlimit";i:0;s:12:"uploadenable";i:0;}i:5;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:1000;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:6;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:5000;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:7;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:500;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:8;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";i:0;s:11:"bytesenable";i:0;s:10:"filesdaily";i:0;s:11:"filesenable";i:0;s:11:"uploadlimit";i:0;s:12:"uploadenable";i:0;}i:10;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:200;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:11;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:400;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:12;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:300;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}i:13;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";i:0;s:11:"bytesenable";i:0;s:10:"filesdaily";i:0;s:11:"filesenable";i:0;s:11:"uploadlimit";i:0;s:12:"uploadenable";i:0;}i:14;a:7:{s:12:"carryforward";i:1;s:10:"bytesdaily";d:1.024E+8;s:11:"bytesenable";i:1;s:10:"filesdaily";i:500;s:11:"filesenable";i:1;s:11:"uploadlimit";d:1.024E+8;s:12:"uploadenable";i:1;}}";s:11:"sync_userid";s:1:"0";s:29:"ldm_player_WindowsMediaPlayer";s:426:"a:10:{s:4:"name";s:18:"WindowsMediaPlayer";s:8:"priority";i:10;s:7:"enabled";i:1;s:16:"filetypes_played";s:44:"mpg, mpeg, wmv, mp3, swf, asf, wma, avi, wav";s:9:"playerbit";s:27:"links_playerbit_MediaPlayer";s:5:"opsys";a:3:{s:7:"Windows";i:1;s:5:"Linux";i:0;s:3:"Mac";i:0;}s:4:"vars";a:2:{s:12:"player_width";s:3:"320";s:13:"player_height";s:3:"240";}s:13:"player_stream";s:6:"stream";s:9:"urlencode";i:0;s:8:"ismaster";i:1;}";s:25:"ldm_player_QuickTimeAudio";s:387:"a:10:{s:4:"name";s:14:"QuickTimeAudio";s:8:"priority";i:8;s:7:"enabled";i:1;s:16:"filetypes_played";s:13:"mp3, wma, wav";s:9:"playerbit";s:25:"links_playerbit_QuickTime";s:5:"opsys";a:3:{s:7:"Windows";i:1;s:5:"Linux";i:0;s:3:"Mac";i:1;}s:4:"vars";a:2:{s:12:"player_width";s:3:"240";s:13:"player_height";s:2:"16";}s:13:"player_stream";s:6:"stream";s:9:"urlencode";i:0;s:8:"ismaster";i:1;}";s:20:"ldm_player_QuickTime";s:407:"a:10:{s:4:"name";s:9:"QuickTime";s:8:"priority";i:8;s:7:"enabled";i:1;s:16:"filetypes_played";s:38:"mov, qt, mpg, mpeg, wmv, swf, asf, avi";s:9:"playerbit";s:25:"links_playerbit_QuickTime";s:5:"opsys";a:3:{s:7:"Windows";i:1;s:5:"Linux";i:0;s:3:"Mac";i:1;}s:4:"vars";a:2:{s:12:"player_width";s:3:"320";s:13:"player_height";s:3:"256";}s:13:"player_stream";s:6:"stream";s:9:"urlencode";i:0;s:8:"ismaster";i:1;}";s:21:"ldm_player_RealPlayer";s:428:"a:10:{s:4:"name";s:10:"RealPlayer";s:8:"priority";i:3;s:7:"enabled";i:1;s:16:"filetypes_played";s:56:"mp3, mpg, mpeg, avi, mov, qt, ra, ram, rm, rmvb, rpm, rv";s:9:"playerbit";s:26:"links_playerbit_RealPlayer";s:5:"opsys";a:3:{s:7:"Windows";i:1;s:5:"Linux";i:1;s:3:"Mac";i:1;}s:4:"vars";a:2:{s:12:"player_width";s:3:"320";s:13:"player_height";s:3:"240";}s:13:"player_stream";s:6:"stream";s:9:"urlencode";i:0;s:8:"ismaster";i:1;}";s:15:"ldm_player_DivX";s:368:"a:10:{s:4:"name";s:4:"DivX";s:8:"priority";i:5;s:7:"enabled";i:1;s:16:"filetypes_played";s:9:"divx, avi";s:9:"playerbit";s:20:"links_playerbit_DivX";s:5:"opsys";a:3:{s:7:"Windows";i:1;s:5:"Linux";i:1;s:3:"Mac";i:1;}s:4:"vars";a:2:{s:12:"player_width";s:3:"320";s:13:"player_height";s:3:"240";}s:13:"player_stream";s:7:"fullurl";s:9:"urlencode";i:0;s:8:"ismaster";i:1;}";}',
                        get='a:0:{}',
                        post='a:29:{s:7:"subject";s:3:"LDM";s:6:"action";s:10:"doeditlink";s:6:"linkid";s:1:"1";s:5:"catid";s:1:"1";s:4:"page";i:1;s:7:"linkdoi";s:0:"";s:8:"linkname";s:30:"Paris Hilton - Stars Are Blind";s:7:"message";s:136:"Ha! Just a music video I am using to test the module. Made ya look though, didn't it?<br><br><img src="images/thumbnails/paris.jpg"><br>";s:7:"wysiwyg";s:1:"1";s:8:"keywords";a:5:{i:0;s:1:"3";i:1;s:1:"2";i:2;s:1:"1";i:3;s:1:"4";i:4;s:1:"5";}s:11:"newkeywords";s:0:"";s:7:"linkurl";s:55:"http://flamers-heaven.com/forums/media/video/hilton.wmv";s:13:"MAX_FILE_SIZE";s:8:"96916912";s:8:"linkfile";s:0:"";s:7:"linkimg";s:0:"";s:9:"imgupload";s:0:"";s:8:"linkuser";s:12:"Eccentricity";s:4:"date";a:7:{s:5:"month";s:1:"3";s:3:"day";s:2:"28";s:4:"year";s:4:"2007";s:4:"hour";s:2:"02";s:3:"min";s:2:"29";s:4:"ampm";s:1:"2";s:3:"now";s:1:"1";}s:9:"expirenow";s:1:"0";s:6:"pcatid";a:1:{i:0;s:1:"1";}s:6:"pforum";s:2:"42";s:14:"linkreviewfreq";s:1:"0";s:6:"notify";s:1:"0";s:13:"display_order";s:1:"1";s:20:"change_display_order";s:1:"2";s:4:"hide";s:1:"0";s:6:"submit";s:6:"Submit";s:10:"pagenumber";R:6;s:4:"ajax";i:0;}',
                        files='a:1:{s:10:"linkupload";a:5:{s:4:"name";s:0:"";s:4:"type";s:0:"";s:8:"tmp_name";s:0:"";s:5:"error";i:4;s:4:"size";i:0;}}',
                        cookie='a:17:{s:20:"psistats_screenwidth";i:1280;s:21:"psistats_screenheight";i:720;s:20:"psistats_screendepth";i:32;s:14:"bblastactivity";i:0;s:18:"vbulletin_collapse";s:0:"";s:9:"bbstyleid";i:27;s:8:"bbuserid";i:1;s:10:"bbpassword";s:32:"41d6a97f1edbc5c5658c5c747eb34552";s:11:"bblastvisit";i:1174445153;s:13:"bbsessionhash";s:32:"4c7a8e46f9f0f7ec1392d33090924ab8";s:11:"bbcpsession";s:32:"83bf66f902e6c2c7cdade749257f324a";s:17:"bbarcade_viewdata";s:82:"6921c80555afeeb033e020d0745c6f0fa-2-{s-10-.categoryid._i-0_s-10-.pagenumber._i-1_}";s:9:"PHPSESSID";s:32:"86fdb35d41c77b00a4a7b93d9f6c7626";s:9:"bbbarsize";s:1:"0";s:12:"bbreferrerid";i:0;s:14:"bbthreadedmode";s:0:"";s:12:"bblanguageid";i:0;}';

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 't it?<br><br><img src="images/thumbnails/paris.jpg"><br>";s:7:"wysiwyg";s:1:"1";' at line 9
Error Number : 1064
Date        : Wednesday, March 28th 2007 @ 04:38:21 PM


Ophelia 03-28-2007 08:41 PM

Quote:

Originally Posted by AndrewD (Post 1214542)
Noted - all well with you?

Yes thank you :) My little one is almost 2 months old now! Hope your vacation was relaxing!

digital3 03-29-2007 12:31 AM

The problem is that apostrophes are causing the SQL error. Has a fix been posted for this that I am unaware of?

itsblack 03-29-2007 03:16 AM

Hi Andrew, I wish I can delete the uploaded image when I edit the entry. Now I can only replace it with new one. Can you add this function in the next version? Thank you.

AndrewD 03-29-2007 04:10 AM

Quote:

Originally Posted by digital3 (Post 1214930)
The problem is that apostrophes are causing the SQL error. Has a fix been posted for this that I am unaware of?

Sorry, this should not have slipped through. But it's happening because you've enabled either tracing or debugging on the LDM admin page. I recommend you turn these off, not least because you'll fill your database.

I'll post a fix for this and other reported bugs when possible

AndrewD 03-29-2007 04:13 AM

Quote:

Originally Posted by itsblack (Post 1215005)
Hi Andrew, I wish I can delete the uploaded image when I edit the entry. Now I can only replace it with new one. Can you add this function in the next version? Thank you.

Sure, will put this on the list

Demon fox 03-29-2007 04:18 AM

Hey Andrew im having a little problem. When files are uploaded through LDM there names are changed into numbers making it difficult for us to know what they are on the server. But the main problem is that when they get downloaded the name doesnt change even when its set to be renamed differently when downloaded.

Demon fox 03-29-2007 04:42 AM

It seems you need to have force redirect set to 0 for it to work I have mine set to 1 so users can use download managers. But if I set it to 0 users cant use download managers. Any way to get around this?

Edit: Perhaps the best way to get around it would be making it so that when files get uploaded the name doesnt get changed to straight numbers.


All times are GMT. The time now is 03:34 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.03394 seconds
  • Memory Usage 1,809KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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