Thread

Good morning,

We recently moved our website with EE 1.6.9 to an in-house server running IIS7.  Recently I noticed that I cannot create new templates even though the CP says that the template was created.  It does not exist in the panel or in the back end of the files.  Is this a result of moving from Apache to IIS?

If so, any ideas what the work around is?

thanks,

Justapen.

Hi Justapen,

I’m sorry you are having trouble after the move!

Are you saving templates-as-files? If so, have you verified the IIS equivalent permission to 777 on your templates folder? When you try to create a new template, does it show in the Template Manager at all?

Are you able to create new weblog entries or have you noticed any other database related problems?

Read over the Wiki on Moving ExpressionEngine to a New Server and double check the procedure you followed. Pay special attention to any file paths with regards to Windows-style paths.

I look forward to your reply!

Cheers,

Hi Dan,

Thanks for the response, and sorry it took me so long to follow up on it. 

I am saving templates as files and I have verified the IIS equivalent of permission 777 to templates folder.  When i try to create a new template the system tells me that the template was created but it doesn’t actually show up in the template manager and it is not in the file folder either.

This is also true for new weblog entries.  The system tells me that the entry has been created, but it doesn’t actually show up.  I can add the templates and the weblog entires into the SQL tables and then edit them from EE I just dont seem able to create it from EE.

I read over the wiki article and I followed the procedure correctly.

Hi Justapen,

No worries on the reply!

Ok - with the new information, it sounds as though you are connecting to the wrong database. Meaning that you are still pointed at the database you were using prior to the move?

When i try to create a new template the system tells me that the template was created but it doesn’t actually show up in the template manager and it is not in the file folder either.

The troubling part here is that they aren’t showing in the Template Manager. The files themselves will not appear until *after* the template is opened in the Control Panel and you check the box to save that particular template as a file. However, if you don’t see the new template in the Template Manager, then that is a problem!

Can you verify the database settings are correct in /system/config.php ?

Cheers,

Dan,

I checked the sql db settings on my config file and it looks right to me.  This is for MYSQL installed on the same machine.

$conf[‘db_hostname’] = “localhost”;
$conf[‘db_username’] = “root”;
$conf[‘db_password’] = “*******”;
$conf[‘db_name’] = “db106359_daycon”;
$conf[‘db_type’] = “mysql”;
$conf[‘db_prefix’] = “exp”;
$conf[‘db_conntype’] = “0”;

Now db_name is the same on my new server as the old one, hwoever the hostname, username, and password are all different and correct for the new server.

Thanks for your help.

Hi Justapen,

2 more questions -

1) What version of MySQL and PHP are running here?

2) There may be something odd with the tables themselves. Can you have your host double check that the database made the move OK?

Cheers,

Hi Dan,

I’m running MySQL 5.0 and PHP 5.3.

As near as I can tell the db made it just fine but I haven’t received final confirmation of that from them yet.  I compared what I have running against what I orginially backed up on the old server and aside from the new information I’ve put there, everything looks good.

Thanks again for your help.

Dan,

Turns out that someone was trying to be helpful at some point and enabled Strict mode in MySQL.  I turned it off and everything is working great.

Thanks for your help,

Seiji

Hi Seiji,

Turns out that someone was trying to be helpful at some point and enabled Strict mode in MySQL.  I turned it off and everything is working great.

Oh, indeed, that will do it every time. I’m glad you were able to track that down!

If you need anything else, just let us know.

Cheers!