welford

Hi bradmillar, as of yet there has been no response to confirm the shortcode or what is required to do this in the latest version. I have downgraded to the previous version and added in the SQL to do it for me.

Hi Shaon,

I’ve been looking at posts where people have had the same issue and have tried executing this SQL statement you mentioned:

ALTER TABLE `ahm_files` ADD `icon` VARCHAR( 255 ) NOT NULL

and adding the following code:

$wpdb->query(“ALTER TABLE `ahm_files` ADD `icon` VARCHAR( 255 ) NOT NULL”); – this was already in the code though

If I DROP the icon column from the ahm_files table, I am able to create new packages again but not able to select an icon as there is no column to save the data too, is there anything I can do to resolve this or is there an issue with my database?

Many thanks

Welford

Hi Clarity,

I understand your workaround to get this to work as this is what I have done myself but this shouldn’t be happening, I have uploaded about 50 downloads without having to set an icon or modify anything in phpmyadmin, why all of a sudden would it now require us to select an icon to continue. If the plugin was meant to function that way wouldn’t it give us an error like “please select an icon” rather than just showing the user a small green box. Would this be a plugin issue or something else causing this erratic behaviour?

I just added the SQL command “order by id desc” after the current SQL Search query already on line #591 “select * from ahm_files where category like ‘%\”$id\”%’”. The SQL command just sorts the files into reverse order on the live front end that your visitors will see. I edited the download-manager.php file directly as I host the web server myself, I didn’t change any existing code, I only added to it, Maybe it’s error if you have copied the code directly from the forum, try putting your original download-manager.php file back on you server so all is working the just add the code “order by id desc” as I did. Hope this helps.