Drain Hole Plugin

438 comments

1. Drain Hole sounds a wonderful idea but it is causing me some problems. I installed the plugin as directed and from the options page gave it a directory (“downloads”) which contains the files i have for download. The files are listed correctly in the options page. However when I try to download one of them I get a 404 page saying:

   The requested URL /wp-content/plugins/drain-hole/drain_plumber.php was not found on this server.

   This was when I tried to download for example:

   http://rmarshsj.f2s.com/rob/downloads/aevr.pdf

   which seems to be the right url and Filezilla confirms is present.

   My next step was to deactivate and remove Drain Hole and delete the drain hole tables. The same url to aevr.pdf still gets the same 404 message that drain_plumber is missing.

   Help!!!
   Rob

2. Pingback: Sideways - 这伟大而恶心的时代 » [wordpress插件] 几个插件介绍

3. Hello. I’ve got some problems using this plugin. The tables and the htaccess are well created, but no file appears in the options page. And when I click on the ‘Update’ button, I receive this error message :

   Warning: Invalid argument supplied for foreach() in drain_hole.php on line 27

   Warning: Invalid argument supplied for foreach() in drain_hole.php on line 54

   What can I try ?

4. Pingback: 牛建国的发言 » WordPress插件

5. […] Drain Hole：统计某个目录下的文件下载情况的插件。下载。 […]

6. Any way you could add a feature to be able to add a name and description through the Drain Hole admin area? And then of course corresponding template tags?

7. hi,
   im triying the plugin but i dont know what to do with this errors after plugin was activated:

   WordPress database error: [Table ‘wordpress.wp00_drainhole_access’ doesn’t exist]
   DELETE FROM wp00_drainhole_access WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY) > created_at

   WordPress database error: [Table ‘wordpress.wp00_drainhole_holes’ doesn’t exist]
   SELECT * FROM wp00_drainhole_holes ORDER BY url

   Could you help me?
   Regards,

8. Jorge, problem fixed in 1.1.2. You’ll need to deactivate and re-activate the plugin

9. Hi,

   I’ve got Drain Hole installed and I have Redirection installed.

   I created a drain hole with
   URL ‘/download/project/jhdi’
   DIR ‘/home/blogpeer/Downloads/Projects/JHDI’
   AL ‘Subscriber’
   FAIL ‘/download/project/404’

   I went into the files section for the new hole and rescanned the directory, and it found and listed the file I had placed there.

   I added the code to a post ‘[drain file 1 url (download)]’ and it correctly displayed the URI link I expected. However when i click on the link it generates a 404 error.

   Any Ideas what I might be missing?

10. Oh great. It is almost what I need. Is it compatible with WordPress 2.2?

    Is it possible to add in Download Statistics the IP address of who was downloading the file?
    And second thing. If somebody wonts to download a file has to give an email address. Possible?

11. Yes it works in 2.2.

    The download stats already tell you the IP address.

    You can configure Drain Hole to restrict downloads to registered users. A registered user would need to have given an email address.

12. The plugin is great but one think is missing here.
    To add a file to a post, first I have to add a file, see what ID it has and then go to the post and add.
    [drain file ID url]

    Is it possible to do it automatically?

    Let say I will put in my post [drain hole ID] and every file that is in this “hole” will be automatically added to my post and all files will be shown as a list.

    I would be really cool because I will have to only add a file to specific “hole” and it will automatically appear on my site.

    Do you think is possible?

13. @Drain Hole: I have the same problem.
    John can you tell us what is the problem? Maybe something in .htaccess??

14. Tino,

    That’s a great suggestion and I’ve added it to the plugin (see [drain hole ID show])

    Dane: Are there any messages in the redirection logs?

15. Hi John,

    I’m having the same problem as Dane using WP 2.2 with the latest versions on drain hole and redirection. Both FTP’d and activated fine.

    I configured a drain hole as follows:
    URL: /robo/downloads/bee_patents
    Directory: /home/bushkill/downloads/bee_patents
    Access Level: Anybody
    error redirect: http://www.********.com/404.shtml

    rescanned the directory and all the files where found. Created a post with [drain file 1 show] and it displays the correct link, http://********.com/robo/downloads/bee_patents/US03994034 Beehive Heater.pdf
    But when you click on it I get a 404 error, but not the 404 error redirect defined in the hole.

    I checked the redirection logs as you suggested to Dane, but they are empty. Is there any configuration of redirection required other than activating to use drain hole?

    Any help would be appreciated as all other download plug-ins I’ve looked at pale in comparison to drain hole.

