7
The error message is related to:
$result=$xoopsDB->query("SELECT cid, title, imgurl FROM ".$xoopsDB->prefix("mylinks_cat")." WHERE pid = 0 ORDER BY title") or exit("Error");
The error indicates that there seem to be entries in mylinsks_cat table.
You need to install the module by
deactivate -> uninstall
then re-install.