質問 > 管理機能 > 商品登録CSVを使った商品登録が全くうまくいかない |
管理機能
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | 下へ |
投稿者 | スレッド |
---|---|
miri |
投稿日時: 2007/10/1 15:18
対応状況: −−−
|
新米 登録日: 2007/10/1 居住地: 投稿: 1 |
商品登録CSVを使った商品登録が全くうまくいかない 現在、rapidsiteのレンタルサーバーで以下のような環境でサイトを構築しております。
EC-CUBEバージョン : 1.3.0 PHPバージョン : PHP 4.4.7 DBバージョン : MySQL 4.1.22-standard まずは、商品を一括で登録しようとしたのですが、そこで早速躓きました。 ファイルのアップロードを行うと、文末のようなエラーがでerror_logがディスクを食いつぶすまでエラーを履き続けます。 最初に、数行のエラーが出た後は、feof/fgets/fwriteの繰り返しの状態で、そのタイミングでは、httpdがCPUを40%〜50%食い続けていました。 ログの最初の方にpermission errorが記録されていたので、TEMP_IMAGE のディレクトリのpermissionを 777 に変更し、再度試してみた所error_log#2の様になりました。 CSVファイルがTEMP_IMAGEのフォルダにアップロードされている事も確認できました。 一応1〜2歩位は前に進んでいるようですが、この後はソースを読むくらいしか対応を思いつきません。 どなたか解決にご協力いただけないでしょうか? また、商品登録CSVの記載について詳細に記録されているドキュメントなどが見当たらなかったのですが、どこかにあるでしょうか? 長々と書きましたが、宜しくお願いいたします。 ===CSVFILE=== "商品ID","商品規格ID","規格名1","規格名2","商品名","公開フラグ","商品ステータス","商品コード","通常価格","販売価格","在庫数","送料","ポイント付与率","購入制限","メーカーURL","検索ワード","一覧-メインコメント","一覧-メイン画像","メインコメント","メイン画像","メイン拡大画像","カラー比較画像","商品詳細ファイル","詳細-サブタイトル(1)","詳細-サブコメント(1)","詳細-サブ画像(1)","詳細-サブ拡大画像(1)","詳細-サブタイトル(2)","詳細-サブコメント(2)","詳細-サブ画像(2)","詳細-サブ拡大画像(2)","詳細-サブタイトル(3)","詳細-サブコメント(3)","詳細-サブ画像(3)","詳細-サブ拡大画像(3)","詳細-サブタイトル(4)","詳細-サブコメント(4)","詳細-サブ画像(4)","詳細-サブ拡大画像(4)","詳細-サブタイトル(5)","詳細-サブコメント(5)","詳細-サブ画像(5)","詳細-サブ拡大画像(5)","発送日目安","おすすめ商品(1)","詳細-サブコメント(1)","おすすめ商品(2)","詳細-サブコメント(2)","おすすめ商品(3)","詳細-サブコメント(3)","おすすめ商品(4)","詳細-サブコメント(4)","おすすめ商品(5)","詳細-サブコメント(5)","おすすめ商品(6)","詳細-サブコメント(6)","商品カテゴリ" "","","","","商品1","1","0","71000","32000","32000","10","0","0","1","","","","071000S.JPG","","071000M.JPG","071000.JPG","","","","","","","","","","","","","","","","","","","","","","","2","","","","","","","","","","","","","食品" "","","","","商品2","1","0","71001","32000","32000","10","0","0","1","","","","071000S.JPG","","071000M.JPG","071000.JPG","","","","","","","","","","","","","","","","","","","","","","","2","","","","","","","","","","","","","食品" "","","","","商品3","1","0","71003","32000","32000","10","0","0","1","","","","071000S.JPG","","071000M.JPG","071000.JPG","","","","","","","","","","","","","","","","","","","","","","","2","","","","","","","","","","","","","食品" ===error_log#1=== [Mon Oct 01 01:21:25 2007] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Mon Oct 01 01:21:26 2007] [notice] mod_python: Creating 4 session mutexes based on 50 max processes and 0 max threads. [Mon Oct 01 01:21:27 2007] [notice] Apache/2.0.52 (Red Hat) configured -- resuming normal operations [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: copy(/var/www/html/eccube/html/upload/temp_image//10010218_46ffda5e9ba6c.csv) [<a href='function.copy'>function.copy</a>]: failed to open stream: Permission denied in /var/www/html/eccube/data/class/SC_UploadFile.php on line 93, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fopen(/var/www/html/eccube/html/upload/temp_image//10010218_46ffda5e9ba6c.csv) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /var/www/html/eccube/data/lib/slib.php on line 2128, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fopen(/var/www/html/eccube/html/upload/csv/enc_10010218_46ffda5e9ba6c.csv) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/eccube/data/lib/slib.php on line 2133, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2135, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgets(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2136, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2135, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgets(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2136, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2135, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgets(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2136, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 02:18:22 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2135, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php ===error_log#2=== [Mon Oct 01 03:05:51 2007] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Mon Oct 01 03:05:54 2007] [notice] mod_python: Creating 4 session mutexes based on 50 max processes and 0 max threads. [Mon Oct 01 03:05:55 2007] [notice] Apache/2.0.52 (Red Hat) configured -- resuming normal operations [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fopen(/var/www/html/eccube/html/upload/csv/enc_10011511_47008f9492ccc.csv) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: Permission denied in /var/www/html/eccube/data/lib/slib.php on line 2133, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2138, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fclose(): supplied argument is not a valid stream resource in /var/www/html/eccube/data/lib/slib.php on line 2141, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fopen(/var/www/html/eccube/html/upload/csv/enc_10011511_47008f9492ccc.csv) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /var/www/html/eccube/html/admin/products/upload_csv.php on line 424, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 425, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgetcsv(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 426, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 425, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgetcsv(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 426, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 425, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgetcsv(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 426, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 425, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: fgetcsv(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 426, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php [Mon Oct 01 03:11:32 2007] [error] [client xx.xxx.xx.x] PHP Warning: feof(): supplied argument is not a valid stream resource in /var/www/html/eccube/html/admin/products/upload_csv.php on line 425, referer: http://www.xxxx.jp/eccube/html/admin/products/upload_csv.php |
gallu |
投稿日時: 2007/10/25 17:57
対応状況: −−−
|
半人前 登録日: 2007/9/13 居住地: 東京 投稿: 28 |
Re: 商品登録CSVを使った商品登録が全くうまくいかない がると申します。
ひとつには、パーミッションエラーに属するものが出たときに、どうも「永久ループ」をしている様子なので。 このあたりはぜひとも改善をお願いしたいところなのですが。 もうひとつ、これに伴って。 私のBlogでも書いたのですが、このプログラムでつかっているfgetcsvで普通にCSVを読み込ませると「日本語が読めなくなる」可能性があります。 抜本的な対策はいろいろあろうかと思うのですが。 とりあえず極場当たり的には、 インストールディレクトリ/html/admin/products/upload_csv.php のファイルで、行頭付近の適当な場所に setlocale(LC_ALL, 'ja_JP'); の1文を入れることである程度ヘッジできる感じです(ある程度なので、検証は各自お願いします)。 以上、ちょいと気づいたので書き込みをしておきます。 |
スレッド表示 | 新しいものから | 前のトピック | 次のトピック | トップ |