Support Forums - All Posts - XOOPS Web Application System

1

Re: Name of the module to re-order menus

2009/7/2 12:39
ntread
Just popping in
Posts: 9
Since: 2007/7/20

Thank you Mariane! MultiMenu was what I was looking for!

Nick.

2

Name of the module to re-order menus

2009/7/2 10:18
ntread
Just popping in
Posts: 9
Since: 2007/7/20

I used XOOPS a while back while doing some part time work.
The version of XOOPS I was using (2.0.13.0) had a module that let you dynamically change the order of menus. e.g. the user menu, admin menu.
I can't remember what the name of the module is. Can anyone help me out?
Just installed the latest XOOPS and could do with the module.

Regards,

Nick.

3

Re: Invisible posts! Arrggghhh.

2007/8/2 1:21
ntread
Just popping in
Posts: 9
Since: 2007/7/20

well, the simple solution is not always the one you try first!!
Just browsing the installation folders I discovered the newbb_viewtopic_flat.html file was 0 bytes! How flipping annoying! The FTP upload must have messed up at some point.
All is working now.

4

Re: Invisible posts! Arrggghhh.

2007/8/2 0:52
ntread
Just popping in
Posts: 9
Since: 2007/7/20

Bus as I mentioned above, it worked fine on a separate XOOPS installation which runs on the same server, using same version of PHP etc, so I'm thinking that something must have gone wrong with the installation. I'll try running through the installation process again and see what happens.

5

Re: Invisible posts! Arrggghhh.

2007/8/1 4:06
ntread
Just popping in
Posts: 9
Since: 2007/7/20

update

The correct MySQL debug (i.e when trying to view a topic) includes this error


300

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 '-300' at line 1

Nick.

6

CBB 1.6 Forum 'View Topic' page is empty

2007/8/1 3:39
ntread
Just popping in
Posts: 9
Since: 2007/7/20

I've just upgraded newbb 1 to CBB 1.6.
Everything went fine and dandy, I can add categories and forums, and the layout is all fine. I can even post a new topic, however, when ever I try and look at topic posts I just get a blank screen.
I did a test install on a separate installation of XOOPS and this DIDN'T happen! So i'm at a loss to why this has happened now. I've posted the debug reports below. There appears to be no MySQL erros, just 1 PHP error. Help please!

PHP debug


Version 2.0.13.0

Notice [PHP]: Constant _MI_TEXT already defined in file modules/xoopspartners/language/english/modinfo.php line 38

MySQL Debug


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 = '765481adc1352edea8d605f8fae3bfaf'

SELECT * FROM xoops_users WHERE uid=2

SELECT * FROM xoops_modules WHERE dirname = 'newbb'

SELECT * FROM xoops_config WHERE (conf_modid = '4') ORDER BY conf_order ASC

SELECT * FROM xoops_bb_topics WHERE topic_id=6

SELECT * FROM xoops_bb_forums WHERE forum_id = 13

SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_itemid = '4' AND gperm_modid = '1')

SELECT uid FROM xoops_groups_users_link WHERE groupid=4

SELECT uid FROM xoops_groups_users_link WHERE groupid=5

SELECT uid FROM xoops_groups_users_link WHERE groupid=1

SELECT * FROM xoops_group_permission WHERE (gperm_modid = '4' AND gperm_groupid IN (1,2,4) AND gperm_itemid = '13' AND gperm_name IN ('forum_can_post','forum_can_view','forum_can_reply','forum_can_edit','forum_can_delete','forum_can_addpoll','forum_can_vote','forum_can_attach','forum_can_noapprove'))

SELECT t.topic_id, t.topic_title, t.topic_poster, t.topic_status, t.topic_subject, t.topic_sticky, t.topic_digest, t.digest_time, t.topic_time, t.topic_last_post_id, t.approved, t.poster_name, t.rating, t.votes, t.topic_haspoll, t.poll_id, f.forum_id, f.forum_name, f.allow_html, f.allow_sig, f.hot_threshold, f.forum_type, f.allow_attachments, f.attach_maxkb, f.attach_ext, f.allow_polls, f.parent_forum FROM xoops_bb_topics t LEFT JOIN xoops_bb_forums f ON f.forum_id = t.forum_id WHERE t.topic_id = 6

SELECT * FROM xoops_bb_topics WHERE topic_id=6

SELECT COUNT(*) FROM xoops_bb_posts WHERE topic_id=6 AND approved = 1

SELECT p.*, t.* FROM xoops_bb_posts p, xoops_bb_posts_text t WHERE p.topic_id=6 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 0, 10

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC

SELECT COUNT(*) FROM xoops_banner

SELECT * FROM xoops_banner LIMIT 0, 1

UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 1

SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,4)

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,4) AND b.bid IN (31,30,47,40,38,5,2,35,1,37,36,33,32,28,27,26,25,24,23,22,21,44,20,19,18,43,17,16,42,15,14,13,12,11,49,10,9,8,7,6,4,3,39,34,29,46,50,51,52,53,54,55,56,57,58,59,60,61) ORDER BY b.weight,b.bid

