472,133 Members | 1,177 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,133 software developers and data experts.

getting Error ,query failed

is there any posibility to block mysql port or someting?

I am getting "Error ,query failed" during adding any data through the admin panel of that website:-(

same softwares(php, mysql and IIS) with the same script woking fine in my local server but in the main webserver its giving the above message. More over couldn't edit the data also over there.

Thats why I am asking, is there any posibility.............

I don't have permission to access the main server. I keep update the website through the adminpanel of that website.

Can anyone help me please:-D
Jan 17 '07 #1
1 4671
4,258 Expert 4TB
This error really gives no information at all. It could be caused by either a MySQL query error or by an authorization issue in the admin script.

When it is MySQL you should try to capture the complete error message. Probably the message is generated by a statement like
Expand|Select|Wrap|Line Numbers
  1. $var=mysql_query("query" or die ("query error");
what should be coded is
Expand|Select|Wrap|Line Numbers
  1. $var=mysql_query("query" or die ("query error: " . mysql_error());
showing the real error.

When it is in the admin script, you'd better check that you have the correct authorizations set for your login id and psw.

Ronald :cool:
Jan 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by mikey_boy | last post: by
reply views Thread by StevePBurgess | last post: by
4 posts views Thread by kalaisuresh | last post: by
15 posts views Thread by Lawrence Krubner | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.