Warning when moving Pligg from one host to another

[srikat]

I moved Pligg Beta 9.0 from DreamHost to another host.

The site seems to be working fine except for the following which appears at the top:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home2/showbloc/public_html/vote/libs/dbtree.php on line 322

URL: http://www.showblocked.info/vote/

PHPinfo: http://www.showblocked.info/phpinfo.php

Any help is highly appreciated?

[AshDigg]

See if this helps.

[srikat]

It worked. I did the change via phpMyAdmin.

The SQL query for the same is:

UPDATE `pligg_categories` SET `category__auto_id` = '0' WHERE `pligg_categories`.`category__auto_id` =5 LIMIT 1 ;

In the above code, replace 'pligg_categories' with the name of categories table as appropriate. Usually it will be just 'categories' or 'pligg_categories'.