Announcement

Collapse
No announcement yet.

5.0.5 Error when uploading files to topics

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mark.B
    replied
    If you're not confident playing in the database (which is absolutely fair enough), it might be worth raising a support ticket so that one of our technicians can get your credentials and have a go at fixing it.

    http://www.vbulletin.com/go/techsupport

    Please include:

    A link to this topic
    AdminCP credentials
    FTP credentials
    phpMyAdmin credentials (or whatever database management tool your host provides)

    Please add the credentials to the "Sensitive Data" field.

    Leave a comment:


  • superwow
    replied
    How do we resolve this?

    Leave a comment:


  • superwow
    replied
    I definitely have not done anything like that. This is a pretty much brand new installation with hardly any modifications done. The latest thing i did was change the setting to store attachments in the file system instead of the DB. I could not attach large files because of that and now i cannot attach large files because of this.

    Where do we change this nodeid autoincrement and how do i find out what the max child value is in that table? Everything is default settings, the last thing i want to do is start poking around the DB haha.

    Leave a comment:


  • Wayne Luke
    replied
    Fix Unique indexes won't do anything to fix this. All it does is check old vBulletin 4 tables to see if they have an auto-increment index. If they don't it adds them. It will do nothing with the 5.X tables.

    closure_uniq is an index on the parent and child fields. These are derived from the nodeid. I suggest increasing the nodeid autoincrement to be higher than your max child value in that table. Not sure how your transactions would have gotten out of sync though unless you tried to delete content directly from the database for some reason.

    Leave a comment:


  • superwow
    replied
    Any ideas on this?

    Leave a comment:


  • superwow
    replied
    Tried that as well.

    Database error in vBulletin 5.0.5:

    Invalid SQL:
    INSERT INTO vB_closure (parent, child, depth, publishdate)
    SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
    FROM vB_node AS node
    INNER JOIN vB_closure AS parent ON parent.child = node.parentid
    WHERE node.nodeid = 180
    /**addClosure**/;

    MySQL Error : Duplicate entry '36-180' for key 'closure_uniq'
    Error Number : 1062
    Request Date : Wednesday, January 1st 2014 @ 10:09:40 PM
    Error Date : Wednesday, January 1st 2014 @ 10:09:40 PM
    Script : http:///forum/create-content/text/
    Referrer : http://www.super-wow.com/forum/new-content/36
    IP Address : 108.67.152.74
    Username : superwowadmin
    Classname : vB_Database_MySQLi
    MySQL Version : 5.1.72-cll

    Leave a comment:


  • Joe D.
    replied
    Originally posted by superwow View Post
    Also tried this from a different user account and got the following message.

    Database error in vBulletin 5.0.5:

    Invalid SQL:
    INSERT INTO vB_closure (parent, child, depth, publishdate)
    SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
    FROM vB_node AS node
    INNER JOIN vB_closure AS parent ON parent.child = node.parentid
    WHERE node.nodeid = 184
    /**addClosure**/;

    MySQL Error : Duplicate entry '2-184' for key 'closure_uniq'
    Error Number : 1062
    Request Date : Wednesday, January 1st 2014 @ 03:29:01 AM
    Error Date : Wednesday, January 1st 2014 @ 03:29:01 AM
    Script : http:///forum/create-content/text/
    Referrer : http://www.super-wow.com/forum/new-content/36
    IP Address : 108.67.152.74
    Username : superwowadmin
    Classname : vB_Database_MySQLi
    MySQL Version : 5.1.72-cll

    In Admin CP -> Maintenance -> Repair / Optimize Tables, at the bottom is an option to fix unique indexes, try running that.

    Leave a comment:


  • beishe8
    replied

    Originally posted by superwow View Post

    I would like to be able to upload 50 or 100mb attachments since we have unlimited storage space.

    Let me know what we need to do for this.
    Don't take your host's word seriously about that "unlimited storage space".
    Videos could be easily that large, causing a warning not to upload them.

    Leave a comment:


  • superwow
    replied
    Also tried this from a different user account and got the following message.

    Database error in vBulletin 5.0.5:

    Invalid SQL:
    INSERT INTO vB_closure (parent, child, depth, publishdate)
    SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
    FROM vB_node AS node
    INNER JOIN vB_closure AS parent ON parent.child = node.parentid
    WHERE node.nodeid = 184
    /**addClosure**/;

    MySQL Error : Duplicate entry '2-184' for key 'closure_uniq'
    Error Number : 1062
    Request Date : Wednesday, January 1st 2014 @ 03:29:01 AM
    Error Date : Wednesday, January 1st 2014 @ 03:29:01 AM
    Script : http:///forum/create-content/text/
    Referrer : http://www.super-wow.com/forum/new-content/36
    IP Address : 108.67.152.74
    Username : superwowadmin
    Classname : vB_Database_MySQLi
    MySQL Version : 5.1.72-cll

    Leave a comment:


  • superwow
    replied
    I have made the change. Now i am receiving this error message.
    "There has been a database error, and the current page cannot be displayed. Site staff have been notified."

    I receive an email stating the following.
    Database error in vBulletin 5.0.5:

    Invalid SQL:
    INSERT INTO vB_closure (parent, child, depth, publishdate)
    SELECT parent.parent, node.nodeid, parent.depth + 1, node.publishdate
    FROM vB_node AS node
    INNER JOIN vB_closure AS parent ON parent.child = node.parentid
    WHERE node.nodeid = 183
    /**addClosure**/;

    MySQL Error : Duplicate entry '2-183' for key 'closure_uniq'
    Error Number : 1062
    Request Date : Monday, December 30th 2013 @ 09:13:19 PM
    Error Date : Monday, December 30th 2013 @ 09:13:19 PM
    Script : http:///forum/create-content/text/
    Referrer : http://www.super-wow.com/forum/new-content/36
    IP Address : 12.111.84.66
    Username : superwow
    Classname : vB_Database_MySQLi
    MySQL Version : 5.1.72-cll

    Hopefully we can get this squared away, thanks for the help.

    Leave a comment:


  • Zachery
    replied
    One that is not available via the web, so at the same level of public_html

    Leave a comment:


  • superwow
    replied
    What path would you recommend creating to store the attachments?

    Leave a comment:


  • Zachery
    replied
    If you move attachments into the file system, it is a one time move, and all of the old attachments are moved, and new attachments go into there by default.

    Leave a comment:


  • superwow
    replied
    Thanks for the info! I could not find the instructions on how to do that permanently. I found something that looks like it shows you how to move them out of the database and into the file system but it does not sound permanent. If you could like me directly to the instructions for that i may give it a shot.

    Thanks!

    Leave a comment:


  • Joe D.
    replied
    the 'max_allowed_packet' is smaller than the file you are trying to upload.

    You should consider moving attachments to your file system so you don't need to deal with this limitation, info on how to do that is in the manual, here-
    https://www.vbulletin.com/docs/html/...hments_storage

    There is also a php file size limit set by your host, make sure that value is larger than the largest file you want to upload.

    Leave a comment:

Related Topics

Collapse

Working...
X