My.diary.in.th

Language / Charset Problems – Things To Check

Some people encounter problems with garbled characters when using vBulletin with non-English languages. Here are some things you can check based on my experience troubleshooting these problems:
Make sure your HTML charset is appropriate to your forum language:

Read more:  Click here

Popularity: 1% [?]

If you are trying to use CURLOPT_FOLLOWLOCATION and you get this warning:
Warning: curl_setopt() [function.curl-setopt]: CURLOPT_FOLLOWLOCATION cannot be activated when in safe_mode or an open_basedir is set…

then you will want to read http://www.php.net/ChangeLog-4.php which says “Disabled CURLOPT_FOLLOWLOCATION in curl when open_basedir or safe_mode are enabled.” as of PHP 4.4.4/5.1.5.  This is due to the fact that curl is not part of PHP and doesn’t know the values of open_basedir or safe_mode, so you could comprimise your webserver operating in safe_mode by redirecting (using header(‘Location: …’)) to “file://” urls, which curl would have gladly retrieved.

อ่านต่อที่นี่ได้ครับ: http://www.php.net/manual/ro/function.curl-setopt.php#71313

Popularity: 1% [?]

ผม upgrade vBulltein จากเวอร์ชัน 3.5.X เป็น เวอร์ชัน 4.01  แล้วพบว่าเกิดข้อความ error ดังข้างล่าง

PHP Fatal error:  Call to a member function hide_errors() on a non-object in /home/www/vhosts/xxxx.com/httpdocs/forums/includes/class_bootstrap.php(283) : eval()'d code on line 4

ปัญหาเกิดจากตัว plugin ที่ใช้ในเวอร์ชัน 3.5.X วิธีการแก้ปัญหาคือ ให้แก้ไขไฟล์ config.php โดยใช้คำสั่ง

define('DISABLE_HOOKS', true);

เพื่อยกเลิกการใช้งานทั้งหมดก่อน

Popularity: 1% [?]

วิธีการเปลี่ยน password ให้ทำตามนี้

4.4 Losing Your Root Password
If for some reason you lose your root password you can change it by following these steps:

1) Reboot your machine.

2) From GNOME, log out, and choose the reboot option. Or from the login screen, click ‘System’ then ‘Reboot’. From console mode, press Ctrl-Atl-Del (which in Linux reboots the system in a controlled fashion). You will see the shutdown sequence begin.

3) Allow the system to reboot to the GRUB splash screen, and then press “e”. Select the line containing “kernel”, and press “e” again. GRUB will display the line in edit mode.

4) Add “single” to the end of the line, and press return. GRUB will return you to the previous screen.

5) Press “b” to boot the system into what will now be single user mode. The system will come part of the way up, and then drop you into a root shell – the prompt will look like this: sh-2.05# _

6) Type “passwd” and press return. The system will ask you for a new password. Type in your new password, then to retype it as confirmation (it will not display on the screen). If the two entries do not match, it will ask you to try again. It will also warn you if it thinks the password is too obvious; you can ignore the warning, but if you are on a computer that either isn’t behind a firewall or is in a public area, this is not recommended.

7) Once the new password is in place, type “exit” and press return to allow the system to finish booting. Passwords should be something you can remember without writing down, but not something anyone else could figure out. Dictionary words and passwords that are all numbers are not recommended. Subtle misspellings, funny capitalizations (Linux is case sensitive), and substituting numbers or special characters for letters make good passwords. For instance, the first letters of the words in a phrase can work, too. Some good examples are:

BaceBawl
fOOdfiGHt
p@ssw3rd

With the new MD5 password security, passwords are no longer limited to eight characters as in older versions of UNIX. The limit is on your own memory, typing accuracy, and patience.
Important: Please remember to change the default root password as soon as you become acqainted with your system.

ที่มา: #151525

Popularity: 1% [?]

ตัวอย่าง Query การจัดลำดับของข้อมูล

SET @rank=0;
SELECT @rank:=@rank+1 AS rank, id, name, subject  FROM mca ORDER BY id DESC;

ที่มา: http://www.roseindia.net/sql/mysql-example/mysql-rank.shtml

Popularity: 1% [?]