1
limecity
lost administrative power in cbb
  • 2009/2/18 1:46

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


This is getting frustrating as I still cannot get this problem solved.

Resized Image


Warning: Class 'xoopstree' is deprecatedcheck 'XoopsObjectTree' in tree.php in file class/xoopstree.php line 45


SET NAMES 'ISO-8859-1'
Error number1115
Error message
Unknown character set'ISO-8859-1'
SELECT FROM xt3x5_config WHERE (conf_modid '0' AND conf_catid '1'ORDER BY conf_order ASC
SELECT sess_data
sess_ip FROM xt3x5_session WHERE sess_id '6ff55e7c1664f41b35d519945d9ecfb0'
SELECT FROM xt3x5_users WHERE uid '1963'
DELETE FROM xt3x5_protector_access WHERE expire UNIX_TIMESTAMP()
SELECT COUNT(*) FROM xt3x5_protector_access WHERE ip='124.82.39.220' AND request_uri='/modules/newbb/admin/admin_forum_manager.php?op=mod&forum=33'
SELECT COUNT(*) FROM xt3x5_protector_access WHERE ip='124.82.39.220'
INSERT INTO xt3x5_protector_access SET ip='124.82.39.220',request_uri='/modules/newbb/admin/admin_forum_manager.php?op=mod&forum=33',expire=UNIX_TIMESTAMP()+'60'
SELECT FROM xt3x5_modules WHERE dirname 'newbb'
SELECT FROM xt3x5_config WHERE (conf_modid '180'ORDER BY conf_order ASC
SELECT 
FROM xt3x5_group_permission WHERE (gperm_name 'module_admin' AND gperm_modid '1' AND (gperm_groupid '1' OR gperm_groupid '2'))
SELECT FROM xt3x5_bb_forums WHERE forum_id '33'
SELECT cat_idcat_title FROM xt3x5_bb_categories WHERE 0=0 ORDER BY cat_id
SELECT 
FROM xt3x5_bb_categories WHERE 0=4 ORDER BY cat_id
SELECT 
FROM xt3x5_bb_categories WHERE 0=5 ORDER BY cat_id
SELECT 
FROM xt3x5_bb_categories WHERE 0=14 ORDER BY cat_id
SELECT 
FROM xt3x5_bb_categories WHERE 0=18 ORDER BY cat_id
SELECT 
FROM xt3x5_bb_categories WHERE 0=25 ORDER BY cat_id
SELECT 
FROM xt3x5_smiles
SELECT COUNT
(*) FROM `xt3x5_users`
SELECT FROM `xt3x5_usersWHERE (uid IN ()) ORDER BY uname ASC
Error number
1064
Error message
You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY uname ASC' at line 1
Total
21 queries



I have 2000 over users in my database but none of them show up in my the list when I am trying to add a moderator.

And somehow, I don't have the administrative power for cbb as well. it listed me as a normal user. I only have the ability to "delete, edit" postings but I don't have the ability to move the topics or merge the topics which I am suppose to as I am the webmaster of the site. Its as shown as the image below.

Resized Image


with the debug below:
NoticeDeprecated function 'mod_getip', use XoopsUserUtility directlyin file Frameworks/art/functions.user.php line 20
Notice
Only variables should be assigned by reference in file modules/newbb/class/permission.php line 117
Notice
Deprecated function 'mod_getunamefromids', use XoopsUserUtility directlyin file Frameworks/art/functions.user.php line 26
Notice
Undefined indexshoutbox_smibar in file modules/shoutbox/blocks/shoutbox.php line 60
Notice
Only variable references should be returned by reference in file modules/smartpartner/include/functions.php line 252
Notice
Only variable references should be returned by reference in file modules/smartpartner/include/functions.php line 252
Notice
Only variable references should be returned by reference in file modules/smartpartner/include/functions.php line 252
Notice
Only variable references should be returned by reference in file modules/smartpartner/include/functions.php line 252
Notice
Only variables should be assigned by reference in file modules/smartpartner/blocks/partners_list.php line 27
Notice
Undefined indextitle in file modules/newbb/class/user.php line 248
Warning
: Class XoopsEditorHandler does not exist
Handler Name
editor in file include/functions.php line 446
Notice
Only variables should be assigned by reference in file modules/newbb/viewtopic.php line 584



I tried uninstalling and resintalling the module and loaded the database of the cbb module. It does work but problem is some of the later pages will be empty.


Please help. I need my administrative power in cbb to moderate the postings.

hhttp://www.mounthiking.com
all your hiking gears and gadgets


2
ghia
Re: lost administrative power in cbb
  • 2009/2/18 13:10

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I'm not sure where it comes from (mainfile.php(?)), but the set names should read:
SET NAMES 'latin1'

For adding moderators, click search.
Make sure popup windows are allowed.
For the admin functions, there is a link below named Admin (/modules/newbb/viewtopic.php?topic_id=123456&mode=1#admin). But it is only for moderators.
Did you run the file check (see release notes)?
Did you empty the cache directories?

3
limecity
Re: lost administrative power in cbb
  • 2009/2/18 22:56

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


i change the mainfile.php

if (defined("XOOPS_DB_CHARSET")) die();
define( 'XOOPS_DB_CHARSET', 'latin1' );

Now it looks ok and doesn't have any errors. but not sure if the database is in what char encoding.


Tried adding moderators through the search function.
it does popup the search window and was able to search
click when clicking the "add" button. it doesn't seem to have any respond. like a dummy button.

the admin link is not there either and can't access manually also.

yes I did empty the cache file.

File check. I think I did run it during upgrade. Maybe I should do it again. How do i do it?

hhttp://www.mounthiking.com
all your hiking gears and gadgets


4
vietnam
Re: lost administrative power in cbb
  • 2009/3/19 5:42

  • vietnam

  • Just popping in

  • Posts: 59

  • Since: 2007/5/25


Warning: Class XoopsEditorHandler does not exist
Handler Name: editor in file /include/functions.php line 446
xoops 2.3.3 + cbb3.08
New installation

5
DarinAllan
Re: lost administrative power in cbb

For the adding of Moderators part of the OP's post, I had the same problem, well it was with Firefox, to add a moderator I had to use Internet Exploder and it worked how it was meant to.

Bit of a bugger when you use linux but WINE helped there lol.

What browser do you use?

;o)

6
limecity
Re: lost administrative power in cbb
  • 2009/3/19 7:14

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


Lol. darinallan

IE actually works for the adding moderators part
but I still can't regain back my admin powers in cbb. darn it.

I can't Merge, Move, Delete topics !
hhttp://www.mounthiking.com
all your hiking gears and gadgets


Login

Who's Online

458 user(s) are online (371 user(s) are browsing Support Forums)


Members: 0


Guests: 458


more...

Donat-O-Meter

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

Latest GitHub Commits