Free blogging

Error:
svn: Can't convert string from 'UTF-8' to native encoding

Resolve:
$ export LC_CTYPE=en_US.UTF-8
$ locale
LANG=
LC_COLLATE="C"
LC_CTYPE="en_US.UTF-8"
LC_MESSAGES="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_ALL="C/en_US.UTF-8/C/C/C/C"

PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 31 bytes)

Edit file /etc/php.ini and increase memory limit:
memory_limit = 32M

Add to /etc/my.cnf
[mysqld]
max_allowed_packet = 100M

svn authentication is stored in the ../.subversion directory. Check that it exists and your user has access to store information in it.

put into .htaccess:
AddHandler application/x-httpd-php .php
or
AddHandler application/x-httpd-php5 .php

put into .bashrc
export SVN_EDITOR=vim

1. Delete the `log` file in the .svn directory
2. Delete .svn/props-base
3. svn cleanup

//copy data of the vocabulary by id=1 into vocabulary id=3
insert into term_data (vid, name, description) select 3, name, description
FROM `term_data` WHERE vid=1;
//update tid data of the new terms.
insert into term_hierarchy (tid) select tid FROM `term_data` WHERE vid=3;

NOTE: don't forget to fix sequences for term_data_tid

If you get such error:
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT qid FROM
top_searches WHERE q = 'орп' in .\includes\database.mysql.inc on line 172.
Change all collation for the db, each table, each row of the table from latin1_swedish_ci collation to utf8_general_ci

In case if you don't have permissions to run use charset utf8

1. Open database dump sql file and add such lines on top of it.

SET NAMES utf8;
SET CHARACTER_SET utf8;

Goto mysql command tool, run it and log in.
type use database name_of_db Enter.
type \. path_to_the_dump_file Enter.