XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / how to import xOops comments
Register
1
limecity
how to import xOops comments

  • 2004/8/13 13:54

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


i tried to import some XOOPS comments..
using a sql dump..

but each time i import it..
the page went plain white..

on debug.. it gave me this

Fatal error: Call to a member function on a non-object in /home/catscity/public_html/modules/system/blocks/system_blocks.php on line 339

i am attempting to restore my site data by data..
when it comes to XOOPS comments..
there will be a problem...

so how do i settle this?
2
limecity
Re: how to import xOops comments

  • 2004/8/14 2:53

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


<bump>
i still can't solve this problem
3
mikeh
Re: how to import xOops comments

  • 2004/8/14 3:32

  • mikeh

  • Just popping in

  • Posts: 70

  • Since: 2002/1/18


below may help,

after doing a fresh install of XOOPS and then modules
when trying to import a complete sites data
there are a few issues

one was can remember having to go thru tables and manually edit them so that the comments matched the relevant modules
as the modules id changed in the re-install

4
limecity
Re: how to import xOops comments

  • 2004/8/14 3:41

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


oh.. that sounds reasonable..
Okay.. i checked out the tables..
and which one represent the module id ?
and also how do know the module's id ?
is there anyway to find out?


com_id
com_pid
com_rootid
com_modid
com_itemid
com_icon
com_created
com_modified
com_uid
com_ip
com_title
com_text
com_sig
com_status
com_exparams
dohtml
dosmiley
doxcode
doimage
dobr
5
mikeh
Re: how to import xOops comments

  • 2004/8/14 4:04

  • mikeh

  • Just popping in

  • Posts: 70

  • Since: 2002/1/18



working off memory here

think com_modid is the one concerned with

what you need to do is find out and then match
current and old id modules

look in xoops_modules table
match mid with module name

goto XOOPS comments look up that comment id and see what com_modid is pointing to , if different you should have to change all them to the new one

suggest you do one and then goto that "module item" and see if works


apoligies, its all off the top of my head and suggest "care" as may not be 100% :::)))

6
djsckizo
Re: how to import xOops comments

  • 2004/8/14 7:18

  • djsckizo

  • Just can't stay away

  • Posts: 401

  • Since: 2003/5/9 8


Wait. If all you are doing is just connecting the data to the site again (ie. dumping in ALL original data), then you module id's will be the same as they were before. In other words:

If you are dumping in the data that has the module id's from that same sql file that had these same comments, then the id's should be the same. You shouldn't have to modify them unless you activated the modules through the admin system panel, and then started dumping in the comments data.
7
limecity
Re: how to import xOops comments

  • 2004/8/14 8:31

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


okay...i think i am begining to understand the problem already..

thanks guys..

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

177 user(s) are online (120 user(s) are browsing Support Forums)

Members: 0

Guests: 177

more...

Donat-O-Meter

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

Latest GitHub Commits