Recent Topics

1 Apr 02, 2010 01:11    

My b2evolution Version: Not Entered


I need to change some posts contents, as I explained here:

UPDATE `evo_items__item` SET `post_content` = '...'  WHERE  `evo_items__item`.`post_ID` = ...;

Now I have a caching issue. I've updated some 107 posts, but the result isn't displayed. I would need to edit and save all those 107 posts to show their containt.

Is this related to any caching issue? If yes, how may I flush this cache?

Any idea would be welcome.

2 Apr 02, 2010 01:22

That was a bad idea. Now I have a character set issue :D

Depuis de longs mois déjà ...

3 Apr 02, 2010 01:36

I think I'll enjoy some help. My SQL input from a DB export looks like this, without extra encoding:

UPDATE `evo_items__item` SET `post_ID` = 4922, `post_content` = 'L''idée de la lampe...

When I feed this into phpmyadmin, using windows-1256 set for this file, I get a correct information displayed in phpmyadmin backend. But once the b2evolution cache is flushed, I get a bad front end display, for the records I just updated:

Depuis de longs mois déjà , sur Google et...

Other records which I didn't update are correctly displayed by the front end. For example:

Ce soir, au téléphone, le...

So, here, any advice would clearly be welcome.

4 Apr 02, 2010 02:10

I used headers and footers from my utf8 export, importing it again as utf8 data. That finally worked, then I cleaned the cache:

/*!40101 SET NAMES utf8 */;
UPDATE `evo_items__item` SET `post_content` = 'Par le passé, ...

I think I have now almost jumped from 2.4.0rc2 to 3.3.3-stable.

Form is loading...

b2evo – This forum is powered by b2evolution CMS, a complete engine for your website.