Hi! I'm running cbb 3.05 on XOOPS 2.0.17 using a MySQL v5
database. The location is at
http://www.brooksidefellowship.org/modules/newbb/. The
problem I'm having is that I'm not being given the
option to post - not even admin is given the option!
I've tried setting the permissions to post over and
over, but that particular permission doesn't seem to be
getting set, like it's not going into the database.
Other permissions are being set just fine, but not
posting permission.
Here are the error messages I'm given in debug mode:
All errors (2) queries (35) blocks (5) extra (0) timers (6)
Errors
Notice: Use of undefined constant desc - assumed 'desc'
in file /modules/myguestbook/xoops_version.php line 92
Notice: Use of undefined constant desc - assumed 'desc'
in file /modules/myguestbook/xoops_version.php line 115
Queries
SELECT * FROM brookside_config WHERE (conf_modid = '0'
AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM brookside_session WHERE
sess_id = '8ce3678578c96645fd065e03792fa396'
SELECT * FROM brookside_users WHERE uid=1
SELECT * FROM brookside_modules WHERE dirname = 'newbb'
SELECT * FROM brookside_config WHERE (conf_modid =
'10') ORDER BY conf_order ASC
SELECT * FROM brookside_bb_categories WHERE 1 = '1'
ORDER BY cat_order ASC
SELECT COUNT(l.groupid) FROM
brookside_groups_users_link AS l LEFT JOIN
brookside_group_permission AS p ON
p.gperm_groupid=l.groupid WHERE l.uid=1 AND
p.gperm_modid = '1' AND p.gperm_name = 'module_admin'
AND p.gperm_itemid = '10'
SELECT * FROM brookside_config WHERE (conf_modid = '0'
AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM
brookside_group_permission WHERE gperm_name =
'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM brookside_newblocks b,
brookside_block_module_link m WHERE m.block_id=b.bid
AND b.isactive=1 AND b.visible=1 AND m.module_id IN
(0,10) AND b.bid IN
(1,2,3,4,5,6,7,86,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,91,38,39,40,41,90,89,42,43,44,45,46,47,48,49,88,87,79,78,77,50,51,52,76,75,74,73,81,82,83,80,85,84)
ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM brookside_priv_msgs WHERE
(read_msg = '0' AND to_userid = '1')
SELECT * FROM brookside_modules WHERE (hasmain = '1'
AND isactive = '1' AND weight > '0') ORDER BY weight
ASC, mid ASC
SELECT * FROM brookside_group_permission WHERE
(gperm_name = 'module_read' AND gperm_modid = '1' AND
(gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM brookside_modules WHERE dirname = 'news'
SELECT * FROM brookside_config WHERE (conf_modid =
'11') ORDER BY conf_order ASC
SELECT * FROM brookside_modules WHERE dirname =
'PDdownloads'
SELECT COUNT(*) FROM brookside_online WHERE online_uid=1
UPDATE brookside_online SET online_updated=1192401565,
online_module = 10 WHERE online_uid = 1
SELECT * FROM brookside_online
SELECT COUNT(*) FROM brookside_online WHERE
online_module = '10'
SELECT * FROM brookside_users WHERE (level > '0') ORDER
BY user_regdate DESC LIMIT 0, 10
SELECT COUNT(*) FROM brookside_online WHERE online_uid=1
UPDATE brookside_online SET online_updated=1192401565,
online_module = 10 WHERE online_uid = 1
SELECT COUNT(*) FROM brookside_bb_online WHERE online_uid=1
UPDATE brookside_bb_online SET online_updated=
'1192401565', online_forum = '0', online_topic = '0'
WHERE online_uid = 1
DELETE FROM brookside_bb_online WHERE ( online_uid > 0
AND online_uid NOT IN ( SELECT online_uid FROM
brookside_online WHERE online_module =10 ) ) OR (
online_uid = 0 AND online_ip NOT IN ( SELECT online_ip
FROM brookside_online WHERE online_module =10 AND
online_uid = 0 ) )
SELECT * FROM brookside_bb_online
SELECT COUNT(l.groupid) AS count, l.uid FROM
brookside_groups_users_link AS l LEFT JOIN
brookside_group_permission AS p ON
p.gperm_groupid=l.groupid WHERE l.uid IN (1) AND
p.gperm_modid = '1' AND p.gperm_name = 'module_admin'
AND p.gperm_itemid = '10' GROUP BY l.uid
SELECT COUNT(*) FROM brookside_bb_topics WHERE
(approved > '0')
SELECT COUNT(*) FROM brookside_bb_posts WHERE (approved
> '0')
SELECT * FROM brookside_bb_forums WHERE (1 = '1' AND
cat_id IN (4, 2, 3)) ORDER BY forum_order ASC
SELECT read_item,post_id,read_id FROM
brookside_bb_reads_forum WHERE (uid = '1' AND read_item
IN ()) ORDER BY read_id DESC
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 ')) ORDER BY
read_id DESC' at line 1
SELECT * FROM brookside_smiles
SELECT * FROM brookside_xoopsnotifications WHERE
(not_modid = '10' AND not_category = 'global' AND
not_uid = '1') ORDER BY not_id ASC
SELECT * FROM brookside_modules WHERE mid = 10
Total: 35 queries
Blocks
User Menu: No Cache
Login: No Cache
Main Menu: No Cache
Who's Online: No Cache
New Members: No Cache
Total: 5 blocks
Extra
Timers
XOOPS took 0.586 seconds to load.
XOOPS Boot took 0.109 seconds to load.
Module init took 0.075 seconds to load.
XOOPS output init took 0.256 seconds to load.
Module display took 0.090 seconds to load.
Page rendering took 0.025 seconds to load.
Any idea as to what's going wrong?
Thanks so much!
Francine
