Comments on articles missing [Module troubleshooting]

Comments on articles missing

2005/1/23 15:14
tvesala
Just popping in
Posts: 35
Since: 2003/8/25

I've been moving some tables from one XOOPS site to another one. Everything has worked perfectly except for the comments on news (1.21) articles. When looking in the Admin-System-Comments window, I can see all the comments but no module is selected in the Module column in that list.

Anyone that knows how to resolve this problem?

/Roger

Re: Comments on articles missing

2005/1/24 20:51
tvesala
Just popping in
Posts: 35
Since: 2003/8/25

Quote:

UPDATE `prefix_xoopscomments` SET `com_modid` = '8' WHERE `com_modid` = '2' ;

The problem was the table relation for the module id was altered from 2 to 8. Therefore I ran the SQL command to change all occurencies in the field prefix_xoopscomments.modid to module id in the new database.

Cheers!!!

Re: Comments on articles missing

2005/1/24 21:45
brash
Friend of XOOPS
Posts: 2206
Since: 2003/4/10

Glad we could help tvesala

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Comments on articles missing

Re: Comments on articles missing

Re: Comments on articles missing

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}