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

为什么这个在Discuz!_4.0.0_SC_UTF8.zip  里用不起来    怎么没人回答？

求婚中心、法院、月老版块访问出现这个：

Discuz! info: MySQL Query Error

User: chinah
Time: 2006-2-8 8:43pm
Script: /bbs/plugin.php

SQL: select uid,gender,hw, from cdb_members WHERE username='chinah'
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from cdb_members WHERE username='chinah'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before

升级数据库的代码在哪儿？
请大家帖出来吧！

原帖由 jinlun721 于 2005-11-25 10:00 发表

这句也不行

还是不行
提示
升级错误，MySQL 提示: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cdb_members' ADD 'hw' varchar( 15 ) NULL' at line 1

是不是就是用不起来了？

显示正在结婚……
但是找不到酒店~~~
酒店都是没人在结婚

你的社区婚姻插件运行marryset.php错误!!
Discuz! info: MySQL Query Error

User: admin
Time: 2006-2-12 8:58pm
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

Similar error report has beed dispatched to administrator before.

自行解决了#177
如果有人出现同样情况

把marryset.php入面的SQL语句拿出手动添加

1. CREATE TABLE `cdb_jhzhufu` (
   
2.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
   
3.   `jhid` mediumint(8) unsigned NOT NULL default '0',
   
4.   `username` varchar(15) NOT NULL default '',
   
5.   `tousername` varchar(15) NOT NULL default '',
   
6.   `addtime` int(10) unsigned default NULL,
   
7.   `lmoney` int(10) unsigned default NULL,
   
8.   `message` text,
   
9.   KEY `ID` (`ID`)
   
10. ) TYPE=MyISAM AUTO_INCREMENT=2 ;

复制代码

1. CREATE TABLE `cdb_jie` (
   
2.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
   
3.   `username` varchar(15) NOT NULL default '',
   
4.   `thename` varchar(15) NOT NULL default '',
   
5.   `year` int(10) unsigned default NULL,
   
6.   `longs` int(10) unsigned default NULL,
   
7.   `addtime` int(10) unsigned default NULL,
   
8.   `TYPE` tinyint(3) unsigned NOT NULL default '0',
   
9.   `content` text,
   
10.   `jiehun` tinyint(1) unsigned NOT NULL default '0',
    
11.   KEY `ID` (`ID`)
    
12. ) TYPE=MyISAM AUTO_INCREMENT=10 ;

复制代码

1. CREATE TABLE `cdb_lihun` (
   
2.   `id` mediumint(8) unsigned NOT NULL auto_increment,
   
3.   `username` varchar(15) NOT NULL default '',
   
4.   `tousername` varchar(15) NOT NULL default '',
   
5.   `addtime` int(10) unsigned default NULL,
   
6.   `reason` text,
   
7.   `indict` smallint(1) NOT NULL default '0',
   
8.   PRIMARY KEY  (`id`)
   
9. ) TYPE=MyISAM AUTO_INCREMENT=5 ;

复制代码

1. CREATE TABLE `cdb_qiuhun` (
   
2.   `ID` mediumint(8) unsigned NOT NULL auto_increment,
   
3.   `username` varchar(15) NOT NULL default '',
   
4.   `tousername` varchar(15) NOT NULL default '',
   
5.   `addtime` int(10) unsigned default NULL,
   
6.   `message` text,
   
7.   `dlg` tinyint(1) unsigned NOT NULL default '0',
   
8.   `jiehun` tinyint(1) unsigned NOT NULL default '0',
   
9.   `content` text,
   
10.   KEY `ID` (`ID`)
    
11. ) TYPE=MyISAM AUTO_INCREMENT=10 ;

复制代码

1. ALTER TABLE cdb_members add hw varchar(15) NULL;

复制代码

[ 本帖最后由 ljdsy 于 2006-2-12 21:45 编辑 ]

所使用的扩展字段可不可以修改呢?后台默认的extcredits2好象不能换成其他的呢

求婚以后显示

Discuz! info: MySQL Query Error

User: 小羊
Time: 2006-2-14 12:04pm
Script: /plugin.php

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

An error report has been dispatched to our administrator.