TinyPortal

Incorrect integer value: '' for column 'category' at row 1
File: [...]\flyonthenet.com\Sources\TPortalAdmin.php
Line: 995

This happens when I save an existing article with category set as 'none'.
Always reproducible, I'm using Tinyportal 0.9.8

I temporarly patched by myself:


elseif(substr($what,0,19)=='tp_article_category'){
  $val=substr($what,19);
  if(empty($value)) $value = '0';
  if(is_numeric($val) && $val>0)
    db_query("UPDATE {$tp_prefix}articles SET category='$value' WHERE id=$val", __FILE__, __LINE__);
  $go=3;
}

Thanks for reporting it. In fact, the template should have a value of "0" for the "none" option, which it hasn't. Fixed in v1.0.