• Because the only posts on this problem I’ve seen and a fix for it are over 6 months old, is this still the recommended fix? I’m having the same problem, not being able to upload video ads, or link to video ads for pre-roll. I’m not getting any errors when I try to upload.

    What I read in another post says I should run these updates on my db table:

    ALTER TABLE wp_hdflvvideoshare_vgads CHANGE file_path file_path VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
    
    ALTER TABLE wp_hdflvvideoshare_vgads CHANGE title title VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL;
    
    ALTER TABLE wp_hdflvvideoshare_vgads MODIFY impressionurl TEXT NULL;
    
    ALTER TABLE wp_hdflvvideoshare_vgads MODIFY clickurl TEXT NULL;

    In phpadmin when I select the table wp_hdflvvideoshare_vgads and then the SQL tab, I see a line of code already inserted that says:

    SELECT * FROM wp_hdflvvideoshare_vgads WHERE 1

    Do I leave this line there, or do I delete it first to run the updates on the table? Is running these updates on my DB still the suggested fix?

    https://www.ads-software.com/plugins/contus-video-gallery/

Viewing 3 replies - 1 through 3 (of 3 total)
  • priyadarshinimuthuraman

    (@priyadarshinimuthuraman)

    This is the suggested fix for video ads not getting uploaded. Delete the line, SELECT * FROM wp_hdflvvideoshare_vgads WHERE 1 that has been already inserted in the SQL tab and paste the update code mentioned in your post and run the queries.

    If still the issue persists contact our support at [email protected], so that we can check and do the needful.

    Thread Starter NetMonkey

    (@headmonkey)

    I did exactly as you mentioned. I deleted the text in the SQL window, I pasted the alter table commands, I clicked GO and there was this MySQL error:

    # MySQL returned an empty result set (i.e. zero rows).

    I can troubleshoot this and correct things if you give me a suggestion.

    priyadarshinimuthuraman

    (@priyadarshinimuthuraman)

    Now try uploading the video ads in the admin panel and check whether the uploads are successful. If not, try adding the Alter table commands one by one. And if still the issue persists contact our support at [email protected], so that we can trace out the actual issue with the ads upload.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cannot upload video ads’ is closed to new replies.