[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 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