SELECT COUNT(*) FROM xoops_multimenu01 WHERE hide = 1

SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu01 WHERE hide = 1 ORDER BY weight ASC

SELECT * FROM xoops_smiles

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_01.html') ORDER BY tpl_refid

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert.html') ORDER BY tpl_refid

SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '2')

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid

SELECT COUNT(*) FROM xoops_multimenu04 WHERE hide = 1

SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu04 WHERE hide = 1 ORDER BY weight ASC

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_04.html') ORDER BY tpl_refid

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert_css.html') ORDER BY tpl_refid

SELECT COUNT(*) FROM xoops_multimenu02 WHERE hide = 1

SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu02 WHERE hide = 1 ORDER BY weight ASC

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_02.html') ORDER BY tpl_refid

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert_css.html') ORDER BY tpl_refid

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' OR gperm_groupid = '4'))

SELECT * FROM xoops_bb_forums ORDER BY forum_order

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid

SELECT COUNT(*) FROM xoops_online WHERE online_uid=2

UPDATE xoops_online SET online_updated=1185941057, online_module = 4 WHERE online_uid = 2

SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=2

UPDATE xoops_bb_online SET online_updated= '1185941057', online_forum = '13', online_topic = '6' WHERE online_uid = 2

SELECT online_uid, online_ip FROM xoops_online WHERE online_module = 4

DELETE FROM xoops_bb_online WHERE ( online_uid NOT IN (2) )

SELECT COUNT(*) FROM xoops_bb_online WHERE online_topic = '6'

SELECT * FROM xoops_bb_online WHERE (online_topic = '6' AND online_uid <> '0')

SELECT * FROM xoops_users WHERE uid IN (2)

SELECT * FROM xoops_bb_online WHERE online_uid IN (2)

SELECT * FROM xoops_groups

SELECT groupid FROM xoops_groups_users_link WHERE uid=2

SELECT rank_title AS title, rank_image AS image FROM xoops_ranks WHERE rank_min <= 4 AND rank_max >= 4 AND rank_special = 0

SELECT * FROM xoops_bb_categories WHERE cat_id = 5

SELECT * FROM xoops_bb_categories ORDER BY cat_order

SELECT * FROM xoops_bb_forums ORDER BY forum_order

SELECT post_id FROM xoops_bb_posts WHERE topic_id = 6 AND pid = 0

SELECT COUNT(*) FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'thread' AND not_itemid = '6' AND not_event = 'new_post' AND not_uid = '2')

SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'thread' AND not_itemid = '6' AND not_uid = '2') ORDER BY not_id ASC

SELECT * FROM xoops_modules WHERE mid = 4

SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'forum' AND not_itemid = '13' AND not_uid = '2') ORDER BY not_id ASC

SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'global' AND not_uid = '2') ORDER BY not_id ASC

SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_viewtopic_flat.html') ORDER BY tpl_refid

Info

XOOPS Version:2.0.13.2
Module Name/Version:CBB - 1.16
PHP Version: 5.0.5
MySQL Version: 4.1.20
Web Server Software (Apache/IIS/Other):Apache/2.2.2
Operating System:
Theme you are using:blue lagoon
Custom template: (Yes/No)
PHP Debug Messages: See above
MySQL Debug Messages: See above

Thanks,

Nick

7

Re: Forum install causes database error

2007/7/24 3:01
ntread
Just popping in
Posts: 9
Since: 2007/7/20

A couple more things have cropped up.
The right hand blocks have disapeard from the forum. my main.php seems to have the relevant update -


[b]

MUST-DO: replace your /modules/system/admin/modulesadmin/main.php with the

