Converting from CP1251 to UTF8

[alv2937]

There was a problem after database converting from CP1251 to UTF8. While cache of categories updating an error occurs:

Content visible to verified customers only.

Please, somebody knows how to fix it?

[Luciano]

I also encoutered that error, and fixed it on my install...
(strange enough it came long time after i moved to UTF-8)
somehow the gallery options are not passed on.. dont ask me why...

as a quickfix:
open forum/includes/functions_gallery.php
find this:

Content visible to verified customers only.

Just Above (!) add

Content visible to verified customers only.

That should get you running again..

Luc

PS: In my case it came from the fact that i was calling the function from outside gallery...(in a hack) so its normal but in your case the ppg_options should be there...
Are you sure everything went right while updating your database to utf-8? are all text fields utf-8_general_ci? Also I experienced some problem when using mysql vs. mysqli in php
Also I had some post problem when I had saved a php file in UTF-8... (that made the zip compression stall) - so the php files had to stay ansi..

[alv2937]

All tables of a database are utf-8_general_ci

There was no problems at conversion procedure. Our forum is international, and we should upgrade to utf-8_general_ci in any case, so we prepared for it.

The fix that you gave me has helped me for this function, but the same problem appears when calling in a photo gallery.

Whether is it possible, that you have looked at this error?

I'll inform a login and password to you.

[Luciano]

question: how did you prepare?
i can take a look if you want.. anytime..
Luc

[Luciano]

you can now remove the fix...
if anybody is interested what the problem was.. the settings could not be fetched from datastore because of db changes...
saving the settings twice.. forced the datastore to be regenerated ...
seems to work now

Luc