1
devilock76
Multiple problems and questions
  • 2011/5/15 20:54

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


OK current system is xoops 2.3.3 (not 2.3.3b). Recently upgraded to php5.3 and in the process of that cbb 3.07 stopped working.

SO I said OK I am way overdue for upgrading xoops let's start there. So first I hit my test account with the upgrade to 2.4.4 highest version I could find with an upgrade from 2.3.3 (although it says 2.3.3b) anyway in test this worked. A few snags, call them lessons learned but got everything sorted out. One snag was catads module was no longer working so I downloaded the newer classifieds module and a manual conversion from one to the other was not a big deal. The upgrade got cbb working again.

So carrying forward from there I figured ok let's apply to production. Well the upgrade ran but the admin pages, and of course the link from upgrade to upgrade the admin module failed, error 500. So I have reverted back from the backup I made before starting the upgrade so I am by no means dead in the water, still without a forum but oh well.

My test account is a bit older that production, but for the most part the only differences is test has older data, some extra modules I was testing but not implemented in production yet, oh and the big one the xoops_* directories are in the doc root for test, for production they actually are a directory under the document root.

I read in the detailed installation guide something about altsys and well not sure what that is talking about. I haven't been uber active with xoops.org lately, or even keeping up. Sorry.

Anyway that being said the end goal is to bring everything current, xoops 2.5.1a cbb 308 etc. I am thinking of refreshing test with current production and see if that will upgrade again properly. If I can go straight from 2.3.3 to 2.5.1 that would be best but not really sure if that is practical. Anyway what to do here. Any idea why admin got hosed? Can I go straight from 2.3.3 to 2.5.1a? Any idea why cbb crashes under 2.3.3 and php 5.3?

Ken

2
wishcraft
Re: Multiple problems and questions

Can I suggest you migrate from CBB over to XForum, there is an upgrade script on here as it is designed to use the Class system of 2.5.1a rather than CBB 3.08 which uses older legacy systems..

it has more features as well.

If you could list the bugs you are experiencing as

* Point 1
* Point 2
* Point 3

And then list what you did before the bug happened I will try to help..
vCard (*.vcf): Dr. Simon Antony Roberts.vcf
Follow, Like & Read:-

x.com/EmpressFX
facebook.com/DrAntonyRoberts

3
devilock76
Re: Multiple problems and questions
  • 2011/5/18 3:38

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


Sorry just got your reply now. Got sidetracked on some other stuff. I am refreshing the test area with a current snap shot from live. More to come from there.

Ken

4
devilock76
Re: Multiple problems and questions
  • 2011/5/18 4:16

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


OK here is what I got debug wise, this is from the test area now refreshed with the current live snapshot. Additionally it turns out the user profiles are not working. Anyway this is XOOPS 2.3.3, CBB 3.0.7, server is CentOS 5.6.

Ok errors specific to the forums:

URL: http://www.raleighmusic.com/Test/modules/newbb/

le="color: #000000"><?php None All errors (3) queries (7) blocks (0) extra (2) timers (3) Errors Unknown: Assigning the return value of new by reference is deprecated in file /include/site-closed.php line 35 Unknown: Assigning the return value of new by reference is deprecated in file /modules/newbb/include/functions.php line 377 Unknown: Assigning the return value of new by reference is deprecated in file /modules/newbb/include/functions.php line 391 Queries SET NAMES 'utf8' SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data, sess_ip FROM session WHERE sess_id = 'ol3eqv3gen3c9u26afvnuti6r6' SELECT * FROM users WHERE uid = '1' SELECT * FROM modules WHERE dirname = 'newbb' SELECT * FROM config WHERE (conf_modid = '16') ORDER BY conf_order ASC SELECT * FROM `bb_categories` WHERE 1 = '1' ORDER BY cat_order ASC Total: 7 queries Blocks Total: 0 blocks Extra Included files: 51 files Memory usage: 2747500 bytes Timers XOOPS took 0.055 seconds to load. XOOPS Boot took 0.046 seconds to load. Module init took 0.009 seconds to load.


Additionally code from profile view:

URL: http://www.raleighmusic.com/Test/modules/profile/userinfo.php?uid=1

