Restoring old gallery in Bulgarian Cyrillic

[usmivkata]

I did that and no more question marks, but I get something like this appearing in the CPG- години 17 класации.

I now noticed that when I am not logged in I am not able to view the full size of the images even though this is allowed through the configuration. I get a  database query error.

Probably is best to give you access to a test account where I am working on this, or do you prefer a copy of the DB, there is more then just one table broken, but mainly the comments are the problem, as the rest of the data is not that much and can be manually modified.

-----------------------------------------------------------------------------------------

If by the 'front end' you mean CPG - one additional change to try...
You changed the tables to UTF-8... but sometimes we have seen that MySQL doesn't correctly open the connection (varies by host, MySQL defaults, and maybe other reasons...)

In include/config.inc.php add the following line (location doesn't matter)

Code Select Expand

$CONFIG['dbcharset'] ='utf8';
This will force CPG to explicitly tell MySQL the data is encoded as should be treated as UTF8 when the connection is opened...

If that doesn't work - I would like a copy (backup) of your categories table from BEFORE any changes were made to do some testing in my sandbox...  (unless Αndré has another approach since he was already working this...)

[usmivkata]

That's the error that I get now, not sure when it appeared. Will have to recreate the whole process again to figure it out.

http://is.gd/bAFsCt

[usmivkata]

Quite despaired now, things are going rather worse.

I reloaded everything many times now, however this error appears right away, from the start. Any idea how to fix it?

On top of all previous problems mainly with the Cyrillic when I click to open a picture now I get:

Critical error
There was an error while processing a database query

[Αndré]

Please enable debug mode to get an extended error message.

[usmivkata]

This helped, the cpg_hit_stats table was missing, its all there now. Will try to update and convert again and see if it goes better.

Do you recommend converting first and than updating or the other way around?

[Αndré]

I assume converting before updating is better, but I never had to deal with that issue, so I may be wrong.

[usmivkata]

I must say huge thanks to all who helped. All your advices were spot on. The additional troubles came from the missing cpg_hit_stats table. Once there, it was all working fine. Shall have thought earlier about this