zen cart:1264 Out of range value for column 'expiry' at row 1
点击 2381 创建时间 2011-09-20 17:46:02
<p>
1264 Out of range value for column 'expiry' at row 1<br />
in:<br />
[insert into zc_sessions values ('ec1kktbetsq3pgk6iurvptqkk4', '191316511197', 'c2VjdXJpdHlUb2tlbnxzOjMyOiJiOWIyODU3ZGJhZTFlMjBiNWI5Njc3OTM4ZDVlZjRmMSI7Y3VzdG9tZXJzX2hvc3RfYWRkcmVzc3xzOjY6ImFwcC5wbiI7Y2FydElEfHM6MDoiIjtjYXJ0fE86MTI6InNob3BwaW5nQ2FydCI6Nzp7czo4OiJjb250ZW50cyI7YTowOnt9czo1OiJ0b3RhbCI7aTowO3M6Njoid2VpZ2h0IjtpOjA7czoxMjoiY29udGVudF90eXBlIjtiOjA7czoxODoiZnJlZV9zaGlwcGluZ19pdGVtIjtpOjA7czoyMDoiZnJlZV9zaGlwcGluZ193ZWlnaHQiO2k6MDtzOjE5OiJmcmVlX3NoaXBwaW5nX3ByaWNlIjtpOjA7fW5hdmlnYXRpb258TzoxNzoibmF2aWdhdGlvbkhpc3RvcnkiOjI6e3M6NDoicGF0aCI7YToxOntpOjA7YTo0OntzOjQ6InBhZ2UiO3M6NToiaW5kZXgiO3M6NDoibW9kZSI7czo2OiJOT05TU0wiO3M6MzoiZ2V0IjtzOjA6IiI7czo0OiJwb3N0IjthOjA6e319fXM6ODoic25hcHNob3QiO2E6MDp7fX1jaGVja192YWxpZHxzOjQ6InRydWUiO2xhbmd1YWdlfHM6NzoiZW5nbGlzaCI7bGFuZ3VhZ2VzX2lkfHM6MToiMSI7bGFuZ3VhZ2VzX2NvZGV8czoyOiJlbiI7Y3VycmVuY3l8czozOiJVU0QiO3RvZGF5X2lzfHM6MTA6IjIwMTEtMDktMjAiO3VwZGF0ZUV4cGlyYXRpb25zfGI6MTtzZXNzaW9uX2NvdW50ZXJ8YjoxO2N1c3RvbWVyc19pcF9hZGRyZXNzfHM6OToiMTI3LjAuMC4xIjs=')]</p>
<p>
解决办法：<code class="sql"><span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">ALTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_quote syntax_quote_backtick">zc_sessions</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHANGE</span> <span class="syntax_quote syntax_quote_backtick">expiry</span> <span class="syntax_quote syntax_quote_backtick">expiry</span> <span class="syntax_alpha syntax_alpha_columnType">VARCHAR</span><span class="syntax_punct syntax_punct_bracket_open_round">(</span> <span class="syntax_digit syntax_digit_integer">12</span> <span class="syntax_punct syntax_punct_bracket_close_round">)</span> <span class="syntax_alpha syntax_alpha_reservedWord">CHARACTER</span> <span class="syntax_alpha syntax_alpha_reservedWord">SET</span> <span class="syntax_alpha syntax_alpha_charset">latin1</span> <span class="syntax_alpha syntax_alpha_reservedWord">COLLATE</span> <span class="syntax_alpha syntax_alpha_charset">latin1_general_ci</span> <span class="syntax_alpha syntax_alpha_reservedWord">NOT</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <span class="syntax_alpha syntax_alpha_columnAttrib">DEFAULT</span> <span class="syntax_quote syntax_quote_single">'0'</span></span></code></p>
上一篇： 威客经验分享
下一篇： discuz学习 2011-9-29