16. [drain hole ID show] this is great but maybe one more thing.

    Now I can put on my page [drain hole ID show] and I will have list of all files generated autmatically:

    My files
    -file 1
    -file 2
    -file 3
    -file 4

    But, now I would like to have on this site not one category but two, for example:

    My files 1
    -file 1
    -file 2

    My files 2
    -file 3
    -file 4

    It will be possible if there will be a possibility to add two or more drain holes to one page so I will have:

    My files 1
    [drain hole ID show]

    My files 2
    [drain hole ID show]

    or think about category? Every file will have category and then we will use for example
    [drain hole ID show catID]

    Or do category by subfolders?

    What do you think John?

17. No John, not for any of the drain hole stuff. I am using redirection itself now too, and it’s logging those, but never did log anything for drain hole except the 404 errors generated by clicking the drain hole links.

    Incidentally, I was never sure whether creating a drain hole should also create a new record in the redirection tables, but in my case it does not.

18. Hi John,

    I finally set up Drain Hole (1.1.3) and Redirection (1.7.9) on the KC site but I also seemed to get issues with 404s. However, after manually setting up the redirection I managed to get it to work.

    I was wondering if Drain Hole is supposed to be creating the redirection automatically, or is this just a step that I missed in the installation?

    Cheers,

    Zain 🙂

19. Perhaps I haven’t read through all of the comments quite enough, but is there a way to show the stats in, perhaps, a sidebar? Ideally I’m looking at showing a “top downloads” type statistic. I’ll poke around the code as well. Great plugins btw.

20. tino: You can already do that – just create two drain holes and do exactly what you wrote.

    miklb: A good suggestion and added to 1.1.4. See the updated docs for details

    Dane, Rob, & Zane: Drain Hole shouldn’t create anything in Redirection. The plugins work together so that it happens transparently to you (at least, that’s the theory). I’ll look into this problem some more

21. Looks like an excellent plugin – I look forward to installing it this weekend. 🙂

22. Well, I thought maybe I had a plugin conflict, but I installed a fresh WP install and I’m still getting the same thing. Everything works up until I click on a generated drainhole file download link. Then i get the 404.

23. Hey John if any of my setup/config info will help let me know what you need and I’ll send it to ya. I’d really like to get this to work. It’s everything you could hope for in a download manager.

24. Rob, Dane, and Zain: I found the problem! You need to get Redirection 1.7.10

25. perfect! You Rock, Man!

26. Hi, John! Nice to see there’s a new version available! Great plugin! I have a doubt though: what mime type do I set for .png files? Do you intend to add ‘image/png’?

27. Pingback: WP Plugins DB » Plugin Details » Drain Hole

28. Hi
    Drain-Hole, not functional in my hosting (Hostgator). I think the problem is with redirections.

    I have Drain-Hole in wp 2.2.1 in a server at HOME and the pugin work very well.
    Anyone can help me in this?
    Thanks

29. Drain-Hole, didn’t work in my wordpress 2.2.1
    I need help.

30. Problem solved.
    It’s a problem in htaccess fil with permanent links.
    Confirmed, plugin work in wp 2.2.1

31. […] con el cual tenemos ahora un sistema de galería de imágenes integrado al blog; también tenemos Drain Hole, que es un gestor y monitor de descargas con muchas características. Conforme tengamos más […]

32. Great set of plugins.

    One question. Are there plans to add an optional description field for each file? So if I want to give a quick note of what the file is, I can?

    Thanks.

33. Jose: I’ll make the next version auto-detect if a file is PNG

    Graeme: A description to be display only in the admin interface, or one that would also appear on the website?

34. I was thinking of something that would appear on the site, but optional so you could enter a description to show on the site for each file, if you wanted one, but a description wouldn’t be compulsory.

    Also, is there any way to list ALL the files in the hole? i.e. instead of:

    [drain file 7 show drainhole]
    [drain file 8 show drainhole]
    [drain file 9 show drainhole]

    something like:

    [drain file * show drainhole]

    Thanks.

