MySQL Error: Unknown column 'dodeleted'

[natas]

First, I noticed that the image for progress was broken on my site. When I right-clicked it and viewed the image source I get this:
http://www.vbadvanced.com/forum/images/misc/progress.gif

When I try to generate a new report I get this error:
Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO adv_links_reports
(userid, data, dateline, endtime, checkagain, type, dodeleted)
VALUES (
1,
'',
1221152237,
1221152237,
1,
1,
0
);

MySQL Error : Unknown column 'dodeleted' in 'field list'
Error Number : 1054
Request Date : Thursday, September 11th 2008 @ 04:57:17 PM
Error Date : Thursday, September 11th 2008 @ 04:57:17 PM
Script : http://domain.com/links/moderate.php
Referrer : http://domain.com/links/moderate.php?do=statusreports
IP Address : 71.154.18.246
Username : sjordan
Classname : vB_Database
MySQL Version : 5.0.58

[Brian]

First, I noticed that the image for progress was broken on my site. When I right-clicked it and viewed the image source I get this:
http://www.vbadvanced.com/forum/images/misc/progress.gif
Where at exactly?

When I try to generate a new report I get this error:
Thank you for pointing this out. The 'dodeleted' field is new in 3.0.0, but looks like it wasn't added to the query when doing a new install (which has been corrected in the install file now). For anyone who has already done a fresh install of v3.0.0, you can correct that by running the following query via your Admin CP or phpMyAdmin: If you use table prefixes, be sure to add your table prefix before 'adv_links_reports' on the first line.
ALTER TABLE adv_links_reports
CHANGE `type` `type` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
ADD dodeleted SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0'

[Our Sponsors]

[natas]

[QUOTE=Brian;154806]Where at exactly?

When you click on "Continue" on adding a link. I did a search for the image in my templates and the direct link to vbadvanced.com was there:

ADV_LINKS_ADD_START

setTimeout('document.images["wait_img"].src = "http://www.vbadvanced.com/forum/images/misc/progress.gif"', 200);

[Brian]

Huh... Not sure how that got in there. I've went ahead and applied the fix to the files in the download package here though, so you can correct one of two ways.

1). Download the files from here agian, upload the forum/admincp/vbalinks_install.php file, go to it in your browser, and select the option to re-install the templates (this will add the fix and prevent you from having a customized template).

2). Edit your 'ADV_LINKS_ADD_START' template through your Style Manager and replace 'http://www.vbadvanced.com/forum/images/misc' with '$stylevar[imgdir_misc]'.