Unable to start xampp after upgrade

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

Unable to start xampp after upgrade

Postby lmolenaar » 26. February 2009 16:15

Dear support guys,

I upgraded my xampp installation using the installation (executable) method from 1.6.8 to 1.7 but now mySQL is no longer able to start.
I found a topic where someone had the exact same problem: Link

In that topic it was advice to comment out the "skip-bdb" line in the my.cnf file.
After I did this and start the mysql the following was returned:
C:\Program Files\xampp>mysql_start
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
090226 15:57:53 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
090226 15:57:53 [Note] Plugin 'InnoDB' disabled by command line option
mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist
090226 15:57:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090226 15:57:53 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090226 15:57:53 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50015, now running 50130. Please use mysql_upgrad
e to fix this error.
090226 15:57:53 [ERROR] mysql.user has no `Event_priv` column at position 29
090226 15:57:53 [ERROR] Cannot open mysql.event
090226 15:57:53 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090226 15:57:53 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)


The service is not started though according to the services window.
When I press CTRL-C it is displaying:
090226 15:59:42 [Note] mysql\bin\mysqld: Normal shutdown

090226 15:59:42 [Note] mysql\bin\mysqld: Shutdown complete

Terminate batch job (Y/N)?


Please help me out as the site I host with xampp is used frequently.

Many thanks for your help.
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59

Re: Unable to start xampp after upgrade

Postby Wiedmann » 26. February 2009 16:24

090226 15:57:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

Stop any MySQL service.
First start MySQL with "mysql_start.bat"
Code: Select all
cd \xampp\mysql\bin
mysql_upgrade --force -u root -p -t "%TEMP%"

Stop MySQL with "mysql_stop.bat"
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Unable to start xampp after upgrade

Postby lmolenaar » 26. February 2009 16:40

That resolved my issue, many thanks for your swift reply!

I hope you could help me with the second problem I encounter :oops:
It seems PHP pages are no longer loading?
The server keeps loading the PHP file while when I try to access an image that image is displayed immediatly

Thanks in advance
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59

Re: Unable to start xampp after upgrade

Postby Wiedmann » 26. February 2009 16:44

It seems PHP pages are no longer loading?

- Anything in Apaches error.log?
- The XAMPP demo pages are also not working?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Unable to start xampp after upgrade

Postby lmolenaar » 26. February 2009 16:53

It seems the problem is not related to PHP, as the phpinfo() page is working.
I hope my mediawiki DB is still intact.

I will keep you updated, thanks for your help
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59

Re: Unable to start xampp after upgrade

Postby lmolenaar » 26. February 2009 16:58

However, http://127.0.0.1/phpMyAdmin/index.php is also no longer loading...still a database error?
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59

Re: Unable to start xampp after upgrade

Postby Wiedmann » 26. February 2009 17:02

However, http://127.0.0.1/phpMyAdmin/index.php is also no longer loading

3 additional things to do:
- Rename/copy "libmysql_5.1.51a.dll" to "libmysql.dll" in "\xampp\apache\bin" and "\xampp\php".
- Rename/copy "php_mysql_5.0.51a.dll" to "php_mysql.dll" in "\xampp\php\ext".
- Rename/copy "php_mysqli_5.0.51a.dll" to "php_mysqli.dll" in "\xampp\php\ext".
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Unable to start xampp after upgrade

Postby lmolenaar » 26. February 2009 20:16

That did it! Many many thanks!
lmolenaar
 
Posts: 6
Joined: 26. February 2009 15:59


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 46 guests