1
bassyard
News 1.3 : problems after upgrade
  • 2005/3/22 20:02

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Hi there,

I have a problem after I upgraded from News 1.1 to 1.3
I wanted to backup the 1.1 version and just renamed the folder from news to news_bu, and then I copied the 1.3 folder to my server as news, and ran the upgrade script...

I don't know if what I did is OK or if I had to overwrite all the existing files.

Now I have some problems:

News Display Layout:
If I choose "By Topic" all news is showed correctly within it's topic
but with Php debug on:

le="color: #000000"><?php Notice [PHP]: Undefined offset: 4 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 4 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 6 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 6 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 9 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 9 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 11 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 11 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 12 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 12 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 13 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 13 in file modules/news/index.php line 237


When I choose "Classic" it doesn't show any news, only the page numbers are shown, and its doesn't give any php debug notices

And the latest news block won't show the teaser, only the title...
I've used the Spotlight module for some time now, and I'm having the same problem there, no teaser, only title. Although I'm running a second site on the same server, where the teaser works perfect in the Spotlight module.

Who knows what's wrong? I'm a php noob so keep those answers in simple human language plz

2
bassyard
Re: News 1.3 : problems after upgrade
  • 2005/3/23 17:49

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


anyone plz

3
suico
Re: News 1.3 : problems after upgrade
  • 2005/3/23 19:41

  • suico

  • Friend of XOOPS

  • Posts: 374

  • Since: 2003/7/24


I have a similar problem:

le="color: #000000"><?php Notice [PHP]: Undefined index: submissions in file modules/mydownloads/xoops_version.php line 78 Notice [PHP]: Undefined offset: 3 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 3 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 4 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 4 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 5 in file modules/news/index.php line 237 Notice [PHP]: Undefined offset: 5 in file modules/news/index.php line 237


Anyone?

4
hervet
Re: News 1.3 : problems after upgrade
  • 2005/3/24 21:18

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Bassyard,

Could you try what you can read in the FAQ please ?

Bye,
Hervé

5
bassyard
Re: News 1.3 : problems after upgrade
  • 2005/3/25 0:26

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Hi Hervet
The "by topic/classic" problem is fixed!!
In the FAQ: 8.a solved my problem

But the recent news block issue isn't solved yet
It still doesn't show the teaser

Thx for your help so far!!!

Login

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits

