It is not working for me as well —
Also having the same problem 🙁
VP
(@studio500)
Same here and no change despite latest update released 9hrs ago.
New update, same problem 🙁
The solution that works for me, from Apptha Support Team:
Please go to the below file path:
\wp-content\plugins\contus-video-gallery\front\models\videoshortcode.php
Find the code:
public function getshort_video_detail ( $vid, $number_related_video ) {
global $wpdb;
NOTE: After the above code , please paste the below query and refresh the video detail page so that the query will execute.
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY google_adsense_value INT( 3 ) NULL’;
$this->_wpdb->query( $query );
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY google_adsense INT( 3 ) NULL’;
$this->_wpdb->query( $query );
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY midrollads INT( 11 ) NULL’;
$this->_wpdb->query( $query );
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY imaad INT( 11 ) NULL’;
$this->_wpdb->query( $query );
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY prerollads VARCHAR(25) NULL’;
$this->_wpdb->query( $query );
$query = ‘ALTER TABLE ‘ . $this->_videoinfotable . ‘ MODIFY postrollads VARCHAR(25) NULL’;
$this->_wpdb->query( $query );
After this, the add new video function works again (for me, I hope for you too) 🙂
Thank you Biggia for sharing Apptha solution. Unfortunately, the solution didn’t solve the problem for me.
Thanks Biggia. The code you provided didn’t seem to work for me either, however, after reviewing the PHP error logs it appeared to be related to my ‘postrollads’ table not allowing ‘NULL’ values. I went into my DB and updated that table to allow ‘NULL’. I did this in phpMyAdmin… not sure if there is a way to do it in the query, as well… nonetheless, this seemed to fix things for me and I can now add uploaded videos again. Thanks again.
Thank you stratogod for sharing your solution. My error log shows “… WordPress database error Column ‘imaad’ cannot be null for query …”. ALTER TABLE didn’t fix the “imaad” problem for me.
Hello,
unfortunately, I have the same problem. But I can link only 10 videos in the Video Gallery. The code from biggia (thanks for your post) is not working. Have you already a solution?
Many thanks for your help.
Christian
I should note that I added Biggia’s code to the 2.9 version of this plugin NOT to the latest release – then made made the null adjustments directly to the columns via phpmyadmin. Now I can add videos using 2.9 and WordPress 4.4.
Finally, I can upload video. Following are the steps:
1- Based on the code posted above by biggia. I used the following code:
ALTER TABLE WP_hdflvvideoshare MODIFY google_adsense_value INT( 3 ) NULL;
ALTER TABLE WP_hdflvvideoshare MODIFY google_adsense INT( 3 ) NULL;
ALTER TABLE WP_hdflvvideoshare MODIFY midrollads INT( 11 ) NULL;
ALTER TABLE WP_hdflvvideoshare MODIFY imaad INT( 11 ) NULL;
ALTER TABLE WP_hdflvvideoshare MODIFY prerollads VARCHAR(25) NULL;
ALTER TABLE WP_hdflvvideoshare MODIFY postrollads VARCHAR(25) NULL;
Please note that I changed the table name _videoinfotable to _hdflvvideoshare. Also, you will need to change WP_ to your Database Prefix. Then, RUN the above SQL statements in phpMyAdmin.
My Result: after this step I able to upload videos and the plugin created the video pages. But, the video pages didn’t play any videos. I tried resetting the Permlink, but it didn’t help.
2- Delete the plugin folder /contus-video-gallery/ under /wp-content/plugins/ and install the plugin from the Dashboard.
My Result: All video pages are working and I can upload new videos.
Final note: after install the plugin, to see the plugin created pages, you will need to edit hdflvvideoshare.php at /wp-contents/plugins/contus-video-gallery/ and find show_ui. (at Line 112 in current plugin version 3.0), change the value from false to true.
That’s it. Good luck.
That worked! Thank you hellowm!
