Support Requests item #1482151, was opened at 05/04/06 14:46
Message generated for change (Comment added) made by sf-robot
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1482151&group_id=23067
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: None
>Status: Closed
Priority: 5
Submitted By: Robert Jory (rjory)
Assigned to: Nobody/Anonymous (nobody)
Summary: Delete Record Problem
Initial Comment:
I probably have something setup wrong so any help would
be appreciated.
Normally I can click on the red x and delte rows. The
verification prompt that appears is "Do you really want
to :
DELETE FROM `event` WHERE `eventID` = 1 LIMIT 1
"
However one of my tables will not allow me to delete
rows. The prompt I get is
Do you really want to :
DELETE FROM `events` WHERE `eventID` = 25 AND
`clientID` = 3 AND CONVERT(`eName` USING utf8) = 'a'
AND CONVERT(`eDesc` USING utf8)
= 'a' AND `eStartDate` = '2006-05-04' AND `eStartTime`
IS NULL AND `eEndTime` IS NULL AND CONVERT(`eLocation`
USING utf8) = '' AND
CONVERT(`eAddress1` USING utf8) = '' AND
CONVERT(`eAddress2` USING utf8) IS NULL AND
CONVERT(`eCity` USING utf8) = '' AND
CONVERT(`eState` USING utf8) = '' AND CONVERT(`eZip`
USING utf8) = '' AND CONVERT(`ePhone` USING utf8) = ''
LIMIT 1
If I hit OK anyway I get the error message "Fatal
error: Call to undefined function PMA_DBI_try_query()
in
D:\wamp\phpmyadmin\libraries\check_user_privileges.lib.php
on line 16"
----------------------------------------------------------------------
>Comment By: SourceForge Robot (sf-robot)
Date: 05/28/06 19:20
Message:
Logged In: YES
user_id=1312539
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
----------------------------------------------------------------------
Comment By: Michal ÄihaÅ (nijel)
Date: 05/14/06 11:54
Message:
Logged In: YES
user_id=192186
Please upgrade to something more recent, there were fixed
many bugs meantime.
Anyway real problem with your table is that it doesn't have
proper primary key.
----------------------------------------------------------------------
Comment By: Robert Jory (rjory)
Date: 05/14/06 11:49
Message:
Logged In: YES
user_id=1516957
Versopm 2.7.0=p12. This only happens with one table on the
system. All other tables work fine. It is the CONVERT
statements which are causing the error and they do not
appear in the tother tables when doing a delete.
----------------------------------------------------------------------
Comment By: Michal ÄihaÅ (nijel)
Date: 05/14/06 10:55
Message:
Logged In: YES
user_id=192186
What phpMyAdmin version are you using?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1482151&group_id=23067
|