None All Errors (0) Deprecated (0) Queries (86) Blocks (13) Extra (2) Timers(8)
Errors
Deprecated
Queries
0.000081 - SET SQL_BIG_SELECTS = 1
0.000940 - SELECT * FROM config WHERE (`conf_modid` = 0 AND `conf_catid` = 1) ORDER BY conf_order ASC
0.000330 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'bf8dc7e0c39864b7cd6988b827fe5c22'
0.001082 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = 1 AND (`gperm_groupid` = 2) AND `gperm_name` = 'module_read' AND `gperm_itemid` = 7)
0.001090 - SELECT * FROM config WHERE (`conf_modid` = 7) ORDER BY conf_order ASC
0.000391 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip='216.73.216.134'
0.003817 - UPDATE online SET online_updated = 1785123002, online_module = 7 WHERE online_uid = 0 AND online_ip='216.73.216.134'
0.000554 - SELECT * FROM config WHERE (`conf_modid` = 139) ORDER BY conf_order ASC
0.000151 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000191 - SELECT COUNT(*) FROM protector_access WHERE ip='216.73.216.134' AND request_uri='/modules/newbb/viewtopic.php?topic_id=33497&post_id=145810'
0.000290 - SELECT COUNT(*) FROM protector_access WHERE ip='216.73.216.134'
0.000197 - INSERT INTO protector_access SET ip='216.73.216.134', request_uri='/modules/newbb/viewtopic.php?topic_id=33497&post_id=145810', expire=UNIX_TIMESTAMP()+'60'
0.000214 - SELECT t.* FROM newbb_topics t, newbb_posts p WHERE t.topic_id = p.topic_id AND p.post_id = 145810
0.000152 - SELECT * FROM newbb_forums WHERE forum_id = '28'
0.000205 - SELECT COUNT(*) FROM `newbb_posts` WHERE (`topic_id` = 33497 AND `approved` = 1)
0.000228 - SELECT COUNT(*) FROM newbb_posts AS p WHERE p.topic_id=33497 AND p.approved = 1 AND p.post_id < 145810
0.000613 - SELECT p.*, t.* FROM newbb_posts p, newbb_posts_text t WHERE p.topic_id=33497 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 10 OFFSET 0
0.000255 - UPDATE newbb_topics SET topic_views = LAST_INSERT_ID(topic_views + 1) WHERE topic_id =33497
0.000814 - SELECT * FROM config WHERE (`conf_modid` = 1) ORDER BY conf_order ASC
0.000115 - SELECT COUNT(*) FROM `publisher_categories`
0.000511 - SELECT gperm_itemid FROM group_permission WHERE (`gperm_name` = 'category_read' AND `gperm_modid` = 123 AND (`gperm_groupid` = 2))
0.001458 - SELECT COUNT(*) FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)))
0.000220 - SELECT COUNT(*) FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 1))
0.005636 - SELECT COUNT(*) FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2))
0.000237 - SELECT COUNT(*) FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 3))
0.000199 - SELECT COUNT(*) FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 4))
0.000164 - SELECT * FROM groups
0.001434 - SELECT DISTINCT c.* FROM imagecategory c LEFT JOIN group_permission l ON l.gperm_itemid=c.imgcat_id WHERE (l.gperm_name = 'imgcat_read' OR l.gperm_name = 'imgcat_write') ORDER BY imgcat_weight, imgcat_id ASC
0.000281 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 4 OFFSET 0
0.000262 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 3 OFFSET 0
0.000327 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 4 OFFSET 0
0.000315 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 10 OFFSET 0
0.000352 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 4 OFFSET 0
0.000254 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 4 OFFSET 0
0.000267 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 1 OFFSET 0
0.000291 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 8 OFFSET 0
0.000299 - SELECT * FROM publisher_items WHERE ((`categoryid` IN (15,14,12,11,10,9,8,7,6,5,4,3,2,1)) AND (`status` = 2)) LIMIT 9 OFFSET 0
0.000248 - SELECT * FROM config WHERE (`conf_modid` = 0 AND `conf_catid` = 5) ORDER BY conf_order ASC
0.000145 - SELECT COUNT(*) FROM banner
0.000303 - SELECT * FROM banner LIMIT 1 OFFSET 0
0.000228 - UPDATE banner SET impmade = 72219500 WHERE bid = 40
0.000309 - SELECT * FROM config WHERE (`conf_modid` = 0 AND `conf_catid` = 3) ORDER BY conf_order ASC
0.005809 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (2)
0.000983 - SELECT b.* FROM newblocks b JOIN block_module_link m ON m.block_id = b.bid LEFT JOIN modules mo ON mo.mid = b.mid WHERE b.isactive =1 AND (mo.isactive =1 OR b.mid = 0) AND b.visible=1 AND m.module_id IN (0,7) AND b.bid IN (312,313,310,293,292,85,291,290,216,215,214,213,212,211,206,207,208,209,210,189,188,184,183,182,181,180,179,178,177,151,136,138,137,86,84,83,82,81,80,79,78,77,96,205,204,314,317,316,315,367,226,132,91,90,89,191,190,161,10,7,44,6,3,2,305,295,288,231,230,229,228,227,221,201,200,294,187,186,185,175,174,166,160,159,158,157,156,147,146,145,144,143,142,140,139,128,127,129,113,94,65,106,88,92,219,60,53,97,40,37,61,153,26,29,311,326,327,335,334,333,336,356,363,366,358,361,364,357,359,362,365,352,353,354,355,368,447,369,384,378,379,374,375,46,370,371,372,373,380,376,381,382,383,360,386,131,387,388,389,390,391,392,393,394,395,396,397,398,450,448,446,449,418,417,416,415,425,424,423,422,421,420,419,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488) ORDER BY b.weight, m.block_id
0.000560 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_login.tpl') ORDER BY tpl_refid
0.000511 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_search.tpl') ORDER BY tpl_refid
0.001076 - SELECT t.topic_id, t.topic_replies, t.forum_id, t.topic_title, t.topic_views, t.type_id, f.forum_name,t.topic_status, p.post_id, p.post_time, p.icon, p.uid, p.poster_name FROM newbb_topics AS t LEFT JOIN newbb_posts AS p ON t.topic_last_post_id=p.post_id LEFT JOIN newbb_forums AS f ON f.forum_id=t.forum_id WHERE 1=1 AND t.forum_id IN (47,46,40,34,59,60,58,18,23,14,10,21,39,2,8,69,68,67,66,75,65,12,33,16,5,31,17,32,15,30,29,28,4,9,13,7,1,20,27,74,72,64,52,63,62,57,53,3,43,42,11,73,6,81,76,77,78,82,84) AND t.approved = 1 AND p.post_time>1779939002 ORDER BY t.topic_last_post_id DESC LIMIT 10 OFFSET 0
0.000205 - SELECT uid, uname, name FROM users WHERE level > 0 AND uid IN(19563)
0.000461 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'newbb_block.tpl') ORDER BY tpl_refid
0.000451 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_dummy.tpl') ORDER BY tpl_refid
0.001836 - SELECT p.post_id, p.subject, p.post_time, p.icon, p.uid, p.poster_name, f.forum_id, f.forum_name FROM newbb_posts AS p LEFT JOIN newbb_forums AS f ON f.forum_id=p.forum_id WHERE 1=1 AND p.forum_id IN (47,46,40,34,59,60,58,18,23,14,10,21,39,2,8,69,68,67,66,75,65,12,33,16,5,31,17,32,15,30,29,28,4,9,13,7,1,20,27,74,72,64,52,63,62,57,53,3,43,42,11,73,6,81,76,77,78,82,84) AND p.approved = 1 AND p.post_time>1754019002 ORDER BY p.post_id DESC LIMIT 10 OFFSET 0
0.000267 - SELECT uid, uname, name FROM users WHERE level > 0 AND uid IN(19563,32997)
0.000394 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'newbb_block_post.tpl') ORDER BY tpl_refid
0.000451 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_comments.tpl') ORDER BY tpl_refid
0.000267 - SELECT name, value FROM donations_config WHERE subtype = '' OR subtype = 'array'
0.000425 - SELECT * FROM config WHERE (`conf_modid` = 105) ORDER BY conf_order ASC
0.000189 - SELECT value FROM donations_config WHERE name = 'xdonation_amt_checked' LIMIT 1
0.000304 - 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 donations_transactions WHERE payment_date >= DATE_FORMAT(NOW(),'%Y-%m-1')
0.000211 - SELECT value FROM donations_config WHERE name='month_goal' AND subtype='Jul' LIMIT 1
0.000291 - SELECT custom AS muser_id, option_selection1 AS showname, DATE_FORMAT(payment_date,'%b %e') AS date, SUM(mc_gross) AS gross_amount, CONCAT('$', FORMAT(SUM(mc_gross),2)) AS amt FROM donations_transactions WHERE payment_date >= DATE_FORMAT(NOW(),'%Y-%m-1') GROUP BY txn_id ORDER BY payment_date DESC LIMIT 10
0.000328 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'donations_donatometer.tpl') ORDER BY tpl_refid
0.000690 - SHOW TABLES LIKE 'menuscategory'
0.000657 - SHOW TABLES LIKE 'menusitems'
0.000382 - SELECT * FROM group_permission WHERE (`gperm_name` = 'menus_category_view' AND `gperm_modid` = 1 AND (`gperm_groupid` = 2))
0.000413 - SELECT * FROM group_permission WHERE (`gperm_name` = 'menus_items_view' AND `gperm_modid` = 1 AND (`gperm_groupid` = 2))
0.000264 - SELECT * FROM `menuscategory` WHERE (`category_active` = 1 AND `category_id` IN (1,2)) ORDER BY category_position ASC
0.000256 - SELECT * FROM `menusitems` WHERE (`items_active` = 1 AND `items_id` IN (2,3,1,4,5,6,7)) ORDER BY items_position ASC
0.000231 - SELECT * FROM newbb_categories WHERE cat_id = '2'
0.000341 - SELECT * FROM `users` WHERE `uid` IN (13309,11591,14075)
0.000200 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 15
0.000194 - SELECT groupid FROM groups_users_link WHERE uid=11591
0.000184 - SELECT * FROM groups WHERE `groupid` IN (3)
0.000159 - SELECT * FROM smiles
0.000266 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_min <= 157 AND rank_max >= 157 AND rank_special = 0
0.000159 - SELECT groupid FROM groups_users_link WHERE uid=13309
0.000134 - SELECT * FROM groups WHERE `groupid` IN (3)
0.000396 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 15
0.000166 - SELECT groupid FROM groups_users_link WHERE uid=14075
0.000124 - SELECT * FROM groups WHERE `groupid` IN (3)
0.000153 - SELECT user_digests, uid FROM newbb_user_stats WHERE uid IN( 11591, 13309, 14075)
0.000236 - SELECT * FROM `newbb_moderates` WHERE (`uid` = 0 AND (`forum_id` = 0 AND `forum_id` = 28) AND `mod_end` > 1785123002)
0.001246 - SELECT * FROM group_permission WHERE (`gperm_modid` = 7 AND `gperm_groupid` IN (2) AND `gperm_itemid` = 28 AND `gperm_name` IN ('\'forum_access\'','\'forum_view\'','\'forum_post\'','\'forum_reply\'','\'forum_edit\'','\'forum_delete\'','\'forum_addpoll\'','\'forum_vote\'','\'forum_attach\'','\'forum_noapprove\'','\'forum_type\'','\'forum_html\'','\'forum_signature\'','\'forum_pdf\'','\'forum_print\''))
0.000233 - SELECT `cat_id`, `cat_order`, `cat_title` FROM `newbb_categories` WHERE `cat_id` IN (10,3,1,2,7,4) ORDER BY cat_order ASC
0.000486 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'newbb_viewtopic.tpl') ORDER BY tpl_refid
0.000380 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'newbb_thread.tpl') ORDER BY tpl_refid
0.000266 - INSERT INTO session (sess_id, sess_updated, sess_ip, sess_data) VALUES ('bf8dc7e0c39864b7cd6988b827fe5c22', 1785123002, '216.73.216.134', 'protector_last_ip|s:14:\"216.73.216.134\";newbb_LV|i:1785123001;') ON DUPLICATE KEY UPDATE sess_updated = 1785123002, sess_data = 'protector_last_ip|s:14:\"216.73.216.134\";newbb_LV|i:1785123001;', sess_ip = '216.73.216.134'
Total: 86
Blocks
Login: Not cached
Search: Not cached
Recent Replied Topics. It Will drop (use advance topic renderer block): Not cached
Custom Block (HTML): Not cached
Recent Posts: Not cached
Custom Block (HTML): Not cached
Recent Comments: Cached (regenerates every 60 seconds)
Donat-O-Meter: Not cached
Custom Block (HTML): Not cached
Custom Block (HTML): Not cached
Custom Block (HTML): Not cached
Custom Block (HTML): Not cached
Custom Block (HTML): Not cached
Total: 13
Extra
Included files: 388 files
Memory usage: 1726344 bytes
Timers
XOOPS took 0.088 seconds to load.
XOOPS Boot took 0.007 seconds to load.
Module init took 0.012 seconds to load.
newBB_Header took 0.001 seconds to load.
newBB_viewtopic took 0.072 seconds to load.
XOOPS output init took 0.050 seconds to load.
Module display took 0.017 seconds to load.
Page rendering took 0.002 seconds to load.