35. Never mind the 2nd request. I just realised you’ve already provided that mechanism – to display the whole hole.

    Helps to read the docs… D’oh!

36. Hi there, i like this plugin, thanks…
    but, why do i have to use redirekt plugin? it works also wihtout Redirection plugin….
    What does not work is the download counter, when i create a List with [drain hole 1 show]
    there is always 0 (zero) ??
    any idea why?

37. Tom, you are not getting any download counting because you are not using Redirection. I would also guess you have your files in a publically accessible directory?

    The ideal way of using Drain Hole is to store all your files in a private directory (i.e not in public_html) and then use the plugin, in collaboration with Redirection, to make the files available publically. See the ‘Usage’ section for more details.

38. Hi, a returning visitor/user of your other plugin =P. I’m just wondering if it’s also good to have an enabled password protected directory or link? Well, this–password protected part of the post– can probably be achieved by the Post Tools plugin by Headzoo.com…Is there an interest in adding this measure John =?

39. I’m not sure what you mean M.T? You can restrict access to files by setting the access level in Drain Hole

40. Hi John, great plugins!
    However, i have the same problem with Rob, Dane and Zain. in comments no 21 You said that we need to get Redirection 1.7.10. Where can i find it? Now im using 1.7.11.
    Thanks

41. bhina, 1.7.10 or greater. Are you using permalinks?

42. Hi John, i don’t use pemalinks in my blog. should I ?

43. Hi John, I think the problem is not in Drain Hole but in Rederection. My server still use PHP 4.4.7. Guess its not working for this version. Or maybe you have other solution?

44. You don’t need to be using permalinks, but you need to have a .htaccess file created for you (when saving permalinks). Without this any access to a file will not go through WordPress.

45. hello
    First thanks for the plugin.

    However I have a problem :
    whatever is access level, downloads are possible. I guess I have missed something… but what?

46. Hi John,
    I have a .htaccess file. But its located in home/bhina/public_html/ while my blog is installed in /home/bhina/public_html/bhinablog. This is what the .htaccess looks like:

    php_flag session.use_trans_sid off
    php_value arg_separator.output ‘&’

47. Hi John, you’re right. after i create permalinks and save it now it works. Thanks for your support.

48. Hi, I want first thank you for the great plug in.

    Now I have a problem. I hope you can help me out.

    I accidentally deleted a database and now I am getting error massages like:

    [WordPress database error: [Table ‘database1. contentsdrainhole_access’ doesn’t exist]
    DELETE FROM contentsdrainhole_access WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY) > created_at]

    I want to start over by reinstalling this plug in.
    How can I clean re-install this?

49. Is there anyway to have a Drain Hole file in a page template rather than a page post?
    thanks,

    / Hami

50. Hello,

    Using drain-hole 1.1.4, wp2.2.2 and redirect 1.7.14, I add my drain holes using:

    URL: /filevault
    DIR: /home/frank/filevault/

    My webserver is running in /home/frank/www/wordpress/ (I have copied index.php with modifications to /home/frank/www/ so I get my blog by just typing the URL address, and not needing to prefix it with wordpress/)

    I can list the files in the drain hole from the admin page, and I can create download-URLs by using [drain file 1 url Download me!] which shows up in pages/posts. But when I press this link, I just get

    "The requested URL /filevault/test.jpg was not found on this server."

    No logs in the redirect plugin either, so I’m pretty clueless right now what’s wrong. I appreciate any input on this issue, as the plugin seems to do exactly what I want from it, but right now I can’t use it.

51. Excellent plug-in, we are using it on one of our other blogs to manage the downloads of our WP Mega Feedjit Widget, but for some strange reason, we are unable to download files in FireFox.

    We were able to see it when previewing the post, and downloaded a file from there, and then published that post, but after publishing it, we were unable to click on the icon or the file name. Is it because we have already downloaded the file? In internet Explorer, we were able to click on it, and even after that, we could click it agin (but did not do so due to not wanting to create fake statistics). If this is the case, it is a good reason to do so, but we are concerned about updates, at which point, will FireFox start working again, or is it really a bug in the plug-in itself…?

52. Finally got it working, though it seems it does not support spaces in the filename. I’ve tried downloading the file using both [drain file foobar]. Both works when filename does not contain spaces, but none work if it contains spaces.

    The "strange" thing is that filenames with spaces are recognized and listed in the drain hole nonetheless.

