missing entries with flat.db

Get help with installation and running PivotX 2.0.x here. Please do not post Extension or Theme related questions here.

missing entries with flat.db

Postby lassowski » Wed May 07, 2014 10:50 am

Hi!
Since today I have missing entries in my blog. I'm using pivotx 2.3.8 with flatdb on debian squeeze with apache.

Since the URL does change today I wanted to update all links inside the entries and did that with an external tool (tea over ssh) in the directory /pivotx/db/standard-00000/. Everything seemed fine, all rights were ok, but the modified entries do not show up anywhere. The files are still there, e.g. 00080.php, which is marked as 'not ok' below...
Obviously something went wrong. What can I do to get the missing entries back in my blog? I hope that you can help me to solve the problem...

Frank

ps: This is the debug output of pivotx while rebuilding the index:
Code: Select all
2014-05-07 12:45:54 - 0.477 -- modules/module_debug.php:414 / userErrorHandler() --  ( 11538544 )
Warning: Missing argument 2 for makeArchiveArray(), called in /media/WDpassport/var/www/blogs/blog_Frank/pivotx/pages.php on line 2170 and defined. (in 'pivotx/lib.php' on line 2433)
2014-05-07 12:45:57 - 0.441 -- modules/entries_flat.php:422 / generate_index() --  ( 11738168 )
Start rebuild index
2014-05-07 12:45:57 - 0.460 -- modules/entries_flat.php:1608 / index_entries() --  ( 11788160 )
(00046.php is ok: Hege og Torill: Takk en million! - 2011-08-04-18-35)
(00053.php is NOT ok: Hege og Torill: Takk en million! - 2011-08-04-18-35)
(00084.php is ok: Die Kunst des Verpackens - 2014-03-10-16-33)
(00010.php is ok: Festplatte mal wieder - 2010-01-12-17-00)
2014-05-07 12:45:57 - 0.539 -- modules/module_debug.php:414 / userErrorHandler() --  ( 11803656 )
Warning: array_intersect(): Argument #2 is not an array. (in 'modules/entries_flat.php' on line 1753)
Warning: array_values() expects parameter 1 to be array, null given. (in 'modules/entries_flat.php' on line 1753)
2014-05-07 12:45:57 - 0.542 -- modules/entries_flat.php:1608 / index_entries() --  ( 11797256 )
(00002.php is ok: Example linkdump... - 2010-03-29-23-54)
(00085.php is ok: Ab in den Knast! - 2014-03-14-11-11)
(00086.php is ok: Autarkes Weidezaungerät - 2014-03-23-19-12)
(00013.php is NOT ok: Autarkes Weidezaungerät - 2014-03-23-19-12)
(00015.php is ok: Zum Glück gibt's Linux! - 2010-03-22-16-22)
(00048.php is ok: Bemerkenswertes und Unwichtiges - 2011-10-20-10-09)
(00074.php is ok: Asteroid 2012 DA14 - 2013-02-15-10-03)
(00038.php is ok: Die Bierder Störche sind fort - 2011-05-26-15-57)
(00065.php is ok: Rollern mit Strom - 2012-05-21-20-38)
(00041.php is ok: Flaschenpost - 2011-06-26-20-50)
(00056.php is NOT ok: Flaschenpost - 2011-06-26-20-50)
(00068.php is ok: Ein Klavier, ein altes Klavier, ein schönes Klavier!!! - 2012-12-16-20-49)
(00045.php is ok: Utøya - 2011-07-23-21-20)
(00043.php is ok: Fußball WM 2011 - 2011-07-07-15-28)
(00066.php is ok: Urzeit in Bierde - 2012-08-25-12-56)
(00006.php is ok: Schnee in Bierde - 2010-01-01-16-11)
(00003.php is ok: Umzug von fritzbox auf sheeva - 2009-12-24-02-10)
(00072.php is ok: Luftfeuchte/Taupunkt berechnen - 2013-01-25-14-24)
(00064.php is ok: Tankstelle für Hautflügler... - 2012-05-14-13-24)
(00081.php is ok: Noch eine Uhr - 2014-01-21-16-31)
(00055.php is ok: Eisvögel und Wasserverband - 2012-01-18-13-28)
(00004.php is ok: Buntum-Atelier macht Fortschritte - 2009-12-24-02-43)
(00078.php is ok: Feigheit vor dem Freund - 2013-07-03-07-26)
(00007.php is ok: Schlittenknappheit!! - 2010-01-02-17-49)
(00067.php is ok: iriver H320 mit CF-Karte - 2012-11-22-15-50)
(00069.php is ok: 2013! - 2013-01-01-13-04)
(00054.php is ok: SOPA/PIPA - 2012-01-15-17-13)
(00077.php is NOT ok: SOPA/PIPA - 2012-01-15-17-13)
(00016.php is ok: Photovoltaik - 2010-03-29-14-35)
(00031.php is ok: Eine 2. Storchencam in Bierde - 2011-03-05-18-35)
(00032.php is ok: Ein kleines Experiment - 2011-03-10-18-27)
(00083.php is ok: And the Oscar goes to... - 2014-03-04-11-08)
(00020.php is ok: Angst vor Dunkelheit? - 2010-06-28-10-00)
(00059.php is ok: Rücktritt! - 2012-02-17-17-05)
(00033.php is ok: Fukushima Daiichi, Westerwelle und Wahlen - 2011-03-14-11-43)
(00039.php is ok: Meinungs-Manipulation? - 2011-06-08-11-18)
(00075.php is ok: Die Qual der Wahl - 2013-03-02-17-50)
(00029.php is NOT ok: Die Qual der Wahl - 2013-03-02-17-50)
(00051.php is ok: Winterdecke - 2011-11-12-16-35)
(00042.php is NOT ok: Winterdecke - 2011-11-12-16-35)
(00022.php is NOT ok: Winterdecke - 2011-11-12-16-35)
(00076.php is ok: Endlich wieder Wölfe - 2013-03-05-09-13)
(00008.php is ok: Sheeva wird angegriffen! - 2010-01-05-00-28)
(00044.php is ok: Fußball WM 2011 die 2. - 2011-07-10-19-55)
(00030.php is NOT ok: Fußball WM 2011 die 2. - 2011-07-10-19-55)
(00017.php is NOT ok: Fußball WM 2011 die 2. - 2011-07-10-19-55)
(00087.php is ok: Neue Adresse! - 2014-05-01-15-51)
(00035.php is ok: Sheeva ohne Strom! - 2011-05-14-18-28)
(00071.php is ok: Ein Wort zu... - 2013-01-13-14-45)
(00005.php is ok: ftp://sheeva - 2009-12-26-22-56)
(00070.php is ok: Herrlich unkorrekt! - 2013-01-10-12-53)
(00037.php is ok: Kleiner Teich mit vielen Bewohnern - 2011-05-19-11-47)
(00025.php is ok: Töpferofen vom Weihnachtsmann - 2010-12-27-18-49)
(00028.php is ok: Darf ich vorstellen: - 2011-01-27-21-16)
(00049.php is ok: 1. Brand - 2011-10-17-11-09)
(00040.php is ok: Trecker endlich zugelassen - 2011-06-24-18-34)
(00079.php is ok: DVB-T mit Hindernissen - 2014-01-06-00-18)
(00012.php is ok: Externe Festplatte - 2010-01-24-21-11)
(00021.php is ok: Kieler Woche - 2010-06-28-10-15)
(00047.php is ok: Eine Reise wert: Zoo Osnabrück - 2011-08-28-20-30)
(00036.php is ok: Trockenheit und Schwalben - 2011-05-16-16-05)
(00011.php is NOT ok: Trockenheit und Schwalben - 2011-05-16-16-05)
(00026.php is NOT ok: Trockenheit und Schwalben - 2011-05-16-16-05)
(00052.php is ok: Einladung an Cornelia Funke wegen 'Reckless' - 2011-11-26-22-16)
(00024.php is ok: Wir sind das Volk! - 2010-09-24-11-12)
(00023.php is ok: Urlaub ohne Kinder - 2010-08-03-08-39)
(00060.php is ok: Gemachte Betten - 2012-02-26-14-43)
(00062.php is ok: Was gesagt wurde - 2012-04-04-21-52)
(00057.php is NOT ok: Was gesagt wurde - 2012-04-04-21-52)
(00019.php is ok: Hausbesetzung! - 2010-05-18-10-19)
(00050.php is ok: Formel 1 Landwirt - 2011-11-04-17-37)
(00058.php is NOT ok: Formel 1 Landwirt - 2011-11-04-17-37)
(00061.php is NOT ok: Formel 1 Landwirt - 2011-11-04-17-37)
(00027.php is ok: Sauberes Geschirr - auf Knopfdruck - 2011-01-20-00-52)
(00014.php is ok: Hardware kaputt - 2010-03-22-15-52)
(00009.php is ok: Ich möchte hoop! - 2010-01-07-22-23)
(00063.php is NOT ok: Ich möchte hoop! - 2010-01-07-22-23)
(00034.php is ok: Fukushima Daiichi und kein Ende - 2011-03-25-15-38)
(00018.php is ok: Datenkraken und Softwaremonster - 2010-04-08-20-52)
(00073.php is ok: I love free software - 2013-02-14-11-29)
(00080.php is NOT ok: I love free software - 2013-02-14-11-29)
2014-05-07 12:45:58 - 2.149 -- modules/module_debug.php:414 / userErrorHandler() --  ( 12031616 )
Warning: array_intersect(): Argument #2 is not an array. (in 'modules/entries_flat.php' on line 1753)
Warning: array_values() expects parameter 1 to be array, null given. (in 'modules/entries_flat.php' on line 1753)
2014-05-07 12:45:58 - 2.152 -- modules/entries_flat.php:1608 / index_entries() --  ( 12025256 )
(00001.php is ok: Welcome to PivotX - 2.0.2 - 2010-03-29-23-45)
2014-05-07 12:45:59 - 2.161 -- modules/entries_flat.php:1446 / write_entry_index() --  ( 12025248 )
Save entry index (70,index-standard-00000.php)
2014-05-07 12:45:59 - 2.162 -- modules/entries_flat.php:436 / generate_index() --  ( 12008944 )
Finish rebuild index
2014-05-07 12:45:59 - 2.164 -- modules/entries_flat.php:1459 / write_date_index() --  ( 12009120 )
Save date index (70,70)
lassowski
 
Posts: 28
Joined: Thu Mar 04, 2010 12:09 pm

Re: missing entries with flat.db

Postby hansfn » Wed May 07, 2014 12:16 pm

OK, so you have edited the database files manually with a text-editor? You are aware that these files are serialized PHP arrays, and you need to be very careful to not beak them by creating invalid syntax? (Most importantly your editor should not insert line breaks.)

Since the URL does change today I wanted to update all links inside the entries


By this you mean links in the text of the entry - in the introduction and/or body? You don't mean the link of the entry (which would be easier to fix).
hansfn
Developer
 
Posts: 3282
Joined: Sun Nov 25, 2007 7:48 pm
Location: Molde, Norway

Re: missing entries with flat.db

Postby lassowski » Wed May 07, 2014 1:02 pm

Hi!
hansfn wrote:OK, so you have edited the database files manually with a text-editor?
Yes.
You are aware that these files are serialized PHP arrays, and you need to be very careful to not beak them by creating invalid syntax? (Most importantly your editor should not insert line breaks.)
I fear that happened... I won't do that again, I promise :-)
lasser wrote:Since the URL does change today I wanted to update all links inside the entries

By this you mean links in the text of the entry - in the introduction and/or body?You don't mean the link of the entry (which would be easier to fix).
Both. First I registered a domain, and the log now has a different URL. That was easy to fix. But secondly the links in the entries text (to another entry in the same blog) should also change, because they will not be valid anymore from tonight on. I did not know the tag [[link]] until today, so I have used the full URL to my entries. That's history from now on, [[link]] is much more elegant :-)

Luckily there was a backup of the db, which I forgot. After copying back the broken files they appeared again. This time I will use pivotx's editor and the [[link]] tag.

Thanks for your time and patience. Have a nice time!

Frank
lassowski
 
Posts: 28
Joined: Thu Mar 04, 2010 12:09 pm


Return to 2.x Support Forum

Who is online

Users browsing this forum: No registered users and 4 guests

cron