> 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,<http://frs_filetype.name> AS
> filetype,<http://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,<http://frs_filetype.name> AS
> filetype,<http://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
_______________________________________________
Fusionforge-general mailing list
Fusionforge-general@lists.fusionforge.org
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general