-- [url=http://sourceforge.net/tracker/index.php?func=detail&aid=1052403&group_id=41586&atid=430842] Bugfix for block update[/url]

[/b]

but the blocks dont appear. Any clues?

And also, the last instruction in the forum update readme.txt is to update the newbb templates.
I'm not exactly sure what this means. I've accessed the Template Set Manager through the admin interface and can see that there is a big list of templates for each module (making up the XOOPS default template set) , including the forum module. The files are things like 'newbb_online.html' and 'newbb_index.html'. Do I need to do something with these?

The only thing that appears wrong with the forum update is that the drop down menu background colour is too light so it's difficult to read the text.

Thanks,

Nick

8

Re: Forum install causes database error

2007/7/24 1:23
ntread
Just popping in
Posts: 9
Since: 2007/7/20

Quote:

Bandit-X wrote:
did you run the upgrade script in the update folder?

taken from the readme file.
[quote]Update Scripts Along with the Package:
-- Newbb 1 to Newbb 2.0.2 ( newbb1_to_newbb2.php )
-- Newbb 2.0 RC1 to Newbb 2.0.2 ( newbb2rc1_to_newbb2.php )
-- Newbb 2.0 RC2 to Newbb 2.0.2 ( newbb2rc2_to_newbb2.php )
-- Newbb 2.0 RC3 to Newbb 2.0.2 ( newbb2rc3_to_newbb2.php )
-- Newbb Pro 1.03 to Newbb 2.0.2 ( newbbpro_to_newbb2.php

haha, nope I didn't, and having now done so all is working fine! Thankyou!
My reason for not doing this in the first place was because I just did a fresh install, i.e got rid of the newbb folder from the modules directory and didn't think I was 'updating' so to speak, more just 'installing'.
Anyway, all is good, thanks Bandit-X and cybersensei (you were also spot on about the missing tables, which of course were created by the update script.
I'll get the knack of this xooping soon enough I hope.

Nick

9

Forum install causes database error

2007/7/23 8:29
ntread
Just popping in
Posts: 9
Since: 2007/7/20

I've just installed newbb 2.02 on a XOOPS installation, upgrading from version 1 (which worked fine)
The install seemed to go ok, but now when I try to create a category it simply says 'Database Error' and returns to the 'new category' page. I found a very similar entry to this already on the forums, with the main reply being 'upgrade to CBB3.xx, however the version of XOOPS being used doesn't support this, and i'd rather try and figure out why i'm getting this problem at this point, in case i've done any major damage!

When I try to view the forum, everything is there (all icons etc) except any categories/forums, the space is just blank. I've documented below the debug messages.
I'm new at using xoops, and i'm just trying to update a site for someone.
It might be as simple as wrong file permissions or something, but i've no idea.

Using php debug I got the following messages on the actual forum page.


Warning [PHP]: Invalid argument supplied for foreach() in file modules/newbb/index.php line 90

Warning [PHP]: Invalid argument supplied for foreach() in file modules/newbb/index.php line 124

Notice [PHP]: Undefined variable: category_array in file modules/newbb/index.php line 158

Warning [PHP]: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in file modules/newbb/index.php line 158

Notice [PHP]: Undefined variable: category_array in file modules/newbb/index.php line 160

Notice [PHP]: Undefined variable: display in file modules/newbb/index.php line 161

And on the forum admin menu page i got these messages.


Notice [PHP]: Undefined variable: row in file modules/newbb/class/report.php line 141

Notice [PHP]: Undefined variable: row in file modules/newbb/class/report.php line 141

Using MySQL Debug on the Forum admin page I get this:


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 = '00c3f4fd4382dc92061ef09f48c07784'

SELECT * FROM xoops_users WHERE uid=2

SELECT * FROM xoops_modules WHERE dirname = 'newbb'

SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC

SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))

SELECT * FROM xoops_modules WHERE dirname = 'xoopspoll'

SELECT COUNT(*) AS total FROM xoops_bb_topics

SELECT COUNT(*) AS total FROM xoops_bb_posts

SELECT sum(topic_views) FROM xoops_bb_topics

SELECT COUNT(*) as report_count FROM xoops_bb_report WHERE report_result = 0

Error number: 1146

Error message: Table 'xoops_community.xoops_bb_report' doesn't exist

SELECT COUNT(*) as report_count FROM xoops_bb_report WHERE report_result = 1

Error number: 1146

Error message: Table 'xoops_community.xoops_bb_report' doesn't exist

SELECT p.*, t.post_text FROM xoops_bb_posts p LEFT JOIN xoops_bb_posts_text t ON p.post_id=t.post_id LEFT JOIN xoops_bb_topics tp ON tp.topic_id=p.topic_id WHERE p.approved='0'

Error number: 1054

Error message: Unknown column 'p.approved' in 'where clause'

SELECT t.* FROM xoops_bb_topics t LEFT JOIN xoops_bb_posts p ON p.topic_id=t.topic_id WHERE p.pid = 0 AND p.approved = 1 AND t.approved = 0

Error number: 1054

Error message: Unknown column 'p.approved' in 'where clause'

Hope someone can shed some light on this.
It may well be that I should just upgrade to CBB 1.16, but I just worry that i might have done something with this install that may effect any future install.

Info

XOOPS Version:2.0.13.2
Module Name/Version:newbb - 2.02
PHP Version: 5.0.5
MySQL Version: 4.1.20
Web Server Software (Apache/IIS/Other):Apache/2.2.2
Operating System:
Theme you are using:blue lagoon
Custom template: (Yes/No)
PHP Debug Messages: See above
MySQL Debug Messages: See above

Thanks,

Nick

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: Name of the module to re-order menus

Name of the module to re-order menus

Re: Invisible posts! Arrggghhh.

Re: Invisible posts! Arrggghhh.

Re: Invisible posts! Arrggghhh.

CBB 1.6 Forum 'View Topic' page is empty

Re: Forum install causes database error

Re: Forum install causes database error

Forum install causes database error

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}