Re: problems with mysql & php4 pages after mysql upgrade

Brent Bailey writes:
> Dear sirs
>
> I recently upgraded the version of mysql im using to 3.23.58
> Before the upgrade we were using some web pages written with php4 to
> track abuse complaints and such from our customers.
> However now after the upgrade the pages will view the data from the
> mysql database but from the website I cant edit or delete any of the
> data.
> But I can do it from the command line as well as phpMyAdmin. The error
> im getting is
> "Cant Query"
> when I go to use the edit or delete functions of the website
>
>
> the code im using (which has work all along until after the upgrade) is
> this is the submit page code that connects and submits and queries mysql
>

[skip]

>
> Any and all help is VERY appreciated
>
> Brent Bailey CCNA
> High Speed Data Services
> MetroCast Cablevision
> 603-332-8629 ext:242
> bbailey@metrocastcablevision.com
>

Hi!

This list is dedicated to the repeatable test cases in MySQL.

Your message does not contain a repeatable test case.

This looks like some error in your code or setup, as things work just
fine with our command line programs.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

problems with mysql & php4 pages after mysql upgrade

------=_NextPart_000_017A_01C39711.731B6800
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Dear sirs

I recently upgraded the version of mysql im using to 3.23.58
Before the upgrade we were using some web pages written with php4 to
track abuse complaints and such from our customers.
However now after the upgrade the pages will view the data from the
mysql database but from the website I cant edit or delete any of the
data.
But I can do it from the command line as well as phpMyAdmin. The error
im getting is
"Cant Query"
when I go to use the edit or delete functions of the website


the code im using (which has work all along until after the upgrade) is
this is the submit page code that connects and submits and queries mysql


$sql= "INSERT INTO abuse(offendingip, cmmac, cpemac, location,
username, typeofabuse, actiontaken, openclose) VALUES ('$offe
ndingip','$cmmac','$cpemac','$location','$username','$typeof abuse','$act
iontaken','$openclose')";
$connect = mysql_connect("localhost","blah","blah" ) or die
("Can't connect to server");
$db = mysql_select_db("abuse", $connect) or die ("Can't connect
to the Data Base");
$sql_result = mysql_query($sql, $connect) or die ("Can't execute
query");


For whatever reason it seems that I can view the data but that's it

Any and all help is VERY appreciated

Brent Bailey CCNA
High Speed Data Services
MetroCast Cablevision
603-332-8629 ext:242
bbailey@metrocastcablevision.com


------=_NextPart_000_017A_01C39711.731B6800--

Re: problems with mysql & php4 pages after mysql upgrade

Brent,

> I recently upgraded the version of mysql im using to 3.23.58
> Before the upgrade we were using some web pages written with php4 to
> track abuse complaints and such from our customers.
> However now after the upgrade the pages will view the data from the
> mysql database but from the website I cant edit or delete any of the
> data.

depending on what MySQL version you were using before, you might have to
recompile PHP too, as it was compiled against the previous version of the
MySQL libraries and might lead to unexpected results running against newer
ones.



Rgds,
Indrek

--=20
| Indrek Siitan, MySQL AB, Support Engineer & Bugmaster
| Uuem=F5isa, Haapsalu, Estonia
+-=20
| Are you MySQL Certified? http://www.mysql.com/certification/
--


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org