Hi,

Can someone please help me before I go crazy ! I am just on the verge of uninstalling everyting and reinstalling php + XOOPS + MySQL as I can't find out where the problem is.

Ok here is the problem.

In Preferences -> System -> General Settings, if I set any other module e.g. CBB or News as the 'Module for your start page', all modules which are set to 'Visible in->Top Page' do not appear. If I remove the starting module, they appear again.

The used to work ok (E.g. Top Page modules and starting module content appearing at same time) but I don't know what happened - there are two other webmasters and I think one of them messed up something and is not telling me what happened.

Would appreciate some help.

Thanks

EDIT2: I bit the bullet, deleted the database, reinstalled XOOPS , reinstalled PHP5.1.2 and it still does not work :(


EDIT1: Found some more clues... XOOPS is executing different queries for the same configuration (dev box/server)

I've been doing some debugging and I find it strange that with identical version of XOOPS (local/server), the queries are different. WIth same number of modules on each site (same config, module visibility, layout etc) XOOPS is executing different queries. When I changed the page visibility/position (Top Page/All Frontside pages) the data is being updated correctly in both cases (local/server). I just don't know what's corrupted the sql queries on the server.

I've attached the debug files for your reference. An example is the module selection query (ignore table names and block instance ids e.g. 16,2,3,14):

(Server Website)
SELECT DISTINCT i.instanceid, b.*, i.* FROM xoops_block_instance i, xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (16,2,3,14) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND ( (m.module_id=0 AND m.pageid=0) OR (m.module_id=8 AND m.pageid IN (0,0)) ) ORDER BY i.weight,i.instanceid

(Local Website)
SELECT DISTINCT i.instanceid, b.*, i.* FROM BToec_block_instance i, BToec_newblocks b, BToec_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (1,2,3,11) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND m.module_id=0 AND m.pageid IN (0, 1) ORDER BY i.weight,i.instanceid


Full debug files below:


-------------------------------------------------------
(Server Website)
Queries core
SELECT * FROM xoops_config WHERE (conf_modid = '1' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = 'eg5eh8su84g20acsp1c3a2vcj7'
( 0.00046)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '1' LIMIT 0, 1
( 0.000787)
SELECT * FROM xoops_modules WHERE dirname = 'AMS'
( 0.000584)
SELECT * FROM xoops_config WHERE (conf_modid = '8') ORDER BY conf_order ASC
( 0.001186)
SELECT * FROM xoops_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.000876)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_groupid IN (1,2))
( 0.000736)
SELECT DISTINCT i.instanceid, b.*, i.* FROM xoops_block_instance i, xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (16,2,3,14) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND ( (m.module_id=0 AND m.pageid=0) OR (m.module_id=8 AND m.pageid IN (0,0)) ) ORDER BY i.weight,i.instanceid
( 0.004236)
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '8' AND not_category = 'global' AND not_uid = '1')
( 0.001031)
SELECT * FROM xoops_modules WHERE mid = 8
( 0.000456)
Total Number of Queries: 10 | Total SQL Generation Time: 0.010352

Queries module
SELECT * FROM xoops_ams_article n, xoops_ams_text t, xoops_ams_audience a WHERE t.storyid=n.storyid AND n.audienceid=a.audienceid AND published > 0 AND published <= 1145706586 AND (expired = 0 OR expired > 1145706586) AND ihome=0 AND t.current=1 ORDER BY published DESC LIMIT 0, 5
( 0.001984)
SELECT * FROM xoops_ams_topics ORDER BY weight
( 0.000776)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid IN (2,1)
( 0.000914)
SELECT * FROM xoops_smiles
( 0.000575)
SELECT COUNT(*) FROM xoops_ams_article WHERE published > 0 AND published <= 1145706586 AND (expired = 0 OR expired > 1145706586) AND ihome=0
( 0.000495)
Total Number of Queries: 5 | Total SQL Generation Time: 0.004744

Queries block
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC
( 0.000832)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid IN (1,2))
( 0.000945)
SELECT * FROM xoops_modules WHERE dirname = 'pm'
( 0.000586)
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
( 0.000951)
Total Number of Queries: 4 | Total SQL Generation Time: 0.003314

