Thread

Also, I attempted to repair your database tables and get this:

    The storage engine for the table doesn’t support repair

Can you check with your host about why that might be happening?  I suspect something is very wrong with your actual database; a backup may be critical to getting you back up and running.

Thanks!

We have not made any changes to the database. The changes that were done was related to Plesk. Our Plesk had issues with read/write permissions that was bringing down our web sites. Plesk has been disabled and we moved the PHP interpreter from the Plesk PHP version to FastCGI for IIS 6. All of the Wordpress sites were moved over without issues. We have only one EE site on this server and it’s the only one that is experiencing a problem. Is there a PHP setting that is required for EE to access MySQL?

Hi, dreamworld -

You can find the minimum requirements listed; I would be curious if you can run a repair and optimize via something like PHPMyAdmin; these are very standard commands and your host should be able to help out.  Once we’re past that we can continue troubleshooting the main issue.

We have full access to the server. The user account for the database has all the necessary access privileges to the database.

PHP Version: 5.2.17
MySQL Version 5.0
EE Version 1.6.7

We are using MySQL Administration tools instead of PHPMyAdmin.

Hi, dreamworld -

Are you able to run a repair and optimize on all of the database tables?

Yes. I have run the Check Tables and Optimize Tables. There was an error when trying to run the repair. The message say “The storage engine for the table doesn’t support repair.”

Hi, dreamworld -

Yes, that is the error that concerns me as that may be indicative of a larger problem with the database.  Do you happen to know what storage engine you’re running?

If not, can you check with your admin on that?

Thanks!

The database structure is InnoDB. Base on Google search on the error message, it looks to be normal for “The storage engine for the table doesn’t support repair” when you manually run the repair table tool.

Back to my earlier post #11. Whenever we add the index.php to the URL of the individual page, it loads correctly. For example, http://www.newlifehomecare.com/index.php/healthcare_professionals/

Is there a way to turn on the navigation to include the index.php file to the URL or does this give you an idea as to where the problem lies?

Yes, in your CP in Admin > General Config add index.php to Name of your site’s index page, then your URLs should automatically include that if your templates are using EE variables appropriately.

Thanks! That worked on the top navigation. However, after going through the site, it looks like the site was set to have pretty URL as there are hyperlinks on the site, such as image hyperlinks that does not include the index.php in the URL.

It looks like Structure is used to assist with navigation. Since the site has Structure, is it possible that Structure is not working correctly?

Hi, dreamworld -

It is possible, but unlikely as I believe Structure still relies on EE’s path variable type system.  Are your URLs hardcoded then?

There are ways to remove index.php, however that is much easier done on Apache than IIS; in fact, we have a supported method for Apache, but not one for IIS, so you’ll need to speak with an IIS administrator about how to accomplish that feat on that webserver.

Make sense?

I don’t think our DB is the problem here. Here is an blog about InnoDB and Repair Table. It’s not required. I ran it through the Analyzed and there were no problems found.

https://www.vbulletin.com/forum/showthread.php/371388-Mixed-MyISAM-and-innoDB-tables-in-same-database

Our site used to work with the friendly URL. Something in the PHP, EE or Structure has changed or requires another setting that is missing here. In my previous post, there is a filter setting in IIS that points to a file IsapiRewrite4.dll in a folder called EE. See post #8. What is this library file used for?

If you go back to the web archive, the site links are without the index.php.
http://web.archive.org/web/20100614030933/http://newlifehomecare.com/

Hi, dreamworld -

EE does require index.php; the rewrites do effectively highlight it - but we don’t offer technical support for doing that on IIS server.  That particular part - which is a server configuration, not specific to EE - will need an experienced ISAPI admin to help out with.