[TYPO3-english] Duplicate entries and missing files in 6.2 Filelist [SOLVED]

[Scotty C]

Everyone,

Sorry to flood this list with my ramblings, but I solved it. It's tied to a known bug in TYPO3 6.2. When creating the sys_file table, you'll need to create it manually because the system-based script is wrong. Here's what it should look like:

CREATE TABLE sys_file ( uid int(11) NOT NULL auto_increment, pid int(11) NOT NULL default '0', tstamp int(11) NOT NULL default '0', last_indexed int(11) NOT NULL default '0', missing tinyint(4) NOT NULL default '0', storage int(11) NOT NULL default '0', type varchar(10) NOT NULL default '', metadata int(11) NOT NULL default '0', identifier text, identifier_hash varchar(40) NOT NULL default '', folder_hash varchar(40) NOT NULL default '', extension varchar(255) NOT NULL default '', mime_type varchar(255) NOT NULL default '', name tinytext, sha1 tinytext, size bigint(20) unsigned NOT NULL default '0', creation_date int(11) NOT NULL default '0', modification_date int(11) NOT NULL default '0', PRIMARY KEY (uid), KEY sel01 (storage,identifier_hash), KEY folder (storage,folder_hash), KEY tstamp (tstamp), KEY lastindex (last_indexed), KEY sha1 (`sha1`(40)) ); 


(Note the backticks wrapping sha1 at the end)

The more I learn about T3 6.2, the more buggy it seems? That's odd, considering I have the LTS version - not encouraging!

HTH,
-Scott.


>________________________________
> From: Scotty C <superscotty19 at yahoo.com>
>To: "typo3-english at lists.typo3.org" <typo3-english at lists.typo3.org> 
>Sent: Monday, November 10, 2014 10:17 PM
>Subject: Re: Duplicate entries and missing files in 6.2 Filelist
> 
>
>
>Hey,
>
>
>Update: If I clear system cache then reload the frame, I get the correct file listing (i.e. I see styles.css and template.html). However, it only lasts for a moment and images/ is still a blank column entirely.
>
>
>-Scott.
>
>
>
>>________________________________
>> From: Scotty C <superscotty19 at yahoo.com>
>>To: "typo3-english at lists.typo3.org" <typo3-english at lists.typo3.org> 
>>Sent: Monday, November 10, 2014 9:23 PM
>>Subject: Duplicate entries and missing files in 6.2 Filelist
>> 
>>
>>
>>Hi everyone,
>>
>>
>>I've just completed my first upgrade to 6.2.6 LTS from 4.5LTS. Everything works except one strange occurrence with my files. In my PuTTY shell I can see my file listing:
>>-rw-r--r-- 1 user user 8753 Oct 24 00:26 styles.css
>>-rw-r--r-- 1 user user 1719 Oct 23 23:42 template.html
>>drwxr-xr-x 2 user user 4096 Oct 23 21:45 images/
>>
>>
>>Inside images/ I have:
>>
>>
>>-rw-r--r-- 1 user user 651242 Oct 23 21:45 background.png
>>-rw-r--r-- 1 user user 195100 Oct 23 21:45 banner2.png
>>-rw-r--r-- 1 user user 323131 Oct 23 21:45 banner.png
>>
>>
>>... However, in the Filelist, I see 
>>- styles.css *twice* 
>>- template.html is not visible
>>- images/ is present but when I enter the directory it appears as empty. Note: I do not mean "empty directory"; I mean, "empty column", "nothing".
>>
>>
>>At first I thought this was a permissions error, but then the images/ directory gave a blank page/column, so that made me reach out to you all.
>>
>>
>>As always, any input is greatly appreciated - thanks!
>>-Scott.
>>
>>
>>
>>
>>
>>
>
>