WampServer

Hello guys,
Am trying to migrated joomla from wamp servers and get error 500.


I Checked my MySQL logs and noticed this error message. 130617 15:45:51 InnoDB: The InnoDB memory heap is disabled

So in MySQL.ini file, I uncommented the codes below. But the wamp server is not restarting. Kindly advise

here is my code ( NOte I changed the default path from c:\mysql\data/ to what you have below, as there is my db installed )

many thanks
Ehi

Code:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = C:\wamp\bin\mysql\mysql5.5.24\data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:\wamp\bin\mysql\mysql5.5.24\data/
innodb_log_arch_dir = C:\wamp\bin\mysql\mysql5.5.24\data/
#You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

If you found a my.ini ( or mysql.ini ) that has the datadir param set to c:\mysql\data\ then its not wamps my.ini.

What are you trying to migrate your Joomla to?


By the way its not an error message its INFO and means InnoDB is configured to use system memory instead of memory allocated by itself.

[forums.mysql.com]

Are you using innodb format databases?



Edited 2 time(s). Last edit at 06/19/2013 10:57AM by RiggsFolly.

Yes it is, I found it in both locations C:\wamp\bin\mysql\mysql5.5.24 and clicking on the my.ini file under the wamp tray icon.

To be honest, I am totally new to joomla and mysql environment. As our client site was built with joomla and the lead developer left, hence am stuck with the migration.

And I get the error 500 when I try to browse it, hence posting the logs here.

So what do i do ?

thanks

If you have another my.ini in a location other than the c:\wamp\..... folder structure it should be removed.
Best rename it rather than delete it.

MySQL does a search for its .ini or .cnf file and sometimes there is one in the c:\windows\..... folder structure and it can pick that up before it looks in its own execution folder.

A 500 error is from Apache and usually means either the PHP code has done something very bad or there is some misconfiguration of Apache.