Presslabs

Hello Jason,

For the blank page issue or any other issue, try using the latest code version that you can find here https://github.com/PressLabs/gitium/archive/master.zip

For the bitbucket issue try using the html repo URL and insert the user and password as the URI standard is defined here https://en.wikipedia.org/wiki/Uniform_Resource_Identifier#Syntax

Something like this: https://youbitbucjetusername:[email protected]/youbitbucjetusername/youbitbucjereponame.git

Thanks

Hi! Can you please tell me if this worked ? Is your issue fixed?

This is because you have in same time activated the plugin Utf8ize and the function utf8ize_generator is already defined into the plugin. Use another name for the function in debug bar console or deactivate the plugin when you use the debug bar console.

• This reply was modified 8 years, 3 months ago by Presslabs. Reason: add an alternative

Hello!
Can you please tell me how/ if it now works with the latest W3 Total Cache version ? If you are having the same issue, can you please give us more details about this, besides the fact that you are using W3 Total Cache?

I don’t know for sure but do not forget to do a backup before you run the SQL commands.

This plugin can help you compose those SQL commands you need to convert your tables to use utf8 characters, if this brings your chinese chars back than go for it.

• This reply was modified 8 years, 4 months ago by Presslabs. Reason: updating

Then you can try another method to debug like this:
– install two plugins: Debug Bar & Debug Bar Console;
– copy-paste the function utf8ize_generator into the console of the Debug Bar Console plugin;
– use return ‘message:’.time(); in order to find out where the function breaks like inserting “return ‘message:’.time();” starting with the line https://github.com/PressLabs/utf8ize/blob/master/utf8ize.php#L20 and echo the returned message of the function like in the attached printscreen. https://i.imgsafe.org/257665ae38.png https://i.imgsafe.org/2576726cc4.png

I’ve tried to replicate the issue and the error I’ve got is:

conq: repository access denied. access via a deployment key is read-only.
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.

Can you try the most recent version of Gitium from here https://github.com/PressLabs/gitium/archive/master.zip and tell me what error you encounter?

Then you can try yo find out what is wrong by using the die, print_r, serialize, var_dump functions starting with line https://github.com/PressLabs/utf8ize/blob/master/utf8ize.php#L25 Just use something like this die( print_r( $your_debug_var, true ) ); where your_debug_var is $db_collate and so on, for every line of the function.

Hi and thank you for your interest!

Sorry for the delayed answer. Did you check your Analytics account to see if the correct property is listed? Please see: https://lh3.ggpht.com/6fie7uOT1P4_qqCIjaOThH7vYX5Xn-hl8ffzUJ0TKbUvP7bxPt4TALQwWRkfSQ7E1Xo46Bocnw=w895

There is an issue with this https://github.com/PressLabs/utf8ize/issues/3

Thanks

This is because the functions utf8ize_generator has some error and not execute well. https://github.com/PressLabs/utf8ize/blob/master/utf8ize.php#L145

Can you check the error log file in order to figure out what is the error?

• This reply was modified 8 years, 6 months ago by Presslabs.

Hi Denis,

1. First thing first: do a DB backup!

After you go to Tools > UTF8ize you should read the first notice:

If you run the following SQL statements, you will convert all your database character sets to utf8, trying to follow Codex guides https://codex.www.ads-software.com/Converting_Database_Character_Sets

2. You can build one big SQL file that will convert your site, by copy-paste the SQL commands from Tools -> UTF8ize to a file named let’s say myutf8ize.sql

3. Run your SQL file against your database using a tool like phpMyAdmin or via the MySQL/MariaDB command line if you are hardcore like that, see https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
$ mysql
mysql> use ‘database_name’;
mysql> soruce myutf8ize.sql

Just let me know if you need more help about this. Cheers!

As the notice says, the ssh-git file has not the execution permission. Note that this is not an issue but a requirement.

I would like to bump this issue, as it can really be a pain for relatively large sites.

$meta_query = array(
    'relation' => 'OR',
    array(
        'key' => PageFrog_PostStatus::FBIA_STATUS_KEY,
        'value' => 1,
    ),
    array(
        'key' => PageFrog_PostStatus::FBIA_STATUS_KEY,
        'compare' => 'NOT EXISTS',
        'value' => '' // to fix a wp bug: https://core.trac.www.ads-software.com/ticket/23268
    ),
    array(
        'key' => PageFrog_PostStatus::FBIA_STATUS_KEY,
        'value' => '',
    )
);
$args = array(
    'meta_query' => $meta_query,
    'post_status' => 'publish'
);
$query = new WP_Query( $args );

These queries happen way too often and they should be rethought. This specific section of the plugin can really put a huge load on the database and render a site useless in times of high traffic.

Here comes an updated version of the setup procedure: https://www.presslabs.com/help/toplytics/usage. Please let us know if you managed to install it. Cheers!