le="color: #000000"><?php None All errors (26) queries (57) blocks (13) extra (2) timers (5) Errors Unknown: Assigning the return value of new by reference is deprecated in file /include/site-closed.php line 35 Unknown: Assigning the return value of new by reference is deprecated in file /header.php line 61 Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 464 Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 514 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 102 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 103 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 104 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 105 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 106 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 107 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 108 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 119 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 120 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 121 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/statistics/include/hitcounter.php line 135 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/statistics/include/hitcounter.php line 23 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/statistics/include/hitcounter.php line 51 Notice: Undefined index: query in file /modules/statistics/include/hitcounter.php line 64 Notice: Undefined index: fragment in file /modules/statistics/include/hitcounter.php line 68 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 73 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 196 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 248 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme_blocks.php line 90 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/piCal/blocks/pical_coming_schedule.php line 32 Unknown: Function ereg() is deprecated in file /modules/piCal/class/piCal.php line 185 Warning: mktime() [function.mktime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/piCal/class/piCal.php line 193 Queries SET NAMES 'utf8' SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data, sess_ip FROM session WHERE sess_id = 'ol3eqv3gen3c9u26afvnuti6r6' SELECT * FROM users WHERE uid = '1' SELECT * FROM modules WHERE dirname = 'profile' SELECT * FROM config WHERE (conf_modid = '19') ORDER BY conf_order ASC UPDATE counter SET count=count+1 WHERE (type='total' AND var='hits') OR (var='AppleWeb' AND type='browser') OR (var='Linux' AND type='os') SELECT year FROM stats_year WHERE year='2011' SELECT hour FROM stats_hour WHERE (year='2011') AND (month='05') AND (date='18') UPDATE stats_year SET hits=hits+1 WHERE year='2011' UPDATE stats_month SET hits=hits+1 WHERE (year='2011') AND (month='05') UPDATE stats_date SET hits=hits+1 WHERE (year='2011') AND (month='05') AND (date='18') UPDATE stats_hour SET hits=hits+1 WHERE (year='2011') AND (month='05') AND (date='18') AND (hour='00') SELECT id FROM stats_ip WHERE ip='24.136.232.28' AND date>'2011051799' UPDATE stats_ip SET date='2011051800', hits=hits+1 WHERE id='522776' select options from newblocks where name='Top Referers' and dirname='statistics' SELECT id FROM stats_refer WHERE refer='www.raleighmusic.com' AND referpath='/Test/' AND date>'2011051799' UPDATE stats_refer SET date='2011051800', hits=hits+1 WHERE id='253820' SELECT COUNT(*) FROM banner SELECT * FROM banner LIMIT 8, 1 UPDATE banner SET impmade = impmade+1 WHERE bid = 24 SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2) SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,19) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,17,18,19,20,21,22,23,24,90,89,91,25,26,77,79,78,27,28,29,43,42,41,40,30,31,32,33,34,35,39,38,37,36,44,45,46,47,72,100,92,93,80,81,88,82,84,99,98,97,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115) ORDER BY b.weight, m.block_id SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2')) SELECT COUNT(*) FROM catads_ads WHERE uid = '1' SELECT year, hits from stats_year SELECT * FROM modules WHERE dirname = 'pm' SELECT COUNT(*) FROM `priv_msgs` WHERE (read_msg = '0' AND to_userid = '1') SELECT COUNT(*) FROM banner SELECT * FROM banner LIMIT 5, 1 UPDATE banner SET impmade = impmade+1 WHERE bid = 19 SELECT mid FROM modules WHERE dirname='piCal' SELECT conf_name,conf_value FROM config WHERE conf_modid=10 SELECT * FROM groups SELECT * FROM smiles SELECT lid, cid, title, date, hits FROM addresses_links WHERE status>0 ORDER BY hits DESC LIMIT 0, 10 SELECT lid, cid, title, date, hits FROM addresses_links WHERE status>0 ORDER BY date DESC LIMIT 0, 10 SELECT COUNT(*) FROM online WHERE online_uid=1 UPDATE online SET online_updated=1305691836, online_module = 19 WHERE online_uid = 1 SELECT * FROM online SELECT COUNT(*) FROM online WHERE online_module = '19' SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '2') ORDER BY conf_order ASC SELECT field_id FROM profile_visibility WHERE profile_group IN (1,2,0) AND user_group IN (1,2,0) SELECT * FROM `profile_field` WHERE field_id != '0' ORDER BY field_weight ASC SELECT * FROM `profile_category` ORDER BY cat_weight ASC SELECT * FROM profile_profile WHERE profile_id = '1' SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 7 SELECT * FROM modules WHERE (hassearch = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2')) SELECT n.storyid,uid,title,updated FROM ams_article n, ams_text t WHERE t.storyid=n.storyid AND t.current=1 AND published>0 AND published<=1305691836 AND uid=1 ORDER BY created DESC LIMIT 0, 5 SELECT l.lid,l.cid,l.title,l.submitter,l.date,t.description FROM addresses_links l LEFT JOIN addresses_text t ON t.lid=l.lid WHERE status>0 AND l.submitter=1 ORDER BY l.date DESC LIMIT 0, 5 SELECT d.lid,d.title,d.submitter,d.date,t.description FROM myReviews_downloads d LEFT JOIN myReviews_text t ON t.lid=d.lid WHERE status>0 AND d.submitter=1 ORDER BY d.date DESC LIMIT 0, 5 SELECT COUNT(*) FROM catads_ads WHERE uid = '1' SELECT ads_id, uid, ads_title, published FROM catads_ads WHERE published >0 AND expired >1305691836 AND uid=1 ORDER BY published DESC LIMIT 0, 5 SELECT * FROM `bb_forums` WHERE (1 = '1') ORDER BY forum_order ASC Total: 57 queries Blocks Main Menu: No Cache Site Hits: No Cache Custom Block (HTML): No Cache User Menu: No Cache Login: No Cache Custom Block (PHP): No Cache Custom Block (HTML): No Cache MiniCalendar (piCal): No Cache Custom Block (HTML): No Cache Coming Events (piCal): No Cache Top Addresses: No Cache Recent Addresses: No Cache Who's Online: No Cache Total: 13 blocks Extra Included files: 122 files Memory usage: 6223724 bytes Timers XOOPS took 0.764 seconds to load. XOOPS Boot took 0.027 seconds to load. Module init took 0.432 seconds to load. XOOPS output init took 0.217 seconds to load. Module display took 0.088 seconds to load.


