Bug mysql data double entry recently

Submitted by chrissim on Thu, 09/24/2009 - 00:50

hi,

i'm using the latest bear sql v1.20 and so far everything is working fine on my side. As i have added more tables in my database eg wordpress etc and other tables, i have noticed recently each time i login to bearsql and adding personal data it gave a double entry in my mysql database. Previously it was fine until lately and i don't understand what is happening here. Can you advise me on this matter and solve it out?

‹ linux bug Parse error ›

Is the double data only

Submitted by Tony on Thu, 09/24/2009 - 07:09.

Is the double data only happening when you add personal data?
Could it be specific to the database.
I don't get double data when inserting records.
Please walk me through exactly how to reproduce the double data issue.

Double Data

Submitted by chrissim on Thu, 09/24/2009 - 13:09.

hi Tony,

Yes this issue only happened when adding personal data and i have to delete the dupplicate entry when it has record my the detail entry.
Previously it doesn't happened when i'm using bearsql.Tried to optimize the selected Table in mysql that gave problem but the issue still the same. That selected table has generated around 254488 bytes of data recently and i just noticed the problem of adding data to that table.

I tried tested adding data on other new table with the same fields name which i have created few months ago and this new table has 0 data entry. So i tried adding them to see whether the problem persisted but it still showed the same issue.

Could it be the database gave problem to bearsql?

Thanks

Chris

Double Data

Submitted by chrissim on Thu, 09/24/2009 - 13:21.

hi Tony,

Yes this issue only happened when adding personal data and i have to delete the dupplicate entry each time it has recorded my the detail entry.
Previously it doesn't happened when i'm using bearsql.Tried to optimize the selected Table in mysql that gave problem but the issue still the same. That selected table has generated around 254488 bytes of data recently and i just noticed the problem of adding data to that table since yesterday.

I tried tested adding data on other new table with the same fields name which i have created few months ago and this new table has 0 data entry. So i tried adding them to see whether the problem persisted but it still showed the same issue.

Could it be the database gave problem to bearsql?

Thanks

Chris

I noticed you have submitted

Submitted by Tony on Thu, 09/24/2009 - 13:30.

I noticed you have submitted the same entry twice here. Did you refresh the page or submit twice?
Is the browser refreshing or are you causing the refresh. Try using a different browser possibly one of your browser extensions or plugins is causing a page refresh.

Data Entry

Submitted by chrissim on Thu, 09/24/2009 - 20:40.

hi Tony,

You right about the stupid FireFox browser. I tried on Internet Explorer and tested on the new table...everything turns out good. Actually when i tried to adding data using the FireFox i didn't refreshed them but i have no idea what really cause them this way. The Browser page didn't refreshed when the data recorded them and i never tried to submit twice.
Thanks for clarifying the problem otherwise i will not knowing what is going wrong with my bearsql software.

Thanks

Chris

don't give up with Firefox..

Submitted by ilyaskazi on Thu, 10/29/2009 - 16:04.

Hello Chris,

don't give up with Firefox.. Try re-installing the firefox completely.

Once un-installed, make sure you delete all add-ons/extensions of firefox from your program and documents directory. Then you should be good to go.

Ty,
Ilyas Kazi