Please help for mysql database

I have some flv files from an old project, which has all fields. I want to import into boonex.

I have insert into

RayMovieFiles

RayMoviePlayLists

and make copy to

/ray/modules/movie/files/*.flv, *.jpg, *_smal.jpg, *.mpg

all seems done but when play movies, the player said

"Error! File not found."

I tried to upload movie, it works fine. I checked files, they are in same directory and in database.

All seems same but copied file can't play.

Do I missing some data insert into database or missing something else?

Please help me!

Thanks

Peter

How many video files to you want to import?

No, just file itself is missing.

each unit must have several types of files by ID (as name)

Hello:

Thanks for your reply.

video files going to import are just like 90.

The video ID 87 was imported, ID 88 was uploaded by browser. ID 88 works fine, but ID said not found.
Really dont know what's wrong. I spent two days try to find out but no lucky.

Mysql:

RayMovieFiles table:
+----+------------+------------------+------------------+------------+----------------+------+------------+---------+-------+-------+----------+
| ID | CategoryId | Title               | Uri              | Tags       | Description    | Time | Date       | Reports | Owner | Views | Approved |
+----+------------+------------------+------------------+------------+----------------+------+------------+---------+-------+-------+----------+
| 87 |         -1 | my video       | my_video      | whatever   | desc           |    7 | 1233725833 |       0 | 31366 |  1473 | true     |
| 88 |         -1 | Trailer_4Minutes  | Trailer_4Minutes | ddddd      | pppppp         |   66 | 1238616773 |       0 | 3     |     8 | true     |
+----+------------+------------------+------------------+------------+----------------+------+------------+---------+-------+-------+----------+

RayMoviePlayLists table:
+--------+-------+-------+
| FileId | Owner | Order |
+--------+-------+-------+
|     87 | 31366  |     1   |
|     88 | 3         |     1   |
+--------+-------+-------+

in file system
/ray/modules/movie/files, the files are listed as
-rw-r--r-- 1 www-data www-data   870730   2009-04-01 21:10   87.flv
-rw-r--r-- 1 www-data www-data     8030    2009-04-01 21:10    87.jpg
-rw-r--r-- 1 www-data www-data   956416   2009-04-01 21:10   87.mpeg
-rw-r--r-- 1 www-data www-data     8030    2009-04-01 21:10    87_small.jpg
-rw-r--r-- 1 www-data www-data  8258506  2009-04-01 16:12    88.flv
-rw-r--r-- 1 www-data www-data     1952    2009-04-01 16:12    88.jpg
-rw-r--r-- 1 www-data www-data  9095168  2009-04-01 16:12    88.mpg
-rw-r--r-- 1 www-data www-data      684     2009-04-01 16:12    88_small.jpg

Please help!

Thanks

Peter

Try to rename

87.mpeg

to

87.mpg

Hi, Andrey:

You save me a lot of time.

Yes, it works. that means it must generate a file for *.mpg, even I create an empty file called 87.mpg

Thank you so much !!!

Peter