uploading local videos problem « MediaDrop Community

MediaDrop Community » General Discussion & Feedback

uploading local videos problem

5 posts Started 11 years ago by nerion Latest reply from nerion

nerion
Member
Posted 11 years ago

Hi everybody,

I have a problem uploading to mediacore from my local files. It appears that works fine because it charges the video until 100%, but then, when a few seconds pass the error
"Error al guardar el archivo. Por favor, inténtelo de nuevo" raises (its the relative "Saving the file failed. Please try again").

The weird thing is that mediacore was already installed and it works fine. There are several local files uploaded, but recently we change the files (not the mediacore configuration) in our server and it's when fails.

Looking at the logs, they show the next error:

Error - <class 'sqlalchemy.exc.IntegrityError'>: (IntegrityError) (1062, "Duplicate entry '154' for key 'PRIMARY'") 'INSERT INTO media (type, slug, podcast_id, reviewed, encoded, publishable, created_on, modified_on, publish_on, publish_until, title, subtitle, description, description_plain, notes, duration, views, likes, dislikes, popularity_points, popularity_likes, popularity_dislikes, author_name, author_email) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (None, '_stub_2011-08-25-101004', None, True, False, False, datetime.datetime(2011, 8, 25, 10, 10, 4, 502914), datetime.datetime(2011, 8, 25, 10, 10, 4, 502925), None, None, 'Temporary stub 2011-08-25 10:10:04', None, None, None, None, 0, 0, 0, 0, 0, 0, 0, 'Admin', 'mail@domain.tld')

What is working wrong?

Thanks in advance.
nerion
Member
Posted 11 years ago

Sorry, but ¿need post more information?.

I did not mention because from the last 20 errors that the logs report me, 17 was about the first post; but in three times, and appearing without doing nothing more than trying to upload a local video file, another log was shown.

It told something like "Unusable URL".

I beg you if you can give me a solution or tell how i must procceed.

Thanks in advance.

nerion
Felix Schwarz
MediaDrop developer
Posted 11 years ago

nerion: Can you check in your db if there is a row in table 'media' with id 154? If so, your DB is broken and you need to repair this manually.

Looks to me as if your db is confused and does not remember the last automatically assigned id anymore. In postgresql you would need to change the sequence, MySQL has something similar.
nerion
Member
Posted 11 years ago

Hi Felix,
thanks for your reply.

The DB is MySQL, and we already search for "errors" with the command CHECK showing nothing unual in every table. For assuring it, then we use the command REPAIR but obviously it probably did nothing because CHECK shows no errors.

We just look for the id 154 in the table media, and the select has no returns. It's weird that the log told us that the id is duplicate when there is no id=154 in our table.

What we found out on the web is that this can be repair saving the DB, recreate it and then import the save one.
Another solution appears to be to alter the index field to unsigned int.

Here is the forum I'm talking about:
http://www.softwareprojects.com/resources/programming/t-how-to-fix-mysql-duplicate-entry-for-key-primary-o-1844.html

We must try with one of these? What is your opinion?

Thanks again,
nerion
nerion
Member
Posted 11 years ago

Hi again,

We finally fix the auto-increment problem but appears the second one. How we solve this first problem is to alter the index to 200. We suppose that is not a 100% fix but now has no problem with posible repeat keys.

Now, the "Unusable URL" error reappears. One solution we find out in other forums was to recreate the "Local File Storage".
Previously we made a backup of all the files. Then delete this file and create it again.
Finally we put the backup again to this folder.

The problem is that the same error is appearing "Unusable URL"; but far of doing nothing with the previous actions, now the number of files uploaded from our local files are 0. So the dump of the backup fails too.

Some ideas about this?

RSS feed for this topic

Reply

You must log in to post.

Community Forums

uploading local videos problem

Reply