HTML Logo by World Wide Web Consortium ( Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS. ocPortal 9 is superseded by Composr 10.

Head over to for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.

error trying to insert a video

Login / Search

 [ Join | More ]
 Add topic 
#110623 (In Topic #22183)

Fan in action

On ocPortal version 9.0.19, server is Windoze Server 2008r2.

I am getting an error trying to insert a video. All credentials for the new files and existing videos in our ocPortal are the same. Attached is the stack trace.
» Download: insert video error.pdf (452 Kb, 83 downloads so far)

Cannot connect to the server in the URL, is likely either the domain name is wrong, the server is down, or you are restricted by a firewall or proxy server).
An error has occurred
Unfortunately a query has failed [INSERT INTO ocp_videos (title, edit_date, video_views, add_date, allow_rating, allow_comments, allow_trackbacks, notes, submitter, url, thumb_url, comments, cat, validated, video_length, video_width, video_height) VALUES (6510, NULL, 0, 1450297597, 1, 0, 0, '', 2, '', '', 6511, 'webinars', 1, 0, 320, 240)] [Field 'id' doesn't have a default value] (version: 9.0.19, PHP version: 5.4.24, URL: /ocportal/cms/index.php?page=cms_galleries&type=_av&

Seemingly related, uploading a file in “Downloads” gives this error, but the file is inserted.

Cannot connect to the server in the URL, is likely either the domain name is wrong, the server is down, or you are restricted by a firewall or proxy server).
Your download has been added successfully. You can also
add images to the download.
Editing the Downloads page after insert, get the same error, but again, the edits do stick.
All feedback appreciated.
Back to the top

It looks like the auto_increment setting has disappeared from the id field of the ocp_videos table somehow.

I remember someone else losing auto_increment this year, maybe that was you also and this is same issue.

As for the connect error, it isn't uncommon for a server to not be able to connect to itself unfortunately, for a variety of possible reasons. You can try triggering the "My server uses firewall and IP forwarding, or uses a Windows computer name instead of DNS" config option to see if that helps.

Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Support me on Patreon
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top

Fan in action

Yep, ID lost its auto increment. Thanks MySql :(

Thanks for the help Chris.
Back to the top
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: