Page 1 of 1

Need some help with my site

Posted: Sun Oct 23, 2011 10:35 pm
by loadafile
Hi Guys


I am currently running an upload site which I modified in several ways.

I purchased the script but ofcourse the "support" that was promised is not there. I have two questions firstly.


1.When a member uploads a file it is stored to the root directory of the members uploads which is public access.

I was wondering if anyone can take a look and see how I can fix this to be set to private. I dont like the fact that if somone wants to upload sensitive material it is public until they move it into a private folder.


2.I had to remove the members ability to remove a folder off of my site because I was getting an error when I would press the delete button next to my folders in the folder managment section

here is the error


database error has been encountered
There was an error communicating with the database. This error may be temporary, or an administrator may need to correct the problem to resolve the error. If you are the administrator, you can check the error logs (if enabled) for more information.

The following information is available about the error:

Error Code: 1054
Error Message: Unknown column 'folder_id' in 'where clause'Query: DELETE FROM files WHERE folder_id=1




I would really appreciate somones time and help. I have a general understand of php but these two bugs I can not fix. Not to mention the 30 or so I already have.

my site is http://www.loadafile.com

THIS IS IN NO WAY AN EFFORT OF PROMOTION. SIMPLY ASKING FOR SOME HELP

Re: Need some help with my site

Posted: Sun Oct 23, 2011 11:47 pm
by twinedev
Another thing to check is the handling of slashes....

see http://www.loadafile.com/index.php/1FXQa

So, the script was it a custom paid one, or one that is available for anyone to download, if so, what is it?

-Greg

Re: Need some help with my site

Posted: Mon Oct 24, 2011 12:25 am
by loadafile
it was a paid one horribly filled with bugs had to transform many things to make it more user friendly. not to happy with all the bugs

any ideas on what could be wrong?

Re: Need some help with my site

Posted: Mon Oct 24, 2011 1:07 am
by twinedev
Well the error with "Unknown column folder_id", it flat out a badly written script.

As to other things, I wouldn't be able to advise without seeing the code. The part you mentioned about the files being in public until moved, are you referring the list of "recently uploaded files" on the home page?

-Greg

Re: Need some help with my site

Posted: Mon Oct 24, 2011 1:31 am
by twinedev
Well I was bored, so was playing around on the site more....

I created two accounts, and uploaded a file to each, and could not see the files from the other account, even though it says it will on the site (as you asked about here). Also, it appears to of let me delete them...

So not sure if you are just working on it and got it going or not....

Some other suggestions though, you may want to filter signup emails to not accept domains from "anonymous e-mail" services, like the one I used.

Also, adjust the e-mails it sends out when you sign up, here is what I got:
[text]Subject: Registration validation
From: user@p3nlhg512.shr.prod.phx3.secureserver.net
To: ieqnwivj@sharklasers.com
When: 2011-10-24 06:15:57

Hello testuser,

You are receiving this email because your email address has been registered
at Load A File Unlimited Online Storage for $9..99 yr
(http://www.loadafile.com/).

In order to complete your registration you must verify your email address.
To do that, you simply need to visit the following URL:

http://www.loadafile.com/index.php/validate/register

When prompted for your validation key and your validation id, use the
following information:

Validation key: 33db50db3ef05022cb7f65a1c3897ef7
Validation id: 10

For reference, the password registered was "test4321".

Please be aware that we do not keep your password on file in an accessible
manner.
You should be sure to note your password for future reference.

Thank you,
Load A File Unlimited Online Storage for $9.99 yr[/text]

Things I would change on it: The from address, Clean it up to not show #36; and such, and provide a link that will auto take users to validate the signup. (also is thre really a reason to show what appears to be the USER_ID in the e-mail or the password.

BTW, if it didn't actually delete the two files, please do so.

-Greg

Re: Need some help with my site

Posted: Mon Oct 24, 2011 2:54 am
by loadafile
twinedev wrote:Well the error with "Unknown column folder_id", it flat out a badly written script.

As to other things, I wouldn't be able to advise without seeing the code. The part you mentioned about the files being in public until moved, are you referring the list of "recently uploaded files" on the home page?

-Greg

no it was not it was in regards to the folders members create not files they upload

Re: Need some help with my site

Posted: Mon Oct 24, 2011 2:56 am
by loadafile
twinedev wrote:Well I was bored, so was playing around on the site more....

I created two accounts, and uploaded a file to each, and could not see the files from the other account, even though it says it will on the site (as you asked about here). Also, it appears to of let me delete them...

So not sure if you are just working on it and got it going or not....

Some other suggestions though, you may want to filter signup emails to not accept domains from "anonymous e-mail" services, like the one I used.

Also, adjust the e-mails it sends out when you sign up, here is what I got:
[text]Subject: Registration validation
From: user@p3nlhg512.shr.prod.phx3.secureserver.net
To: ieqnwivj@sharklasers.com
When: 2011-10-24 06:15:57

Hello testuser,

You are receiving this email because your email address has been registered
at Load A File Unlimited Online Storage for $9..99 yr
(http://www.loadafile.com/).

In order to complete your registration you must verify your email address.
To do that, you simply need to visit the following URL:

http://www.loadafile.com/index.php/validate/register

When prompted for your validation key and your validation id, use the
following information:

Validation key: 33db50db3ef05022cb7f65a1c3897ef7
Validation id: 10

For reference, the password registered was "test4321".

Please be aware that we do not keep your password on file in an accessible
manner.
You should be sure to note your password for future reference.

Thank you,
Load A File Unlimited Online Storage for $9.99 yr[/text]

Things I would change on it: The from address, Clean it up to not show #36; and such, and provide a link that will auto take users to validate the signup. (also is thre really a reason to show what appears to be the USER_ID in the e-mail or the password.

BTW, if it didn't actually delete the two files, please do so.

-Greg


I fixed the issue with files not being private simple sql switch...regarding deleting files...it works 100% i was talking about the folders. If you go to folder managment and create a folder you wouldnt be able to delete it that is why I included contact site admin to delete folders....


when the delete folder function was included on my site this was the error( that is why i removed capabilities)

database error has been encountered
There was an error communicating with the database. This error may be temporary, or an administrator may need to correct the problem to resolve the error. If you are the administrator, you can check the error logs (if enabled) for more information.

The following information is available about the error:

Error Code: 1054
Error Message: Unknown column 'folder_id' in 'where clause'Query: DELETE FROM files WHERE folder_id=1