Blocks
Main Menu: (2 Queries) No Cache
User Menu: (2 Queries) No Cache
Total: 2 blocks

Execution Time
XOOPS took 0.66399693489075 seconds to load.

-------------------------------------------------------

(Local)
Queries core
SELECT * FROM BToec_config WHERE (conf_modid = '1' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM BToec_session WHERE sess_id = '2578757c4752461ded09257a707a3e0c'
( 0.001839)
SELECT * FROM BToec_users u, BToec_user_profile p WHERE u.uid = p.profileid AND uid = '1' LIMIT 0, 1
( 0.002474)
SELECT * FROM BToec_modules WHERE dirname = 'AMS'
( 0.003131)
SELECT * FROM BToec_config WHERE (conf_modid = '13') ORDER BY conf_order ASC
( 0.003504)
SELECT * FROM BToec_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.002587)
SELECT * FROM BToec_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_groupid IN (1,2))
( 0.00244)
SELECT DISTINCT i.instanceid, b.*, i.* FROM BToec_block_instance i, BToec_newblocks b, BToec_block_module_link m WHERE m.block_id=i.instanceid AND i.instanceid IN (1,2,3,11) AND i.visible=1 AND i.bid=b.bid AND b.isactive=1 AND m.module_id=0 AND m.pageid IN (0, 1) ORDER BY i.weight,i.instanceid
( 0.010789)
SELECT * FROM BToec_xoopsnotifications WHERE (not_modid = '13' AND not_category = 'global' AND not_uid = '1')
( 0.001691)
SELECT * FROM BToec_modules WHERE mid = 13
( 0.002007)
Total Number of Queries: 10 | Total SQL Generation Time: 0.030462

Queries module
SELECT * FROM BToec_group_permission WHERE (gperm_modid = '13' AND gperm_name = 'ams_view' AND gperm_groupid IN (1,2))
( 0.00222)
SELECT * FROM BToec_ams_article n, BToec_ams_text t, BToec_ams_audience a WHERE t.storyid=n.storyid AND n.audienceid=a.audienceid AND published > 0 AND published <= 1145706287 AND (expired = 0 OR expired > 1145706287) AND ihome=0 AND t.current=1 ORDER BY published DESC LIMIT 0, 5
( 0.002367)
SELECT COUNT(*) FROM BToec_ams_article WHERE published > 0 AND published <= 1145706287 AND (expired = 0 OR expired > 1145706287) AND ihome=0
( 0.001505)
Total Number of Queries: 3 | Total SQL Generation Time: 0.006092

Queries block
SELECT * FROM BToec_modules WHERE dirname = 'pm'
( 0.005413)
SELECT * FROM BToec_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC
( 0.00279)
SELECT * FROM BToec_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid IN (1,2))
( 0.003067)
SELECT gperm_itemid FROM BToec_group_permission LEFT JOIN BToec_modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
( 0.002468)
DELETE FROM BToec_online WHERE online_updated < 1145705987
( 0.001402)
SELECT COUNT(*) FROM BToec_online WHERE online_uid=1
( 0.001442)
UPDATE BToec_online SET online_updated=1145706287, online_module = 13 WHERE online_uid = 1
( 0.001324)
SELECT * FROM BToec_online
( 0.015782)
SELECT COUNT(*) FROM BToec_online WHERE online_module = '13'
( 0.001593)
Total Number of Queries: 9 | Total SQL Generation Time: 0.035281

Blocks
User Menu: (1 Queries) No Cache
Main Menu: (3 Queries) No Cache
Who's Online: (5 Queries) No Cache
Total: 3 blocks

Execution Time
XOOPS took 1.4016430378 seconds to load.

Quote:

First of all don't reinstall - yet at least. There is sure to be something....which XOOPS are we dealing with here? 2.0 or 2.2?

I am trying to get a picture of your problem:
Quote:

You say any 'other' module - which one are you using that is the one that does work??? Which one is your starting module?

Second of all - do the time consuming double check - check the permission and access settings on each and every module...you might find the change the other webmasters made there.