53. Hi,

    have some problems with counting. All other is working…maybe it has something to do with redirection plugin…how i have to configure it to make counting work?
    e.g. for an structure like this:
    http://www.example.com/downloads/files
    http://www.example.com/downloads/pictures

    what is the setting in redirection? Source URL? Target URL? Type and mehtod? i dont understand 🙁
    And the Statistic retention could not be save…

    please help…thx

54. great plugin but,

    it would be great to have a separate caption field for each file which supports spaces in filenames.
    now every file is shown as "file_name.extension" on my site, but i would like to have it like "file name" only. Which then redirects to "file_name.extension".

    Maybe you can implement that.

    regards

    chris

55. Hi again,
    have also problem with no counting, everything work fine bunt counting is always 0
    any ideas?

    Tomsn

56. It don’t work for me when I press create drain hole it give me a download dialog asking me download edit.php

57. A shiny new version has been released adding a lot of functionality. This should take care of most of the reported problems. Redirection is no longer required.

    Tomsn, it is probably because your files are stored in public_html. Files should be stored outside of your public area.

    Trish, is your site properly configured to run PHP? That kind of behaviour is usually associated with bad Apache configuration.

58. activating the plugin gives me an fatal error.
    I used 0.1.7 prior upgrading to 2.0
    I deactivated 0.1.7, deleted the folder and uploaded 2.0. Activation of the plugin ends up in an fatal error.

    Any ideas?

    regards

    chris

59. Hi John
    it is not possible for me to store the files outside public_html, i have webspace from a Provider, its not my own server!!

60. I had the same problem as chris (fatal error). I’m using WP 2.2.3 and WAS using drain-hole 1.1.4…

    Another question: How do I delete a drain hole WITHOUT deleting the files?

61. Hi John
    I get the same error as Trish (using DH 2.0.0, WP 2.2.3), the server is recently built, any detail about what you might mean by "bad Apache configuration" so I can give my sys admin a nudge? WordPress generally appears to otherwise run ok on this server…

62. Tomsn, you can still store files outside of public_html. Every provider should give you a ‘home’ directory (something like /home/yourname/). You can create files in this directory just like any other. It’s only files in /home/yourname/public_html that are available to the world.

    Trish and YikYak, there’s a support page here which suggests a number of causes for this problem. Why it would only occur with Drain Hole I don’t know, but other people get similar effects (with WordPress in general) that seem to be caused by Google Toolbar, gzip compression, old cookies, or Apache configuration. See if anything there is helpful – it may be something as simple as clearing out cookies for your site.

    Jose, there’s now an option to enable or disable file deletions.

    Do you have any more details on the fatal error? I’ve tried installing it on a clean WP install and everything goes fine.

63. Ah, that did the trick Colin, my new zip routine was stripping slashes. Fixed. Incidentally, it seems that WP 2.3 shows details about why a plugin failed – very useful!

64. John, now it works fine. Actually, I didn’t even notice any of the problems Colin did (yet).

    But I noticed these messages on the bottom of Options Page:
    WordPress database error: [MySQL server has gone away]
SELECT count(*) FROM wp_fs_visits

    WordPress database error: [MySQL server has gone away]
    SELECT time_install FROM wp_fs_data

    WordPress database error: [MySQL server has gone away]
    SELECT max_visits FROM wp_fs_data

    WordPress database error: [MySQL server has gone away]
SELECT max_visits_time FROM wp_fs_data

65. I upgraded from 1.1.4 to 2.0.2

    Activating works, BUT..

    i can not delete a drain hole, which i build in 1.1.4
    i can not make a new hole, trying that ends up in the following error message:

    WordPress Database Error: [Unknown column ‘hotlink’ in ‘field list’]
    INSERT INTO wp_drainhole_holes (url,directory,role,role_error_url,hotlink) VALUES (‘/download’,’/srv/www/htdocs/web72/html/sisoweb/musik’,NULL,’/download’,”)

    The Drain Hole was not created – you must supply a unique URL and directory

    and, after activating the new plugin, the downloads on my site do not work, i get an 404 error.
    So atm, downloading an old 1.1.4 drain hole does not work, building a new one does not work and deleting an old one does not work.

    AND, i can not step bacl to version 1.1.4 – that ends up in massive .php errors when i try to download a file after setting up the old version.

    maybe you can fix that asap..

    the ajax features are very nice, but we need 100% stable functions first 🙂

    regards

    chris

