error in add banner

[safatweb]

I am really happy with the banner & mass mailer system, This is what i was expecting :) thanks simon & others too...

:beer:

i tried to add a banner, and got this error,
Error: Unknown column 'width' in 'field list'
UPDATE dir_banners SET `image`='1.gif', `width`='468',`height`='60' WHERE id='1'

[Simon Gooffin]

Hi,
I'm sorry for the bug. Please execute this query in your Manage Database section:

ALTER TABLE `dir_banners` ADD `width` SMALLINT( 3 ) UNSIGNED NOT NULL AFTER `clicked` ,
ADD `height` SMALLINT( 3 ) UNSIGNED NOT NULL AFTER `width` ;

DO not forget to use correct prefix for your tables

[microlinx]

Simon:

When I add a new banner, I upload my image, and it does add it to the /domain/link/ads directory, however the image link it creates links to www.domain.com/ads NOT www.domain.com/link/ads/ as it should.

I had set the base directory right during install, www.domain.com/link/
but for some reason the script is creating its links to banners into the root/ads directory rather than into /links/ads .

I notice in config settings the base directory is set to www.domain.com/ and if I try to modify it to www.domain.com/link/, all hell breaks loose.

[Simon Gooffin]

Hi,
Try to reupload zip file and replace your old admin/manage-banners.php and banner.tpl file with the new ones taken from an uploaded archive.