Bug Got DATABASE ERROR after deleting user. Need help

[Mv.c9]

hi, I just deleted a user for a certain raeson and now all his files are giving database error. plase help: http://gamemodscore.org/downloads.php?do=listings&catid=20

what should i do, i cant delete the files, please help. this is very bad for my forum reputation, and i cant just disable the downloads until its finished, please help.

EDIT: I had the user reupload the files, so i just want to get rid of them for now and then move on to the main problem, can you help me on that ?

 

[Ozzy47]

I see on that page the one that throws the database error has no uploader associated with it, try adding a valid user id to it in phpmyadmin, dbtech_downloads_filegroup

For this file:
Extended durations for Oils/Potions
By eRe4s3r

What it does.
Extends all potions that had 10m duration to 30m.
Simply download this file either directly ...

 

[Ozzy47]

On this page you need to do the same for these files:

http://gamemodscore.org/downloads.php?do=listings&catid=13

Crafting price equalizing
this reduces all crafting prices to 3 oren, by eRe4s3r

This only reduces the "fee" you pay to the crafters for crafting - crafting is thus made profitable - so its an imbalance.
...





Return of the Black Wolf
Another Mod by eRe4s3r

On this page:
http://gamemodscore.org/downloads.php?do=listings&catid=8

Medical Problems 2: The Witcher Disease
This is a new adventure just hot out of the oven by Corylea. something really good before playing witcher, im gonna play now. i noticed everyone post readme as quote so i post hers her too

"Di...

I think with the user being deleted that was associated with those files breaks the database.

 

[Mv.c9]

im sorry can you tell me where exactly is the phpadmin ?

 

[Ozzy47]

In your cPanel for your site, where you set up the database.

It is in the box for Databases

 

[Mv.c9]

Thanks ALOT, i just found it and removed them, thanks alot

 

[Ozzy47]

Not a problem. glad to help!!

 

[Mv.c9]

actually this IS a bug, i mean at any point if I delete a user that uploaded something that file will be inaccessible. there should be something to turn the null values into guest. or something else.

sorry if I sound bad -- not my intention.