Upgrade vShare 2.6 to vShare 2.7

[admin]

I get this error:
I tried the fix from vshare Skins, but it don´t worked (it is for 2.6).

Please help me :)
Speedridingvideos - Share Your Videos

Where you get this error ?

[nitramf]

Where you get this error ?

The user buyscripts helped me.

The problem was that multiviews was enabled in the apache. Got it at searching.

[pjohn]

Hi there!

Got this error:

Error at the line 7: ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

Query: ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

MySQL: Table 'youclone.channel' doesn't exist

There is only channels no channel..


EDIT: Just edited the line in install/sql/upgrade_2.6_to_2.7.sql

ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

from channel to channels? But then emailinfo error pops out..

[pjohn]

Hi there!

Tried the upgrade again and its giving me the same error over and over:
Error at the line 7: ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

Query: ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

MySQL: Table 'tubedb.channel' doesn't exist

It seems like the command (in the file install/sql/upgrade_2.6_to_2.7.sql):

line 65: ALTER TABLE `channel` RENAME TO `channels`;

is done before the command in the first lines:
line 7: ALTER TABLE channel CONVERT TO CHARACTER SET utf8;

so the name of the table is changed to channels before the line 7.. have no idea why.

any idea why?

[pjohn]

So i deleted this from upgrade_2.6_to_2.7sql

ALTER TABLE adv CONVERT TO CHARACTER SET utf8;
ALTER TABLE buddy_list CONVERT TO CHARACTER SET utf8;
ALTER TABLE channel CONVERT TO CHARACTER SET utf8;
ALTER TABLE comments CONVERT TO CHARACTER SET utf8;
ALTER TABLE config CONVERT TO CHARACTER SET utf8;
ALTER TABLE contact CONVERT TO CHARACTER SET utf8;
ALTER TABLE disallow CONVERT TO CHARACTER SET utf8;
ALTER TABLE emailinfo CONVERT TO CHARACTER SET utf8;
ALTER TABLE favourite CONVERT TO CHARACTER SET utf8;
ALTER TABLE feature_req CONVERT TO CHARACTER SET utf8;
ALTER TABLE friends CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_mem CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_own CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_tps CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_tps_post CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_vdo CONVERT TO CHARACTER SET utf8;
ALTER TABLE guest_info CONVERT TO CHARACTER SET utf8;
ALTER TABLE inappro_req CONVERT TO CHARACTER SET utf8;
ALTER TABLE last_5users CONVERT TO CHARACTER SET utf8;
ALTER TABLE package CONVERT TO CHARACTER SET utf8;
ALTER TABLE pages CONVERT TO CHARACTER SET utf8;
ALTER TABLE playlist CONVERT TO CHARACTER SET utf8;
ALTER TABLE pm CONVERT TO CHARACTER SET utf8;
ALTER TABLE poll_question CONVERT TO CHARACTER SET utf8;
ALTER TABLE process_queue CONVERT TO CHARACTER SET utf8;
ALTER TABLE profile_comments CONVERT TO CHARACTER SET utf8;
ALTER TABLE relation CONVERT TO CHARACTER SET utf8;
ALTER TABLE sconfig CONVERT TO CHARACTER SET utf8;
ALTER TABLE servers CONVERT TO CHARACTER SET utf8;
ALTER TABLE signup CONVERT TO CHARACTER SET utf8;
ALTER TABLE subscriber CONVERT TO CHARACTER SET utf8;
ALTER TABLE tags CONVERT TO CHARACTER SET utf8;
ALTER TABLE tag_video CONVERT TO CHARACTER SET utf8;
ALTER TABLE uservote CONVERT TO CHARACTER SET utf8;
ALTER TABLE verify_code CONVERT TO CHARACTER SET utf8;
ALTER TABLE video CONVERT TO CHARACTER SET utf8;
ALTER TABLE vote_result CONVERT TO CHARACTER SET utf8;
ALTER TABLE words CONVERT TO CHARACTER SET utf8;

And it has upgraded.. it works nice

[pjohn]

Got an other issue now. When i want to check a video the page simply doesnt loads.. it works only in Opera, in Ie and FF it expires and shows only a blank page. Only the root is loading in those.. Any idea how to fix this?

[browniegirl]

I cant find the tpl files or the template folder in verison 2.7.. Where are they? And it seems as if the logo position has to be a pre-set size -- how and where do I have this to make the logo the size of my choosing?

[buyscripts]

tpl files are in template folder.

If its not there. Your site will not work.

You can set the width and height of the logo in css/style.cs

}
#header h1 a {
display: block;
width: SET LOGO WIDTH;
height: SET LOGO HEIGHT;
border: none;
}

[buyscripts]

Got an other issue now. When i want to check a video the page simply doesnt loads.. it works only in Opera, in Ie and FF it expires and shows only a blank page. Only the root is loading in those.. Any idea how to fix this?

Post url here.We will check here in Firefox.

If you are using the older version of Firefox, please upgraded it and try.

[pjohn]

Post url here.We will check here in Firefox.

If you are using the older version of Firefox, please upgraded it and try.

Already fixed that problem
http://forums.buyscripts.in/general-...html#post19916