[Phpmyadmin-devel] phpMyAdmin crashes several times a day

[Bill Hernandez]

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