Hi all After make the changes on the preproduction platform in Cenatic i have test on the visual part on FusionForge and apparently all works fine:
Date Size D/L Arch Type Latest GestionSFA-1.0.tar.gz <https://mailtrack.io/trace/link/933b3cbe44a9b435648833158d9b6bbdbde0b7cb> 2009-05-29 13:25 8.02 GiB 174 Any .gz Latest version <https://mailtrack.io/trace/link/bfb9ea5baf402ce3261b1f1664dbe3de5f8c7e8c> On this part we could see the 8.02 Gib working Are any other place to looking for bugs? frsfile_get_object only make a SELECT * FROM frs_file, but the file_size field is correct on the visual, are the frsfile_get_object getting correctly the select parameters from the postgresql? Thanks a lot!! Enviado con MailTrack <https://mailtrack.io/install?source=signature&lang=es&referral=joseangel.d...@cenatic.es&idSignature=23> 2014-06-02 11:51 GMT+02:00 franck.villa...@trivialdev.com < franck.villa...@trivialdev.com>: > > > > Le 2 juin 2014 à 11:40, Jose Angel Diaz <joseangel.d...@cenatic.es> a > écrit : > > Hi Sylvain > > I have made this steps and now it doesn't affect to the platform: > > > fusionforge=# DROP VIEW frs_file_vw; > DROP VIEW > > fusionforge=# ALTER TABLE frs_file ALTER COLUMN file_size TYPE bigint; > ALTER TABLE > file_size | bigint | not null valor por omisión 0 > > fusionforge=# CREATE VIEW frs_file_vw AS SELECT frs_file.file_id, > frs_file.filename, frs_file.release_id, frs_file.type_id, > frs_file.processor_id, frs_file.release_time, frs_file.file_size, > frs_file.post_date, frs_filetype.name AS filetype, frs_processor.name AS > processor, frs_dlstats_filetotal_agg.downloads FROM frs_filetype, > frs_processor, frs_file LEFT JOIN frs_dlstats_filetotal_agg ON > frs_dlstats_filetotal_agg.file_id = frs_file.file_id WHERE > frs_filetype.type_id = frs_file.type_id AND frs_processor.processor_id = > frs_file.processor_id; > > fusionforge=#\d frs_file_vw > Vista «public.frs_file_vw» > Columna | Tipo | Modificadores > --------------+---------+--------------- > file_id | integer | > filename | text | > release_id | integer | > type_id | integer | > processor_id | integer | > release_time | integer | > file_size | bigint | > post_date | integer | > filetype | text | > processor | text | > downloads | integer | > Definición de vista: > SELECT frs_file.file_id, frs_file.filename, frs_file.release_id, > frs_file.type_id, frs_file.processor_id, frs_file.release_time, > frs_file.file_size, frs_file.post_date, frs_filetype.name AS filetype, > frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads > FROM frs_filetype, frs_processor, frs_file > LEFT JOIN frs_dlstats_filetotal_agg ON > frs_dlstats_filetotal_agg.file_id = frs_file.file_id > WHERE frs_filetype.type_id = frs_file.type_id AND > frs_processor.processor_id = frs_file.processor_id; > > > When i have DROPPED the view the forge works on the file section > perfectly, Where is the frs_file_vw used from? > > > > frs_file_vw is used to contruct the FRSFile object. (see > ~/src/common/frs/FRSFile.class.php) > > file_size column is just a helper to display size on the PHP GUI. It's not > used when downloading the file (see ~/src/www/frs/download.php) > > Currently, the function frsfile_get_object does not use the frs_file_vw > but do a select * from frs_file. I suspect a lot of bugs in here. (btw I'm > currently working on the rewrite of the FRS module in master). > > > > Regards, > > Franck > > > > > TrivialDev Founder > http://trivialdev.com > -- --------------------------------------------------------------------------------------------------------- Correo Corporativo Fundación Cenatic Este email ha sido enviado desde una plataforma perteneciente a la Fundación Cenatic Cualquier duda o modificacion contactar con Fundación Cenatic +34 924 67 73 16 i...@cenatic.es
_______________________________________________ Fusionforge-general mailing list Fusionforge-general@lists.fusionforge.org http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general