And well here is what I see from the home page, the home page shows but below it here is the error list:

URL: http://www.raleighmusic.com/Test/

le="color: #000000"><?php Errors Unknown: Assigning the return value of new by reference is deprecated in file /include/site-closed.php line 35 Unknown: Assigning the return value of new by reference is deprecated in file /header.php line 61 Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 464 Unknown: Assigning the return value of new by reference is deprecated in file /class/xoopsblock.php line 514 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 102 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 103 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 104 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 105 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 106 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 107 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 108 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 119 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 120 Unknown: Function ereg() is deprecated in file /modules/statistics/include/hitcounter.php line 121 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/statistics/include/hitcounter.php line 135 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/statistics/include/hitcounter.php line 23 Notice: Undefined index: host in file /modules/statistics/include/hitcounter.php line 49 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 73 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 196 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme.php line 248 Unknown: Assigning the return value of new by reference is deprecated in file /class/theme_blocks.php line 90 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: MyTextSanitizer::makeTboxData4Show is deprecated in file /class/module.textsanitizer.php line 665 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /class/xoopslocal.php line 185 Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/piCal/class/piCal.php line 129 Unknown: Function ereg() is deprecated in file /modules/piCal/class/piCal.php line 185 Warning: mktime() [function.mktime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in file /modules/piCal/class/piCal.php line 193 Queries SET NAMES 'utf8' SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC SELECT sess_data, sess_ip FROM session WHERE sess_id = 'ol3eqv3gen3c9u26afvnuti6r6' SELECT * FROM users WHERE uid = '1' UPDATE counter SET count=count+1 WHERE (type='total' AND var='hits') OR (var='AppleWeb' AND type='browser') OR (var='Linux' AND type='os') SELECT year FROM stats_year WHERE year='2011' SELECT hour FROM stats_hour WHERE (year='2011') AND (month='05') AND (date='18') UPDATE stats_year SET hits=hits+1 WHERE year='2011' UPDATE stats_month SET hits=hits+1 WHERE (year='2011') AND (month='05') UPDATE stats_date SET hits=hits+1 WHERE (year='2011') AND (month='05') AND (date='18') UPDATE stats_hour SET hits=hits+1 WHERE (year='2011') AND (month='05') AND (date='18') AND (hour='00') SELECT id FROM stats_ip WHERE ip='24.136.232.28' AND date>'2011051799' UPDATE stats_ip SET date='2011051800', hits=hits+1 WHERE id='522776' SELECT COUNT(*) FROM banner SELECT * FROM banner LIMIT 10, 1 UPDATE banner SET impmade = impmade+1 WHERE bid = 37 SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2) SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,17,18,19,20,21,22,23,24,90,89,91,25,26,77,79,78,27,28,29,43,42,41,40,30,31,32,33,34,35,39,38,37,36,44,45,46,47,72,100,92,93,80,81,88,82,84,99,98,97,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115) ORDER BY b.weight, m.block_id SELECT * FROM modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC SELECT * FROM group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2')) SELECT COUNT(*) FROM catads_ads WHERE uid = '1' SELECT year, hits from stats_year SELECT * FROM modules WHERE dirname = 'AMS' SELECT * FROM ams_spotlight WHERE display = '1' ORDER BY weight ASC SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5290 SELECT * FROM ams_topics WHERE topic_id=6 SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5291 SELECT * FROM ams_topics WHERE topic_id=4 SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5282 SELECT * FROM ams_topics WHERE topic_id=4 SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5267 SELECT * FROM ams_topics WHERE topic_id=6 SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5275 SELECT * FROM ams_topics WHERE topic_id=4 SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE n.storyid=t.storyid AND n.audienceid=a.audienceid AND t.current=1 AND n.storyid=5262 SELECT * FROM ams_topics WHERE topic_id=4 SELECT * FROM `users` WHERE uid IN (2886,6468,5679) SELECT * FROM smiles SELECT * FROM config WHERE (conf_modid = '25') ORDER BY conf_order ASC SELECT * FROM ams_article n, ams_text t, ams_audience a WHERE t.storyid=n.storyid AND n.audienceid=a.audienceid AND published > 0 AND published <= 1305691959 AND (expired = 0 OR expired > 1305691959) AND n.storyid NOT IN (5290,5291,5282,5267,5275,5262) AND t.current=1 ORDER BY published DESC LIMIT 0, 5 SELECT * FROM ams_topics ORDER BY weight SELECT COUNT(*) FROM ams_article WHERE published > 0 AND published <= 1305691959 AND (expired = 0 OR expired > 1305691959) AND ihome=0 SELECT SUM(counter) FROM ams_article WHERE published > 0 AND published <= 1305691959 AND (expired = 0 OR expired > 1305691959) SELECT COUNT(*) FROM xoopscomments WHERE com_modid = '25' SELECT * FROM modules WHERE dirname = 'pm' SELECT COUNT(*) FROM `priv_msgs` WHERE (read_msg = '0' AND to_userid = '1') SELECT COUNT(*) FROM banner SELECT * FROM banner LIMIT 0, 1 UPDATE banner SET impmade = impmade+1 WHERE bid = 23 SELECT lid, cid, title, date, hits, votes, rating, logourl FROM myReviews_downloads WHERE status>0 ORDER BY date DESC LIMIT 0, 3 SELECT title, cid FROM myReviews_cat WHERE cid=2 SELECT title, cid FROM myReviews_cat WHERE cid=1 SELECT title, cid FROM myReviews_cat WHERE cid=2 SELECT mid FROM modules WHERE dirname='piCal' SELECT conf_name,conf_value FROM config WHERE conf_modid=10 SELECT * FROM groups SELECT mid FROM modules WHERE dirname='piCal' SELECT conf_name,conf_value FROM config WHERE conf_modid=10 SELECT * FROM groups SELECT * FROM modules WHERE dirname = 'catads' SELECT * FROM config WHERE (conf_modid = '8') ORDER BY conf_order ASC SELECT COUNT(*) FROM catads_ads WHERE (waiting = '0' AND published < '1305691960' AND expired > '1305691960') SELECT * FROM catads_ads WHERE (waiting = '0' AND published < '1305691960' AND expired > '1305691960') ORDER BY published DESC LIMIT 0, 5 SELECT lid, cid, title, date, hits FROM addresses_links WHERE status>0 ORDER BY hits DESC LIMIT 0, 10 SELECT lid, cid, title, date, hits FROM addresses_links WHERE status>0 ORDER BY date DESC LIMIT 0, 10 SELECT COUNT(*) FROM online WHERE online_uid=1 UPDATE online SET online_updated=1305691960, online_module = 0 WHERE online_uid = 1 SELECT * FROM online SELECT COUNT(*) FROM priv_msgs WHERE (read_msg = '0' AND to_userid = '1') Total: 70 queries Blocks Main Menu: No Cache Site Hits: No Cache Custom Block (HTML): No Cache AMS Spotlight: No Cache Custom Block (HTML): No Cache User Menu: No Cache Login: No Cache Custom Block (PHP): No Cache Custom Block (HTML): No Cache Recent Reviews: No Cache MiniCalendar (piCal): No Cache Custom Block (HTML): No Cache Coming Events (piCal): No Cache Latest ads: No Cache Top Addresses: No Cache Recent Addresses: No Cache Who's Online: No Cache Custom Block (Auto Format): No Cache Total: 18 blocks Extra db:system_homepage.html: Cached (regenerates every 604800 seconds) Included files: 127 files Memory usage: 6141408 bytes Timers XOOPS took 0.516 seconds to load. XOOPS Boot took 0.024 seconds to load. Module init took 0.137 seconds to load. XOOPS output init took 0.355 seconds to load. Page rendering took 0.004 seconds to load.


