1
toddherrold
Newbb and Xoops 2.2 error - can't post or edit forum

Just realized that my forums have been down since upgrading to 2.2. Users can't reply or start new topics. All they get is "an error has ocurred" with no message using php debug.

Also, when trying to edit a forum on the Forum tab of the admin panel, the follow message from php debug ocurrs:

Quote:
Fatal error: Call to undefined function: xoopsformselect() in /home/hotdogbl/public_html/modules/newbb/class/formselectuser.php on line 34


I guess it's a good thing that this site hasn't upgraded to 2.2 yet

2
Mithrandir
Re: Newbb and Xoops 2.2 error - cant post or edit forum

1) Why are you double-posting? Is one thread not good enough?
2) The call to undefined function is a bug in the Newbb module, caused by a change in the XoopsFormSelectUser class
3) What about MySQL debug on the non-posting issue?
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

3
toddherrold
Re: Newbb and Xoops 2.2 error - cant post or edit forum

1. I'm double posting because my original post was in a different section and I felt this error is so significant that it should be in the 2.2 bug report section. I would have deleted my other post but i don't have priviledges to do that. Perhaps registered users should be able to delete their posts? Not sure why this is a concern.

2. Newbb is so widely used that I would hope that a bug fix is a focus and forthcoming soon.

3. My Sql debug:
Quote:
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 = 'dde1ded22cab1e494de2e2f39d3a7ae9'
( 0.000466)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '3' LIMIT 0, 1
( 0.000283)
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
( 0.0002)
SELECT * FROM xoops_config WHERE (conf_modid = '64') ORDER BY conf_order ASC
( 0.000415)
SELECT COUNT(*) FROM xoops_banner
( 0.000284)
SELECT * FROM xoops_banner LIMIT 0, 1
( 0.000601)
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 5
( 0.000843)
SELECT * FROM xoops_config WHERE (conf_modid = '1' AND conf_catid = '3') ORDER BY conf_order ASC
( 0.000299)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'block_read' AND gperm_groupid IN (1,2))
( 0.000705)
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 (8,9,221,225,74,227,105,246,217,216,106,232,104,30,226,296,279,278,263,228,224,118,103,11,3,65,63,73,66,244,10,231,219,107,102,101,75,4,235,268,230,77,14,236,267,229,76,13,295,294,12,19,309,7,218,308,307,64,117,78,1,2,271,251,250,249,248,247,131,126,125,124,123,122,121,119,116,115,5,310,311) 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=64 AND m.pageid IN (0,0)) ) ORDER BY i.weight,i.instanceid
( 0.000338)
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '64' AND not_category = 'global' AND not_uid = '3')
( 0.00021)
SELECT * FROM xoops_modules WHERE mid = 64
( 0.000217)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_index.html') ORDER BY tpl_refid
( 0.000203)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_online.html') ORDER BY tpl_refid
( 0.000217)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid
( 0.000208)
Total Number of Queries: 16 | Total SQL Generation Time: 0.005489

Queries module
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=3
( 0.000421)
UPDATE xoops_bb_online SET online_updated= '1122564004', online_forum = '0', online_topic = '0' WHERE online_uid = 3
( 0.000833)
SELECT COUNT(*) FROM xoops_bb_online
( 0.000225)
SELECT * FROM xoops_bb_online WHERE online_uid <> '0'
( 0.00057)
SELECT COUNT(*) AS total FROM xoops_bb_topics
( 0.000521)
SELECT COUNT(*) AS total FROM xoops_bb_posts
( 9.8E-05)
SELECT * FROM xoops_bb_categories ORDER BY cat_order
( 0.000183)
SELECT f.*, u.uname, u.name, u.uid, p.topic_id, p.post_time, p.subject, p.poster_name, p.icon FROM xoops_bb_forums f LEFT JOIN xoops_bb_posts p ON p.post_id = f.forum_last_post_id LEFT JOIN xoops_users u ON u.uid = p.uid ORDER BY f.cat_id, f.forum_order
( 0.000316)
SELECT * FROM xoops_bb_forums ORDER BY forum_order
( 0.000275)
SELECT uid, uname FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid IN (3) ORDER BY uname
( 0.000152)
Total Number of Queries: 10 | Total SQL Generation Time: 0.003593

