Hall of Fame

[Marius P.]

Manual changes apply to :


- vibe_config.php
- .htaccess (main in root)
- database





root/vibe_config.php:
Add

Code Select Expand

define( 'page', 'read' );
define( 'embedcode', 'embed' );

after

Code Select Expand

// SEO url structure

Save the vibe_config.php file and keep it.



.htaccess file : (main one, near load.php)


Add

Code Select Expand

RewriteRule ^embed/([^/]*)/$ /embed.php?id=$1 [L]

After

Code Select Expand

RewriteBase /

Database changes:

Code Select Expand

ALTER TABLE  `#db-prefix#videos` ADD  `token` VARCHAR( 255 ) NOT NULL AFTER  `id` ;
ALTER TABLE  `#db-prefix#videos` ADD  `tmp_source` MEDIUMTEXT NOT NULL AFTER  `source` ;
ALTER TABLE  `#db-prefix#videos` CHANGE  `pub`  `pub` INT( 11 ) NOT NULL DEFAULT  '0';
CREATE TABLE IF NOT EXISTS `#db-prefix#ads` (
  `ad_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad_spot` varchar(64) NOT NULL DEFAULT '',
  `ad_type` varchar(64) NOT NULL DEFAULT '0',
  `ad_content` longtext NOT NULL,
  `ad_title` varchar(64) NOT NULL,
  `ad_pos` varchar(64) NOT NULL,
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;


CREATE TABLE IF NOT EXISTS `#db-prefix#pages` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `menu` int(11) NOT NULL DEFAULT '0',
  `date` text COLLATE utf8_swedish_ci NOT NULL,
  `title` varchar(300) COLLATE utf8_swedish_ci NOT NULL,
  `pic` longtext COLLATE utf8_swedish_ci NOT NULL,
  `content` longtext COLLATE utf8_swedish_ci NOT NULL,
  `tags` varchar(500) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=0 ;

Replace BEFORE using the sql code #db-prefix# to your actual prefix , ex : vibe_


Overwrite all files except /vibe_config.php
Chmod the new now folder /rawmedia to writeable (ex: 0777)

[Marius P.]

If you are not familiar with sql you can use this:


1. Create a file called up.php


with the following content:

Code Select Expand

<?php  error_reporting(E_ALL); 
//Vital file include
require_once("load.php");


$db->query("ALTER TABLE  `".DB_PREFIX."videos` ADD  `token` VARCHAR( 255 ) NOT NULL AFTER  `id`");
$db->query("ALTER TABLE  `".DB_PREFIX."videos` ADD  `tmp_source` MEDIUMTEXT NOT NULL AFTER  `source`");
$db->query("ALTER TABLE  `".DB_PREFIX."videos` CHANGE  `pub`  `pub` INT( 11 ) NOT NULL DEFAULT  '0'");
$db->query("CREATE TABLE IF NOT EXISTS `".DB_PREFIX."ads` (
  `ad_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ad_spot` varchar(64) NOT NULL DEFAULT '',
  `ad_type` varchar(64) NOT NULL DEFAULT '0',
  `ad_content` longtext NOT NULL,
  `ad_title` varchar(64) NOT NULL,
  `ad_pos` varchar(64) NOT NULL,
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ");




$db->query("CREATE TABLE IF NOT EXISTS `".DB_PREFIX."pages` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `menu` int(11) NOT NULL DEFAULT '0',
  `date` text COLLATE utf8_swedish_ci NOT NULL,
  `title` varchar(300) COLLATE utf8_swedish_ci NOT NULL,
  `pic` longtext COLLATE utf8_swedish_ci NOT NULL,
  `content` longtext COLLATE utf8_swedish_ci NOT NULL,
  `tags` varchar(500) COLLATE utf8_swedish_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=0 ");


$db->debug();
?>

2. Upload up.php in your PHPVibe root (near load.php)
3. Run up.php in browser, ex: yourinstall.com/up.php it should show you an errorless debug.
4. Delete up.php from server.


this php file will make the sql changes for the upgrade.

[Noel]

Will you post the download link here?

[Marius P.]

I will add it in the pack on the store.

[Marius P.]

It's uploaded.

[Noel]

Congratulations with the new release!! ... But I can not find it :/

[Marius P.]

Download http://store.phprevolution.com/buy.php?id=14 It's in the zip

[Noel]

Got it... phpvibe_cms.zip

Let make some backups 1st and than install it.

Will report back.

[Marius P.]

Ok, I'm here for another 2h , after that going in vacation, no more internet.

[Noel]

Update done (no problems)
Now it's testing time....

Will report back

[Marius P.]

Make sure the two crons have execute permissions set, videocon.php and cron.php and the php bin path it's set in admin.

[Noel]

Till now I've not been using the crons.
Any extra info on how to set this up?

The Scheduled tasks (Crons management) is showing: No crons yet
How do I add the crons to this?

Also.. Have a nice holiday! You (and rest of team) deserves it!

[Marius P.]

Thank you! Same to you!
If you don't use the cron, but use conversion with ffmpeg, you need to setup the videocron.php to be executable from php.


You also need exec and shell_exec enabled for ffmpeg (plus de actual ffmpeg and plugins).


Just try, if it doesn't work, you'll know why and what to do

[Noel]

That should be okay on my server.

You also need exec and shell_exec enabled for ffmpeg (plus de actual ffmpeg and plugins).

I'm getting this with videocron.php: Warning: Unknown column 'tmp_source' in 'field list' in /var/www/clients/client1/web102/web/lib/class.ezsql.php on line 249

Going to give it some more testing tomorrow.
I will get it working!

One more question. How do I add a scheduled task to the admin?

[Marius P.]

My bad!


run this in bd:

Code Select Expand

ALTER TABLE `vibe_videos` ADD `tmp_source` MEDIUMTEXT NOT NULL AFTER `source` ;

change vibe_ to your prefix.

[Marius P.]

I've updated the db.sql in setup and first post here...idk how I've missed that :|

[Noel]

That fixed the warning!
Does FFMPEG leave a log? Looks like something is not working here as the uploaded MP4 does not convert.
Where does it get moved to after conversion?

[Marius P.]

It doesn't convert .mp4, I've added a skip to it for .mp4 files as per the discussions in development, just the other formats in .mp4

It uploads to /rawmedia and moves to /media if you don't change the folders in admin.

[Marius P.]

You can edit lib/upload-ffmpeg.php

and change

Code Select Expand

if($ext !== "mp3" && $ext !== "mp4") {

to

Code Select Expand

if($ext !== "mp3") {

and you get the same processing/conversion/recoding for .mp4 files.

[Noel]

Will do..

And now.. it's time for you to shutdown that PC and go on your holiday!

L8ter......

[Marius P.]

Yeah Thanks! Merry Christmas!

[Noel]

You to.. Happy Holidays


And.. My PHP5 is not in "/usr/bin/php5"
Will change it to the correct place.

[Noel]

LOL...

I'm testing this on one of my servers that does not have FFMPEG :-)
And me thinking .. w.t.f. can be wrong ......
Pffff.. who needs a holiday now :-/

[Fleswodka]

MARIO TYTYTY you rock!! love to see its your passion!!

[Marius P.]

MARIO TYTYTY you rock!! love to see its your passion!!

Thank you! Please report any issue with this so I can patch it before New Year's.

Pffff.. who needs a holiday now :-/

I honestly do, I have 5 months of work straight on 3 projects and I really need a break, and Alex and Natali from here as well.

[leen12]

nice work mario, i upgraded from 3.3 to 3.4 but my css must be off or something, the searchbar does not expand it is already the full length of the window,

and the extra buttons beside the icon are below the searchbar barely visible and overlapping eachother,

channels are also expaneded by default?

if your on could you possibly help me with this? thanks

[leen12]

wow? lol hold that, seems like as soon as i posted that my server must have cached the pages or something for 12 hours its fixed now thanks

merry christmas everyone

[Martin]

There is something wrong with the EMBEDDING

[Marius P.]

There is something wrong with the EMBEDDING

Details?

[ampstar]

We will build an upgrader after the Christmas break. Releasing 3.4 beta in a couple of minutes.

did you build the upgrader yet? I cant find it so i assume you haven't but better to ask right?

[PHPVibe A.]

Will be available after 3.4 will be a full release, but the upgrader will just create the database changes (so same thing as manually running the sql commands in phpmyadmin).

[ampstar]

Will be available after 3.4 will be a full release, but the upgrader will just create the database changes (so same thing as manually running the sql commands in phpmyadmin).

Ok thanks I thought as much.

[ajitsingh]

best is, you make a Step by Step video demo: how to upgrade PHPVIBE
use www.screenr.com

this will save lost of time..

[PHPVibe A.]

I know about screener, but don't make the mistake of believing that is the same for all so a video may be helpful for some, confusing for others.

[ampstar]

Is there any other guides apart from this one. im ok up to the point of the database changes.

[PHPVibe A.]

Paste the code (sql) in a text editor, use replace in file, replace #db-prefix# with vibe_ (if you have not changed it), then paste it in phpmyadmin (select database, and the "SQL" tab).
It should take a minute

[ampstar]

Ok thanks alexander makes sense to me now. ill give it a go.

[ampstar]

Every thing went ok thank men.

[PHPVibe A.]

Anytime!

[Marius P.]

Second post updated with a php solution for database upgrade.

[ajitsingh]

I know about screener, but don't make the mistake of believing that is the same for all so a video may be helpful for some, confusing for others.

no offence, but as a marketer point of view there should be videos step by step.
"Monkey see, monkey do" later any problem u have forum to ask, video demo should be must for any product...

not only upgrade also for install and settings etc.. this will help your customers.
also expend PHPVibe reach. (youtube channel)

for example WordPress u can find lot of video and customers find easy to use it.