It would be really good to have a module where users could enter in text and have it translated to another language.
(if this has been done already please let me know where I can download it )

It's working now.

the page taking 10 minutes to load was caused by the headline module - I guess that the news site I get the rss feed from is having problems. This was I think also why getting logged off.

But the syntax error was being caused by the recent forum topics module anyone have any ideas why or how as I'd still like to be able to use it on the top page. When i take the module off there is no error.

Thanks Artigas,

I kind of think I understand roughly what you mean (the error message is like morse code to me )

In the XOOPS phpbb module I have 2 templates, ( I installed the second one on a couple of days ago but didn't have any problems then)
Could it be that I need to uninstall/remove one of the templates from the phpbb module?
And would this syntax error be making the index page take up to 10 mins to load?

Someone please please go and look at my site and tell me if it takes decades to load http://lost-in-france.com/forum/

Hi,

I wasn't sure which forum to post this in so I'm sorry if it's in the wrong section. I have XOOPS 2. 09. 2 I have the phpbb forum module and I used a converter to transfer my members and threads over from a phpbb2 standalone forum, (which had various templates and mods on it).

I've been having problems with XOOPS - can't get on to main page, getting logged out and sometimes running very slow in IE. There is a php.ini file set to 9 (I think) to speed it up a bit. Today I couldn't access the main page it was taking 8 - 15 minutes to load if at all. I tried on different pc's, different browsers etc thinking it might be a cookie problem.
Eventually I got into the admin panel after accessing through a module url and I turned on debug it returned the following error. Sorry it's very long I'm sorry also as understand zilch about MySQL so it means very little to me
How do I fix it? (in step by step simple instructions)

SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '0ee24be3ef509d2574f1f647dab067c9'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'pbboard'
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND

b.bid IN (1,2,3,4,5,45,6,36,42,7,37,8,9,31,10,43,11,12,34,14,22,35,25,24,21,48,47,28,46,27,32,44,41,23,49,33,29,26,51,52,53,54,55,56,57,58,59)


ORDER BY b.weight,b.bid
SELECT user_new_privmsg FROM xoops_users WHERE uid = '1'
SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2))
SELECT COUNT(*) FROM xoops_catads_ads WHERE uid = 1
SELECT * FROM xoops_xoopscomments WHERE (com_status = 2) ORDER BY com_created DESC LIMIT 0, 10
SELECT * FROM xoops_modules WHERE hascomments = 1 ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_users WHERE uid=119
SELECT * FROM xoops_users WHERE uid=111
select uid from xoops_users where uname= 'admin'
select accid, wcid, station_type, station_name, tpc, tps from xoops_userweather where userid='1'
select accid, wcid, station_type, station_name, tpc, tps from xoops_userweather where userid='0'
SELECT * FROM xoops_marquee WHERE marqueeid=1
SELECT * FROM xoops_smiles
SELECT * FROM xoops_xoopsheadline WHERE headline_asblock = 1 ORDER BY headline_weight ASC
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1113666673, online_module = 0 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT * FROM xoops_xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
SELECT * FROM xoops_xoopspoll_option WHERE poll_id=3 ORDER BY option_id

SELECT * FROM xoops_xoopspoll_option WHERE poll_id=4 ORDER BY option_id
SELECT t.topic_id, t.topic_title, t.topic_views, t.topic_replies, t.topic_status, t.topic_type, p.post_username, p.poster_id, p.post_time,

f.forum_id, f.forum_name, f.auth_read FROM xoops_pbb_topics t, xoops_pbb_posts p, xoops_pbb_forums f WHERE t.forum_id = f.forum_id AND

(t.topic_last_post_id = p.post_id) ORDER BY p.post_time DESC LIMIT 0, 10
SELECT * FROM xoops_pbb_config
SELECT template_name FROM xoops_pbb_themes WHERE themes_id =
Error number: 1064
Error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use

near '' at line 1
SELECT template_name FROM xoops_pbb_themes WHERE themes_id = 2
SELECT uname FROM xoops_users WHERE uid = '66' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '119' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 2
SELECT uname FROM xoops_users WHERE uid = '118' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '119' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '66' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 14
SELECT uname FROM xoops_users WHERE uid = '7' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '9' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '5' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 2
SELECT uname FROM xoops_users WHERE uid = '9' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT uname FROM xoops_users WHERE uid = '13' LIMIT 1
SELECT aa.forum_id, aa.auth_read, aa.auth_mod, ug.user_id, ug.group_id FROM xoops_pbb_user_group ug, xoops_pbb_auth_access aa WHERE ug.group_id =

