**[++梦幻宠物(简繁研究版)++]** For Discuz! 5.0 正式版

elvislee58 · 发表于 2006-9-13 22:42:41

Discuz! info: MySQL Query Error

User: 飛仔
Time: 2006-9-13 10:40pm
Script: /vb5/petshop.php

SQL: UPDATE cdb_mypetdata SET hack=0 WHERE username='飛仔'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (big5_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.

how can i fix it?

83267556 · 发表于 2006-9-13 23:10:03

原帖由 elvislee58 于 2006-9-13 22:42 发表
Discuz! info: MySQL Query Error

User: 飛仔
Time: 2006-9-13 10:40pm
Script: /vb5/petshop.php

SQL: UPDATE cdb_mypetdata SET hack=0 WHERE username='飛仔'
Error: Illegal mix of collations (lat ...

You can make reference to page one

83267556 · 发表于 2006-9-13 23:38:53

建议BOBII把你大哥哥的发帖加经验的方法也公布到1楼

hysea · 发表于 2006-9-14 02:39:19

第一次下载，第一次安装，完全按1楼的顺序和要求试装，报了个和前面很多人一样的错误，为什么？

第一步，上传所有文件到对应文件夹，第二步，执行installpf.php，点全新安装，然后点“开始安装”，然后就报下面的错误了！

出现错误后，仔细看了看前面的朋友，有同样的1067错误，也有人提供了解决办法，修改petpknpcf.php文件等，但是经检查，petpknpcf.php文件已经和９月１０号的文件内容不一样了，请问出这个错误怎么办？
已经用43楼的文件试过了，错误一模一样！

注意：安装插件有风险，小心安装没问题！天使梦幻宠物系统V2.10安装程序 by 快乐天使 2006.1.30

Discuz! info: MySQL Query Error

User: hysea
Time: 2006-9-14 2:29am
Script: /bbs/installpf.php

SQL: CREATE TABLE `cdb_petconfig` (
`version` varchar(30) NOT NULL default '快乐天使PetPlusV2.10',
`play` smallint(5) unsigned NOT NULL default '0',
`peopen` smallint(5) unsigned NOT NULL default '0',
`people1` smallint(5) unsigned NOT NULL default '0',
`people2` smallint(5) unsigned NOT NULL default '0',
`people3` smallint(5) unsigned NOT NULL default '0',
`people4` smallint(5) unsigned NOT NULL default '0',
`people5` smallint(5) unsigned NOT NULL default '0',
`people6` smallint(5) unsigned NOT NULL default '0',
`people7` smallint(5) unsigned NOT NULL default '0',
`people8` smallint(5) unsigned NOT NULL default '0',
`basichp` smallint(5) unsigned NOT NULL default '100',
`basicsp` smallint(5) unsigned NOT NULL default '5000',
`basicsp2` smallint(5) unsigned NOT NULL default '500',
`eggmoney` smallint(5) unsigned NOT NULL default '200',
`basichpmoney` smallint(5) unsigned NOT NULL default '100',
`basicbhpmoney` smallint(5) unsigned NOT NULL default '500',
`basicmpmoney` smallint(5) unsigned NOT NULL default '200',
`basicspmoney` smallint(5) unsigned NOT NULL default '100',
`basicexpmoney` smallint(5) unsigned NOT NULL default '50000',
`nomoney` int(11) unsigned NOT NULL default '100000',
`livemoney` smallint(5) unsigned NOT NULL default '3000',
`basicusehp` smallint(5) unsigned NOT NULL default '100',
`basicusemp` smallint(5) unsigned NOT NULL default '25',
`basicusebhp` smallint(5) unsigned NOT NULL default '2500',
`basicusebmp` smallint(5) unsigned NOT NULL default '100',
`basicuseexp` smallint(5) unsigned NOT NULL default '50',
`petpkhp` smallint(5) unsigned NOT NULL default '0',
`petpklv` smallint(5) unsigned NOT NULL default '10',
`petpktime` int(10) unsigned NOT NULL default '1',
`losegd` smallint(5) unsigned NOT NULL default '0',
`changesexmoney` smallint(5) unsigned NOT NULL default '500',
`swordmoneya` smallint(5) unsigned NOT NULL default '30',
`swordmoneyb` smallint(5) unsigned NOT NULL default '60',
`swordmoneyc` smallint(5) unsigned NOT NULL default '120',
`swordmoneyd` smallint(5) unsigned NOT NULL default '240',
`swordmoneye` smallint(5) unsigned NOT NULL default '480',
`swordmoneyf` smallint(5) unsigned NOT NULL default '960',
`swordmoneyg` smallint(5) unsigned NOT NULL default '1920',
`swordmoneyh` smallint(5) unsigned NOT NULL default '3840',
`swordmoneyi` smallint(5) unsigned NOT NULL default '7680',
`necklacemoneya` smallint(5) unsigned NOT NULL default '1500',
`necklacemoneyb` smallint(5) unsigned NOT NULL default '3000',
`necklacemoneyc` smallint(5) unsigned NOT NULL default '4500',
`necklacemoneyd` smallint(5) unsigned NOT NULL default '6000',
`necklacemoneye` smallint(5) unsigned NOT NULL default '7500',
`necklacemoneyf` smallint(5) unsigned NOT NULL default '9000',
`necklacemoneyg` smallint(5) unsigned NOT NULL default '10500',
`necklacemoneyh` smallint(5) unsigned NOT NULL default '12000',
`necklacemoneyi` smallint(5) unsigned NOT NULL default '13500',
`headmoneya` smallint(5) unsigned NOT NULL default '25',
`headmoneyb` smallint(5) unsigned NOT NULL default '50',
`headmoneyc` smallint(5) unsigned NOT NULL default '100',
`headmoneyd` smallint(5) unsigned NOT NULL default '200',
`headmoneye` smallint(5) unsigned NOT NULL default '400',
`headmoneyf` smallint(5) unsigned NOT NULL default '800',
`headmoneyg` smallint(5) unsigned NOT NULL default '1600',
`headmoneyh` smallint(5) unsigned NOT NULL default '3200',
`headmoneyi` smallint(5) unsigned NOT NULL default '6400',
`bodymoneya` smallint(5) unsigned NOT NULL default '20',
`bodymoneyb` smallint(5) unsigned NOT NULL default '40',
`bodymoneyc` smallint(5) unsigned NOT NULL default '80',
`bodymoneyd` smallint(5) unsigned NOT NULL default '160',
`bodymoneye` smallint(5) unsigned NOT NULL default '320',
`bodymoneyf` smallint(5) unsigned NOT NULL default '640',
`bodymoneyg` smallint(5) unsigned NOT NULL default '1280',
`bodymoneyh` smallint(5) unsigned NOT NULL default '2560',
`bodymoneyi` smallint(5) unsigned NOT NULL default '5120',
`footmoneya` smallint(5) unsigned NOT NULL default '10',
`footmoneyb` smallint(5) unsigned NOT NULL default '20',
`footmoneyc` smallint(5) unsigned NOT NULL default '40',
`footmoneyd` smallint(5) unsigned NOT NULL default '80',
`footmoneye` smallint(5) unsigned NOT NULL default '160',
`footmoneyf` smallint(5) unsigned NOT NULL default '320',
`footmoneyg` smallint(5) unsigned NOT NULL default '640',
`footmoneyh` smallint(5) unsigned NOT NULL default '1280',
`footmoneyi` smallint(5) unsigned NOT NULL default '2560',
`area` smallint(5) unsigned NOT NULL default '0',
`arealv` smallint(5) unsigned NOT NULL default '50',
`arealv2` smallint(5) unsigned NOT NULL default '100',
`arealv3` smallint(5) unsigned NOT NULL default '150',
`arealv4` smallint(5) unsigned NOT NULL default '200',
`arealv5` smallint(5) unsigned NOT NULL default '250',
`arealv6` smallint(5) unsigned NOT NULL default '300',
`arealv7` smallint(5) unsigned NOT NULL default '350',
`arealv8` smallint(5) unsigned NOT NULL default '400',
`arealv9` smallint(5) unsigned NOT NULL default '450',
`arealv10` smallint(5) unsigned NOT NULL default '1500',
`arealv11` smallint(5) unsigned NOT NULL default '1600',
`repoints` int(10) unsigned NOT NULL default '1000000',
`setactime` int(10) unsigned NOT NULL default '0',
`pofa` smallint(5) unsigned NOT NULL default '0',
`dirange` smallint(5) unsigned NOT NULL default '900',
`dirange2` smallint(5) unsigned NOT NULL default '900',
`dirange3` smallint(5) unsigned NOT NULL default '900',
`dirange4` smallint(5) unsigned NOT NULL default '900',
`dirange5` smallint(5) unsigned NOT NULL default '600',
`dirange6` smallint(5) unsigned NOT NULL default '600',
`closetime` varchar(6) NOT NULL default '0||24',
`dayocset` varchar(100) NOT NULL default '',
`chaton` smallint(5) unsigned NOT NULL default '0',
`dropmm1` smallint(5) unsigned NOT NULL default '2',
`dropmm2` smallint(5) unsigned NOT NULL default '3',
`dropmm3` smallint(5) unsigned NOT NULL default '4',
`dropmm4` smallint(5) unsigned NOT NULL default '5',
`dropmm5` smallint(5) unsigned NOT NULL default '6',
`dropmm6` smallint(5) unsigned NOT NULL default '8',
`dropmm7` smallint(5) unsigned NOT NULL default '10',
`put` smallint(5) unsigned NOT NULL default '5',
`put1` smallint(5) unsigned NOT NULL default '10',
`postline` smallint(5) unsigned NOT NULL default '0',
`setpost` smallint(5) unsigned NOT NULL default '5',
`settime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`version`)
) TYPE=MyISAM;
Error: Invalid default value for 'version'
Errno.: 1067

[ 本帖最后由 hysea 于 2006-9-14 15:17 编辑 ]

hysea · 发表于 2006-9-14 02:51:01

３２７楼也有这个错误，翻遍了也没看到有人来解答，难道就没人管吗？

yoki850914 · 发表于 2006-9-14 07:03:53

宠物币和论坛币无法兑换是因为什么??

取钱失败，你都没存过那么多宠物币或没有宠物！
宠物银行

我存了1000进去宠物银行,可是取款却多少都取不出

宠物币和论坛币也无法兑换，请问是怎么回事呢?
谢谢

dgcr007 · 发表于 2006-9-14 09:14:54

原帖由 bobbi 于 2006-9-8 20:29 发表
安装后出现问号乱码问题

先卸载然后
把安装文件换成附件试试或者在每个建表语句后面加

简体GBK版character set=gbk

繁体big5版character set=big5
具体加的位置在每个表的 TYPE=MyISAM 后面

原 ...

用这楼（43楼）的安装文件再安装一次试一下。
https://discuz.dismall.com/thread-394323-5-2.html

[ 本帖最后由 dgcr007 于 2006-9-14 09:27 编辑 ]

机虫 · 发表于 2006-9-14 10:18:18

我的出现乱码现象。。下了升级包也不行。。这到底是怎么回事

yoki850914 · 发表于 2006-9-14 10:32:34

宠物币和论坛币无法兑换
取宠物银行的款也不能取是怎么回事啊~?

jopt · 发表于 2006-9-14 10:44:30

BUG：

当你身上有一只宠物，而你寄存所里又有一只宠物，而你身上又没有5000块宠物币的话，去寄存所点领出宠物，系统会提示你，“你已经把选中的宠物领了出来，而把身上原来带的宝宝放进了寄存所，共花了5000宠物币。”

但是你身上没这么多钱啊？于是，你的宠物币就变成负数了。而你领出来的宠物所有装备都会消失。

解决办法：

打开petorphanage.php

查找

$members = $db->fetch_array($db->query("SELECT * FROM ".$tablepre."mypetdata WHERE username='$discuz_user'"));

复制代码

在后面加上：

if($members[agibow]<5000){pet_showmessage("你的宠物币不够5000,不能在宝宝寄存所取出宠物！<br><br><a href=petshop.php?index=petcenter>宠物中心</a>");}

复制代码

另外，我转成了utf-8版本的，不知是不是存在于gbk版本中。

PS，你们的宠物系统设定了必需发贴才能野战功能后，是否好使？？

		自动登录	找回密码
密码			立即注册

[插件] [++梦幻宠物(简繁研究版)++] For Discuz! 5.0 正式版

回复 #396 hysea 的帖子

梦幻宠物(简繁研究版)已知的BUG及其解决办法

[插件] **[++梦幻宠物(简繁研究版)++]** For Discuz! 5.0 正式版

回复 #396 hysea 的帖子

梦幻宠物(简繁研究版)已知的BUG及其解决办法

[插件] [++梦幻宠物(简繁研究版)++] For Discuz! 5.0 正式版