Jump to content

Hendrik

Members
  • Posts

    24
  • Joined

  • Last visited

Hendrik's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. thanks for your help guys. i have found the problem, it was from my side thank you for your patience
  2. I see that i accidentally wrote that i can't drop tables in my previous post, but that ain't the case. It is the stored procedures i cannot drop, which i could do 2 weeks ago. For some reason back then i could not drop the procedures from MySQL Workbench but i could do it from phpAdmin, therefore i had no problems, but now i cannot drop them even from control panel phpAdmin. I know that you have previously mentioned that it is due to some sort of a MySQL 5.x bug. But what confuses me is that why was i able to do the dropping before anyway even though there was a bug :S
  3. It was actually working about 2 weeks ago, when i could drop the tables from phpAdmin, but not alter the tables from the MySQL Workbench
  4. I was trying to drop stored procedures. EDIT: I get the following error: #1370 - alter routine command denied to user 'tazan_ngsis'@'localhost' for routine 'tazan_ngsis.new_routine' Hendrik
  5. Hi Support, Server: johnny Domain: ngs.is Username: tazan About 2 weeks ago i had no problems with dropping stored procedures in the database, but now i cannot drop my procedures. Why is that so? Best Regards, Hendrik
  6. that is okey thanks for your concern guys
  7. This is due to a problem with mono. Please see the topic in escalated requests. I read the topic that Krydos referred to and i have never used Mono before, therefore i do not understand how that can be a problem at all? And i have downgraded my application from .Net 4.0 to .NET 3.5 Is it still not working? If not, shall I escalate this? If so, what should djbob do? I'm able to add your name servers to my domain registrar, as all of the issues with that were solved. But the problem now is that error i get when accessing my page "Error 324 (net::ERR_EMPTY_RESPONSE)" and i have do not know how to fix it.
  8. That topic is also created by me, i think all the .is domain related topics are created by me. But how long do you think it will take to get everything sorted out? Hendrik
  9. Hi Support, I assume that the problem I state in this topic is related to name servers again, as I got an error when I was changing name servers for my Icelandic domain name. Error: --------------- ns1.heliohost.org does not exist. For .is domains the nameservers must be configured correctly before the delegation can be completed. Not all ISPs are aware of this. Please contact the administrators of the nameservers you are trying to use, and ask them to create a valid zone file for ngs.is on all the nameservers. --------------- Previously, I had 2 other errors related to Icelandic domain names, which have been solved, so this is the third one . Best Regards, Hendrik
  10. username: tazan domain: ngs.is server: johnny
  11. I use mysql workbench to execute the changes. I can delete and create routines easily through the tool, but that is a bit annoying when it comes down to small changes which i wanna test out. Previously my database resided in another web-server and there i didn't have any problems with changing the routines. I won't give the full routine as i don't want to publish it, but when i even add a comment to the routine it fails and therefore i think it is unnecessary to view my routine in full content That is what mysql workbench tries to execute. //mysql workbench added code start USE `tazan_ngsis`; DROP procedure IF EXISTS `insertVisitor`; DELIMITER $$ USE `tazan_ngsis`$$ //mysql workbench added code end //my routine start CREATE DEFINER=`tazan_ngsis`@`%` PROCEDURE `insertVisitor`(IN shortUrl TEXT) BEGIN //changed code here END //my routine end After i execute my code i get an error message with this information //mysql workbench added code start ERROR 1370: alter routine command denied to user 'tazan_ngsis'@'%' for routine 'tazan_ngsis.insertVisitor' SQL Statement: DROP procedure IF EXISTS `insertVisitor` ERROR: Error when running failback script. Details follow. ERROR 1304: PROCEDURE insertVisitor already exists //mysql workbench added code end SQL Statement: //changed code here
  12. Hi Support, It makes me wonder, why can't i alter my stored procedures while i can drop and create them? Best Regards, Hendrik
  13. Hi Support, Very weird put im not able to load my website. Domain: ngs.is Username: tazan I'm getting this error: Error 324 (net::ERR_EMPTY_RESPONSE) I have tried to solve it, without success. I also found some other topic which stated that my website should be in asp.net 3.5 so i converted my website to that, but still. When I'm testing my website in local host and connecting to the database at johnny.heliohost.org it is all okey. I'm sure it is some small thing that I don't know about. Do you guys have any idea what might be causing it? Best Regards, Hendrik
  14. thanks, it helped me. but what baffles me is that prior to making this topic i was trying the same very solution, but the cPanel did not accept '%' at all, but now it does
  15. Hi Support, I have looked around the forum and have found that other people have had the same problem, but none of the solutions helped me. The error i get. --------------------------- Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: MySql.Data.MySqlClient.MySqlException: Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES) -------------------------- My domain name is ngs.is. I have created a database and user and assigned a user to the database. The user has all the privileges. Also johnny.heliohost.org is the database server address, right? I am able to connect to the database through cpanel phpmyadmin, but not remotely. I doubt that the mistake is in the connection string but i will add it anyway, just in case "SERVER=johnny.heliohost.org; DATABASE=tazan_ngsis; USERNAME=tazan_ngsis; PASSWORD=***********"; Will be waiting for the reply Best Regards, Hendrik
×
×
  • Create New...