PAINEL DE CONTROLE DO MODERADOR ]

1264 - Out of range value adjusted for column 'manufacturers_id' at row 1



1264 - Out of range value adjusted for column 'manufacturers_id' at row 1

Mensagempor Patty » Sáb Mai 29, 2010 11:55 pm

ERRO

1264 - Out of range value adjusted for column 'manufacturers_id' at row 1
insert into products (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('10', '', '1000', null, '1', '1', '0', '', '2.gif', now())



SOLUÇÃO:

Abra o arquivo loja/admin/categories.php e procure por esta linha:
Código: Selecionar tudo
$sort_order = tep_db_prepare_input($HTTP_POST_VARS['sort_order']);

Adicione logo após:
Código: Selecionar tudo
if ($sort_order=='')
{$sort_order='0';
}



Procure por:
Código: Selecionar tudo
<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_pull_down_menu('manufacturers_id', $manufacturers_array, $pInfo->manufacturers_id); ?></td>

Substitua por:
Código: Selecionar tudo
<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_pull_down_menu('manufacturers_id', $manufacturers_array, $pInfo->manufacturers_id); ?> <font color="red">* Required</font></td>



Procure por:
Código: Selecionar tudo
<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', $pInfo->products_quantity); ?></td>

Substitua por:
Código: Selecionar tudo
<td class="main">
<?php
if ($pInfo->products_quantity=='') {
echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', "0");
}else{
echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_quantity', $pInfo->products_quantity);
}
?>
<font color="red">* Obrigatório</font>
</td>



Procure por:
Código: Selecionar tudo
<td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight); ?></td>

Substitua por:
Código: Selecionar tudo
<td class="main">
<?php
if ($pInfo->products_weight=='') {
echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', "0");
}else{
echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_weight', $pInfo->products_weight);
}
?>
<font color="red"> * Obrigatório</font>
</td>
Patty
______________________________________________________________
Módulos adicionais e gateways de pagamento Cielo e Rede
para osCommerce e WHMCS

Certificados SSL por apenas R$ 89,00/ano
http://www.cybernetfx.com
Patty

Avatar de usuário
Administrador
Administrador
 
Mensagens: 1155
Data de registro: Ter Mai 04, 2010 1:31 am

Retornar para osCommerce - Erros e Problemas mais comuns

Quem está online

Usuários vendo este fórum: Nenhum membro registrado online e 1 visitante

cron
Shared Web Hosting by HostDime