Woops missed the extra page so the following is redundant -what you did may have fixed the database I leave it for your interest
-----------------------------------------------------------
I will try and back the truck up a bit:-

As you know XOOPS keeps all the settings you make and the data you enter in a database - not in the installation files which are larely static unless you modify them. These are merely the program or frontend to read and write the XOOPS database.

Depending on where you have installed XOOPS and what server functions your host system or ISP uses depends on how the data is stored and using which tools. For my installation which is remotely hosted, the internet server is Apache which runs php and uses a MySQL database. This can be accessed by me through phpMyadmin.

Your system may be running a different web server (such as microsoft and even a different database system (eg SQL Server). If you wish to get into the database you must ascertain how (i.e. if you have access to phpMyadmin) - you will also need to know the database login and password (which you would have needed for your first XOOPS installation.

I still believe you problem lies in the database not in the install files that you have FTP access to - but I may be wrong.

Perhaps if you have no phpMyadmin experience you should resort to a clean new install of XOOPS which will recraete the database, atbles and data. If you are really stuck - someone here could probably write a php file (or even me if I really put my mind to it) to do a one time record addition to the table tplfile that I mentioned - but this may be tricky if we have not first verified the record is missing from the data table and that the autonumber primary key would not be repeated. What tools do you have to have to manage your site outside of XOOPS (e.g. set up ftp and pop users etc)?. This may give a clue if you can access phpMyadmin function which is built into the server not into your site.

I am not nearly an expert in hosting systems, php or apache so someone else may be able to clarify better.

Don't know if this will help but I had a similar problem with Main Menu dissapearing and a similar error to

Smarty error: unable to read resource: "db:xoopsheadline_block_rss.html" in file class/smarty/Smarty.class.php line 1084

but mine mentioned "db:system_block_mainmenu.html" instead

I traced this to a missing entry in the database yourprefix_tplfile table that should have been there (yourprefix should be replaced with your own prefix)- I fished out the correct record of another installation and using phpMyAdmin browsed the data table and added the entry as a new line
This fixed my problem completely

it looked something like this for the fields in order comma delimited:-

22,5,system,default,system_block_mainmenu.html,Shows the main navigation menu of the site,1125097970,0,block

NOTE I made sure not to use existing values for the 22,5 bit and the long number is a date/time I think but not critical(I hope)

If something like this is not in the table then that may be your problem also you should look for xoopsheadline_block_rss.html at the same time

Again don't know if this would help and someone else may be able to give further instruction. If you don't know how to run phpMyAdmin someone else may also help as it is built in to my siteadmin ensim tools.

Also be aware that this was a fix for my version of XOOPS 2.2.3 Final so it may be different for your version. My problem occured after installing multiMenu

After updating from using xoops-2.0.13.1-to-2.2.3a-Final Which I downloaded and installed today. I followed the instructions on checking mainfile.php url for relative and also installed and reran the hot fix xoopsupdate.php

Popup error on every page is as follows:

Element 'menu1' does not exist in this document. Admenu cannot be initialized

I get nothing on my front page (except logo) and this error on every other page (user.php, admin.php etc)

I have searched the forum and found some reference to this problem under the clean blue theme so I have

1.Updated the cleanblue theme
2.Run general settings manually and reverted to default theme for main theme and admin theme
3.Reverted to default template set

Still have the problem any help would be appreciated.

Ok I had two problems (make that 3) after upgrading to 2.2.3
1. Login block showed section header but no login form or other detail (ie register now etc) (still haven't figured this out and just removed the block temporarily)
2. New registrations not accepting password (giving the "Sorry, your password must be at least 3 characters long" problem
3. Activation email link looking like this "http://www.mysite.comhttp://www.mysite.com/modules/profile/activate.php?op=actv&id=7&actkey=d7b6617e"

My solution to 2 after browsing here was to follow rodie's advice:

modules/profile/register.php
line #75
Quote:
My solution to 3 was:
to ftp the xoopsmailer.php from my 2.2.2 upgrade download to the /class directory replacing the one from 2.2.3

I hope my modification sticking plasters will all be overridden/sorted with the next patch