Install webmagik. (solve the error at the top of the homepage. Check that the error at the top of the Management page and the module name is question mark !)

Install webmagik. (solve the error at the top of the homepage. Check that the error at the top of the Management page and the module name is question mark !)

Finally, you can use the document to import SQL scripts.
Note that:
1. We recommend that you set the webpage encoding display to UTF-8 during import. Although the displayed Chinese may be messy, the success rate is higher.
2. For the first installation, you must register a number first. Otherwise, the Administrator's number will be confused with the first registration number (is the bug true ?)
3. when the database is installed for the first time, you must post a post first, and then go to the background, website operations-verification management through that post, in this case, initialize "dy_content_id" in the database (ID is the number of changed !!), Otherwise, a warning message is displayed. It is similar to the one on the homepage with incorrect character set ,,

By clin003 at 20070623 from: http://clin003.com/or http://blog.csdn.net/clin003/

Error Description: homepage warning. The Management page is displayed as a question mark in Chinese ..
Mix of collations (latin1_swedish_ci, implicit) and (utf8_general_ci, coercible) for Operation '= 'select * From 'dy _ Riki' Where 'dy _ riki_tag '= 'homepage 'order by 'id' DESC limit 1
Warning: mysql_fetch_array (): supplied argument is not a valid MySQL result resource in/My directory/web2/lib/DB. function. php on line 74
Illegal mix of collations (latin1_swedish_ci, implicit) and (utf8_general_ci, coercible) for Operation '= 'select * From 'dy _ Riki' Where 'dy _ riki_tag '= 'homepage 'order by 'id' DESC limit 1
Warning: mysql_free_result (): supplied argument is not a valid MySQL result resource in/My directory/web2/lib/DB. function. php on line 83

The above is an error message.
I have just installed it.

Google, two-day article, check the official webmagik post:
Http://webmagik.cn/bbs/viewthread.php? Tid = 160
Http://webmagik.cn/bbs/viewthread.php? Tid = 139 & extra = Page % 3d1 (mysqladmin)
By clin003 at 20070623 from: http://clin003.com/or http://blog.csdn.net/clin003/
The reason is as follows:
WM is a character set that requires the use of UTF-8 general-ci,
Generally, the default character set is latin1_swedish_ci.

The reason is found. Let's see how it works,
In phpMyAdmin, I wanted to follow the "rockoy" practice, but even the MySQL provided by the virtual machine does not have the "database --> operation" option.
Let's stop ,,
The "Electronic Dictionary" provides SQL statements:
////
//// If the database is created manually, execute the following in the Database SQL statement:
/// Alter database 'your database name' default Character Set utf8 collate utf8_general_ci
/// Re-install WM after completion!
I don't know where to execute it ..
///
Click a table on the left. There was an "operation" on the bright side of the page, so you can sort out the "Character Set" as soon as possible ..

..
By clin003 at 20070623 from: http://clin003.com/or http://blog.csdn.net/clin003/

The next step is to change the character set of a table.
, Changed
Open the http://clin003.com/web2/ of the test page
!! There are no more or fewer errors.
Let's take a closer look at "from 'dy _ Riki 'Where 'dy _ riki_tag' = 'homepage '" or something, open the dy_riki table --> operation -- the character set is correct. It is utf8 (I have read the instructions. The default utf8 is utf8_general_ci ), next, let's take a look at "field" dy_riki_tag -- change (a small icon on the right) -- you can also select character set in it -- I will directly select utf8 -- save. The system prompts that the change is successful.
Open the test page again. Haha.
By clin003 at 20070623 from: http://clin003.com/or http://blog.csdn.net/clin003/

Make up later.

Suddenly I found that the character set for operations on the table did not work. After writing this, I will modify the character set of the fields one by one !! Pain
The execution statement does not work after it is run! (Delete the database and run this statement again)

By clin003 at 20070623 from: http://clin003.com/or http://blog.csdn.net/clin003/
 
If you change the character set in a table, most of the question marks have been removed, and the home page has no warnings,
The question mark in the same city cannot be removed now. No way can be found !!