SQLSTATE[HY000] ... array breaks while filescan ?

[Smergol]

Mounted a local folder as local mountpoint ... then this happend ...

[code][02-Nov-2012 19:23:50 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE4chter' for column 'name' at row 1' in W:\nginx\html\owncloud\lib\db.php:736
Stack trace:
#0 W:\nginx\html\owncloud\lib\db.php(736): PDOStatement->execute(Array)
#1 W:\nginx\html\owncloud\lib\filecache.php(105): PDOStatementWrapper->execute(Array)
#2 W:\nginx\html\owncloud\lib\filecache.php(433): OC_FileCache::put('/Serien/Die W?c...', Array, false)
#3 W:\nginx\html\owncloud\lib\filecache.php(83): OC_FileCache::scanFile('/Serien/Die W?c...')
#4 W:\nginx\html\owncloud\lib\filecache.php(433): OC_FileCache::put('/Serien/Die W?c...', Array, false)
#5 W:\nginx\html\owncloud\lib\filecache\update.php(175): OC_FileCache::scanFile('/Serien/Die W?c...', false)
#6 W:\nginx\html\owncloud\lib\filecache\update.php(117): OC_FileCache_Update::update('/Serien/Die W?c...')
#7 [internal function]: OC_FileCache_Update::fileSystemWatcherWrite(Array)
#8 W:\nginx\html\owncloud\lib\hook.php(62): call_user_func(Array, Arra in W:\nginx\html\owncloud\lib\db.php on line 736

[02-Nov-2012 19:34:27 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xFCr das...' for column 'name' at row 1' in W:\nginx\html\owncloud\lib\db.php:736
Stack trace:
#0 W:\nginx\html\owncloud\lib\db.php(736): PDOStatement->execute(Array)
#1 W:\nginx\html\owncloud\lib\filecache.php(105): PDOStatementWrapper->execute(Array)
#2 W:\nginx\html\owncloud\lib\filecache.php(433): OC_FileCache::put('/Serien/Die Wae...', Array, false)
#3 W:\nginx\html\owncloud\lib\filecache\update.php(175): OC_FileCache::scanFile('/Serien/Die Wae...', false)
#4 W:\nginx\html\owncloud\lib\filecache\update.php(117): OC_FileCache_Update::update('/Serien/Die Wae...')
#5 [internal function]: OC_FileCache_Update::fileSystemWatcherWrite(Array)
#6 W:\nginx\html\owncloud\lib\hook.php(62): call_user_func(Array, Array)
#7 W:\nginx\html\owncloud\lib\filecache\update.php(91): OC_Hook::emit('OC_Filesystem', 'post_write', Array)
#8 W:\nginx\html\owncloud\lib\filecache\update.php(89): OC_FileCache_Update::updateF in W:\nginx\html\owncloud\lib\db.php on line 736[/code]

Folder Name is "Die Wächter"

filecache.php ... 105
[code]$result=$query->execute(array($parent,basename($fullpath),$fullpath,md5($fullpath),$data['size'],$data['mtime'],$data['ctime'],$data['mimetype'],$mimePart,$user,[/code]

So i figure its a translation problem from the filesystem in the array ...

I did rename all german ÄÖÜ int ae oe ue but didnt help ...

Filename is like "01.Unfaelle passieren"

so i renamend files to 001.avi and scanning was accepting that ... ^^

Still hangs at some files but not in cycles ...

So someting there is broken. plz fix it ^^

Sys: winx64 nginx mysql php ... db is utf8_general_ci owncloud 4.5.1

greets

[Smergol]

http://php.net/manual/en/function.utf8-decode.php --- UTF-8 encoded, to ISO-8859-1 thats the problem
http://mail.python.org/pipermail/tutor/2010-March/075016.html
http://www.gossamer-threads.com/lists/python/python/162313

mfg

[mtparet]

That could explain why there are no element detected in my folder mounted as a local storage.
(rights on the folder are good)

[BernhardPosselt]

@icewind1991 is this still an issue?

[Smergol]

26-Feb-2013 16:38:47 UTC] PHP Notice: Undefined index: mimetype in W:\nginx\html\owncloud\lib\filecache.php on line 383
[26-Feb-2013 16:38:47 UTC] PHP Notice: Undefined index: id in W:\nginx\html\owncloud\lib\filecache.php on line 381
[26-Feb-2013 16:38:47 UTC] PHP Notice: Undefined index: mimetype in W:\nginx\html\owncloud\lib\filecache.php on line 383
[26-Feb-2013 16:38:47 UTC] PHP Notice: Undefined index: id in W:\nginx\html\owncloud\lib\filecache.php on line 381
[26-Feb-2013 16:38:47 UTC] PHP Notice: Undefined index: mimetype in W:\nginx\html\owncloud\lib\filecache.php on line 383
[26-Feb-2013 16:38:55 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'song_path' at row 1' in W:\nginx\html\owncloud\lib\db.php:745
Stack trace:
#0 W:\nginx\html\owncloud\lib\db.php(745): PDOStatement->execute(Array)
#1 W:\nginx\html\owncloud\apps\media\lib_collection.php(289): PDOStatementWrapper->execute(Array)
#2 W:\nginx\html\owncloud\apps\media\lib_scanner.php(125): OC_MEDIA_COLLECTION::addSong('Aretha Franklin...', '/Mukke/! ArturL...', '626', '2323', 207, 6, 4974765)
#3 W:\nginx\html\owncloud\apps\media\lib_media.php(55): OC_MEDIA_SCANNER::scanFile('/Mukke/! ArturL...')
#4 [internal function]: OC_MEDIA::updateFile(Array)
#5 W:\nginx\html\owncloud\lib\hook.php(62): call_user_func(Array, Array)
#6 W:\nginx\html\owncloud\lib\filecache\update.php(91): OC_Hook::emit('OC_Filesystem', 'post_write', Array)
#7 W:\nginx\html\owncloud\lib\filecache\update.php(89): OC_FileCache_Update::updateFolder('/Mukke/! ArturL...', false)
#8 W:\nginx\html\owncloud\lib\fi in W:\nginx\html\owncloud\lib\db.php on line 745
[26-Feb-2013 16:44:31 UTC] PHP Notice: Undefined variable: path in W:\nginx\html\owncloud\apps\user_photo\ajax\showphoto.php on line 37

.... still ...

[Smergol]

and getting

2013/02/26 17:57:37 [error] 7104#6588: *69 upstream timed out (10060: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond) while reading response header from upstream, client: 11111, server: xy.xy, request: "POST /core/ajax/translations.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9001", host: "111111:11", referrer: "http://xxxxxxx:111/?app=files"

[BernhardPosselt]

which version do you use?

[Smergol]

nginx-1.2.7 / php-5.4.11-nts-Win32-VC9-x86 / owncloud-4.5.7

server {
#_____83______________________owncloud________________________________________http
listen 83 rcvbuf=256k backlog=512;
server_name XY.zapto.org;
access_log logs/access.log;
index index.php;
keepalive_timeout 12;
root html/owncloud;

      location / {

                                                    rewrite ^/.well-known/host-meta /public.php?service=host-meta last;
        rewrite ^/.well-known/carddav /remote.php/carddav/ redirect;
        rewrite ^/.well-known/caldav /remote.php/caldav/ redirect;
        rewrite ^/apps/calendar/caldav.php /remote.php/caldav/ last;
        rewrite ^/apps/contacts/carddav.php /remote.php/carddav/ last;
        rewrite ^/apps/([^/]*)/(.*\.(css|php))$ /index.php?app=$1&getfile=$2 last;
        rewrite ^/remote/(.*) /remote.php/$1 last;

        try_files $uri $uri/ @webdav;
    }

    location @webdav {
            fastcgi_split_path_info ^(.+\.php)(/.*)$;
            #fastcgi_param HTTPS on;
            include fastcgi_params;
            fastcgi_pass php_verteiler;         
            #fastcgi_max_temp_file_size 0;
    }

    location ~ \.php$ {
        fastcgi_split_path_info ^(.+\.php)(/.*)$;
        fastcgi_pass            php_verteiler;
        fastcgi_index           index.php;
        include                 fastcgi_params;
        fastcgi_read_timeout    60;
        fastcgi_param   SCRIPT_FILENAME $document_root$fastcgi_script_name;
        fastcgi_param   SCRIPT_NAME     $fastcgi_script_name;
        fastcgi_param   PATH_INFO       $fastcgi_path_info;             
        fastcgi_max_temp_file_size 0; 
        fastcgi_param PHP_FCGI_CHILDREN 100;            
    }
    # error handler, codes can also be combined  
    error_page                  400 401 402 403 404         /er/40x.html; 
    error_page                  500 501 502 503 504 505     /er/50x.html;
}

#_______________________________________________________________________/owncloud

#_______________________________________________________________________php verteiler

upstream php_verteiler {
server 127.0.0.1:9000 weight=3;
server 127.0.0.1:9001;
server 127.0.0.1:9002;
server 127.0.0.1:9003;
}
#_______________________________________________________________________/php verteiler

[jancborchardt]

I’m closing this issue because it has been inactive for a few months. This probably means it’s not reproducible or it has been fixed in a newer version.

Please reopen if the error still persists with the latest stable version (currently ownCloud 5.0.9) and then please use the issue template. You an also contribute directly by providing a patch – see the developer manual. :)

Thank you!