Upgrade problems

[Grandpa]

I just upgraded to 2.5 (yes, I'm running behind).

Now several thumbnails are not showing. I have 94 videos, and thumbnails in the thumb file only go to 67.

Videos are playing on a smaller screen and the bottom half of the playback screen is black.

Any suggestions?

[buyscripts]

Upgrade 2.5 to 2.6

vShare 2.6 is the latest version.

The Latest version you create thumbnail with ffmpeg,ffmpeg-php,mplayer.

Nore details at http://docs.buyscripts.in/Create_Thumbnail.

Use the forum search to findout more details about Create Thumbnail

You can set the player width and height in admin area.

Also check the player.inc (include folder)

[Grandpa]

Now I find I should have stayed with 2.2.

I upgraded to 2.6 and re-installed my original database.

Now I get

SELECT * FROM video WHERE active=1 AND approve=1 AND type='public' ORDER by VID DESC LIMIT

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

What is the problem?

(Yes, I uploaded everything in binary.)

[mersh]

I upgraded to 2.6 and re-installed my original database.

My guess is that by re-installing your original database, you un-did changes that the upgrade performs on the database itself. I've worked with this script quite a bit, and I could be wrong, but you might have to go back to 2.2, install that fresh, then import your 2.2 database backup, then do each upgrade without doing a thing to the database itself. Each upgrade adds fields or changes fields within the database, so when you ran the upgrade then put your old database back (if that's what you actually did - I might be reading your post incorrectly), you actually corrupted the data.

[Grandpa]

I installed each upgrade sequentially, and went through a few pages with each upgrade to ensure that it was functional. When I completed 2.6, I uploaded my database.

Are you saying that by upgrading to 2.6, old databases cannot be used?

[buyscripts]

Upgrade.php file will also update the database.

You can upgrade step by setp through cheking the versions

http://buyscripts.in/vshare-release.html

[Grandpa]

I did upgrade step by step. I did not install my original database until I had completed 2.6 because the upgrade scripts throw errors if there are tables in MySQL. I saved my original database, cleared all of the tables from MySQL and then upgraded step by step.

Then when I reinstalled my original database, I get
SELECT * FROM video WHERE active=1 AND approve=1 AND type='public' ORDER by VID DESC LIMIT

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Grandpa]

OK, I'm on a new server and upgraded to 2.6. Everything seems to be working EXCEPT it's not creating thumbnails.

I installed the test script you mentioned, but it throws PHP warnings.

Inside - createThumb

Warning: imagecreatetruecolor() [function.imagecreatetruecolor]: Invalid image dimensions in /home/springfi/public_html/vshare_test/thumb.php on line 125

Warning: imagecopyresampled(): supplied argument is not a valid Image resource in /home/springfi/public_html/vshare_test/thumb.php on line 126

Warning: imagejpeg(): supplied argument is not a valid Image resource in /home/springfi/public_html/vshare_test/thumb.php on line 127

Warning: imagedestroy(): supplied argument is not a valid Image resource in /home/springfi/public_html/vshare_test/thumb.php on line 129


Most major obstacles have been overcome. Just this one minor problem to solve.

[buyscripts]

If you can PM your login details (ftp,cpanel and admin login details)

I can check and let you know why you are having problem with thumbnails.