phpcms 2008 sp4 安装时候 到最后一步，出错1064 后来在 install/main里面的.sql文件中
将type= 改为engine= 解决了1064错误。
但是之后报 1067 错误 报的都是中文字符，中文字符改掉就会跳到下一个中文。哪位大侠遇到过，指教下

MySQL Query : CREATE TABLE `phpcms_c_down` ( `contentid` mediumint(8) unsigned NOT NULL, `template` varchar(30) NOT NULL, `content` mediumtext NOT NULL, `version` varchar(20) NOT NULL default '''', `classtype` varchar(20) NOT NULL default ''国产软件'', `language` varchar(20) NOT NULL default ''简体中文'', `copytype` varchar(15) NOT NULL default ''免费版'', `systems` varchar(100) NOT NULL default ''Win2000/WinXP/Win2003'', `stars` varchar(20) NOT NULL default ''★★★☆☆'', `filesize` varchar(20) NOT NULL default ''未知'', `downurl` varchar(255) NOT NULL default '''', `downurls` text NOT NULL, `groupids_view` tinyint(1) unsigned NOT NULL default ''0'', `readpoint` smallint(5) unsigned NOT NULL default ''0'', PRIMARY KEY (`contentid`)) ENGINE=MyISAM
MySQL Error : Valeur par défaut invalide pour ''classtype''
MySQL Errno : 1067
Message : MySQL Query Error

回复内容：

phpcms 2008 sp4 安装时候 到最后一步，出错1064 后来在 install/main里面的.sql文件中
将type= 改为engine= 解决了1064错误。
但是之后报 1067 错误 报的都是中文字符，中文字符改掉就会跳到下一个中文。哪位大侠遇到过，指教下

MySQL Query : CREATE TABLE `phpcms_c_down` ( `contentid` mediumint(8) unsigned NOT NULL, `template` varchar(30) NOT NULL, `content` mediumtext NOT NULL, `version` varchar(20) NOT NULL default '''', `classtype` varchar(20) NOT NULL default ''国产软件'', `language` varchar(20) NOT NULL default ''简体中文'', `copytype` varchar(15) NOT NULL default ''免费版'', `systems` varchar(100) NOT NULL default ''Win2000/WinXP/Win2003'', `stars` varchar(20) NOT NULL default ''★★★☆☆'', `filesize` varchar(20) NOT NULL default ''未知'', `downurl` varchar(255) NOT NULL default '''', `downurls` text NOT NULL, `groupids_view` tinyint(1) unsigned NOT NULL default ''0'', `readpoint` smallint(5) unsigned NOT NULL default ''0'', PRIMARY KEY (`contentid`)) ENGINE=MyISAM
MySQL Error : Valeur par défaut invalide pour ''classtype''
MySQL Errno : 1067
Message : MySQL Query Error

Application Access Violation or Hang After Applying SP4（从微软站点找来的，E文，看看对你的情况是...

access|application|微软|站点

Application Access Violation or Hang After Applying SP4
This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about obtaining support for a Beta release, please see the documentation included with the Beta product files, or check the Web location from which you downloaded the release.
--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft Windows NT Server version 4.0
Microsoft Windows NT Workstation version 4.0
Microsoft Windows NT Server, Enterprise Edition version 4.0
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Professional
Microsoft Windows 2000 Server

--------------------------------------------------------------------------------
IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.


SYMPTOMS
After applying Windows NT 4.0 Service Pack 4 (SP4) or Windows 2000, you encounter lockups or access violation (Dr. Watson) errors in an application that appeared to be working fine previously.

NOTE: You might encounter other symptoms or errors in an application that relate to the below-mentioned cause.



CAUSE
The application in question is errantly trying to access a block of memory that it had previously freed or deallocated. With Windows NT 4.0 Service Pack 3 (SP3) and earlier, such a reallocation is more likely to succeed, since the same memory location is more likely to still be available for reallocation. SP4 and later, however, introduces a change in the heap manager allocation patterns that can result in a failure of such a reallocation request. For more information on this change, please see the following article in the Microsoft Knowledge Base:

Q195008 Heap Manager Change in Service Pack 4



RESOLUTION
WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT or Windows 2000, you should also update your Emergency Repair Disk (ERD).

To determine if the above-mentioned change is exposing a problem in the application in question, proceed with the following steps. If these steps result in the application generating fewer or no more such errors, contact the vendor of the application to inquire about an updated version of the application that resolves this problem.

NOTE: There are other conditions that can cause such errors or hangs that are not related to this change introduced in SP4 and Windows 2000. If the following workaround does not correct the problem, query on the error or condition you are encountering and the application name in the Microsoft Knowledge Base and/or check with your application vendor for more information on any other known problems.


Start Registry Editor (regedt32.exe) and navigate to the following registry path:


HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Image File Execution Options
With the Image File Execution Options key selected, click Add Key from the Edit menu to create a new key using the name of the executable file that starts the process that is encountering the above-noted problem. An example Key Name entry is "Application.exe". You can leave the Class field blank. This Key Name entry should not include a path, only the name of the executable file itself. Refer to the already-existing Game.exe entry in this location of the registry as an example.


Select the new key you created in step 2 above and click Add Value from the Edit menu to create the Value Name: DisableHeapLookaside and Data Type: REG_SZ. Click OK and then enter 1 in the String field.

Summary for the above entries:


Key Name: application.exe
Class:

Value Name: DisableHeapLookaside
Data Type: REG_SZ
String: 1
It is not usually necessary to restart the system to see the results. You can usually simply restart the application because this registry value is inspected during each process initialization. If the executable is a service, however, restarting the computer may be necessary to cause the executable to be properly restarted.


NOTE: This registry setting only affects the process or processes that you specify.


Additional query words: 4.00 AV stack hang error bug compatguidestability Heap LookAside HeapLookAside Disable Look Aside

Keywords :
Issue type : kbprb
Technology : kbWinNTsearch kbWinNTWsearch kbWinNTW400 kbWinNTW400search kbWinNT400search kbwin2kAdvSer kbwin2kAdvSerSearch kbwin2kDataSer kbwin2kDataSerSearch kbwin2kS kbWinNTSsearch kbWinNTSEntSearch kbWinNTS400search kbWinNTS400 kbwin2kSSearch kbwin2kSearch kbwin2kProSearch kbwin2kPro

Backup SQL Server 2008 R2 Restore on SQL 2008

c# – 从一个DataBase(sql server 2008)到具有不同架构的另一个db(sql server 2008)的传输数据的最佳方式

CMS系统:PHPCMS V9 /phpcms/modules/member/index.php phpcms注入漏洞修复补丁

《CMS系统:PHPCMS V9 /PHPcms/modules/member/index.PHP PHPcms注入漏洞修复补丁》要点：
本文介绍了CMS系统:PHPCMS V9 /PHPcms/modules/member/index.PHP PHPcms注入漏洞修复补丁，希望对您有用。如果有疑问，可以联系我们。

漏洞名称：PHPcms注入漏洞

文件路径：/PHPcms/modules/member/index.PHP
修复方法来源于网络,由风信网整理提供.
源代码大概615行：
if(empty($_SESSION['connectid'])) {
//判断验证码
$code = isset($_POST['code']) && trim($_POST['code']) ? trim($_POST['code']) : showmessage(L('input_code'),HTTP_REFERER);
if ($_SESSION['code'] != strtolower($code)) {
    $_SESSION['code'] = '';
    showmessage(L('code_error'),sans-serif; line-height: 30px;">}
$_SESSION['code'] = '';
$username = isset($_POST['username']) && is_username($_POST['username']) ? trim($_POST['username']) : showmessage(L('username_empty'),sans-serif; line-height: 30px;">$password = isset($_POST['password']) && trim($_POST['password']) ? trim($_POST['password']) : showmessage(L('password_empty'),sans-serif; line-height: 30px;">针对phpsso模块添加过滤代码,最好的方式应该是将转义和过滤放在数据库操作的前一步,这样可以极有效缓解sql注入带来的问题
修改代码：
$password = isset($_POST['password']) && trim($_POST['password']) ? trim($_POST['password']) : showmessage(L('password_empty'),sans-serif; line-height: 30px;">改为：
$password = isset($_POST[‘password‘]) && trim($_POST[‘password‘]) ? addslashes(urldecode(trim($_POST[‘password‘]))) : showmessage(L(‘password_empty‘),HTTP_REFERER);

今天关于phpcms 2008 sp4 安装 出现1067错误 因为中文字符和安装时出错错误代码107的介绍到此结束，谢谢您的阅读，有关Application Access Violation or Hang After Applying SP4（从微软站点找来的，E文，看看对你的情况是...、Backup SQL Server 2008 R2 Restore on SQL 2008、c# – 从一个DataBase(sql server 2008)到具有不同架构的另一个db(sql server 2008)的传输数据的最佳方式、CMS系统:PHPCMS V9 /phpcms/modules/member/index.php phpcms注入漏洞修复补丁等更多相关知识的信息可以在本站进行查询。