Home > Archive > PHP DB > May 2007 > MySQL5037srv//PHP522//WIN2KSP4//IISV5//***MySQL ERRORS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
MySQL5037srv//PHP522//WIN2KSP4//IISV5//***MySQL ERRORS
|
|
| Chetan Graham 2007-05-08, 3:58 am |
| Hi to All,
I am having problems with the MySQL DB. It started with this command from
a call in a PHP script...
"INSERT INTO docprouser (id,valid,password)VALUES
('user5','Y',md5('ksobhinyai'));" or die(mysql_error());"
The script actually connects with the DB fine and no errors at all. You
can see the screen output in the attatched text file. However, there is
no new entry in DB.
Upon looking at the error log for the specified time I get:
**Query Execute Thread cannot connect to MySQL **
However, if I cut/paste the above into the query window of GUI it executes
just fine, and shows the record written.
I've dnloaded the latest OBDC connector and set up correctly.
I've googled the MySQL errors to no avail.
TCP/IP is active on pc.
The tables were even created with this script.
I'm beyond frustrated, as two days now have been stuck with this DB
problem. I just spent the last five or six hours deleting the DB off the
server and reloading it several times which cleared up several previous
problems. Now, it comes down to this one.
Any help would be appreciated.
Blessings,
Chetan
| |
| Chetan Graham 2007-05-08, 3:58 am |
| Thanks for everyone's indulgence, I figured out the problem.
simple syntax around the INSERT as follows with the mysql_query.
mysql_query("INSERT INTO docprouser (id,valid,password
VALUES('root','y',md5('ksobhinyai'))");
Blessings,
Chetan
> I am having problems with the MySQL DB. It started with this command from
> a call in a PHP script...
>
> "INSERT INTO docprouser (id,valid,password)VALUES
> ('user5','Y',md5('ksobhinyai'));" or die(mysql_error());"
>
> The script actually connects with the DB fine and no errors at all. You
> can see the screen output in the attatched text file. However, there is
> no new entry in DB.
>
> Upon looking at the error log for the specified time I get:
>
> **Query Execute Thread cannot connect to MySQL **
>
> However, if I cut/paste the above into the query window of GUI it executes
> just fine, and shows the record written.
>
> I've dnloaded the latest OBDC connector and set up correctly.
> I've googled the MySQL errors to no avail.
> TCP/IP is active on pc.
> The tables were even created with this script.
>
> I'm beyond frustrated, as two days now have been stuck with this DB
> problem. I just spent the last five or six hours deleting the DB off the
> server and reloading it several times which cleared up several previous
> problems. Now, it comes down to this one.
>
> Any help would be appreciated.
> Blessings,
> Chetan
| |
|
|
|
|
|