esu66

Hi!
Same thing with apache/mysql in windows.
When inserting data to table the free_html -field was not assigned any value in functions addBannerFromURL() and addBannerFromLocal().
adding empty value
'free_html' => ''
fixes it.

Other thing is adding free html banner, there was no value for width and height in addBannerWithFreeHTML().
That throws an error too.
I added this after $nofollow = $_POST['nofollow'];

$dimensions = array ( 0,0 );
		$mime       = "";
        if ( isset( $_POST['freeHTML'] ) ){
            if  (strstr( $html, ' width=\"' ) ){
                $w_temp=explode(' width=\"', $_POST['freeHTML'], 1);
                $w_arr=explode('\"', $w_temp[1], 1);
                $dimensions[0]=intval($w_arr[0]);
            }
            if  (strstr($html, ' height=\"')){
                $h_temp=explode(' height=\"', $_POST['freeHTML'], 1);
                $h_arr=explode('\"', $h_temp[1], 1);
                $dimensions[1]=intval($h_arr[0]);
            }
        }

and then this after 'maximpressions' => $_POST['maxImpressions'],

'mime'            => $mime,
'width'           => $dimensions[0],
'height'          => $dimensions[1],

So that seems to work also.

Great plugin, thanks for your effort, gfazioli!

BR, Esu

Hi,
The table creation error seems to be a problem with sql-query in wpBannerizeTable.sql, in line
free_html text NOT NULL DEFAULT ”,
since BLOB and TEXT columns cannot have DEFAULT values.
That line can’t be changed to be without default value, because the plugins code doesn’t work without it.
Chancing data type to varchar(255) does the trick.
In mysql 5.0.3 or later, maximum length can be 65535.

br,
Esu