MemeZilla » 2005

Archive for June, 2005

Lost connection to MySQL server during query

Written by coregps on Thursday, June 16th, 2005 in MySQL.

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

I have a web application which works fine originally. But recently, when I update a table (only change the value of a field from ‘1′ to ‘0′) by executing the following command in the MySQL console:

update ads set validate=’0′ where id=1

I always get the following error message:

Error 2013 <HY000>: Lost connection to MySQL server during query

However, when I update all of the other fields, the SQL commands can be executed successfully. Finally, I export the data from the table to a text file, then drop the table and recreate a new table, and then import the data back into the new table. After finishing these steps, I run the update SQL command again. the SQL statement executes successfully. I imagine that maybe the table is corrupt.

DHTML menu always stays behind Java applet

Written by coregps on Sunday, June 12th, 2005 in Web Design.

No Comments

In my current project, I’m using a DHTML drop down menu in a web page which contains a Java applet. However, the Java applet ALWAYS stays on top. I tried to put the applet in a layer and hide it when the menu is shown. It can work, but I feel that the solution is not perfect. Finally, I found an excellent DHTML menu - DHTML Menu 4. It can be diaplayed outside the physical boundaries of the browser window. The more exciting thing is that it can cover windowed controls such as plugins and select boxes. That is what I want! In addition, the menu system is totally object oriented. Using it is straightforward. The following is my example code:

<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”>
<html>
<head>
<title>DHTML Menu Test</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″>

// 1. include the JavaScript files and CSS file needed

var tmp;

// set default css file to use
Menu.prototype.cssFile = “skins/officexp/officexp.css”;

// 2. create menus

var fileMenu = new Menu();

testMenu.add( tmp = new MenuItem(”Website”, “http://webfx.eae.net/“) );
tmp.target = “_blank”;
tmp.mnemonic = ‘w’;
tmp.shortcut = “Ctrl+W”;

testMenu.add( tmp = new MenuItem(”Exit”, function () { window.close(); }) );
tmp.mnemonic = ‘x’;

// 3. create the menu bar and buttons that opens up the menus

var menuBar = new MenuBar();

menuBar.add( tmp = new MenuButton(”File”, testMenu) );

//]]>
</script>

</head>

<body>
<div style=”border-top: 2px groove; border-bottom: 2px groove;”>
    <script type=”text/javascript”>
       // 4. use the write method to create the menu bar
       menuBar.write();
    </script>

// the applet appears here

</body>
</html>

For more information about DHTML Menu 4, see http://webfx.eae.net/dhtml/dhtmlmenu4/menu4.html.