1
Kainaij
My forum software is giving me this error...
  • 2007/7/18 3:26

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


I'm using NewBB (CBB) ver. 1.12 and I just started getting this error when attempting to access a specific forum:

-----

An Error Occured

SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma, p.require_reply, pt.post_text FROM bc_bb_topics t LEFT JOIN bc_users u ON u.uid = t.topic_poster LEFT JOIN bc_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN bc_bb_posts_text pt ON pt.post_id = t.topic_last_post_id LEFT JOIN bc_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1176091686 OR t.topic_sticky=1) AND t.forum_id = 3 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC

If the page does not automatically reload, please click here

-----

What up with that? Can someone give me some leads? My poor 2.0.9.2 site.

2
Garrath
Re: My forum software is giving me this error...
  • 2007/7/18 13:47

  • Garrath

  • Just popping in

  • Posts: 23

  • Since: 2007/6/11


sorry for my poor and bad english...

I don't know this XOOPS version, but i think you can have a debug mode.
If there is one, put your site in debug mode (in administration, general preference), and after you can have the error, because here, the message give a sql sentence, but not the error.

3
Karen
Re: My forum software is giving me this error...
  • 2007/7/18 16:12

  • Karen

  • Just popping in

  • Posts: 23

  • Since: 2007/4/28


I had a member experiance that same error message yeaterday at our site
An Error Occured
SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma, p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON pt.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1176050683 OR t.topic_sticky=1) AND t.forum_id = 6 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC
If the page does not automatically reload

It happened everytime she went to start a new topic on a forumn it fixed itself I never found out why it happened just grateful that its fixed Hope yours will rectify itself also

4
cutley
Re: My forum software is giving me this error...
  • 2007/7/18 16:22

  • cutley

  • Just popping in

  • Posts: 38

  • Since: 2005/11/27


Are there any differences between that forum and the others?

or is http://blackfootcountry.com/modules/newbb/viewforum.php?forum=1 the same as your other ones? permissions etc

If not, make a new forum and transfer the thread acrost


There may be a fix for it, but I am not very good with cbb so just offering a simple soultion
- - - - -
xoops FTW

5
Kainaij
Re: My forum software is giving me this error...
  • 2007/7/18 21:40

  • Kainaij

  • Quite a regular

  • Posts: 256

  • Since: 2004/10/5


PHP Debug returns this:


An Error Occured
SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma, p.require_reply, pt.post_text FROM bc_bb_topics t LEFT JOIN bc_users u ON u.uid = t.topic_poster LEFT JOIN bc_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN bc_bb_posts_text pt ON pt.post_id = t.topic_last_post_id LEFT JOIN bc_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1176157587 OR t.topic_sticky=1) AND t.forum_id = 1 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC

If the page does not automatically reload, please click here
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 100
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 97
Notice [PHP]: Only variable references should be returned by reference in file kernel/configitem.php line 100
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 547
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file kernel/member.php line 281
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file class/database/mysqldatabase.php line 242
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 547
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 547
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 547
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variable references should be returned by reference in file include/functions.php line 517
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variables should be assigned by reference in file modules/newbb/class/forum.php line 100
Notice [PHP]: Only variable references should be returned by reference in file class/module.textsanitizer.php line 257
Notice [PHP]: Only variables should be assigned by reference in file modules/newbb/viewforum.php line 159
Notice [PHP]: Only variables should be assigned by reference in file class/database/mysqldatabase.php line 236
Notice [PHP]: Only variable references should be returned by reference in file class/database/mysqldatabase

=====

Help

6
cutley
Re: My forum software is giving me this error...
  • 2007/7/20 9:35

  • cutley

  • Just popping in

  • Posts: 38

  • Since: 2005/11/27


they are only notices in the debug, so shouldn't cause that
- - - - -
xoops FTW

7
Garrath
Re: My forum software is giving me this error...
  • 2007/7/25 13:14

  • Garrath

  • Just popping in

  • Posts: 23

  • Since: 2007/6/11


Sorry for my bad english...

The error is not on this page but before this one

You may arrive to get debug from the real page and not on redirect page.
Redirect page give that you have an Error and all notice you can see are notice from this redirect page, and not from the real page.

This page is generated by redirect_header function (or something like this, i don't have XOOPS here...)

8
Karen
Re: My forum software is giving me this error...
  • 2007/8/9 3:41

  • Karen

  • Just popping in

  • Posts: 23

  • Since: 2007/4/28


Hi again webmaster is amoung the missing and I'm left to try and solve this problem I am having the same problem On http://labradorsonline.com/first errot message members got while trying to post to any topic wasI get this error (steve too):

The resource cannot be displayed
The resource you are looking for cannot be opened by your browser.

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

Please try the following:

Click the Back button to try another link.
Click Search to look for information on the Internet.




HTTP Error 406 - Not acceptable
Internet Explorer


I get this error (steve too):

The resource cannot be displayed
The resource you are looking for cannot be opened by your browser.

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

Please try the following:

Click the Back button to try another link.
Click Search to look for information on the Internet.




HTTP Error 406 - Not acceptable
Internet Explorer




Then it resolved itself no problem for any one but now everyone gets this when trying to post a new topic

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.


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

XML document must have a top level element. Error processing resource 'http://labradorsonline.com/modules/newbb/rss.php?f=6...

SELECT t.*, u.name, u.uname, u2.uid, u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.post_karma, p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON pt.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE (p.post_time > 1176050683 OR t.topic_sticky=1) AND t.forum_id = 6 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC
If the page does not automatically reload
any input it di fix itself after a few hours but its doing this now any input??? going to see if I can de bug but our admin control panel is still blank god help us


ok used the inline debug heres what I got

Notice: Only variables should be assigned by reference in file /modules/system/admin/preferences/main.php line 50

Notice: Undefined variable: xoops_admin_menu_js in file /include/cp_functions.php line 72

Notice: Undefined variable: xoops_admin_menu_ft in file /include/cp_functions.php line 127

Warning: array_keys() [function.array-keys]: The first argument should be an array in file /include/cp_functions.php line 127

Warning: Invalid argument supplied for foreach() in file /include/cp_functions.php line 127

Notice: Undefined variable: xoops_admin_menu_dv in file /include/cp_functions.php line 160

Queries
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 = '856158d95a92e2322ec176fa96b49a66'
SELECT * FROM xoops_users WHERE uid=50
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT * FROM xoops_modules WHERE dirname = 'system'
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'system_admin' AND gperm_itemid = '3' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT * FROM xoops_configcategory
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
SELECT COUNT(*) FROM xoops_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_admin' AND gperm_itemid = '1' AND (gperm_groupid = '2' OR gperm_groupid = '4' OR gperm_groupid = '5'))
Total: 13 queries
Blocks
Total: 0 blocks
Extra
Timers
XOOPS took 0.062 seconds to load.
XOOPS Boot took 0.018 seconds to load.
Module init took 0.044 seconds to load.
can someone please help me???? trying by any means available to get a hold of the webmaster I think I'll have to try carrier pigeon or smoke signals

Login

Who's Online

324 user(s) are online (246 user(s) are browsing Support Forums)


Members: 0


Guests: 324


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