aa.group_id AND ug.user_id = 1 AND aa.forum_id = 1
SELECT * FROM xoops_modules WHERE dirname = 'catads'
SELECT * FROM xoops_config WHERE (conf_modid = 7) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_catads_ads WHERE (published > 0 AND expired > 1113666673)
SELECT cat_id, title FROM xoops_catads_cat WHERE pid=0 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=3 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=8 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=4 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=5 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=1 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=6 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=2 ORDER BY title
SELECT * FROM xoops_catads_cat WHERE pid=7 ORDER BY title
SELECT * FROM xoops_catads_ads WHERE (published > 0 AND expired > 1113666673) ORDER BY published DESC LIMIT 0, 5
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-1 00:00:00" AND stamp <="2005-04-1 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-1 00:00:00" AND stamp <="2005-04-1 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-1 00:00:00" AND stamp <="2005-04-1 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-2 00:00:00" AND stamp <="2005-04-2 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-2 00:00:00" AND stamp <="2005-04-2 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-2 00:00:00" AND stamp <="2005-04-2 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-3 00:00:00" AND stamp <="2005-04-3 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-3 00:00:00" AND stamp <="2005-04-3 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-3 00:00:00" AND stamp <="2005-04-3 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-4 00:00:00" AND stamp <="2005-04-4 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-4 00:00:00" AND stamp <="2005-04-4 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-4 00:00:00" AND stamp <="2005-04-4 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-5 00:00:00" AND stamp <="2005-04-5 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-5 00:00:00" AND stamp <="2005-04-5 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-5 00:00:00" AND stamp <="2005-04-5 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-6 00:00:00" AND stamp <="2005-04-6 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-6 00:00:00" AND stamp <="2005-04-6 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-6 00:00:00" AND stamp <="2005-04-6 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-7 00:00:00" AND stamp <="2005-04-7 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-7 00:00:00" AND stamp <="2005-04-7 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-7 00:00:00" AND stamp <="2005-04-7 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-8 00:00:00" AND stamp <="2005-04-8 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-8 00:00:00" AND stamp <="2005-04-8 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-8 00:00:00" AND stamp <="2005-04-8 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-9 00:00:00" AND stamp <="2005-04-9 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-9 00:00:00" AND stamp <="2005-04-9 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-9 00:00:00" AND stamp <="2005-04-9 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-10 00:00:00" AND stamp <="2005-04-10 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-10 00:00:00" AND stamp <="2005-04-10 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-10 00:00:00" AND stamp <="2005-04-10 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-11 00:00:00" AND stamp <="2005-04-11 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-11 00:00:00" AND stamp <="2005-04-11 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-11 00:00:00" AND stamp <="2005-04-11 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-12 00:00:00" AND stamp <="2005-04-12 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-12 00:00:00" AND stamp <="2005-04-12 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-12 00:00:00" AND stamp <="2005-04-12 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-13 00:00:00" AND stamp <="2005-04-13 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-13 00:00:00" AND stamp <="2005-04-13 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-13 00:00:00" AND stamp <="2005-04-13 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-14 00:00:00" AND stamp <="2005-04-14 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-14 00:00:00" AND stamp <="2005-04-14 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-14 00:00:00" AND stamp <="2005-04-14 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-15 00:00:00" AND stamp <="2005-04-15 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-15 00:00:00" AND stamp <="2005-04-15 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-15 00:00:00" AND stamp <="2005-04-15 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-16 00:00:00" AND stamp <="2005-04-16 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-16 00:00:00" AND stamp <="2005-04-16 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-16 00:00:00" AND stamp <="2005-04-16 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-17 00:00:00" AND stamp <="2005-04-17 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-17 00:00:00" AND stamp <="2005-04-17 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-17 00:00:00" AND stamp <="2005-04-17 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-18 00:00:00" AND stamp <="2005-04-18 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-18 00:00:00" AND stamp <="2005-04-18 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-18 00:00:00" AND stamp <="2005-04-18 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-19 00:00:00" AND stamp <="2005-04-19 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-19 00:00:00" AND stamp <="2005-04-19 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-19 00:00:00" AND stamp <="2005-04-19 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-20 00:00:00" AND stamp <="2005-04-20 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-20 00:00:00" AND stamp <="2005-04-20 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-20 00:00:00" AND stamp <="2005-04-20 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-21 00:00:00" AND stamp <="2005-04-21 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-21 00:00:00" AND stamp <="2005-04-21 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-21 00:00:00" AND stamp <="2005-04-21 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-22 00:00:00" AND stamp <="2005-04-22 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-22 00:00:00" AND stamp <="2005-04-22 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-22 00:00:00" AND stamp <="2005-04-22 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-23 00:00:00" AND stamp <="2005-04-23 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-23 00:00:00" AND stamp <="2005-04-23 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-23 00:00:00" AND stamp <="2005-04-23 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-24 00:00:00" AND stamp <="2005-04-24 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-24 00:00:00" AND stamp <="2005-04-24 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-24 00:00:00" AND stamp <="2005-04-24 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-25 00:00:00" AND stamp <="2005-04-25 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-25 00:00:00" AND stamp <="2005-04-25 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-25 00:00:00" AND stamp <="2005-04-25 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-26 00:00:00" AND stamp <="2005-04-26 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-26 00:00:00" AND stamp <="2005-04-26 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-26 00:00:00" AND stamp <="2005-04-26 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-27 00:00:00" AND stamp <="2005-04-27 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-27 00:00:00" AND stamp <="2005-04-27 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-27 00:00:00" AND stamp <="2005-04-27 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-28 00:00:00" AND stamp <="2005-04-28 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-28 00:00:00" AND stamp <="2005-04-28 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-28 00:00:00" AND stamp <="2005-04-28 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-29 00:00:00" AND stamp <="2005-04-29 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-29 00:00:00" AND stamp <="2005-04-29 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-29 00:00:00" AND stamp <="2005-04-29 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-30 00:00:00" AND stamp <="2005-04-30 23:59:00" AND valid='yes'
SELECT count(id) FROM xoops_eCal WHERE stamp >= "2005-04-30 00:00:00" AND stamp <="2005-04-30 23:59:00" AND valid='yes'
SELECT Subject, stamp FROM xoops_eCal WHERE stamp >= "2005-04-30 00:00:00" AND stamp <="2005-04-30 23:59:00" AND valid='yes'
SELECT * FROM xoops_modules WHERE dirname = 'shoutbox'
SELECT * FROM xoops_config WHERE (conf_modid = 13) ORDER BY conf_order ASC
Total: 156 queries