Ken

5
Mamba
Re: Multiple problems and questions
  • 2011/5/18 5:43

  • Mamba

  • Moderator

  • Posts: 11530

  • Since: 2004/4/23


1) Replace the Statistics module with something like TDMStats

2) Update CBB 3.07 to CBB 3.08, or you can try the 4.03 Beta
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

6
devilock76
Re: Multiple problems and questions
  • 2011/5/19 3:22

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


OK I will attempt to implement both of those tomorrow, probably evening time frame. Thank you.

Ken

7
devilock76
Re: Multiple problems and questions
  • 2011/5/20 3:37

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


So I tried upgrading the test area with cbb 3.07. First try, no go, errors out. So I did the following, uninstalled cbb, then reinstalled using 3.08. Of course this cleaned my existing forum data in the backup. Anyway cbb 3.08 vanilla install working, no issues there. So I reloaded my data (just tables named myprefix_bb_*), no go, back to blank page with errors. SO I am guessing the problem is data related. Not sure what. None of the tables are damaged. Visual/cursory inspection of the tables in question do not yield anything that stands out to me.

Not sure where to go from here.

A mention, whatever I do is going to only live for a month. The site is moving to someone else and they are choosing to run it in their own software and are writing conversion scripts. Just trying not to have more migration outage than necessary. However there is an academic component to fixing this. As in I want to see if I can solve this issue. Also I am weighing my own future development of using Xoops as a base. Anyway thanks for the help so far but I am still stuck as far as the forums so far.

Ken

8
Mamba
Re: Multiple problems and questions
  • 2011/5/20 10:06

  • Mamba

  • Moderator

  • Posts: 11530

  • Since: 2004/4/23


These are the steps to follow:

* Install your old XOOPS 2.3.3b from backup, and make sure that it works, incl. CBB

* Make sure that you have PHP 5.2+ in order to update to XOOPS 2.5.1

* Update to XOOPS 2.5.1a by copying all files, except the "mainfile.php" file. Make sure that you follow the instructions related to protector and XOOPS_TRUST_PATH, etc., and then running the "Upgrade". This is explained in our Installation Tutorial

* Once it works, copy the CBB 3.08 files to the /newbb directory and run "module update"

If you followed the instructions correctly, you should be OK now.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

9
devilock76
Re: Multiple problems and questions
  • 2011/5/22 3:14

  • devilock76

  • Just popping in

  • Posts: 56

  • Since: 2005/7/1 2


OK I think we have a minor communication disconnect. Sorry if I was not clear about it before but CBB is not working, that is the problem that started this whole path. Apologies if I muddled that point in my dialog.

Ken