1
Tom,
Just made the changes you mentioned.
Patched smartsection/class/file.php
And changed sql table definition:
A minor "issue" that has been in my website for a long time, is now solved. (probably a newer version of smartsection already exists with this correction, nevertheless, this topic gets the solution for smartsection 2.1.
Once again, thank you Tom!
Just made the changes you mentioned.
Patched smartsection/class/file.php
/**
* $Id: file.php,v 1.14 2005/10/10 19:51:14 malanciault Exp $
* Module: SmartSection
* Author: The SmartFactory <www.smartfactory.ca>
* Licence: GNU
*/
And changed sql table definition:
mysql> desc smartsection_files;
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| fileid | int(11) | NO | PRI | NULL | auto_increment |
| itemid | int(11) | NO | | 0 | |
| name | varchar(255) | NO | | | |
| description | text | NO | | | |
| filename | varchar(255) | NO | | | |
| mimetype | varchar(64) | NO | | | |
| uid | int(6) | YES | | 0 | |
| datesub | int(11) | NO | | 0 | |
| status | int(1) | NO | | -1 | |
| notifypub | tinyint(1) | NO | | 1 | |
| counter | int(8) unsigned | NO | | 0 | |
+-------------+-----------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql> ALTER TABLE smartsection_files MODIFY COLUMN mimetype varchar(255) NOT NULL;
mysql> desc smartsection_files;
+-------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------+------+-----+---------+----------------+
| fileid | int(11) | NO | PRI | NULL | auto_increment |
| itemid | int(11) | NO | | 0 | |
| name | varchar(255) | NO | | | |
| description | text | NO | | | |
| filename | varchar(255) | NO | | | |
| mimetype | varchar(255) | NO | | | |
| uid | int(6) | YES | | 0 | |
| datesub | int(11) | NO | | 0 | |
| status | int(1) | NO | | -1 | |
| notifypub | tinyint(1) | NO | | 1 | |
| counter | int(8) unsigned | NO | | 0 | |
+-------------+-----------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
A minor "issue" that has been in my website for a long time, is now solved. (probably a newer version of smartsection already exists with this correction, nevertheless, this topic gets the solution for smartsection 2.1.
Once again, thank you Tom!