66. John, unfortenatelly, I’m having the same tproblems Chris is having. Fortunatelly, I also use your redirection plugin. 😉

    Can you help us?

67. First error when trying to create a drain hole:

    WordPress database error: [Unknown column 'hotlink' in 'field list']
INSERT INTO wp_drainhole_holes (url,directory,role,role_error_url,hotlink) VALUES ('/filevault','/home/frank/filevault',NULL,'/filevault','')

    Fixed with:
    mysql> alter table wp_drainhole_holes add `hotlink` varchar(100) default NULL;

    Second error when trying to add a file:

    Fatal error: Call to a member function can_write() on a non-object in /home/2/l/lundvestre/www/wordpress/wp-content/plugins/drain-hole/view/admin/files.php on line 66

68. Chris, you can’t downgrade without fully removing Drain Hole. 100% stability is not something you can realistically expect with free software. The new Ajax functions have not affected the stability of Drain Hole in anyway. They actually gave me more spare time to focus on the rest of the plugin. The missing database column has now been added.

    Frank, missing database column added to 2.0.3. You should delete the column you created before installing. The rest of the errors should disappear on their own.

    Jose, I don’t know what those database errors and the errors involved have nothing to do with Drain Hole – looks like something else!

69. Still getting the same error with 2.0.3 when viewing a drain hole:

    
Fatal error: Call to a member function can_write() on a non-object in /home/2/l/lundvestre/www/wordpress/wp-content/plugins/drain-hole/view/admin/files.php on line 66


    I used "Delete Drain Hole" option in plugin for removing SQL tables and deactivating the plugin, before activating it again.

70. Sorry Frank, I didn’t read that the first time. Problem now fixed

71. testing 2.0.4 all errors i found yesterday are fixed,

    BUT

    trying to edit options of a file ends up with data type errors in the ajax window

    Warning: in_array() [function.in-array]: Wrong datatype for second argument in /srv/www/htdocs/web72/html/sisobeta/wp-content/plugins/drain-hole/view/admin/files_edit.php on line 47
    /> Force download
    Warning: in_array() [function.in-array]: Wrong datatype for second argument in /srv/www/htdocs/web72/html/sisobeta/wp-content/plugins/drain-hole/view/admin/files_edit.php on line 50
    /> Force access level

    …keeping testing 🙂

    nevertheless, i really like your plugin and the ajax effects.

    chris

72. This Plugin is exactly what I’ve been looking for!

    Thanks so much John! You Rock!

73. Hi,

    I have a problem with the drain_hole plugin. When I embed the template code [drain file 2 show mytemplate] into my post I get a "Rendering of template mytemplate.php failed" error. I think that because the template file is missing. As far as I can see it is not included in the zip file .. Any Ideas? Thanks! 🙂

74. I think its unneccesary "hard" to add a download URL, in fact I have yet to get it working as i want.

    Why cant I do "["drain file 13 PDF"]" for example? Why do I need an URL, and better yet what is this URL supposed to be? I can display the file size, so I guess the drain hole is working. Can you provide some kind of idiot proof example on the drain file id syntax?

75. I think you just enter it like this Frank

    [drain file 13 url]

76. Totally screwed up for me.

    I have 2 holes defined (num 6 and 7). If I try (through the admin page) to go into num 7 to refresh the files, I get the details for 6, including path, directory, etc. I can’t get into 7 at all.

    I originally had them with files showing, but the files from 7 showed as missing because it was looking at the paths for 6 instead.

    I’m running 2.0.5 along with the latest Redirection.

    Help. At the moment, its useless, but I know from previous versions, its exactly what I want.

77. John! Version 2.0.5 works great! I could find only one minor problem: in the options panel, it does not change the maximum number of days. It is allways set to 0 (zero).

    I had to set it through phpmyadmin… 😉

    Great job! Thanks!

78. OK, one step closer – I can list information about files and create a [drain file id url] link, however when pressing the link, it just takes me back to the frontpage. No error and no statistics show up.

    I do *not* have redirection installed, since I understand its not needed in the 2.X version of Drain Hole.

