[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?

[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

[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

[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

[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]

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

[Author]

Posts