Delete Manually Some Records, It Displays By Executing All Records Inl

[Ganesh M Doss]

Hai all

In sqlyog 8.12 I have deleted some records manually and it was deleted.

then i check the values by executing this query

select * from tblContributionPayment where contributionId = 100789

Record displays without contributionId 100789 rows, works fine.

But by executing,

select * from tblContributionPayment

It list all values including deleted values.

How can completly delete records?

The deleted cant able to edit and update.

Can you give me right solution to fix it asap

Thanks & Regards

Ganesh M Doss

[navyashree.r]

You have posted in wrong category so i am moving to SQLyog: Bugs/Feature Requests section.

[Khushboo]

Hi Ganesh,

SQLyog has never encountered any such problems.

Anyways, we tried your case and it is not reproducible at our end.

If you have manually deleted some records through SQLyog and data is saved, then those records will be deleted from the server.

Can you please try you case with latest version of SQLyog 8.2 ?

If you still have same problems, then please elaborate your test case and provide us sample table structure for which problem occurred.

Thanks You.

Regards,

Khushboo

[Ganesh M Doss]

Hai Mam,

Thank you for your reply, I think this is happening in Mysql server. Mighty be a cache issue.

My team players and client in singapore having the same issue, not sure they using sqlyog.

So Can you have any idea abt clearing cached Or Any other way.

And I'm not sure this is cache issue too. plz asap

Thanks Mam

Regards

Ganesh M S

'Khushboo' wrote on '18:

Hi Ganesh,

SQLyog has never encountered any such problems.

Anyways, we tried your case and it is not reproducible at our end.

If you have manually deleted some records through SQLyog and data is saved, then those records will be deleted from the server.

Can you please try you case with latest version of SQLyog 8.2 ?

If you still have same problems, then please elaborate your test case and provide us sample table structure for which problem occurred.

Thanks You.

Regards,

Khushboo

[peterlaursen]

Are you using transactions?  You may do without knowing if you have “SET AUTOCOMMIT = 0” in server configuration.

Try execute “SHOW GLOBAL VARIABLES LIKE 'autocommit';”. Transactions are effective if OFF is returned.

Please also explain exactly what you did when 'manually deleting rows'.

[Ganesh M Doss]

Thanks peterlaursen

I attached screenshot, how i deleted.

Values in the row not deleted, updated Or anything.

what will be the porblem? Can you explain? and how to fix this?

Thank you

Regards

Ganesh M S

'peterlaursen' wrote on '18:

Are you using transactions?  You may do without knowing if you have “SET AUTOCOMMIT = 0” in server configuration.

Try execute “SHOW GLOBAL VARIABLES LIKE 'autocommit';”. Transactions are effective if OFF is returned.

Please also explain exactly what you did when 'manually deleting rows'.

[Ganesh M Doss]

See the attachment here…

[attachment=1303:12-18-2009 4-04-20 PM01.png]

'Ganesh wrote on '18:

Thanks peterlaursen

I attached screenshot, how i deleted.

Values in the row not deleted, updated Or anything.

what will be the porblem? Can you explain? and how to fix this?

Thank you

Regards

Ganesh M S

[peterlaursen]

That looks fine, but if you are using transactions you will have to “COMMIT;” after changes or execute “SET AUTOCOMMIT = 1” before performing changes. *transactions* means that changes are stored in a log and only written to database on COMMIT. As long as not COMMITTED the changes will only be visible for the session. If you close SQLyog before COMMITTING changes are lost.

Please execute 

SHOW GLOBAL VARIABLES LIKE 'autocommit';

. and tell what it returns (ON or OFF).

Also please tell if the table is MyISAM or InnoDB.

[Ganesh M Doss]

'peterlaursen' wrote on '18:

That looks fine, but if you are using transactions you will have to “COMMIT;” after changes or execute “SET AUTOCOMMIT = 1” before performing changes. *transactions* means that changes are stored in a log and only written to database on COMMIT. As long as not COMMITTED the changes will only be visible for the session. If you close SQLyog before COMMITTING changes are lost.

Please execute 

SHOW GLOBAL VARIABLES LIKE 'autocommit';

. and tell what it returns (ON or OFF).

Also please tell if the table is MyISAM or InnoDB.

Hai peterlaursen

By executin this statement : SHOW GLOBAL VARIABLES LIKE 'autocommit';

No values displayed, Displays two field name called Variable_name and Value

And the table is MyISAM engine.

Also where can i do autocommit manually, I have to check whether the record delete, update etc permanently.

Thanks peterlaursen

Regards

Ganesh M S

[peterlaursen]

hmmm .. what is your server version? Execute  “SELECT VERSION();”.  

For me

SHOW GLOBAL VARIABLES LIKE 'autocommit'

returns ON. 

[Ganesh M Doss]

'peterlaursen' wrote on '18:

hmmm .. what is your server version? Execute  “SELECT VERSION();”.  

For me

SHOW GLOBAL VARIABLES LIKE 'autocommit'

returns ON. 

Server version

4.1.22-log

what would be the problem peterlaursen.

Can explain me possible ways of problem will occur for my issue like autocommit etc…

Thank you

Regards

Ganesh M S

[peterlaursen]

I am sorry, but I have no idea about what the problem could be it if is not transactions enabled per default in server configuration. We will have to discuss on Monday.

[peterlaursen]

According to MySQL manual the variable should be available in MySQL 4.1:

http://dev.mysql.com/doc/refman/4.1/en/mysqld-option-tables.html

Are you sure you spelled it correctly?  Please see image.

[attachment=1307:acommit.jpg]

[peterlaursen]

Please also try to omit the GLOBAL keyword- ie. only “SHOW VARIABLES LIKE 'autocommit';”.

I do not remember details with MySQL 4.1 (it is old now) and I do not have one here.

[peterlaursen]

btw: are you perfectly sure that the data you delete are not inserted again by another client?

[peterlaursen]

Sorry that I did not think about this before, but it is likely an issue with FLOATING POINT datatypes.

Please read:

http://dev.mysql.com…with-float.html

http://www.webyog.com/faq/content/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

“When using Floating Point datatypes there should always be a PK based on non-floating column(s) and the PK-column(s) should be included in every SELECT generating a result set used for updating the table.”

[Ganesh M Doss]

Hai peterlaursen

Client also used to delete some datas who are not complete the registeration,

I tested with me datas, Run the web page registered and contributed for some product, values are stored in the

extract table, then i deleted some values still it remains there,

In the previous post i told this:

select * from tblContributionPayment where contributionId = 100789

Record displays without contributionId 100789 rows, works fine.

But by executing,

select * from tblContributionPayment

It list all values including deleted values.

First i have to find what is the problem?

Then i execute “SHOW VARIABLES LIKE 'autocommit';”

Nothing displayed, then i executed “SHOW VARIABLES;” It list lot of vaiables and values but there is no autocommit Or commit related variables.

I'm sure my client has not insert any values.

I want to know what is the problem?

Can you help me?

Thanks peterlaursen

& Thanks to all

Regards

Ganesh M S

'peterlaursen' wrote on '21:

btw: are you perfectly sure that the data you delete are not inserted again by another client?

[peterlaursen]

Please understand what I wrote about FLOATING POINT datatypes and also please tell the output from “SHOW CREATE TABLE that_table;”

[Author]

Posts