Just stumbled over an old error report with a similar problem:
It seems some mysql setups are more strict concerning field types, so '' won't be accepted as a number.

Both .phps files updated with a simple check - if the id is empty it gets set to 0. This is done for org_id, rank_id and at number to be save.

Just redownload the .phps files, should solve your problem.

conf file:
$tablename = "cache.whois";   // name of the whois table

php file:
$lookup = $this -> bot -> db -> select("SELECT * FROM cache.whois WHERE nickname = '" . $name . "'");
etc etc (just took out manually the table lookup stuff as I'm running slightly older bebot)

that's how mine is setup and works fine for 3 bots.

-jj-

in my whois-update.conf file I have:

$dbname = "aoglobal";
$tablename = "whois";

In theWhoisCache.php I have this:

$lookup = $this -> bot -> db -> select("SELECT * FROM " . aoglobal.whois . " WHERE name = '" . $name . "'");

Slightly different than yours in the php file.  I'll try making the small change to what you have and see if it makes a difference (looking at it it should be the exact same thing but I guess the bot might be interpreting it differently for some reason).

Dabaron you have to put it in this way

$lookup = $this -> bot -> db -> select("SELECT * FROM aoglobal.whois WHERE name = '" . $name . "'");

 for it to work

Updated my version, same link in first post.

Basically I'm doing the same as you, I've pulled the (!empty($lookup)) out of the stale test to the front. If it's not in the table yet it doesn't need to be checked for outdated info anyways.

oki gone over to the updated version now but when i do a update i get

PHP Warning: include<whois-update.addons>: failed to open stream: No such file or directory in c:\php\w_update.php on line 197
PHP Warning: include<>: Failed opening 'whois-update.addons' for inclusion <include_path='.;c:\php5\pear'> in c:\php\w_update.php on line 197

did i do something rong with the musql and|or php again

oki gone over to the updated version now but when i do a update i get

Quote

PHP Warning: include<whois-update.addons>: failed to open stream: No such file or directory in c:\php\w_update.php on line 197
PHP Warning: include<>: Failed opening 'whois-update.addons' for inclusion <include_path='.;c:\php5\pear'> in c:\php\w_update.php on line 197

did i do something rong with the musql and|or php again

No, not at all.

I just added an include "whois-update.addons" at the end of file for possible further processing (which I'm doing).
The warning just tells you that the file doesn't exist (which is no problem at all). If you want to get rid of it either remove the include line or create an empty whois-update.addons file. I'll try to get around and add an exist-check for the file before the include in the next version.

oki thx