Shared Downloads Module fields missing.

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
5/10/2006 3:48:47 AM
Gravatar
Total Posts 92

Shared Downloads Module fields missing.

When experimenting with the Shared Downloads module from svn 976 I ran into a couple of errors where fields were missing in the table mp_sharedfileshistory.

Errors when updating a current file on the system:
#42S22Unknown column 'OriginalFileName' in 'field list'
#42S22Unknown column 'UploadUserID' in 'field list'

MySql Entries to fix:
ALTER TABLE `testportal`.`mp_sharedfileshistory` ADD COLUMN `OriginalFileName` VARCHAR(255);

ALTER TABLE `testportal`.`mp_sharedfileshistory` ADD COLUMN `UploadUserID` INTEGER ZEROFILL NOT NULL DEFAULT 0;

Another bug that I don't have to look into is when you revert to a previous version of the file it tries to copy the real filename, not the guid.config file.

I'm still testing on my localhost IIS testbed, but will be posting on my mono/linux/mysql server and retesting very soon.
5/10/2006 12:50:38 PM
Gravatar
Total Posts 18439

Re: Shared Downloads Module fields missing.

Thanks Richard,

You are right those columns are missing in the MySQL version. I'm surprised no-one has reported that one before.
I'll get that into the scripts so its fixed in the next release.

Cheers,

Joe
5/11/2006 1:26:09 AM
Gravatar
Total Posts 92

Re: Shared Downloads Module fields missing.

Not a problem.    I also noticed that the shared files history table is storing the FriendlyName in the ServerFileName field.   Hopefully I'll get around to fixing that soon.  I'm still learning the infrastructure of the system, but it's been pretty self explanatory so far.  Unfortunately my the job and users  keep getting in the way of the things I want to do.  LOL.
You must sign in to post in the forums. This thread is closed to new posts.