Images are stored in the Database?

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
aguedes
TestLink user
Posts: 2
Joined: Sun Feb 02, 2014 4:44 pm

Images are stored in the Database?

Post by aguedes »

Hi Guys,

I have been using the TL by 4 years. Recently I made the Upgrade to the version 1.9.8, and since this upgrade, I can not upload large print Screens.

After an exhaust investigation, seems that in this version, the print Screen that I paste using the FCKeditor are stored inside of DB, and not a file in the Files System.

How the images are stored inside of the DB, I can not save big print Screens, only very small print Screens.

There is some workaround that allow me to save the print Screens direct in the file System, if not, how can I increase the my DB (MySQL) to accept save a big quantity of characters (to allow me save big print Screens direct in the DB)

Sorry for my bad English =)

Thx
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Images are stored in the Database?

Post by fman »

1. attachment destination:
in general this is controlled by what you have configured => you have to check your TestLink configuration

2. attachments using FCKeditor or CKEDITOR
with FCKEDITOR you have had the possiblity to browser your files, choose and upload.

with CKEDITOR (that we have used from an specific 1.9.x version and up) this feature have dissapear.
ATTENTIO when using drag & drop, because seems only to copy the link.

Anyway if you do (as is always required) some work of searching here and on mantis will find if other have hitted same issues, if have been solved
or you can tea with them to find a solution and provide it to community.

remember: when you have an issue or a doubt you first action should be searching, and only then posting (giving some hint to readers about your searches)
aguedes
TestLink user
Posts: 2
Joined: Sun Feb 02, 2014 4:44 pm

Re: Images are stored in the Database?

Post by aguedes »

Was necessary change the type of some columns inside of the the DB to accept large inputs. (To accept store the Image direct inside in the Database - I think that this is not a good idea, if possible, I suggest the Development team to save the Images direct in the File System)

The commands used to change the DB were:

ALTER TABLE tcversions MODIFY summary MEDIUMTEXT;

ALTER TABLE tcversions MODIFY preconditions MEDIUMTEXT;

ALTER TABLE tcsteps MODIFY actions MEDIUMTEXT;

ALTER TABLE tcsteps MODIFY expected_results MEDIUMTEXT;

ALTER TABLE testsuites MODIFY details MEDIUMTEXT;

This solved my problem.
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Images are stored in the Database?

Post by fman »

>> I suggest the Development team to save the Images direct in the File System
have you configured your installation to use filesystem or database ?
because what you do on your installation is under your control => you have to change to your needs
Post Reply