Queries block
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC
( 0.00029)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid IN (1,2))
( 0.000362)
SELECT * FROM xoops_modules WHERE dirname = 'wfdownloads'
( 0.000263)
SELECT `name`, `page` FROM `xoops_icontent_shortcuts` WHERE `submenu`=1
( 0.00015)
SELECT groupid, name FROM xoops_groups ORDER BY name ASC
( 0.000191)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
( 0.000184)
SELECT * FROM xoops_modules WHERE dirname = 'smartfaq'
( 0.000192)
SELECT * FROM xoops_smartfaq_faq WHERE ((status = '5' OR status = '6') AND (modulelink <> 'None')) ORDER BY datesub DESC
( 0.000465)
SELECT * FROM xoops_smiles
( 0.000964)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'faqs_context.html') ORDER BY tpl_refid
( 0.000169)
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '3')
( 0.000141)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
( 0.000163)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
( 0.000174)
SELECT * FROM xoops_bb_forums ORDER BY forum_order
( 0.000305)
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '64')
( 0.000164)
SELECT uid FROM xoops_groups_users_link WHERE groupid=1
( 0.00011)
SELECT t.*, f.forum_name, f.allow_subject_prefix, p.post_id, p.icon, p.uid, p.poster_name, u.uname, u.name FROM xoops_bb_topics t, xoops_bb_forums f, xoops_bb_posts p LEFT JOIN xoops_users u ON u.uid = p.uid WHERE f.forum_id=t.forum_id AND t.forum_id IN (1,2,11,15,4,6,10,3,7,5,14,9,16,13,8) AND t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER BY t.topic_replies DESC LIMIT 0, 10
( 0.000282)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_block.html') ORDER BY tpl_refid
( 0.00017)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
( 0.000167)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'search_block.html') ORDER BY tpl_refid
( 0.000181)
SELECT COUNT(*) FROM xoops_online WHERE online_uid=3
( 0.000354)
UPDATE xoops_online SET online_updated=1122564004, online_module = 64 WHERE online_uid = 3
( 0.00093)
SELECT * FROM xoops_online
( 0.000334)
SELECT COUNT(*) FROM xoops_online WHERE online_module = '64'
( 0.000392)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_online.html') ORDER BY tpl_refid
( 0.000448)
SELECT * FROM xoops_donations_config WHERE subtype = '' OR subtype = 'array'
( 0.00026)
SELECT count(mc_gross) AS count, sum(mc_gross) AS gross, sum(mc_gross-mc_fee) AS net, date_format( now(),'%M') AS mon, date_format( subdate( date_format( adddate(now(), INTERVAL 1 MONTH),'%Y-%c-1'), INTERVAL 1 DAY), '%b %e') AS due_by, date_format(now(),'%b') AS mon_short FROM xoops_donations_transactions WHERE (payment_date >= date_format(now(),'%Y-%m-1'))
( 0.00052)
SELECT * FROM xoops_donations_config WHERE name='month_goal' AND subtype='Jul'
( 0.00013)
select custom as muser_id, option_selection1 as showname, date_format( payment_date, '%b-%e') as date, concat('$',sum(mc_gross)) as amt from xoops_donations_transactions where (payment_date >= date_format( now(), '%Y-%m-1')) group by txn_id order by payment_date desc
( 0.000582)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '353' LIMIT 0, 1
( 0.000324)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '248' LIMIT 0, 1
( 0.000265)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '131' LIMIT 0, 1
( 0.000298)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '130' LIMIT 0, 1
( 0.000298)
SELECT * FROM xoops_users u, xoops_user_profile p WHERE u.uid = p.profileid AND uid = '187' LIMIT 0, 1
( 0.00028)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'donations_donatometer.html') ORDER BY tpl_refid
( 0.000171)
SELECT * FROM xoops_donations_config WHERE subtype = '' OR subtype = 'array'
( 0.000233)
SELECT * from xoops_donations_config WHERE name='don_amount' ORDER BY subtype
( 0.000127)
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'donations_donate.html') ORDER BY tpl_refid
( 0.000155)
Total Number of Queries: 38 | Total SQL Generation Time: 0.011189

Blocks
Main Menu: (6 Queries) No Cache
Contextual Q&A: (4 Queries) No Cache
Custom Block: (2 Queries) No Cache
User Menu: (1 Queries) No Cache
Most Active Topics: (5 Queries) No Cache
Custom Block: (1 Queries) No Cache
: Cached (regenerates every 2592000 seconds)
Who's Online: (5 Queries) No Cache
Donat-O-Meter: (10 Queries) No Cache
Donate Now!: (3 Queries) No Cache
Total: 10 blocks

Execution Time
XOOPS took 0.91160488128662 seconds to load.

Extra

4
bluenova
Re: Newbb and Xoops 2.2 error - cant post or edit forum

A new release of CBB is due soon which works with XOOPS 2.2 a release candidate is already available.

5
toddherrold
Re: Newbb and Xoops 2.2 error - cant post or edit forum

Thanks for the tip. I hadn't followed CBB but it looks like it is easy to switch between newbb2 and CBB, so I'm game if it gets my forums back up!

Login

Who's Online

124 user(s) are online (93 user(s) are browsing Support Forums)


Members: 0


Guests: 124


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits