Thanks for any help!

Skipping a long story, our hosting company moved our site http://www.vmoa.net from a PHP4.? server to PHP5.1. The site appeared to work until a change was made, then most of the blocks (including login) and content disappeared from the front page.

Our admin quit a year ago, and another took over but he has now disappeared after these problems started so now I'm jumping in in the middle, and I'm somewhat computer savvy but not a PHP programmer nor overly familiar with Xoops, although I'm trying to get up to speed as quickly as possible.

The site is on 2.3.3, I'm assuming it needs to be updated but I can't find an update path. The readme of 2.4.5 gives an "easy" update that says to find the appropriate upgrade file, which I can't, despite looking through sourceforge.

System Overview «
XOOPS Version - XOOPS 2.3.3
PHP Version - 5.1.6
MySQL Version - 5.0.45
Server API Version - cgi-fcgi
OS Version - Linux

safe_mode - Off
register_globals - On
magic_quotes_gpc - On
allow_url_fopen - On
fsockopen - On
allow_call_time_pass_reference - On
post_max_size - 8M
max_input_time - 60
output_buffering -
max_execution_time - 60
memory_limit - 8M
file_uploads - On
upload_max_filesize - 2M
Loaded PHP extensions »

* libxml
* xml
* wddx
* tokenizer
* sysvshm
* sysvsem
* sysvmsg
* standard
* SimpleXML
* sockets
* SPL
* shmop
* session
* Reflection
* pspell
* posix
* pcntl
* mime_magic
* iconv
* hash
* gmp
* gettext
* ftp
* exif
* date
* curl
* ctype
* calendar
* bz2
* zlib
* pcre
* openssl
* gd
* imap
* ldap
* mbstring
* mysql
* mysqli
* PDO
* pdo_mysql
* pdo_sqlite
* Zend Optimizer

I've turned on debug, the site home page shows:

Notice: Undefined offset: 1 in file /modules/statistics/include/hitcounter.php line 58
Notice: Undefined index: fragment in file /modules/statistics/include/hitcounter.php line 68
Warning: Smarty error: unable to read resource: "db:system_block_user.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_online.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 657
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_mainmenu.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_search.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_themes.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_block_dummy.html" in file /class/smarty/Smarty.class.php line 1092
Warning: Smarty error: unable to read resource: "db:system_homepage.html" in file /class/smarty/Smarty.class.php line 1092

OK, the problem seems to be that xoops_tplfile, xoops_tplset and xoops_tplsource were lost from the database, along with a few (less important?) tables. I've recreated them, any easy way to reload them with default template data?

I wish I had a backup, but the guy who should have it has disappeared as mentioned ...

use php my admin export data base add what you need to then import again

Normally the missing templates will be restored by doing an update of the system (and other) module in module admin.

Can't help You right now, but the backup issue I work with.
Do You host use Cpanel?

I had the same problem so I imported database from my local drive.