Apache Friends Support Forum

I've upgraded 1.6.8a to 1.7.0, and got a error message at starting mysql as follows:

090102 18:34:09 [ERROR] K:\xampp\mysql\bin\mysqld-nt.exe: unknown option '--skip-bdb'

According to "http://www.apachefriends.org/winxampp/upgrade-howto.txt", I changed my.cnf:

[By Hand]: Editing "my.cnf" for Mysql => <xampp>\mysgl\bin\my.cnf
Comment out these line with #: innodb_log_arch_dir = "/xampp/mysql/"

How can I solve this problem?

Comment out the skip-bdb part as it is not contained in the new version my.cnf file and the error message confirms that it is no longer recognized - unknown option.

...so the 2 lines looks like this:
# Uncomment the following if you are NOT using BDB tables
# skip-bdb

Save the file and restart MySQL.

Sharley,

Thank you for your kind relpy.

I solved mysql starting error, but now apache has another problem.

When open localhost, apache dies with "stopped Apache HTTP Server".

The error log is as follows;

[Fri Jan 02 19:41:27 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 19:41:27 2009] [notice] Parent: Created child process 7464
[Fri Jan 02 19:41:27 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Child process is running
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Acquired the start mutex.
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Starting 250 worker threads.
[Fri Jan 02 19:41:28 2009] [notice] Child 7464: Starting thread to listen on port 8080.
[Fri Jan 02 19:41:44 2009] [notice] Parent: child process exited with status 255 -- Restarting.

Please try and start Apache using the apache_start.bat file in the xampp folder.

It should give a much more detailed error message why Apache can't start.

If your not sure of what the error message means, if you get an error message that is, then you can paste it here so we can evaluate it for you.

I had longer error log.

[Fri Jan 02 19:53:07 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:53:07 2009] [warn] pid file K:/apm_packages/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Fri Jan 02 19:53:08 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Fri Jan 02 19:53:08 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 19:53:08 2009] [notice] Parent: Created child process 656
[Fri Jan 02 19:53:08 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Child process is running
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Acquired the start mutex.
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Starting 250 worker threads.
[Fri Jan 02 19:53:09 2009] [notice] Child 656: Starting thread to listen on port 8080.
[Fri Jan 02 19:55:01 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.

And my box is vista x64 for reference.

Try this fix even though it is for a PDO issue it might help with yours:
viewtopic.php?f=16&t=32617

This post had your issue and was fixed from the above post.
viewtopic.php?f=16&t=32507

There could be an issue with one of the upgrade dlls and if you replace the one in the above fix it may help but it will do no harm.

Did you run the mysql_upgrade.exe file from the mysql folder after doing the XAMPP upgrade?

Can you check the Windows event viewer for any clues.

Sharley,

Thank you for your further replies.

I didn't run " mysql_upgrade.exe ", after reading your reply I ran it.

Now I amfollowing your instructions. After doing this I'll post result.

=============================

I got this error log.

[Fri Jan 02 20:40:13 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Fri Jan 02 20:40:15 2009] [notice] Child 5528: Exit event signaled. Child process is ending.
[Fri Jan 02 20:40:16 2009] [notice] Parent: Child process exited successfully.
[Fri Jan 02 20:42:16 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 20:42:17 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.9-dev configured -- resuming normal operations
[Fri Jan 02 20:42:17 2009] [notice] Server built: Dec 10 2008 00:10:06
[Fri Jan 02 20:42:17 2009] [notice] Parent: Created child process 6280
[Fri Jan 02 20:42:18 2009] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Child process is running
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Acquired the start mutex.
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Starting 250 worker threads.
[Fri Jan 02 20:42:19 2009] [notice] Child 6280: Starting thread to listen on port 8080.

Mysql also made error logs.

090102 19:40:04 InnoDB: Started; log sequence number 0 43655
090102 19:40:04 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
090102 19:40:04 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090102 19:40:04 [Note] K:\apm_packages\xampp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)
090102 20:18:47 [ERROR] Invalid (old?) table or database name '$g4[singo_reason_table]'
090102 20:41:58 [ERROR] Invalid (old?) table or database name '$g4[singo_reason_table]

I encounter the same problem as hanpedro got with his MySQL Server since my update from 1.7.0 to 1.7.1

Did anyone find a solution?

Thanks for your answers!

Sorry... i don't want to spam but isnt there anyone who got a solution?
I tried to replace the event table with a backup of the previous version (1.7.0) but it still wont work (well the table size was equal so i dont think the patch changed anything).
My MySQL server has gone for 3 days now and i'm hosting several projects on it... i need to get it work!

If anyone got a solution PLEASE post it!

Apache Friends Support Forum

1.7.0 upgrade - unknown option '--skip-bdb'

1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'

Re: 1.7.0 upgrade - unknown option '--skip-bdb'