[wdvltalk] RE: [OT] freezing in MySQL
-Original Message- From: Smile-Poet [Subject: [wdvltalk] RE: [OT] freezing in MySQL The most likely cause (remembering earlier comments on long text in tables, OR links to files) is the blogs as there seems also an issue with varchar. Then poor old mysql gets confused (and aren't we all?). Thanks for nursing me along on this; all I have to do now is find a way of saving work in the blog table!! Joseph Export the blog tables and import them when you get it back up. Just like you would do with archive in outlook. Long text does seem to cause all kinds of problems in many places. We've had some horrific driver issues with blog text in Cold Fusion apps. So you aren't alone. drew The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
Thanks drew, I ended up here http://www.mysqldeveloper.com/manual/index.pcgi?lookup=10796 And as it seems a general fault (all databases, any table) I am assuming it is one of the corruptions (poss index/data files). Since I need to get my hands a bit dirtier anyway I think a complete re-instal of Easyphp (apache, mysql and php with phpmyadmin) is going to be quicker and less painful than searching out the precise fault and then rectifying. The most likely cause (remembering earlier comments on long text in tables, OR links to files) is the blogs as there seems also an issue with varchar. Then poor old mysql gets confused (and aren't we all?). Thanks for nursing me along on this; all I have to do now is find a way of saving work in the blog table!! Joseph > I'm inclined to agree the hotfix seems an unlikely cause. Next thing would > be to check the mysql mail lists and bulletin boards and the sourceforge > mysql faq. Check archives and such to see if the question has already been > answered. If not ask. It's not as if repeat questions don't occur. > > drew > > -Original Message- > From: Smile-Poet [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 06, 2004 7:56 PM > To: [EMAIL PROTECTED] > Subject: [wdvltalk] RE: [OT] freezing in MySQL > > Drew, > > I have uninstalled everything that has been recently added but there is no > change in the problem. However I see that a 'hotfix' was installed by M$ > on 15 May.I wonder if uninstalling that might be my answer?Is it > likely to be affecting any part of a local server, since it seems to be > related to the risk of remote code execution? > > The Security bulletin is: > > >>>>>>>>>>>Microsoft Security Bulletin MS04-015 Vulnerability in Help and > Support Center Could Allow emote Code Execution (840374)<<<<<<<<<<<<< > > And the part that may be relevant says: > > >>>>>>>>>>>>>> Workarounds for Help and support Center Vulnerability - > CAN-2004-0199: > Microsoft has tested the following workarounds. While these workarounds > will not correct the underlying vulnerability, they help block known attack > vectors. When a workaround reduces functionality, it is identified below. > > . Unregister the HCP Protocol. > To help prevent an attack, unregister the HCP Protocol by deleting the > following key from the registry: HKEY_CLASSES_ROOT\HCP. To do so, follow > these steps: >1. Click Start, and then click Run. > 2. Type regedit, and then click OK. > The registry editor program launches. > 3. Expand HKEY_CLASSES_ROOT, and then highlight the HCP key. > 4. Right-click the HCP key, and then click > Delete.<<<<<<<<<<<<<<<<<< > > What do you think?? > > Joseph > > > > > Not so 'Aha...' > > > > Still freezing.I have removed all the tables except the controlling > > 'mysql'.Do I need to reinstall the whole bundle of progams (Easyphp > with > > Apache, MySQL and PHP)?Or just MySQL. Or is there another answer? > > > > If, with phpMyAdmin, I open a database I can, variably, open none, one, > two, > > or three tables; but the next table starts to show a limping attempt and > > then freezes. I can only get back into the databases by restarting the > > machine. > > > > Programs outside the local server do not appear to be affected The local > > website, Blog and ghostshop all appear to be running (though now moaning > > about the lack of databases). > > > > Joseph > > > > ++ > > > > Take the blog program off not just the tables. If you've done that and I > > simple am misunderstanding, then you van put it all back and take off the > > Via Voice. One piece at a time so there is no question about where the > > problems lies when it is found. > > > > drew > > > * The WDVL Discussion List from WDVL.COM * > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] >Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the > words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubs
[wdvltalk] RE: [OT] freezing in MySQL
I'm inclined to agree the hotfix seems an unlikely cause. Next thing would be to check the mysql mail lists and bulletin boards and the sourceforge mysql faq. Check archives and such to see if the question has already been answered. If not ask. It's not as if repeat questions don't occur. drew -Original Message- From: Smile-Poet [mailto:[EMAIL PROTECTED] Sent: Sunday, June 06, 2004 7:56 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [OT] freezing in MySQL Drew, I have uninstalled everything that has been recently added but there is no change in the problem. However I see that a 'hotfix' was installed by M$ on 15 May.I wonder if uninstalling that might be my answer?Is it likely to be affecting any part of a local server, since it seems to be related to the risk of remote code execution? The Security bulletin is: >>>>>>>>>>>Microsoft Security Bulletin MS04-015 Vulnerability in Help and Support Center Could Allow emote Code Execution (840374)<<<<<<<<<<<<< And the part that may be relevant says: >>>>>>>>>>>>>> Workarounds for Help and support Center Vulnerability - CAN-2004-0199: Microsoft has tested the following workarounds. While these workarounds will not correct the underlying vulnerability, they help block known attack vectors. When a workaround reduces functionality, it is identified below. . Unregister the HCP Protocol. To help prevent an attack, unregister the HCP Protocol by deleting the following key from the registry: HKEY_CLASSES_ROOT\HCP. To do so, follow these steps: 1. Click Start, and then click Run. 2. Type regedit, and then click OK. The registry editor program launches. 3. Expand HKEY_CLASSES_ROOT, and then highlight the HCP key. 4. Right-click the HCP key, and then click Delete.<<<<<<<<<<<<<<<<<< What do you think?? Joseph > > Not so 'Aha...' > > Still freezing.I have removed all the tables except the controlling > 'mysql'.Do I need to reinstall the whole bundle of progams (Easyphp with > Apache, MySQL and PHP)?Or just MySQL. Or is there another answer? > > If, with phpMyAdmin, I open a database I can, variably, open none, one, two, > or three tables; but the next table starts to show a limping attempt and > then freezes. I can only get back into the databases by restarting the > machine. > > Programs outside the local server do not appear to be affected The local > website, Blog and ghostshop all appear to be running (though now moaning > about the lack of databases). > > Joseph > > ++ > > Take the blog program off not just the tables. If you've done that and I > simple am misunderstanding, then you van put it all back and take off the > Via Voice. One piece at a time so there is no question about where the > problems lies when it is found. > > drew * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
Drew, I have uninstalled everything that has been recently added but there is no change in the problem. However I see that a 'hotfix' was installed by M$ on 15 May.I wonder if uninstalling that might be my answer?Is it likely to be affecting any part of a local server, since it seems to be related to the risk of remote code execution? The Security bulletin is: >>>Microsoft Security Bulletin MS04-015 Vulnerability in Help and Support Center Could Allow emote Code Execution (840374)< And the part that may be relevant says: >> Workarounds for Help and support Center Vulnerability - CAN-2004-0199: Microsoft has tested the following workarounds. While these workarounds will not correct the underlying vulnerability, they help block known attack vectors. When a workaround reduces functionality, it is identified below. . Unregister the HCP Protocol. To help prevent an attack, unregister the HCP Protocol by deleting the following key from the registry: HKEY_CLASSES_ROOT\HCP. To do so, follow these steps: 1. Click Start, and then click Run. 2. Type regedit, and then click OK. The registry editor program launches. 3. Expand HKEY_CLASSES_ROOT, and then highlight the HCP key. 4. Right-click the HCP key, and then click Delete.<< What do you think?? Joseph > > Not so 'Aha...' > > Still freezing.I have removed all the tables except the controlling > 'mysql'.Do I need to reinstall the whole bundle of progams (Easyphp with > Apache, MySQL and PHP)?Or just MySQL. Or is there another answer? > > If, with phpMyAdmin, I open a database I can, variably, open none, one, two, > or three tables; but the next table starts to show a limping attempt and > then freezes. I can only get back into the databases by restarting the > machine. > > Programs outside the local server do not appear to be affected The local > website, Blog and ghostshop all appear to be running (though now moaning > about the lack of databases). > > Joseph > > ++ > > Take the blog program off not just the tables. If you've done that and I > simple am misunderstanding, then you van put it all back and take off the > Via Voice. One piece at a time so there is no question about where the > problems lies when it is found. > > drew The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
Not so 'Aha...' Still freezing.I have removed all the tables except the controlling 'mysql'.Do I need to reinstall the whole bundle of progams (Easyphp with Apache, MySQL and PHP)?Or just MySQL. Or is there another answer? If, with phpMyAdmin, I open a database I can, variably, open none, one, two, or three tables; but the next table starts to show a limping attempt and then freezes. I can only get back into the databases by restarting the machine. Programs outside the local server do not appear to be affected The local website, Blog and ghostshop all appear to be running (though now moaning about the lack of databases). Joseph > Aha...! > > drew, > > In the course of preparing and gingerly testing what froze and what didn't I > discovered windows was opening in diagnostic mode (I did nothing, guv, > honest).Having allowed myself to be bullied back into loading all > drivers, etc, MySQL appears to be working perfectly. > > Well, at least I have finally backed up the tables! > > Joseph. > > > drew, > > > > At least you're not suggesting a complete reinstallation... > > ... > > ... > > ...yet... > > > > Joseph > > > > PS Thanks for the advice; I'll let you know how it goes. > > > > > > > > > > > This may have happened since I loaded Weblog and put its tables in one > of > > > the databases. ... The other main thing I have > > > installed is Via Voice. > > > > > > > > > Joseph > > > > > > +++ > > > > > > Joe, seems you haven't gotten much response to your request. So here's > the > > > one bit of troubleshooting advice you didn't want to hear: undo the last > > > thing you did and see if that fixes it. Take out Weblog tables first see > > if > > > it solves the problem. Then the entire weblog app. If not then try Via > > > Voice. > > > > > > drew > > > > > > . The WDVL Discussion List from WDVL.COM . > > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > >Send Your Posts To: [EMAIL PROTECTED] > > To set a personal password send an email to [EMAIL PROTECTED] with the > words: "set WDVLTALK pw=yourpassword" in the body of the email. > > To change subscription settings to the wdvltalk digest version: > > http://wdvl.internet.com/WDVL/Forum/#sub > > > > http://www.wdvl.com ___ > > > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to %%email.unsub%% > > > > To unsubscribe via postal mail, please contact us at: > > Jupitermedia Corp. > > Attn: Discussion List Management > > 475 Park Avenue South > > New York, NY 10016 > > > > Please include the email address which you have been contacted with. > > > The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
Way to go Joe! Merit badge in Troubleshooting and a pint. drew -Original Message- From: Smile-Poet [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 6:58 AM To: [EMAIL PROTECTED] Subject: [wdvltalk] RE: [OT] freezing in MySQL Aha...! drew, In the course of preparing and gingerly testing what froze and what didn't I discovered windows was opening in diagnostic mode (I did nothing, guv, honest).Having allowed myself to be bullied back into loading all drivers, etc, MySQL appears to be working perfectly. Well, at least I have finally backed up the tables! Joseph. > drew, > > At least you're not suggesting a complete reinstallation... > ... > ... > ...yet... > > Joseph > > PS Thanks for the advice; I'll let you know how it goes. > > > > > > > This may have happened since I loaded Weblog and put its tables in one of > > the databases. ... The other main thing I have > > installed is Via Voice. > > > > > > Joseph > > > > +++ > > > > Joe, seems you haven't gotten much response to your request. So here's the > > one bit of troubleshooting advice you didn't want to hear: undo the last > > thing you did and see if that fixes it. Take out Weblog tables first see > if > > it solves the problem. Then the entire weblog app. If not then try Via > > Voice. > > > > drew > > > . The WDVL Discussion List from WDVL.COM . > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] >Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > * The WDVL Discussion List from WDVL.COM * To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
Aha...! drew, In the course of preparing and gingerly testing what froze and what didn't I discovered windows was opening in diagnostic mode (I did nothing, guv, honest).Having allowed myself to be bullied back into loading all drivers, etc, MySQL appears to be working perfectly. Well, at least I have finally backed up the tables! Joseph. > drew, > > At least you're not suggesting a complete reinstallation... > ... > ... > ...yet... > > Joseph > > PS Thanks for the advice; I'll let you know how it goes. > > > > > > > This may have happened since I loaded Weblog and put its tables in one of > > the databases. ... The other main thing I have > > installed is Via Voice. > > > > > > Joseph > > > > +++ > > > > Joe, seems you haven't gotten much response to your request. So here's the > > one bit of troubleshooting advice you didn't want to hear: undo the last > > thing you did and see if that fixes it. Take out Weblog tables first see > if > > it solves the problem. Then the entire weblog app. If not then try Via > > Voice. > > > > drew > > > . The WDVL Discussion List from WDVL.COM . > To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] >Send Your Posts To: [EMAIL PROTECTED] > To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. > To change subscription settings to the wdvltalk digest version: > http://wdvl.internet.com/WDVL/Forum/#sub > > http://www.wdvl.com ___ > > You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > > To unsubscribe via postal mail, please contact us at: > Jupitermedia Corp. > Attn: Discussion List Management > 475 Park Avenue South > New York, NY 10016 > > Please include the email address which you have been contacted with. > The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
drew, At least you're not suggesting a complete reinstallation... ... ... ...yet... Joseph PS Thanks for the advice; I'll let you know how it goes. > > > This may have happened since I loaded Weblog and put its tables in one of > the databases. ... The other main thing I have > installed is Via Voice. > > > Joseph > > +++ > > Joe, seems you haven't gotten much response to your request. So here's the > one bit of troubleshooting advice you didn't want to hear: undo the last > thing you did and see if that fixes it. Take out Weblog tables first see if > it solves the problem. Then the entire weblog app. If not then try Via > Voice. > > drew The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
[wdvltalk] RE: [OT] freezing in MySQL
-Original Message- From: Smile-Poet Sent: Wednesday, June 02, 2004 6:26 PM To: [EMAIL PROTECTED] Subject: [wdvltalk] [OT] freezing in MySQL This may have happened since I loaded Weblog and put its tables in one of the databases. ... The other main thing I have installed is Via Voice. Joseph +++ Joe, seems you haven't gotten much response to your request. So here's the one bit of troubleshooting advice you didn't want to hear: undo the last thing you did and see if that fixes it. Take out Weblog tables first see if it solves the problem. Then the entire weblog app. If not then try Via Voice. drew The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.