[HACK]社区婚姻 1.0 For D4（附加sql安装语句）

这个不错,顶!

请问我是干净装的 SQL那些数据库 要不要装

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='drld'' at line 1

如何解决？

SELECT  `uid` , `gender` , `hw` FROM `cdb_members` WHERE username = 'drld'
这样就可以查询注册ID 性别 和配偶名称 但是在那里调用的这个SQL语句啊？

页面显示是这样：
Discuz! info: MySQL Query Error

User: drld
Time: 2005-12-18 1:09am
Script: /plugin.php

SQL: select uid,gender,hw, from cdb_members WHERE username='drld'
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='drld'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

原帖由 gz412 于 2005-12-17 23:22 发表
请问我是干净装的 SQL那些数据库 要不要装

不需要的

1. $db->query("insert into jie (username,thename,content,year,jiehun) values ('$qhinfo[username]','$qhinfo[tousername]','$qhinfo[message]','$timestamp','0')");

复制代码

应改为

1. $db->query("insert into cdb_jie (username,thename,content,year,jiehun) values ('$qhinfo[username]','$qhinfo[tousername]','$qhinfo[message]','$timestamp','0')");

复制代码

insert into jie应改为insert into cdb_jie

[ 本帖最后由 丢丢虫 于 2005-12-21 19:05 编辑 ]

请问楼上的，这个是哪个文件里的

就是你修正后的 marry_manager文件.rar 里的啊

SQL是升级数据库吧。。。
但我执行第一个SQL时，出现了这个：
升级错误，MySQL 提示: Table 'cdb_jhzhufu' already exists

当会员在月老板块同意他人求婚时，就出现以下错误信息了，哪里出错了？

Discuz! info: MySQL Query Error

User: bb
Time: 2005-12-22 11:50am
Script: /plugin.php

SQL: insert into jie (username,thename,content,year,jiehun) values ('aa','bb','dsfdsfds','1135223401','0')
Error: Table '31111.jie' doesn't exist
数据表缺失,请恢复备份数据