Cannot refresh templates after database_update

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 4:26 am

Support Request Template
What version of phpBB are you using? phpBB 3.0.6
What is your board's URL? http://ooakforum.com
Who do you host your board with? No answer given
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? No
Is registration required to reproduce this issue? Yes
What styles do you currently have installed? prosilver, subsilvber2
What language(s) is your board currently using? english
Which database type/version are you using? I Don't Know
What is your level of experience? New to PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? After running the database conversion program (from install folder).
Please describe your problem. I'm upgrading from 3.04 to 3.0.6 and movingto a new domain at the same time.

I've installed 3.0.6 on the new domain. I've backed up the 3.0.4 database and restored into the database on the new domain. I've run database_update.php which conpleted without errors.

New forum seems to work perfect, except I cannot refresh templates, which produced the following error:

General Error
Could not open ./../styles/subsilver2/template/ooakmap_body.html

This was one of my files of an added page on the old forum. When I replace this file, it comes up asking for other files, which I've never created before, like the .txt files with the message about passwords... (I failed to note the exact name), but I have no idea what these files were, and they do not exist in the template directory of the old forum?
Generated by SRT Generator ($Rev: 3396 $)

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Cannot refresh templates after database_update

Post by ric323 » Fri Jan 01, 2010 5:01 am

This "added page" must be part of some MOD you added to phpBB.
It's not a standard part, so we don't know what these "other files" are that it requires.
You should ask wherever you obtained that MOD from.
If it's from the MOD database here, then in the release topic for that MOD.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 7:13 am

The installation of 3.0.6 is fresh with no mods at all, I've only just installed it. This is also the 2nd time I've done it, with exactly the same result.

The ooakmap_body.html was a stand-alone page added to the old 3.0.4 version, and was simply an added page, as described in the KB here http://www.phpbb.com/kb/article/add-a-n ... -to-phpbb/

As I mentention, once I copied that html file to the template folder, it got past that stage, but started asking for other files, NONE of which are in the original template folder and I did not create those files. One was password_something.txt

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Cannot refresh templates after database_update

Post by ric323 » Fri Jan 01, 2010 7:20 am

Those files are NOT created by plain phpBB either, so it must be something to do with the added page.
What is the exact error message you are getting?
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 7:22 am

General Error
Could not open ./../styles/subsilver2/template/ooakmap_body.html
I get this after confirmation of refreshing the template

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Cannot refresh templates after database_update

Post by ric323 » Fri Jan 01, 2010 7:26 am

I was actually asking what error messages you were getting if you did replace that file.

However, could you try something else please.
Use FTP to delete ALL files in your cache folder, EXCEPT for index.htm and .htaccess, and then try to refresh the template.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 7:27 am

I've copied that file the requested location, and the other files it' asks for (withe same
General Error
Could not open ./../styles/subsilver2/template/topic_notify.txt
General Error
Could not open ./../styles/subsilver2/template/user_welcome_inactive.txt
And the list goes on... everytime I give it the file it wants, it asks for another...
Where do these files come from, I've never created these?

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 7:32 am

Thanks for your time here, appreaciate it!

OK I deleted all those file in the cache folder but it made no difference. I've also purged the cache, still no difference.

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Cannot refresh templates after database_update

Post by ric323 » Fri Jan 01, 2010 7:40 am

haggisv wrote:I've copied that file the requested location, and the other files it' asks for (withe same
General Error
Could not open ./../styles/subsilver2/template/topic_notify.txt
General Error
Could not open ./../styles/subsilver2/template/user_welcome_inactive.txt
And the list goes on... everytime I give it the file it wants, it asks for another...
Where do these files come from, I've never created these?
Now that is strange.
They are genuine phpBB3 files, but they live in ./language/en/email/ not in ./styles/subsilver2/template/

I'm hoping someone more familiar with how styles work can guess what has happened.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 7:46 am

When I backed up the 3.0.4 database, I backed up "data AND structure".

Should I have backed up only the data, and copied this to the new database, or can that not be related?

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25227
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Cannot refresh templates after database_update

Post by Paul » Fri Jan 01, 2010 12:21 pm

Run these queries:

Code: Select all

    DELETE FROM `phpbb_styles_template_data` WHERE `template_filename` LIKE '%.txt'
And after that apply this fix:

open includes/functions_messenger.php

Find:

Code: Select all

          // Parse message through template
          $this->msg = trim($this->tpl_obj->assign_display('body'));
Before add:

Code: Select all

          // Quite dirty, but that will stop flooding the database stored styles with our email-templates!
          $orig_template_storedb = $user->theme['template_storedb'];
          $user->theme['template_storedb'] = false;
After add:

Code: Select all

          // Put the value back to default
          $user->theme['template_storedb'] = $orig_template_storedb;
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 12:41 pm

Thanks a lot Paul, I will try that!

Do you know what actually caused this problem?

I'm a bit concerned that there may be other problems related to this, that I may not have discovered yet, so it's good to understand what the problem is... CHeers!

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25227
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Cannot refresh templates after database_update

Post by Paul » Fri Jan 01, 2010 12:46 pm

It is a bug in phpBB 3.0.6 what is causing these errors, it will be fixed in 3.0.7.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
haggisv
Registered User
Posts: 261
Joined: Wed Dec 20, 2006 3:31 am
Location: Adelaide, Australia
Contact:

Re: Cannot refresh templates after database_update

Post by haggisv » Fri Jan 01, 2010 11:21 pm

I have noticed a further problem... It seems the new forum no longer display non-english based character sets anymore. The old forum displayed chinese and arabian characters fine, on the new one they are all garbled up. :o

NOTE: I discovering these problems on a test forum, no the live forum, so I can experiement to try and sort it out.

Thanks a lot for your help guys!

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25227
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Cannot refresh templates after database_update

Post by Paul » Sat Jan 02, 2010 10:53 am

Is that happening on new posted topics, or is it on old topics, created from a backup or something?
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

Locked

Return to “[3.0.x] Support Forum”

cron