Blocks
User Menu: No Cache
Login: No Cache
Main Menu: No Cache
Recent Comments: No Cache
XP-Weather Block: No Cache
Marquee 01: No Cache
Headlines: No Cache
Latest Published Articles: Cached (regenerates every 2592000 seconds)
New Images: Cached (regenerates every 3600 seconds)
Custom Block (Auto Format + smilies): Cached (regenerates every 2592000 seconds)
Random Picture: Cached (regenerates every 3600 seconds)
Who's Online: No Cache
Polls: No Cache
Random quote: Cached (regenerates every 3600 seconds)
Recent Topics: No Cache
Recent chess challenges: Cached (regenerates every 1800 seconds)
Latest ads: No Cache
Recent chess games: Cached (regenerates every 300 seconds)
Block Calendar: No Cache
Upcoming Events: Cached (regenerates every 18000 seconds)
Shoutbox: No Cache
Total: 21 blocks

Execution Time
XOOPS took 120.29321694374 seconds to load.


I don't know why it says no cache on the above modules as I've checked and double checked them eg headlines is set to 1hr, marquee 1 month etc

It's now taking between 4 - 9 mins to load the start page,
this morning it was working fine - I haven't changed anything, and I've checked on 2 different pc's and 2 different ISP's .I asked the people that host it and they said they have checked it and it's working fine. I'm starting to pull my hair out.

If any of you are on dial up and have the time, I'd really appreciate it if you could go and have a look and let me know how long it's taking to load:
http://www.lost-in-france.com/forum

Thanks for the link, I'll give it a go.

I have XOOPS with phpbb forum module and I would like to display the latest forum topics on another (html) website,
there is a phpbb2 mod called "topics anywhere" but it won't work with the phpbb XOOPS forum module - I think the code needs adjusting. Are there any similar mods or modules that would work with xoops?

Have now been told by the host that all data is lost, I still have sql files from my previous phpbb2 standalone forum, does anyone out there know how I can somehow extract the data & import it into XOOPS so I can at least salvage something.
I know very little about sql, is there a way? (with simple step by step instructions)







Solved

Ignore host - re upload everything you had on before and restore database through admin panel if you have backpack module

Hi,
I recently switched to XOOPS 2.0.92 (using the phpbb forum module. I like XOOPS it offers more than phpbb can.
I previously had a phpbb2 standalone board. I used the database transfer script by Koudanshi to transfer my members, topics & threads over to xoops.
I installed the backpack module and backed up my XOOPS db and saved it.
The next day the server that my site is hosted on had a hard disk failure which also destroyed the backup they had made of my site. They've tried to restore my site from the database that I saved but it won't work although the first page displayed I was not able to log in (it said I was logging in but there was no admin menu and the login box was still there, and the phpbb module won't work even though it has been reinstalled (by the servers technicians). If you clicked on "message board" it gave the following error message:

General Error

Could not obtain user/online information

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_allow_viewonline' in 'field list'

SELECT u.uname, u.uid, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.sess_ip FROM xoops_users u, xoops_session s WHERE u.uid = s.session_user_id AND s.sess_updated >= 1113214296 ORDER BY u.uname ASC, s.sess_ip ASC

Line : 125
File : /backup/home/"mysite"/public_html/xoops/modules/pbboard/includes/page_header.php

After that it was just a blank page.

I've given all these details to my hosts technical support, and I've even suggested that I should do a clean install of XOOPS and load on the modules etc that I had previously and then restore my database that I had saved. To me that sounds like the quickest way of getting my site back up but they are saying that it should only be done as a last resort.

Meanwhile my site has been down now for 2 days - and I'm getting more frustrated by the second. They've told me not to change, alter, do anything to the site untill they've finished trying to restore it. I'm very worried that I'll loose my members especially as my site is only a few month old. Any advice greatly appreciated.

Sadly I can't verify if anything works now - the server that my site is hosted on suffered a hard disk failure and though there was a backup of my database etc they can't load it on,
and it looks like I've lost all my members, topics & threads.

Had similar problem - check "hotlinking protection" on server, if it's enabled it can sometimes prevent some browsers from viewing images, if your server has a cpanel you can check to see if it's enabled there.