Can't edit to delete, not even in PHPMyAdmin

marieeve / 2014-02-04 16:08:33   

Hi there!
first of all here's my website: marieevelevasseur.com
Since many months, i have this problem with one exhibit and didn't have the time to take care of it. After reading a lot in the forum, i realized it came from my upgrade to the latest version + way too big pictures in one exhibit. I need to delete this exhibit and when i want to edit it, i get a blank page. When i go to PHPMyAdmin and try to delete only the pictures or even the whole object, i get this message:

Error
SQL query: Edit
DELETE FROM `ndxz_objects` WHERE `ndxz_objects`.`id` =15 LIMIT 1
MySQL said: Documentation #1142 - DELETE command denied to user 'kokonotkunst'@'72.167.233.37' for table 'ndxz_objects'

I really need help here i don't know what else i can do. Thank you!

Vaska A / 2014-02-04 16:14:20   

Yes, because your db user account either doesn't have the 'privilege' to delete or something is wrong with your hosting setup. The fact that you can't do this via PHPMyAdmin means you should contact your webhost.

marieeve / 2014-02-05 18:49:25   

Thanks Vaska, i'll do that!

marieeve / 2014-02-05 20:17:26   

Oh boy, i logged in under my read-only user name. That's why i had no permission to delete stuff. Sorry to have bother you with that inattention mistake.

marieeve / 2014-02-05 20:23:28   

Ok, sorry for the multiple posts, but now i can't enter my indexhibit managing page or the website in itself. When i try, i get this:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator and inform them of the time the error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.
Apache Server at marieevelevasseur.com Port 80

marieevelevasseur.com/ndxzsite/
I just deleted the big pictures of my website in order to delete the exhibit in indexhibit after, and then i deleted the object too... was it a bad idea?

arsondpi / 2014-02-05 21:35:51   

That's a 500 error which means that's it's a server issue.
Can you check the users privileges and permissions can delete an object?
Is there an error log in your server?

marieeve / 2014-02-06 11:04:18   

Hi arsondpi, i'm far from being a pro here and i tried to find how to get to those users privileges or permissions in PHPMyAdmin on the server link up left, but it stays a bit of a mystery. I also check the objects_prefs but i didn't find anything. In my hosting control panel (i'm with GoDaddy), i activated an error log, but it says it will be on in 24 hours, so i don't think it will help. Is there any other things i can do? Now when i try to log in my Indexhibit, i only get a blank page, no more 500 error message. I just hope i didn't messed up too much with me deleting the object (title was: sculpture / 2 mai 2011, and id: 15) Thank you for your help!

marieeve / 2014-02-06 12:11:33   

Ok i have new informations: in my server's error logs i got those:

[Thu Feb 06 03:47:22 2014] [7505968] [fcgid:warn] (104)Connection reset by peer: [client 37.115.112.240:4334] mod_fcgid: error reading data from FastCGI server, referer
[Thu Feb 06 03:47:22 2014] [7505968] [core:error] [client 37.115.112.240:4334] End of script output before headers: index.php, referer

I have no idea, but it sounds like bad news.

marieeve / 2014-02-06 12:14:20   

I'm so sorry they came out as links, i should have put symbols around them it was not my intention at all. I just made a copy paste of my error logs. Next time i'll make a preview before i post. Sorry again.

Vaska A / 2014-02-06 12:17:26   

Why are you showing us logs? The problem is your database connection. Godaddy provides no help at all for that?

They are a huge host who don't really get support...

This thread has been closed, thank you.