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

Greetings soconfused -

I can tell you why you are getting the error, but I do not know how to fix it since I am rather new at xoops.

Quote:
It seems that the first select does not have a valid themes_id number. It says "themes_id = ". The themes_id is blank and it fails.

Quote:
The second themes_id is okay. It says "themes_id = 2". It is a valid number.

Taking a very wild unknowledgeable guess here...

It looks like the first select on the table "xoops_pbb_config" gives you a list of "themes_id".

You are then looping through that list of "themes_id" getting the "template_name" for each corresponding "theme_id" in the table "xoops_pbb_themes".

Since the first "xoops_pbb_config" record looks like it has an invalid "themes_id" [Should it be 1?], something that would make sense would be to delete the first "themes_id" record in "xoops_pbb_config" and eliminate it from the original list.

But that might not be correct. You could try editing the first "xoops_pbb_config" record and making the "themes_id" a value of 1. But that supposes that you have a "themes_id" of 1 in the "xoops_pbb_themes" table.

First I would check to see that there is a "themes_id" record with a value of 1 in the "xoops_pbb_themes" table.

If there is one: Change the first record in the "xoops_pbb_config" table so it has a "themes_id" = 1.

It there is not one: Delete the first record in the "xoops_pbb_config" table.

Backup your system first

You do this at your own risk since:
1) I took a wild guess here...
2) I am not familiar with this module...
3) And your system has been moded...

To accomplish this, I believe you will have to manipulate the MySQL tables directly.

Maybe someone with a bit more knowledge will jump in here.

Good luck with resolving your issues.

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/

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.

Greetings -

The site is loading okay.

Please recall that I am not familiar with this module so be very carefull and please feel free to ignore any of this.

Back up first, then unistall the first template and see if the error message goes away.

If it does, then install it again and check if the error occurs again.

Hope That Helps.

Hi Artygas,

I uninstalled the first template but still get the error.
If I don't display the "recent forum topics" block I don't get the error
I just checked the other blocks that go with the module but they don't give the error.

Greetings soconfused -

Can you check with MySQLAdmin if you have a bad forum topic or forum entry in your entries?

Something with blanks in the fields and/or a "theme_id" of blank/zero?

Since it is in the "recent forum topics" you can concentrate on the last entries that would be showing in that block.

This is just a guess, but there ---might--- have been an entry with something that did not convert quite right.

And if you find one, is not necessarily the fault of the developer and/or the conversion process. Sometimes the data when in one format is perfectly alright. And when converted to another with a different structure becomes invalid due to the nature of the data.

Hope That Helps.

This is the recent topics part:

INSERT INTO `xoops_newblocks` VALUES ('47', '19', '1', '10|1|time', 'Recent Topics', 'Recent Topics', '', '5', '4', '0', 'M', 'H', '1', 'pbboard', 'pbboard.php', 'pbboard_show', 'pbboard_edit', 'pbboard_block_new.html', '0', '1113689376');

These are the only bits I can find that mention the pbb board theme:

INSERT INTO `xoops_pbb_config` VALUES ('smilies_path', '../../uploads');
INSERT INTO `xoops_pbb_config` VALUES ('default_style', '2');
INSERT INTO `xoops_pbb_config` VALUES ('default_dateformat', 'D M d, Y g:i a');


These are the pbb board themes dump (subsilver is the theme that came with the board, aphrodite is the one I added):

-- xoops_pbb_themes dump.
--
INSERT INTO `xoops_pbb_themes` VALUES ('1', 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '445395', '5493B4', '', 'DD6900', 'EFEFEF', 'E5E5E5', 'EFEFEF', '', '', '', '445395', '445395', 'EFEFEF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'EFEFEF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', '0', '0');
INSERT INTO `xoops_pbb_themes` VALUES ('2', 'ca_aphrodite', 'Aphrodite', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', '0', '0', '0', '', '18C935', 'DD6900', '', '', '', '0', '0');
--
-- xoops_pbb_themes_name structure.
--
CREATE TABLE `xoops_pbb_themes_name` (
`themes_id` smallint(5) unsigned NOT NULL default '0',
`tr_color1_name` char(50),
`tr_color2_name` char(50),
`tr_color3_name` char(50),
`tr_class1_name` char(50),
`tr_class2_name` char(50),
`tr_class3_name` char(50),
`th_color1_name` char(50),
`th_color2_name` char(50),
`th_color3_name` char(50),
`th_class1_name` char(50),
`th_class2_name` char(50),
`th_class3_name` char(50),
`td_color1_name` char(50),
`td_color2_name` char(50),
`td_color3_name` char(50),
`td_class1_name` char(50),
`td_class2_name` char(50),
`td_class3_name` char(50),
`fontface1_name` char(50),
`fontface2_name` char(50),
`fontface3_name` char(50),
`fontsize1_name` char(50),
`fontsize2_name` char(50),
`fontsize3_name` char(50),
`fontcolor1_name` char(50),
`fontcolor2_name` char(50),
`fontcolor3_name` char(50),
`span_class1_name` char(50),
`span_class2_name` char(50),
`span_class3_name` char(50),
PRIMARY KEY (themes_id)
) TYPE=MyISAM;
--
-- xoops_pbb_themes_name dump.
--
INSERT INTO `xoops_pbb_themes_name` VALUES ('1', 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
INSERT INTO `xoops_pbb_themes_name` VALUES ('2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
--



Maybe I'm looking in the wrong place

Greetings soconfused -

From my limited knowledge perspective what you posted looks correct.

My guess is that you need to be looking at the posted items in the forums. Posibly the last 10 to 20 items or so on the database.

Hope That Helps.

Hi Artigas,
Many thanks for your help
I couldn't find anything in the database, so I set up a test site and installed just XOOPS & the phpbb module installing only the default themes & new database, I displayed the recent topics block and using sql debug mode I got the exact same error message. In some respects I'm relieved as (I hope)
this indicates that my other database is ok.

Now I'm wondering how many other users of this module also have the error and haven't noticed maybe because they haven't used debug or maybe don't display the recent topics block.
and (not knowing much about these things ) whether it's likely to cause problems later on.

Anyone else out there with this error?