[Phpmyadmin-devel] phpMyAdmin crashes several times a day
I am running on OS X 10.5.7 on an iMac 24 Intel machine, spend 10-14 hours a day programming, and hardly ever experience any kind of an application hang, much less a crash. Several days ago I downloaded and installed Zend Server CE, which came with phpMyAdmin. I have been using Navicat with mySQL and pgSQL for a long time, and for the most part have experienced no problems. Over the past few days I have tried to move away from Navicat, but phpMyAdmin crashes almost every time I use it. I have been reading in an sql file that creates some tables, triggers, adds a few records. There's less than 10 records involved and 3 tables. ( 1 ) Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records ( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes. I have also tried creating a table from scratch, adding a few records, and exporting the Structure and Data to a file. I will then drop the database, and create a new one. At this point I will try steps ( 1 ) through ( 6 ) again with the same results. It doesn't matter whether I try to import the sql file exported from Navicat, or the one exported from phpMyAdmin. It crashes regardless. BTW, I have had to go back to Navicat, and it has yet to crash. It does run rock solid, but has problems exporting out of mySQL and importing into pgSQL, so it's not perfect either. I would love to be able to use phpMyAdmin, and with any luck someone will have a clue. One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me back to the Login Screen and makes me login again. phpMyAdmin seems to work OK from what I've been able to tell with existing databases, the problems appear when I try either pasting the commands to create a table, or actually try to import a file containing the Structure and Data. Here are some observations that have nothing to do with the crashes, but they are just beginners observations.... -- NAVICAT SQL Dump -- version 3.2.0 -- http://www.navicat.com -- -- Host: localhost -- Generation Time: Jul 27, 2009 at 09:50 PM -- Server version: 5.1.32 -- PHP Version: 5.2.10 -- -------------------------------------------------------- -- MY OBSERVATIONS WITH --> SQL Dump -- -------------------------------------------------------- -- Differences between phpMyAdmin and Navicat -- phpMyAdmin does the following : -- -------------------------------------------------------- -- ( 1 ) phpMySQL : Uses // for delimiters in TRIGGERS instead of using ;; -- -------------------------------------------------------- -- ( 1 ) NAVICAT : DELIMITER ;; -- ( 1 ) phpMySQL : DELIMITER // -- -------------------------------------------------------- -- ( 2 ) phpMySQL : DOES NOT put a semi-colon after the END on the triggers -- -------------------------------------------------------- -- ( 2 ) NAVICAT : -- ( 2 ) END; -- ( 2 ) ;; -- -------------------------------------------------------- -- ( 2 ) phpMySQL : -- ( 2 ) END -- ( 2 ) // -- -------------------------------------------------------- -- ( 3 ) phpMySQL : DOES a lot of the keywords in lowercase, not all -- -------------------------------------------------------- -- ( 4 ) phpMySQL : Puts all references to include the database for example: -- ( 4 ) CREATE TRIGGER `mvc_project_01`.`projects_insert_trigger`BEFORE INSERT ON `mvc_project_01`.`projects` -- -------------------------------------------------------- -- ( 4 ) NAVICAT : DOES NOT reference the database for example: -- ( 4 ) CREATE TRIGGER `projects_insert_trigger` BEFORE INSERT ON `projects` -- -------------------------------------------------------- -- ( 6 ) INSERT STATEMENTS -- -------------------------------------------------------- -- ( 6 ) NAVICAT : On the INSERT statements Navicat does not list the fields before the VALUES -- ( 6 ) INSERT INTO `projects` VALUES('1','mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','null','null','Bill Hernandez'); -- -------------------------------------------------------- -- ( 6 ) phpMySQL : Does NOT put single quotes around integers, has a space after each COMMA -- ( 6 ) INSERT INTO `projects` (`id`, `name`, `description`, `created`, `modified`, `modified_by`) VALUES(1,'mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','null','null','Bill Hernandez'); -- -------------------------------------------------------- Any Clues ? Bill Hernandez Plano, Texas
On Jul 28, 2009, at 7:55 PM, Bill Hernandez wrote: Sorry for the double posting, I had just signed up for the list and actually sent the first message before I received authorization to do so. I thought it hadn't gotten through so I took the opportunity to make a few changes and resend it. If you are reading this please delete my first message. Thanks for any insights... Bill Hernandez Plano, Texas
Bill Hernandez wrote:
I am running on OS X 10.5.7 on an iMac 24 Intel machine, spend 10-14 hours a day programming, and hardly ever experience any kind of an application hang, much less a crash.
Several days ago I downloaded and installed Zend Server CE, which came with phpMyAdmin.
I have been using Navicat with mySQL and pgSQL for a long time, and for the most part have experienced no problems.
Over the past few days I have tried to move away from Navicat, but phpMyAdmin crashes almost every time I use it.
I have been reading in an sql file that creates some tables, triggers, adds a few records. There's less than 10 records involved and 3 tables.
( 1 ) Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records
( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes.
I have also tried creating a table from scratch, adding a few records, and exporting the Structure and Data to a file.
How does the crash represent itself to you? White page, back to login screen, or an error message? Anything in the php error log? Could you attach the sql file on which causes the problem?
I will then drop the database, and create a new one.
At this point I will try steps ( 1 ) through ( 6 ) again with the same results.
It doesn't matter whether I try to import the sql file exported from Navicat, or the one exported from phpMyAdmin. It crashes regardless.
BTW, I have had to go back to Navicat, and it has yet to crash. It does run rock solid, but has problems exporting out of mySQL and importing into pgSQL, so it's not perfect either. I would love to be able to use phpMyAdmin, and with any luck someone will have a clue.
One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me back to the Login Screen and makes me login again.
Then how do you come across step (1)? ;) This might very well be a cookie/session problem... Have you looked at the included Documentation.html? -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions
On Jul 29, 2009, at 2:21 AM, Herman van Rink wrote:
Bill Hernandez wrote:
I have also tried creating a table from scratch, adding a few records, and exporting the Structure and Data to a file.
How does the crash represent itself to you? White page, back to login screen, or an error message? Anything in the php error log?
No, the application does a hard crash, It Quits Instantly, NO warning... The next thing I see is a dialog sending Apple the crash dump info... I didn't get a chance to check the log, I will try to do that tomorrow...
Could you attach the sql file on which causes the problem?
I will do a two dumps tomorrow, one from Navicat, and one from phpMyAdmin and forward them to you...
I will then drop the database, and create a new one.
Then how do you come across step (1)? ;)
I create a new database and do an SQL file import...
This might very well be a cookie/session problem... Have you looked at the included Documentation.html?
Yes, but nothing gave me a clue as to the reason for the crashes ? It is a puzzle for sure... Best Regards, Bill Hernandez Plano, Texas
Bill Hernandez wrote:
On Jul 29, 2009, at 2:21 AM, Herman van Rink wrote:
Bill Hernandez wrote:
I have also tried creating a table from scratch, adding a few records, and exporting the Structure and Data to a file.
How does the crash represent itself to you? White page, back to login screen, or an error message? Anything in the php error log?
No, the application does a hard crash, It Quits Instantly, NO warning... The next thing I see is a dialog sending Apple the crash dump info...
Could you check this crash dump info to see which application actually crashed? Since phpMyAdmin runs inside a webserver it would, as far as I know, not generate this king of crash dialog. -- Met vriendelijke groet / Regards, Herman van Rink Initfour websolutions
On Jul 30, 2009, at 1:57 AM, Herman van Rink wrote:
Bill Hernandez wrote:
On Jul 29, 2009, at 2:21 AM, Herman van Rink wrote:
Could you check this crash dump info to see which application actually crashed?
Since phpMyAdmin runs inside a webserver it would, as far as I know, not generate this king of crash dialog.
Herman, I will give you the same response I gave Michal.
Well phpMyAdmin is PHP script, which can not crash on itself. Either your browser did crash or PHP. Both of them (even if triggered by phpMyAdmin) are bugs in software which did really crash.
Herman, You and Michal, are absolutely 100% correct... How could I have missed this ? phpMyAdmin is only a script, even though we get used to calling them (web scripts) applications, they really are not. Even when you look at the Zend Framework structure for a project they always have an "application" folder containing the majority of the code for what should really be a "website script". When you referred to phpMyAdmin as a script, the lightbulb went off in my head and I immediately realized that I was referring to phpMyAdmin as an application, when in fact it is NOT... I further realized that it was most likely Safari that was crashing, and when I went to the crash reporter logs, sure enough, Safari was the culprit, and I was the buffoon that missed it.... I humbly apologize for my brain burp... What an obvious mistake on my part ! Sometimes the forest is so close you cannot see the giant Sequoia you are about to run into... Thank you for bringing me back from the darkness into the light. I changed the default browser from Safari to Firefox, even though it pains me, as much as I like to support Apple, but its time for Firefox. After switching to Firefox, I ran through the same routine several times : ( 1 ) deleting the database, ( 2 ) creating a new one, ( 3 ) importing the structure and data, and ( 4 ) selecting and modifying the records, and phphMyAdmin worked great, and Firefox did not blink ! Thanks very much for the rapid response... Best Regards, Bill Hernandez Plano, Texas
Hi Dne Tue, 28 Jul 2009 19:55:45 -0500 Bill Hernandez <ms@mac-specialist.com> napsal(a):
I have been reading in an sql file that creates some tables, triggers, adds a few records. There's less than 10 records involved and 3 tables.
( 1 ) Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records
( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes.
What does mean it crashes? You get some error message?
One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me back to the Login Screen and makes me login again.
There is some timeout depending on your PHP configuration (session gc) and phpMyAdmin, maybe you just hit the limit.
-- ( 3 ) phpMySQL : DOES a lot of the keywords in lowercase, not all
Can you tell which ones? I think we should be consistent here if possible.
-- ( 6 ) NAVICAT : On the INSERT statements Navicat does not list the fields before the VALUES -- ( 6 ) INSERT INTO `projects` VALUES('1','mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','null','null','Bill Hernandez');
You can configure this on export page. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
On Jul 29, 2009, at 3:52 AM, Michal Čihař wrote:
( 1 ) Create and Select the database ( 2 ) Click on SQL icon ( 3 ) Click on "Import Files" link ( 4 ) Import the file containing the Structure and Data ( 5 ) Try to select a table to view the records
( 6 ) Everything appears fine, but as soon as I try to select a Table to view the records, phpMyAdmin crashes.
What does mean it crashes? You get some error message?
No, the application does a hard crash, It Quits Instantly, NO warning... The next thing I see is a dialog sending Apple the crash dump info... I worked quite a bit yesterday in phpMyAdmin with databases that had been created in Navicat, and had absolutely NO problems. The crashes occur when I am trying to import a Structure and Data that originated from either Navicat, or from phpMyAdmin. phpMyAdmin will export the Structure and Data via a dump, but the if I delete (drop) the database using phpMyAdmin, everything appears fine. I can then create a new database with the same name, and then if I try to import the dump, it appears OK, but when I select a table, there is an instant crash...
One other thing, when I log into phpMyAdmin, it lets me in the door, but as soon as I select a database, it immediately takes me back to the Login Screen and makes me login again.
There is some timeout depending on your PHP configuration (session gc) and phpMyAdmin, maybe you just hit the limit.
-- ( 3 ) phpMySQL : DOES a lot of the keywords in lowercase, not all Can you tell which ones? I think we should be consistent here if possible.
I can send you a database dump from Navicat and one from phpMyAdmin if you would like, I also wrote a script to try to standardize the dump from phpMyAdmin in order to run a diff with BBEdit. I would be happy to send the script as well, but it requires BBEdit...
-- ( 6 ) NAVICAT : On the INSERT statements Navicat does not list the fields before the VALUES -- ( 6 ) INSERT INTO `projects` VALUES('1','mvc_begin','Use Zend Framework to work with a Model, View, Controller PHP System','null','null','Bill Hernandez');
You can configure this on export page.
I like the way phpMyAdmin does this better with the field names included... Thanks for the prompt reply... Best Regards, Bill Hernandez Plano, Texas
Hi Dne Wed, 29 Jul 2009 23:21:57 -0500 Bill Hernandez <ms@mac-specialist.com> napsal(a):
On Jul 29, 2009, at 3:52 AM, Michal Čihař wrote:
What does mean it crashes? You get some error message?
No, the application does a hard crash, It Quits Instantly, NO warning... The next thing I see is a dialog sending Apple the crash dump info...
Well phpMyAdmin is PHP script, which can not crash on itself. Either your browser did crash or PHP. Both of them (even if triggered by phpMyAdmin) are bugs in software which did really crash.
I can send you a database dump from Navicat and one from phpMyAdmin if you would like, I also wrote a script to try to standardize the dump from phpMyAdmin in order to run a diff with BBEdit. I would be happy to send the script as well, but it requires BBEdit...
I think I can figure out what the script does as soon as I can see it. -- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
On Jul 30, 2009, at 4:23 AM, Michal Čihař wrote:
Well phpMyAdmin is PHP script, which can not crash on itself. Either your browser did crash or PHP. Both of them (even if triggered by phpMyAdmin) are bugs in software which did really crash.
Michal, You are absolutely 100% correct... How could I have missed this ? phpMyAdmin is only a script, even though we get used to calling them (web scripts) applications, they really are not. Even when you look at the Zend Framework structure for a project they always have an "application" folder containing the majority of the code for what should really be a "website script". When you referred to phpMyAdmin as a script, the lightbulb went off in my head and I immediately realized that I was referring to phpMyAdmin as an application, when in fact it is NOT... I further realized that it was most likely Safari that was crashing, and when I went to the crash reporter logs, sure enough, Safari was the culprit, and I was the buffoon that missed it.... I humbly apologize for my brain burp... What an obvious mistake on my part ! Sometimes the forest is so close you cannot see the giant Sequoia you are about to run into... Thank you for bringing me back from the darkness into the light. I changed the default browser from Safari to Firefox, even though it pains me, as much as I like to support Apple, but its time for Firefox. After switching to Firefox, I ran through the same routine several times : ( 1 ) deleting the database, ( 2 ) creating a new one, ( 3 ) importing the structure and data, and ( 4 ) selecting and modifying the records, and phphMyAdmin worked great, and Firefox did not blink ! Thanks very much for the rapid response... Best Regards, Bill Hernandez Plano, Texas
participants (3)
-
Bill Hernandez -
Herman van Rink -
Michal Čihař