welcome to my space

Recent Posts

Categories

Blogroll

Meta

  1. RSS
  2. valid XHTML

A few database errors...need help“”

mike | March 18, 2010 | | portal.polala.com

  • When I try to 'Save data to file on server' I get the following errors...can someone help me fix them. I'm with netfirms if that helps

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: SELECT * FROM attachment
    mysql error: MySQL client run out of memory

    mysql error number: 2008

    Date: Friday 27th of June 2003 10:15:07 PM
    Script: www.site.com/admin/backup.php
    Referer: http://www.site.com/admin/backup.php?action=choose&s=

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: UPDATE session SET lastactivity=1056766501,location='' WHERE sessionhash='53a4f4400e5686bec00cf3f5c41ec1d3'
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013

    Date: Friday 27th of June 2003 10:15:08 PM
    Script: http://www.site.com/admin/backup.php
    Referer: http://www.site.com/admin/backup.php?action=choose&s=


  • How do I find this information, as I said I'm using netfirms as my host and using the phpMyAdmin thingy there
    you'll need to contact your web host for the information


  • Attachment - 27.6 MB
    Total - 45.5 MB

    Anymore help you can give me?


  • i guess even small databases depending on hardware need to use mysqldump

    solution: You need to use ssh telnet and mysqldump (guide here http://www.sitepoint.com/article/678) and try again

    you may also need mysql fine tuned so please provide the following info ask here http://www.vbulletin.com/forum/showthread.php?t=70117


  • take a read of http://www.mysql.com/doc/en/Out_of_memory.html

    how large is your forum database total, how large is the attachment table ?

    if it's larger than 50-100MB , you should NOT use vB admin backup script as it will time out, or do what happened here in your case

    use ssh telnet and mysqldump (guide here http://www.sitepoint.com/article/678) and try again

    you may also need mysql fine tuned so please provide the following info ask here http://www.vbulletin.com/forum/showthread.php?t=70117


  • How do I find this information, as I said I'm using netfirms as my host and using the phpMyAdmin thingy there







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about A few database errors...need help , Please add it free.
    edit

    Can anyone tell me the name of the painting/poster Chuck Bass has hanging on his bedroom wall over his bed? Can you help me solve this physics problem?