[Phpmyadmin-devel] phpMyAdmin crashes several times a day

[Bill Hernandez]

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 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 no problems.

I have tried to move away from Navicat over the past few days, 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 )

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, hopefully somebody will have a clue.

One other thing, when I log into phpMyAdmin, and select a database, it  
immediately goes 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  
creation commands for 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
-- --------------------------------------------------------
-- 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','2009-07-27 20:48:54','2009-07-27 20:48:54','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','2009-07-27 20:48:54','2009-07-27 20:48:54','Bill Hernandez');

-- --------------------------------------------------------

Any Clues ?

Bill Hernandez
Plano, Texas