79. Hi John
    how can i explane my situtation that you understand me?
    i have webspace from my Provider, there is no public_html… my "public_html" is my root directory, i can not go out of my rootdir!! i can only make subdirs where i can store my files.. so what should i do??

    Tomsn

80. Tomsn, Drain Hole does attempt to create a .htaccess in your download directory. This is the only way it can prevent direct access. Check if the file is being created

    Frank, you don’t need to specify a URL in the syntax, you just type the word ‘url’ so that Drain Hole knows you want to show a URL. The easiest way to show a file is just [drain file 5 show]

    Sven, ‘mytemplate’ is just an example and is not included with the plugin. The template parameter is optional and you do not have to specify it unless you have a template you wish to use (see section on templates)

    Jose, oops! Fixed.

81. Hey John, is there an easy way to disable .htaccess creation? My folders are already protected by another piece of software and I’m thinking that this could cause trouble for me. I haven’t done alot of testing yet, but I think the other software creates a .htaccess as well(subscription software). If it’s a difficult hack just let me know and I’ll try and figure it out.

    Thanks for the rad plugins!

82. Pingback: Skylog » Blog Archive » links for 2007-09-25

83. I’m trying to use 2.0.7 with WordPress 2.3 and it’s like the new version won’t update the database so Drain Hole will work. I get this error:

    WordPress database error: [Unknown column 'wp_drainhole_files.hits' in 'field list']
SELECT SQL_CALC_FOUND_ROWS wp_drainhole_holes.*,SUM(wp_drainhole_files.hits) AS hits,COUNT(wp_drainhole_files.id) AS files FROM wp_drainhole_holes LEFT JOIN wp_drainhole_files ON wp_drainhole_holes.id=wp_drainhole_files.hole_id GROUP BY wp_drainhole_holes.id ORDER BY name ASC LIMIT 0,25
    I really want to use the new version. I dig the fancy charts and stuff. Any ideas?

84. Well I fixed it. Somehow the drainhole_version was being set to 4. I changed it to 1 and was able to get 2.0.7 working. Very neat stuff. Not sure what was going on. But it works now.

85. Are you kidding me???

    I came to see if anybody saw my comment and had any ideas or hacks for me. I look at the latest file download info and see that it’s been updated……..I then read:

    Option to disable .htaccess creation

    Wow, you are the man John!! Thank you so much!!

86. Well damn. Thank you. 2.0.8 solved all my issues. And the description field that I’d asked for before works exactly as I’d wanted. 100% spot on dude.

87. Hi,

    It would be really cool if for example:
    – when somebody downloading a file from my site I would get an e-mail
    – maybe if someone wants to download a file, he/she has to answer a question or give e-mail

    What do you think?

    Tino

88. Tino,

    I think it would be a good idea. But, to be really useful, should be activated on the options panel or maybe offer a file-by-file flag.

    This way, people who offer a lot of files that are downloaded dozens of time a day wouldn’t be flooded with notification e-mails.

89. José Luís, yes you are right but I was thinking that for example:

    on one page I have 10 files to download – all are in one drain hole so when someone will click first time on any of these 10 files he will need to give an e-mail to download, but if after downloading first file he wonts to download anather he will do it without hiving e-mail again. (it can works on cookies)

    Tino

90. Hi John,
    I finally think I got around the "download of edit.php" problem. It appears to be to do with the directory permissions on the server. The files (and directories) inside my home directory, but outside my public_html were not visible to the apache server process. We did a bit of experimenting, and it seems to be quite subtle what permissions are in place. Given other people don’t generally seem to experience this issues, I am still a bit worried we aren’t quite there…but it’s hard to "debug".

    At the moment I can create a drainhole, and I can manage and upload files in that drain. I tried to set up a blog post using [drain file x show]. When I view the post, I see a nice graphic and a link to click, which seems to be based on the correct filename, which seems to suggest something is working right? But when I click, I get a 404 not found. Any ideas?

91. hmm, I read through all the other comments and a few seem to suffer 404 errors even though they can manage the drain hole files…for the record I am on DH 2.0.8, WP 2.2.3
    I also tried on a different server, where I did not experience the "save edit.php" issue at all, but I still can’t get past the 404. I’ve tried a number of locations for the files, both inside and outside my webspace (As best I can)

