Can't add downloads?

[Nabeel]

I'm not getting this bug, which makes it weird.

If you can do me a favor:

Subscribe to the issue:

http://phpvms.net/forum/index.php?issue=3.com5

And, open /admin/modules/downloads/downloads.php, Line 184/185 is:

DownloadData::AddDownload($this->post->category, $this->post->name, $this->post->description, $this->post->link, $this->post->image);

Under it, above the } add:

DB::debug();

Please post the results in the above issue.

Thanks!

[WVSailor]

Hope I did this correctly.... hehehe

Added the error message that I received as a 'comment'...  but will paste it here just in case:

    ezSQL (v2.03) Debug..

    Last Error -- [unknown column 'description' in 'field list' ()]

    Query [5] -- [iNSERT INTO phpvms_downloads (`pid`, `name`, `description`, `link`, `image`, `hits`) VALUES (3, 'FS ACARS 4.0.11', 'FS ACARS Version 4.0.11', 'http://jnyva.com/downloads/fsacars4.zip', '', 0)]

    Query Result..

        No Results

[Nabeel]

Thanks alot! Here's the fix, run in phpMyAdmin:

ALTER TABLE `phpvms_downloads` ADD `description` TEXT ASCII AFTER `name`;

Added the column in the update install, but not in the full install

[RogerB]

Ok that fixed it, but the images won't show.

[WVSailor]

Thanks alot! Here's the fix, run in phpMyAdmin:

ALTER TABLE `phpvms_downloads` ADD `description` TEXT ASCII AFTER `name`;

Added the column in the update install, but not in the full install

Thanks Nabeel!  That fixed my problem.  Of course, I haven't added an image... yet.  ;D

[RogerB]

This is how to get the images to show, put this in your downloads_list.tpl and save to you skins.

<img src="<?php echo $download->image ?>" />

[Nabeel]

I love the sexy code coloring.