バージョン選択

フォーラム

メニュー

オンライン状況

87 人のユーザが現在オンラインです。 (79 人のユーザが フォーラム を参照しています。)
登録ユーザ: 0
ゲスト: 87
もっと...

サイト内検索

質問 > 管理機能 > 商品登録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文を入れることである程度ヘッジできる感じです(ある程度なので、検証は各自お願いします)。

以上、ちょいと気づいたので書き込みをしておきます。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


EC-CUBE公式 Amazon Payプラグイン

統計情報

総メンバー数は88,856名です
総投稿数は109,989件です

投稿数ランキング

1
seasoft
7367
2
468
3217
3
AMUAMU
2712
4
nanasess
2313
5
umebius
2085
6
yuh
1819
7
h_tanaka
1646
8
red
1570
9
mcontact
1291
10
tsuji
958
11
fukap
907
12
shutta
835
13
tao_s
799
14 ramrun 789
15 karin 689
16 sumida 641
17
homan
633
18 DELIGHT 572
19
patapata
502
20
flealog
485


ネットショップの壺

EC-CUBEインテグレートパートナー

Copyright© EC-CUBE CO.,LTD. All Rights Reserved.