92. Hi, thank you for the great plug in.

    Now I have a problem. I hope you can help me.

    After installing your plugin i receive the following errors by manager > drain hole:

    WordPress database error: [Table ‘drainhole_access’ doesn’t exist]
    DELETE FROM drainhole_access WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY) > created_at

    WordPress database error: [Table ‘drainhole_holes’ doesn’t exist]
    SELECT SQL_CALC_FOUND_ROWS drainhole_holes.*,SUM(drainhole_files.hits) AS hits,COUNT(drainhole_files.id) AS files FROM drainhole_holes LEFT JOIN drainhole_files ON drainhole_holes.id=drainhole_files.hole_id GROUP BY drainhole_holes.id ORDER BY name ASC LIMIT 0,25

    Deactivating & activating doesn’t help 🙁

93. YikYak, version 2.0.8 should have fixed that. The problem with the 404s is that the permalink structure on some sites is taking precedence over the files. Drain Hole thinks everything is ok, but when you click on a link, WordPress jumps in before Drain Hole has a change and thinks you are trying to view a post. As you don’t have a post of such a name it then 404s. Version 2.0.8 puts all the drain hole files at the very top of the queue. Before investigating further, it may be worth just re-saving your permalink structure and then giving it a try. I’ve just realised that while 2.0.8 should fix the problem, it requires that the permalinks be re-saved and you may not have done this

    Over, what version of WordPress are you using? What is your table prefix? From your error message it doesn’t look like you have a table prefix at all (if you’re unsure, look in /wp-config.php and the table prefix is listed there)

94. Hi John,

    Thank you for your reply. I’m using WP 2.2.2. I’ve deleted the prefix from the error-message (security). My prefix is _cms. I really hope i could get this great plugin to work.

    Regards.

95. bad hair day….

    somehow managed to get drain hole into a state where it would not activate, fatal error, so I deleted and re-installed my blog just to clean everything (in MySQL) out (thankfully developmental, no real content!), yeah I probably didn’t need to, but thought I would if I wanted to get drain hole working. My MySQL skills were not up to clearing out just drain hole bits of the database

    The latest is that I have tried every combo of permalinks I can, with lots of combos of file permissions inside the drain hole, everything I can vary without annoying my sysadmin.
    No joy. Just 404 from the theme.
    (I presume "options -> permalinks -> update permalinks" is what you meant me to do, I can’t see how to do anything else with them) – two of the alternative permalink structures seem to give me the same .htacces, is that correct?

    anyway, saving the options with all the standard permalink variants gives me 404 problems.

96. Im having a weird problem. I’ve installed Drain Hole 2.0.8 on WordPress 2.3, and when Im trying to add a new Drain Hole the page turns blank and nothing happens. Any idea what causes that?

    Thanks,
    Paul.

97. If you added this code before any hits received [drain hole 1 hits]

    Fatal error: Call to undefined function: hole_stats() in /home/thinkout/public_html/your/wp-content/plugins/drain-hole/drain-hole.php on line 576

    No big deal! If no stats, shows an error message.

    Thanks

    Roger

98. I’m trying to set up drain hole on a local wordpress install (XAMPP) and I can’t create drain holes — As soon as I set up the two urls and hit "create drain hole", I’m getting a "server reset during page load" message from Firefox, unfortunately no error codes.

    For the local install, I want to set up a folder at "http://localhost/folder/", redirecting to "http://localhost/myblogroot/downloads/", both of which are located inside "/htdocs/" on XAMPP. (On the server, I’d probably use a folder outside the "public_html" folder, as suggested, but on the local install the blogroot and the drain hole live in the same directory).

    When I enter http://localhost/myblogroot/downloads/ for URL and http://localhost/folder for directory, I get the server reset message. Can someone help me out?

    Using: WordPress 2.3, Drain Hole 2.0.8, permalink structure /%category%/%post_name%/

99. I installed it and everything, created the main drainhole with all my downloadable files in it and it doesn’t count the downloads. What can be wrong?

100. Hi, was wondering would the logging of each download with drain hole cause a spike in server load?

     Because I get around 20,000 file downloads a day and I noticed after using this my server load has went up quite a bit. Not sure if its related to drain hole though. Could be something else, but just wondering if that many downloads a day would cause trouble with logging.

Comments are closed.