[solved]Phpmyadmin won't start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

[solved]Phpmyadmin won't start

Postby gimbgimb » 13. June 2012 15:44

Hi Apache Friends,

I'm grateful in advance if anyone can help me on this one.

I've been using Xampp for some time now with no issues. Today my computer restarted after I changed a windows setting (unrelated to xampp) - with Xampp (Apache and MySql) running. After restart I am not able to open Phpmyadmin. The error I see is
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."

MySql and Apache both start OK and I am able to run my applications. I just can't open Phpmyadmin because of the above error.

The Mysql log files shows:

120613 22:07:10 [Note] Plugin 'FEDERATED' is disabled.
120613 22:07:10 InnoDB: The InnoDB memory heap is disabled
120613 22:07:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:07:10 InnoDB: Compressed tables use zlib 1.2.3
120613 22:07:10 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:07:10 InnoDB: Completed initialization of buffer pool
120613 22:07:10 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:07:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120613 22:07:11 InnoDB: Waiting for the background threads to start
120613 22:07:12 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:07:12 [Note] Event Scheduler: Loaded 0 events
120613 22:07:12 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:08:16 [Note] Plugin 'FEDERATED' is disabled.
120613 22:08:16 InnoDB: The InnoDB memory heap is disabled
120613 22:08:16 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:08:16 InnoDB: Compressed tables use zlib 1.2.3
120613 22:08:16 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:08:16 InnoDB: Completed initialization of buffer pool
120613 22:08:16 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:08:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120613 22:08:17 InnoDB: Waiting for the background threads to start
120613 22:08:18 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:08:18 [Note] Event Scheduler: Loaded 0 events
120613 22:08:18 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
120613 22:09:35 [Note] Plugin 'FEDERATED' is disabled.
120613 22:09:35 InnoDB: The InnoDB memory heap is disabled
120613 22:09:35 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120613 22:09:35 InnoDB: Compressed tables use zlib 1.2.3
120613 22:09:35 InnoDB: Initializing buffer pool, size = 16.0M
120613 22:09:35 InnoDB: Completed initialization of buffer pool
120613 22:09:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120613 22:09:35 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120613 22:09:36 InnoDB: Waiting for the background threads to start
120613 22:09:37 InnoDB: 1.1.8 started; log sequence number 193066342
120613 22:09:37 [Note] Event Scheduler: Loaded 0 events
120613 22:09:37 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)

It seems this same log sequence has been occuring for some weeks now so I am not sure that is the issue.

Are there any other log files I need to check? I haven't changed any config settings or passwords in some months.

Any help at all would be appreciated as I am trying to avoid having to dump this Xampp install and start again.

Gen
gimbgimb
 
Posts: 2
Joined: 13. June 2012 15:35
XAMPP Version: 5.6.3
Operating System: Windows 7 64 bit

Re: Phpmyadmin won't start

Postby JonB » 13. June 2012 17:22

Was the Windows change an IE or browser change???

Like maybe cleaning out cookies or disabling them, or installing a firewall/AV ?

:?:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Phpmyadmin won't start

Postby Altrea » 13. June 2012 17:29

Hi Gen,

Please try following possible solutions:
  • delete your browser cookies
  • Read out in your \xampp\php\php.ini file your session.save_path (by default it should be something like C/xampp/tmp) and check if this folder
    • exists
    • is readable and writable for Apache
  • Stop your Apache, remove all sessions in your session.save_path folder and restart it again

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6692
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: W7Ux64

Re: Phpmyadmin won't start

Postby gimbgimb » 14. June 2012 05:25

Clearing the cache, history and cookies resolved the issue. The config setting I was changing was the "locale" in Windows. In hindsight this should have been patently obvious that it was a browser issue. Obviously I should have just gone to bed instead of banging my head against the wall until all hours of the night. Thanks to Altrea and JonB for your replies.
gimbgimb
 
Posts: 2
Joined: 13. June 2012 15:35
XAMPP Version: 5.6.3
Operating System: Windows 7 64 bit

Re: [solved]Phpmyadmin won't start

Postby JonB » 14. June 2012 07:12

We are glad you got it resolved...

Good Luck with your project.
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: [solved]Phpmyadmin won't start

Postby Beltran » 18. July 2013 09:51

Thanks for reporting it. We have just published a new version for OS X that fixes this issue: 1.8.2-1.
User avatar
Beltran
Power-User
 
Posts: 81
Joined: 22. March 2013 12:29
XAMPP Version: 5.5.19
Operating System: Windows, Linux, OS X


Return to XAMPP for Windows

Who is online

Users browsing this forum: Nobbie and 66 guests