When I try to upload a clip I eventually get the following error message

Warning: mysql_data_seek(): Offset 0 is invalid for MySQL result index 33 (or the query data is unbuffered) in /path/to/admin/cs_av.php on line 411

This happened in the free version and the shareware version.

Any suggestions?

Also, is there a limit to the size of the file that can be uploaded?


Another also, is it possible to manually upload the files and then just select it in the "create a new clip" window?

If I can get this all to work I will deffinately be buying the full version.

Just for your info I am running the following

MySQL client version: 4.1.15
PHP: 5

Thanks in advance

Hi

The error message may well be happening because the file hasn't been fully uploaded. To get rid of the error message, you can just insert a '@' immediately before the 'mysql_data_seek(' function call in the file specified in the error message - making it '@mysql_data_seek('... This will only hide the error message but not fix the problem.

To fix the problem, you can try the following things:

1) If you can look in your server's php.ini file, find the settings for 'upload_max_filesize' and 'post_max_size'. These settings govern maximum filesizes for uploads and should be changed to reflect the size of files you intend to upload.

2) If you can't alter your server's php.ini file, then you should try to upload the file via FTP as you suggest. First do the FTP, then create the clip and attempt to do the upload as normal. After you get the error message, click on Tools->CineSound AV in the admin menu and you should still see an entry for the clip you just created. Click on 'Edit' for the new clip to see if it's working okay using the FTP'd copy.

Hope this helps.

Nic

Hi Nic

Thanks for the quick reply. I tried a small 55KB mov file as a test and still got the same result. (The upload is currently set to 2MB but I will try to increase it)


I even tried uploading it manually first and then going through the process again as you suggested and that still failed and there was nothing saved.

All I got apart from the SQL error was the following

The Unit settings were not saved properly.
Please ensure you fill out all the required fields before attempting to save.
(See below pic. I added the original details in again to show what I had originally put)




The 28 is there because it is product id 28

Hi

I think the minimum length for a URL substring in the free versions is 6. Try setting it to 'products_id=28' and see if that helps.

Nick

Super. I changed it fro 28 to products_id=28 and it worked. Well sort of.

The MP4 file just showed as green and locks up the IE window. I will try a few more MP4 files

the sample.mov file (The one you get with quicktime) But because i had Auto start set to no, I could not see the video. Is there a way to use 'show controls' on the shareware version, or is that just for the full version?


Is there a maximum file size that can be used with this app?

(Great support by the way. Really appreciate the quick repsonses)

Hi

Playing mp4 file successfully in QuickTime depends somewhat on how you encoded the mp4 file. The audio should use ACC encoding for QuickTime to play it.

There is no limit to filesizes playable via Cinesound, but playback on some players depends on the bandwidth available and whether or not the player buffers the entire clip before playing (e.g. with .avi files) or plays once a certain amount of the clip has been downloaded.

The premium version of CineSound does include the controls for QuickTime, but most users just use Flash, which doesn't have the same plugin dependencies as the other players and is playable in the largest number of browsers. To use Flash with controls, you would need to create a .swf file which contains a skin for the controls.

If you continue having problems, let me know what you want to achieve and send me your osCommerce admin login details via the support email or contact form on this site and I'll take a look at it for you.

Cheers

Nick

Thanks for the info and support.


I will continue testing and developing my site using your product as I think it has a lot of potential (Using a test/development URL before moving to the real one, so can't buy the full version just yet).

I will keep you updated on my tests/findings.

Cheers