[HACK]社区婚姻 1.0 For D4 （有补丁贴子！！使用主题分类！）

我这问题有办法妈

如何把首页上面登陆那里的“社区婚姻“，改成自己想要的名字啊？？？

办理登记时为何总显示如下提示？
金钱都是够的，且对方也同意了。


“想逼婚啊，你？拉出去砍了！”

我的法院这个怎么显示空白的呀!~?

Discuz! info: MySQL Query Error

User: ts1
Time: 2006-2-17 10:49pm
Script: /plugin.php

SQL: select * from cdb_qiuhun where dlg='0' and (username='ts1' or tousername='ts1')
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.


在求婚时,出现如上错误,怎么回事呀??

Discuz! info: MySQL Query Error

User: ts1
Time: 2006-2-17 10:49pm
Script: /plugin.php

SQL: select * from cdb_qiuhun where dlg='0' and (username='ts1' or tousername='ts1')
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.

造成上述错误的原因是由于mysql配置的字符集为latin1_swedish_ci,而DZ4数据库是采用gbk_chinese_ci字符集的.
因此在升级数据库时必须加上CHARSET=gbk参数才行.
具体代码如下:

1. 
   
2. DROP TABLE IF EXISTS cdb_jhzhufu;
   
3. CREATE TABLE `cdb_jhzhufu` (
   
4.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
   
5.   `jhid` mediumint(8) unsigned NOT NULL default '0',
   
6.   `username` varchar(15) NOT NULL default '',
   
7.   `tousername` varchar(15) NOT NULL default '',
   
8.   `addtime` int(10) unsigned default NULL,
   
9.   `lmoney` int(10) unsigned default NULL,
   
10.   `message` text,
    
11.   KEY `ID` (`ID`)
    
12. ) TYPE=MyISAM AUTO_INCREMENT=2 CHARSET=gbk;
    
13. 
    
14. DROP TABLE IF EXISTS cdb_jie;
    
15. CREATE TABLE `cdb_jie` (
    
16.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
    
17.   `username` varchar(15) NOT NULL default '',
    
18.   `thename` varchar(15) NOT NULL default '',
    
19.   `year` int(10) unsigned default NULL,
    
20.   `longs` int(10) unsigned default NULL,
    
21.   `addtime` int(10) unsigned default NULL,
    
22.   `TYPE` tinyint(3) unsigned NOT NULL default '0',
    
23.   `content` text,
    
24.   `jiehun` tinyint(1) unsigned NOT NULL default '0',
    
25.   KEY `ID` (`ID`)
    
26. ) TYPE=MyISAM AUTO_INCREMENT=10 CHARSET=gbk;
    
27. 
    
28. DROP TABLE IF EXISTS cdb_lihun;
    
29. CREATE TABLE `cdb_lihun` (
    
30.   `id` mediumint(8) unsigned NOT NULL auto_increment,
    
31.   `username` varchar(15) NOT NULL default '',
    
32.   `tousername` varchar(15) NOT NULL default '',
    
33.   `addtime` int(10) unsigned default NULL,
    
34.   `reason` text,
    
35.   `indict` smallint(1) NOT NULL default '0',
    
36.   PRIMARY KEY  (`id`)
    
37. ) TYPE=MyISAM AUTO_INCREMENT=5 CHARSET=gbk;
    
38. 
    
39. DROP TABLE IF EXISTS cdb_qiuhun;
    
40. CREATE TABLE `cdb_qiuhun` (
    
41.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
    
42.   `username` varchar(15) NOT NULL default '',
    
43.   `tousername` varchar(15) NOT NULL default '',
    
44.   `addtime` int(10) unsigned default NULL,
    
45.   `message` text,
    
46.   `dlg` tinyint(1) unsigned NOT NULL default '0',
    
47.   `jiehun` tinyint(1) unsigned NOT NULL default '0',
    
48.   `content` text,
    
49.   KEY `ID` (`ID`)
    
50. ) TYPE=MyISAM AUTO_INCREMENT=10 CHARSET=gbk;
    

复制代码

[ 本帖最后由 guofs 于 2006-2-18 19:39 编辑 ]

图片做的不是很好看...太简单.>>>

安装时出再下面这些。。。。。。

Discuz! info: MySQL Query Error

User: 星云·伤
Time: 2006-2-19 8:39pm
Script: /bbs/marryset.php

SQL:
CREATE TABLE `cdb_jhzhufu` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`jhid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(15) NOT NULL default '',
`tousername` varchar(15) NOT NULL default '',
`addtime` int(10) unsigned default NULL,
`lmoney` int(10) unsigned default NULL,
`message` text,
KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

Error: You have an error in your SQL syntax near ';
' at line 11
Errno.: 1064

An error report has been dispatched to our administrator.

拆卸时出现。。。。。

Discuz! info: MySQL Query Error

User: 星云·伤
Time: 2006-2-19 8:40pm
Script: /bbs/marryset.php

SQL: ALTER TABLE cdb_members DROP hw ;
Error: Table 'shenrui.cdb_members' doesn't exist
数据表缺失,请恢复备份数据

An error report has been dispatched to our administrator.



这是什么原因呀？？？？？

用186楼的方法来手工升级数据就行了。