Apache Friends Support Forum

I looked in my.ini file and found things about "InnoDB" which was mentioned in the error log. Also in "phpMyAdmin" the tables are of InnoDB type.

Code: Select all

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/ke-program/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/ke-program/xampp/mysql/data"
#innodb_log_arch_dir = "C:/ke-program/xampp/mysql/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

I have the same items in red and I don't have any databases only the defaults when I installed XAMPP.

I don't seem to be able to find an 'Engines' selection in the top row of phpMyAdmin, could you point me to where you see this message?

Have you checked that your Joomla version is compatible with the versions included in XAMPP?
The version numbers can be found in the readme_en.txt file in the xampp folder.

I have installed XAMPP in a catalogue:
C:\catalogue\xampp

Have you moved XAMPP to another location or have you more than one XAMPP installation?

I now have found the "overhead" title!
Ok, I have only "-" marked there.

I have looked at the databases that came with the installation. Some of them are of MyISAM type. I have not found any with "InnoDB" type as I have for the Joomla tables.

To find Engines: localhost/phpmyadmin >> Upper meny row (far to the right, you may have to select the "more" button go get to see "Engines").

Summary: There seems to be inconsisties in Federated and InnoDB. Maybe some setting have to be changed.

1. InnoDB: I guess InnoDB should be activated in my.ini properly. Something seems to go wrong with InnoDB tables, if one looks at the mysql error log. Also, I can not run the CD Colletion example.

2. Federated: PhpMyAdmin states Federated storage engine but my.ini states "skip-federated" which I interpret as it is not activated. I tried to comment it with a "#" in front, but then mysql crashes at the first query. In the my sql error log I get "111107 15:18:08 [Note] Plugin 'FEDERATED' is disabled." which further makes me think something is going wrong with federated.

The cdcol demo database table uses innodb as does the webauth database tables.

Normally there should be no need to change the my.ini file from the defaults to get Joomla working correctly and as I said perhaps the Joomla forum can throw more light on the subject.

1. Oh, the CD Collection did not work for me! I get the following message: "Could not connect to database!
Is MySQL running or did you change the password?"

I can not find webauth example.

2. I have increased settings for the my.ini file i looked att the my-large.ini for inspiration, but there were several differences so I can not say I felt convinced I did the right thing. When I at the end also increased innodb_ variables mysql would not start any longer, so now i am back with the initial my.ini.

3. I earlier checked that the requirements for PHP and MySQL were met for Joomla. I have Joomla 1.7.2. PHP 5.3.8 and phpMyAdmin 3.4.5. All are recent versions so there should not be a problem. phpMyAdmin says there is a newer version (3.4.7.1), but I have not updated, because I guess I will run into trouble trying to update something inclueded in the XAMPP package.

MySQL
Server: localhost via TCP/IP
Server version: 5.5.16
Protocol version: 10

4. By the way, Is not there any way one can increase the time out length of phpMyAdmin?

The cdcol will not work after you set a password for MySQL and phpMyAdmin.

The cdcol and (webauth is in a default 1.7.7 installation - did you delete it?) are examples that innodb and myisam can coexists.


Can you give me some history about how you installed Joomla in 1.7.7?
Was it a fresh install or did you copy it from elsewhere?

This page seems to say it's fine for Joomla 1.7.2 and XAMPP 1.7.7:
http://www.joomla.org/about-joomla/tech ... ments.html

Any answer to the XAMPP location question here:
viewtopic.php?p=188768#p188768
as this path in the my.ini file differs:

Code: Select all

innodb_data_home_dir = "C:/ke-program/xampp/mysql/data"

from this:

Code: Select all

I have installed XAMPP in a catalogue:
C:\catalogue\xampp

There is a fix for this if indeed the my.ini file is incorrect.

Thanks for beeing attentive! But I am sorry, Actually the catalogue is ke-program. I changed the name to catalogue as an attempt be pedagogic in the beginning. I wanted to state the location of the installation, because somewhere I had read that one is recommended to install xampp in a root catalogue, but I have installed it in a subcatalogue to the root. I did not do the installation in the windows standard directory "C:/Program (x86).

I installed Joomla 1.7.2 by downloading the Stable Full package from the Joomla site. I then uncompressed the zip file. I put the catalogues and files in the xampp/htdocs directory, becoming "xampp/htdocs/Joomla_1.7.2-Stable-Full_Package" (unfortunately I did not change the name to simply Joomla). I think I then opened some file in a web browser where the installation was made. I chose the recommended setting database type MySQLi (improved mysql) ( http://docs.joomla.org/Installing_Joomla!_1.7 ). I never imported a mysql database for my new installation, instead I worked directly on the standard installation example (modifying it to my needs).

The database I had locally in XAMPP was exported to a Joomla installation of the same version (Joomla 1.7.2), but situated on a server on the web. Then Joomla worked better. Therefore I do not think the MySQL tables per see are defective.

The cdcol will not work after you set a password for MySQL and phpMyAdmin.

The cdcol and (webauth is in a default 1.7.7 installation - did you delete it?) are examples that innodb and myisam can coexists.

I set password because it was recommended in order to assure security. Can I remove the passwords with preserved security (from outside attacks)? I am on ADSL with a modem that claims to have a firewall.

I have webauth in the mysql database, but I can not find it in the XAMPP starting page. Where should it be located in the left meny? Is it under PHP, Perl, ...

Turn off microsoft essentials MsMpEng is fighting apache.

Or if you feel unsafe add to MSE exclude
C:\ProgramData\Microsoft\Microsoft Antimalware
C:\ProgramData\Microsoft\Microsoft Security Essentials
C:\Program Files\Microsoft Security Essentials

Thank you a lot for advise!

I will remember this for the future. Now, I recently installed WampServer and then I can run Joomla without problems (it seems at last). Although the "user interface" does not show up as seen on the images on http://sourceforge.net/projects/wampserver/ ,I can run localhost in the webbrowser.

This topic is now closed as the OP is no longer using XAMPP for Windows.