1
bassyard
XFguestbook: problem after upgrade to 2.22
  • 2005/8/5 17:08

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Hi there!

I have a problem with XFguestbook

I was running xf v2.1 and wanted to upgrade to 2.2, I followed the upgrade instructions in the Lizezmoi.txt:

Made a backup of xfguestbook, made a backup of the databasefiles, uploaded all the files in the folder and overwritten all the old ones, deleted some older unused files, and ran xfguestbook_v21tov22.sql through phpMyAdmin and finally updated the module in the xoopsadmin.

Now when I check the guestbook, I only see Sign Guestbook and no posts at all, in the admin area they are all there even when I make a new post...

Somebody with idea's?
. . . : : : | | | PressureLab.com | | | : : : . . .

2
Mithrandir
Re: XFguestbook: problem after upgrade to 2.22

MySQL debug errors on the view-page?
PHP errors?
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

3
theCat
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/5 18:28

  • theCat

  • Just popping in

  • Posts: 77

  • Since: 2004/2/2 2


Sorry, sqlfile is a bad solution to upgrad a module, while it contain the prefix XOOPS .
Mith
Quote:
No module developer should ever rely on a fixed prefix - that's the whole idea of having it in the first place.


You must change into xfguestbook_v21tov22.sql XOOPS with the real prefix of your tables.

Sorry for this desagrement (and my bad english).
And I change that in the next version !
...

4
bassyard
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/12 10:13

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Hi thanx for the replies, but couldn't figure it out.

theCat: In my database all the xoopstables have the XOOPS prefix, so it shouldn't be a problem right? My mySQL/PHP skills are limited

Mith: It's a very long list with the PHP-debug on: here's the link to the module http://www.pressurelab.com/content/modules/xfguestbook/index.php
Maybe u see what's wrong

thx in advance
B.
. . . : : : | | | PressureLab.com | | | : : : . . .

5
theCat
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/12 12:25

  • theCat

  • Just popping in

  • Posts: 77

  • Since: 2004/2/2 2


are you using PHP5 ?
in this case, apply this fix
...

6
bassyard
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/12 13:09

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


No, I'm using PHP 4.4.0
. . . : : : | | | PressureLab.com | | | : : : . . .

7
bassyard
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/14 19:11

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


Any other suggestions?
. . . : : : | | | PressureLab.com | | | : : : . . .

8
Mithrandir
Re: XFguestbook: problem after upgrade to 2.22

First off - all the "only variables should be returned by reference" notices are caused by the PHP crew creating PHP 4.4 and 5.1 (to which I am grateful, but it means that we are now becoming aware of these errors that seemed small, but have turned out to potentially cause problems)

We will work on eliminating these notices in the core files in future XOOPS versions.

To find the cause of the problem with the entries not showing up, I need you to turn on MySQL debug, access the XF-Guestbook page and see if there are failed SQL queries in the MySQL debug window.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

9
bassyard
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/14 21:54

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


I turned on mySQL debug and checked for errors, I didn't find any I think (this is all very new to me )

just to make sure, here's what the debug came up with:

SELECT FROM xoops_config WHERE (conf_modid AND conf_catid 1ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id 
'e2b04307affcd172a20fca4fa040b55c'
SELECT FROM xoops_users WHERE uid=1
SELECT 
FROM xoops_modules WHERE dirname 'xfguestbook'
SELECT FROM xoops_config WHERE (conf_modid 85ORDER BY conf_order ASC
SELECT 
FROM xoops_config WHERE (conf_modid AND conf_catid 3ORDER BY conf_order ASC
SELECT COUNT
(*) FROM xoops_banner
SELECT 
FROM xoops_banner LIMIT 01
UPDATE xoops_banner SET impmade 
impmade+1 WHERE bid 1
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name 
'block_read' AND gperm_modid AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks bxoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=AND b.visible=AND m.module_id IN (0,85) AND b.bid IN (204,161,24,170,165,155,90,163,171,160,157,141,9,10,18,82,14,119,117,144,17,191,150,16,159,15,13,194,185,158,23,180,12,7,121,6,2,1,151,4,154,152,203,92,198,196,195,193,192,190,189,182,181,153,146,145,138,137,116,115,114,93,113,112,111,26,25,21,20,19,11,8,91,5,3,136,51,202ORDER BY b.weight,b.bid
SELECT 
FROM xoops_tplfile WHERE (tpl_tplset 'PL v6.0' AND tpl_file 'system_dummy.html'ORDER BY tpl_refid
SELECT COUNT
(*) FROM xoops_priv_msgs WHERE (read_msg AND to_userid 1)
SELECT FROM xoops_tplfile WHERE (tpl_tplset 'PL v6.0' AND tpl_file 'system_block_user.html'ORDER BY tpl_refid
SELECT COUNT
(*) FROM xoops_xfguestbook_msg WHERE moderate 0
SELECT COUNT
(*) FROM xoops_xfguestbook_msg WHERE moderate 1
SELECT 
FROM xoops_xfguestbook_msg WHERE moderate 0 ORDER BY msg_id DESC LIMIT 010
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_smiles
SELECT 
FROM xoops_users WHERE uid=4
SELECT rank_title 
AS titlerank_image AS image FROM xoops_ranks WHERE rank_id 6
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_users WHERE uid=1
SELECT rank_title 
AS titlerank_image AS image FROM xoops_ranks WHERE rank_id 7
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_users WHERE uid=1
SELECT rank_title 
AS titlerank_image AS image FROM xoops_ranks WHERE rank_id 7
SELECT 
FROM xoops_xfguestbook_country WHERE country_code ='' ORDER BY country_code ASC
SELECT 
FROM xoops_tplfile WHERE (tpl_tplset 'PL v6.0' AND tpl_file 'xfguestbook_index.html'ORDER BY tpl_refid
SELECT theme
titlesubtitlemetakeymetadesc FROM xoops_ctem_link WHERE mid='85'
SELECT themetitlesubtitlemetakeymetadesc FROM xoops_ctem_pagelink WHERE pid=''
Total37 queries



Thx for the help so far Mith!!
. . . : : : | | | PressureLab.com | | | : : : . . .

10
bassyard
Re: XFguestbook: problem after upgrade to 2.22
  • 2005/8/18 18:34

  • bassyard

  • Not too shy to talk

  • Posts: 157

  • Since: 2003/10/5


I really hope somebody can find what went wrong
. . . : : : | | | PressureLab.com | | | : : : . . .

Login

Username:
Password:

Lost Password? Register now!

Who's Online

57 user(s) are online (35 user(s) are browsing Support Forums)


Members: 0


Guests: 57


more...

Donat-O-Meter

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

Latest GitHub Commits