Author Topic: added files doesn't show up anymore  (Read 4196 times)

Offline bubu48

  • User
  • *
  • Posts: 4
    • View Profile
added files doesn't show up anymore
« on: June 04, 2013, 12:06:54 AM »
Hi,

I've added a couple of files to different content in my knowledgebase.

Now these files doesn't show up anymore except at one page in on content.
If I add new files everything works properly at this content.

The table "files" field "belongs_to" points at the right content.
I can see any differences between the records.

Does anybody has any clue where to look..

Environment:
PHP Version: 5.3.3-7+squeeze15
OS: Linux
Server Software: Apache/2.2.16 (Debian)
MySQL version 5.1.66

Thanks for help
Boris

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 688
    • View Profile
    • http://www.lordlamer.de
Re: added files doesn't show up anymore
« Reply #1 on: June 04, 2013, 04:31:18 PM »
Hi,

which knowledgeroot version are you using?
Does the entries in table files have a deleted flag with 1 or 0 ?
The content itself can be seen in knowledgeroot?
Could you make a dump for me?

regards,
Frank

Offline bubu48

  • User
  • *
  • Posts: 4
    • View Profile
Re: added files doesn't show up anymore
« Reply #2 on: June 04, 2013, 05:00:59 PM »
Hi Frank,

thank's for your fast support.

Knowledge root version was 1.02, now 1.03
The content is always visible.

That was the right hint => all values in table "files" "deleted" where set to 0
A SET deleted = 0 solved the problem
Sorry that I didn't see that yesterday.

DonĀ“t ask me why this has happened . I'm sure nobody marked all attached file in every content as deleted.
I'll will keep an eye on it

regards


Offline bubu48

  • User
  • *
  • Posts: 4
    • View Profile
Re: added files doesn't show up anymore
« Reply #3 on: October 02, 2013, 04:12:28 PM »
Hi again,

FYI - this happens again after using wget to export Knowledgeroot into a static html for offline usage

It doesn't work properly because the page content shows only a xml error message.

The funny thing is this time a couple of rows in the table TREE are marked as deleted now.

So this problem is homegrown however wget could manipulate the database!

OT - any idea how to use KR content offline?


best regards

Boris

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 688
    • View Profile
    • http://www.lordlamer.de
Re: added files doesn't show up anymore
« Reply #4 on: October 02, 2013, 04:39:54 PM »
Hi,

i think the problem is the delete link. wget is following the delete link and will delete a file or content or page.
I will check that and try to find a solution.
WGET cannot manipulate the database ;)

Frank

Offline bubu48

  • User
  • *
  • Posts: 4
    • View Profile
Re: added files doesn't show up anymore
« Reply #5 on: October 02, 2013, 06:46:55 PM »
Hi Frank,

makes sense - wget just pushed the button.
Now I know so don't waste your time!

New tool to mess up the database :))  => And even more so I started to check httrack and WebTTrack which creates much better result than wget.

Is it possible for the KR roadmap to get a export-to-html - button to export single tree to static html?

many thanks

Boris
« Last Edit: October 05, 2013, 05:17:10 PM by bubu48 »

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 688
    • View Profile
    • http://www.lordlamer.de
Re: added files doesn't show up anymore
« Reply #6 on: October 03, 2013, 10:01:43 PM »
Hi,

i think i will change that for knowledgeroot 1 and knowledgeroot 2.

I could add a export to the roadmap. At the moment i am developing knowledgeroot 2 base system.

Frank

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 688
    • View Profile
    • http://www.lordlamer.de
Re: added files doesn't show up anymore
« Reply #7 on: October 07, 2013, 10:07:07 PM »
Hi,

i have made a small change to the branch of version 1.0.
See this: https://sourceforge.net/p/knowledgeroot/code/1343/
You could test this change.

The link for knowledgeroot2 is also changed :D

Hope this helps.

regards,
Frank