[TYPO3-ttnews] restore tt_news items after update

["HocomAdvies [  Wiechert Hooghwinkel]

Hi,

It seems that I managed to solve this one :) What i did. First made a backup from phpMyadmin from te (old) tt_news tabel. Reviewing that showed that it had 'zzz_delete_ in front of all lines. So, with a search and replace action I took these zzz_delete_ parts out. Now in the new system I first ran an database Compare in the BE INSTALL TOOL and cleaned it up. Than I went into phpMyadmin at the new system and emptied the tt_news tabel completely. Next I imported into the empty table the adapted old tt_news.sql file. 
That worked. the old news articles are back in business :)

Only thing which is not clear, what about the other tt_news tabels? The one with tt_news cache is still the same as before. Is that a problem? Any thoughts about that? Thanks

Regards,
HocomAdvies

Wiechert
 


Op 26 nov. 2013, om 20:05 heeft HocomAdvies [ 🌷 Wiechert Hooghwinkel ] <info at hocom-advies.nl> het volgende geschreven:

> Hi, 
> 
> Any help on this? I did have a look in the backup.sql file. But I can't figure out what part(s) I need to copy for inserting the old article into the new database so they will be available there. The strange thin is that all the categories are still available in the new/ updated site. So why not the old articles? 
> 
> What's the way to solve this? 
> 
> Wiechert
> 
> Op 26 nov. 2013, om 09:13 heeft HocomAdvies [ 🌷 Wiechert Hooghwinkel ] <info at hocom-advies.nl> het volgende geschreven:
> 
>> Hi,
>> 
>> Due to a server update I had to update a typo3 system from 4.5. tot 4.7.15. That produced some errors. To get it going I had tot remove amongst others tt_news extension form the BE. On a duplicate site I tried to update tt_news latest version from the extension manager, hoping to keep the many news items! Now it appears there are no news items left in the news_storage_folder. 
>> So how to proceed to get the news Items back or if that's possible import them again form the backup.sql file I have form the old, updated site without the new tt_news extension installed?  
>> 
>> Would be great if I manage to keep or get the news items back again. Thanks. Looking forward to your advises on this. 
>> 
>> Best regards,
>> HocomAdvies
>> 
>> Wiechert Hooghwinkel
>> 
>> 
>> _______________________________________________
>> TYPO3-project-tt-news mailing list
>> TYPO3-project-tt-news at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-tt-news
> 
> _______________________________________________
> TYPO3-project-tt-news mailing list
> TYPO3-project-tt-news at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-tt-news