make sure all 'blocks' you want visible in top page have the yes radio button not the no - do this in blocks admin not general preferences.

I'm sorry if this isn't helpful...but it was worth a try..much rather see than tonight.

Cheers

Quote:

Hi m8.

I am using:

IIS
Windows NT
MySQL 5.0.X
Xoops 2.2.4

Quote:

Ok, here is what happens.

In general settings, if I don't set any Start Module, all modules appear on the site (Left/Right etc) whether they are Top Page or All Front Side Page modules.

If I set *ANY* module e.g. news or CBB etc. in the general settings as the starting module, the Top Page modules do not appear when I go to www.mysite.com (it does redirect to the starting module as expected. In my local dev box I can see the top page modules AND the starting module at the SAME time.)

Quote:

I've gone beyond this - for the testing I am only using 'Who's online' block from the built in system module. Am setting the CBB (newbb) as starting module. I've checked all permissions, config settings etc.

Quote:

Don't think there is an option to set the visibility in the general settings area. Yep, done the Yes/No check a number of times in the Blocks->List All Blocks area.

Cheers

Ok...you need the 2.2.4 gurus to help you on this one...it's over my head...but glad you posted more info...

Any other takers ? Especially 2.2.4 gurus ! If I can only find out what the query means (the example I posted) or if there is a way to change it. I need to know the semantics of the module selection query (so maybe this is not the right forum to post in).

I've seen other module selection queries people have posted and they are similar to what is being executed in my local environment (but not on the hosted server).

Bump? Amyone able to help?

Can anyone help ? The portal is nearly unusable for me at the moment.

Can you guys please try the following and post your debug results (doesnt matter what environment/xoops version you are using)

1. Add a few modules. I had the following
User Menu -All Frontside Pages
Main Menu- All Frontside Pages
Recent Posts - Starting Module
Who's Online - Top Page

2. Set the debug mode from System->preferences (MySQL/Blocks Debug)

3. GO to the index of your website e.g. www.mysite.com/index.php


Post debug text from popup window after whole website page has finished loading.

Would appreciate any help. Thanks.

I have read and am trying to understand what the main problem is. The actual top page is a page with just blocks and no modules by default. If you choose to use a module as your top page (home page) the top page setting in the blocks will no longer work. You need to then set the blocks that you want to show on the start page as starting on the selected module page (as the selected module is being used for a start page.)

If you do not want the module listed in the URL, you will need to set the module to use for start page to "none" and use provided blocks from the module for your content.

If this is not what you are asking, I am sorry.

This may be silly but worth checking to see if it works.

In your blocks admin, for each block you want to show up in your (for example) news, CBB start page maybe you need to go into edit for those blocks and make sure that they are set to be viewed for the top page and the start page module you set as your start page. So in the blocks edit you would have Top Page and CBB highlighted for the block to display on. Which would mean Top Page (not All Pages) of the CBB module.

Oops, looks like JD beat me to it....

Hope this helps,

Quest

Hi JD/Quest,

Thanks for your replies.

JD - I've tried registering on your website, but for some reason when I try to login, and visit the forums it logs me out.

Anyway - this is what's happening in my local dev setup :

1. System -> General Settings

Articles (AMS) is starting module.

System Preferences



2. Blocks -> List all blocks.

Two blocks are visible on Top Page, and the rest are visible on All Frontside pages.

Blocks


3. If I visit root of my website e.g. www.mysite.com/index.php

I get redirected to the Article Management System

Index Page

You can see that the Top Page blocks are STILL visible. (which is what I want).

4. If I visit any other module or block, lets say I click the Archive link from the menu, the Top Page blocks are not visible anymore.

Another Block


This scenario does not work on the hosted server. The Top Page modules are not visible when I visit the index page of my website (and get redirected to the starting module). In my local development environment I am using Apache instead of IIS.

So, whats the normal behaviour ? The one I presented above, or the one thats happening on the hosted server ?

All I want is to have some blocks ONLY appear when I first visit the site e.g. www.mysite.com/ (index page) and NOT appear on any other pages.

Hope that helps.

Cheers