26th March 2015 at 7:22 am #4192
Just read the post by Nigel from last September on ‘HTML Block Variables’ . Sounded very useful, so created a second HTML block under my existing one and I followed the instructions. After about 1 minute, the error message:
appeared, followed by an identical message a minute or so later, then nothing. The instructions said be patient so i was – I have a large DB – over 14000 individuals – but over 30 minutes have passed and still nothing more.
The rest of the Home Page is not displayed correctly but otherwise the site is functioning correctly. Logging in from another device with another user name shows the same ‘skeleton’ Home Page (no other blocks visible – just the main HTML block and the two error message where the new HTML block should appear. The users can use the rest of the site provided they use one of the menu icons or the search function to take them in. But clearly i need to resolve fairly quickly.
Would appreciate advice on what to do to recover.
26th March 2015 at 8:40 am #4195
Look in the /language/ folder an delete the file mi.mo. This is an old and invalid language file that should not be there.
That should clear the error message, and hopefully the HTML block will work then. If not, what HTML variables were you testing?
If you were following the blog suggestion that says ” Look for the field “Templates” and select “Keyword examples” from it’s drop down list” then for a tree the size of yours I wouldn’t recommend it. It loads ALL the possible variables and some of them individually take considerable resources. All of them on even a small tree will be very slow. Then at the end when or if it loads all you will see is an identical list to the one displayed on the blog page.
So ignore point 2. of the instructions and simply select the variable(s) you want from the list displayed there.
I’ll modify the blog/FAQ to reflect this point.
26th March 2015 at 9:08 am #4198
I have deleted the mi.mo file and tried to refresh the Home Page – the error messages have disappeared but I still don’t get the entire Home Page back – just the top menu and my original HTML block.
I was, indeed, following the blog suggestion you mention and I shall not attempt it again, but I’m at a loss to know how to recover. I have tried all the obvious things – have logged out, closed the browser, reopened, cleared the browser cache, logged in again, but can’t restore the original Home Page.
26th March 2015 at 9:20 am #4200
You have to remove the new HTML block you tried to create. Can you login and navigate to the Home page? Once there do you have the “Change the blocks on this page” option? If you do then you should be able to remove the second HTML block from there.
If none of that is possible you will need to delete the block manually from the database. Your main / original html block I can see has an id number of 871, so:
1 – look in the table xx_block for a block with module_name = html and an id number other than 871. Just note its id for now.
2 – In the table xx_block_setting find that same id, and delete all it’s records. There will be at least three.
3 – Now return to xx_block and remove that html block from there as well.
26th March 2015 at 9:44 am #4202
No – I don’t have the ‘Change blocks ..’ option so will follow your guidance re table change. I have another HTML block on the Home Page so will have to try to avoid that one – hopefully the one I just tried to add will have a higher id.
26th March 2015 at 9:46 am #4203
I have another HTML block on the Home Page so will have to try to avoid that one – hopefully the one I just tried to add will have a higher id.
Check my earlier reply – I said that your existing block has ID 871. This is your existing / original block, the one you want to leave in place.
26th March 2015 at 10:00 am #4204
I appear to be venturing into areas that I don’t understand! I have never attempted to access the DB tables before and I seem to have a problem doing so. I have cPanel as the tool for accessing my server. Selecting MySql, I seem to have th options only to ‘Check the Database’ or ‘Repair the Database’. ‘Check’ simply returns a list of the tables with ‘status OK’ beside each, and no option to access/edit any of them. ‘Repai’ returns a list of the tabels with ‘The storage engine for the table doesn’t support repair’
I am the only registered user and the ‘actions’ associated with my user name are ‘set password’, ‘rename’ and ‘delete’ which appears to exclude ‘edit ‘ which I want to do.
Any advice would be welcome!
26th March 2015 at 10:07 am #4205
Just to clarify – I already had TWO HTML blocks on the Home Page. I created a third temporarily in order to try out the ideas from the blog. So I have to avoid ID 871 AND another!
- The topic ‘HTML Block Problem’ is closed to new replies.