ECShop 网上商店系统支持论坛 » 安装使用 » 發紅包時出錯

ngai 发表于 2008-6-5 23:51

發紅包時出錯

[b]MySQL server error report:Array( [0] => Array ( [message] => MySQL Query Error ) [1] => Array( [sql] => INSERT INTO `test`.`ecs_email_sendlist` ( email,template_id, email_content, pri, last_send) VALUES ('umum@abc.com',6, '
[b]Parse error[/b]:  parse error, unexpected $end in [b]C:\Program Files\EasyPHP 2.0b1\www\ecshop\includes\cls_template.php(1133) : eval()'d code[/b] on line [b]6[/b]
', 1, '1212680897') ) [2] => Array ( [error] => You have an errorin your SQL syntax; check the manual that corresponds to your MySQLserver version for the right syntax to use near 'd code[/b] on line [b]6[/b]
', 1, '1212680897')' at line 1        )    [3] => Array        (            [errno] => 1064        ))

bugii 发表于 2008-6-5 23:54

清除缓存后再试

ngai 发表于 2008-6-6 19:27

清除缓存 後也不行

bugii 发表于 2008-6-6 19:32

请问您用的是哪个版本 ？

ngai 发表于 2008-6-7 23:34

2.6.0 非0606版
utf 繁体

MeowJohn 发表于 2008-8-26 20:55

我也是出現這樣(我是2.5版), 請問ngai 前輩是如何解決的?與MySQL版本有關係嗎?


MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => INSERT INTO `greensite`.`ecs_email_sendlist` ( email, template_id, email_content, pri, last_send) VALUES ('john@bdm.tw', 6, '
Parse error: syntax error, unexpected $end in C:\Apache2\htdocs\includes\cls_template.php(1110) : eval()'d code on line 6
', 1, '1219755249') ) [2] => Array ( [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 'd code on line 6
', 1, '1219755249')' at line 1 ) [3] => Array ( [errno] => 1064 ) )

twfirework 发表于 2008-8-27 01:00

按照這方法修改

原內容為
親愛的{$user_name}您好！
恭喜您獲得了{$count}個折價券，金額{if $count > 1}分別{/ if}為{$money}
{$shop_name}
{$send_date}

修改後為
親愛的{$user_name}您好！
恭喜您獲得了1個折價券，金額為{$money}
{$shop_name}
{$send_date}

MeowJohn 发表于 2008-8-27 10:49

twfirework :
感謝您的熱心指導!:handshake

查看完整版本: 發紅包時出錯