+ Reply to Thread
Results 1 to 6 of 6

Thread: help with db conversion?

  1. #1
    moogyness is offline x10Hosting Member moogyness is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    3

    help with db conversion?

    i get this error when converting an ipb database to an smf database

    Caused the error:
    Got a packet bigger than 'max_allowed_packet' bytes


    this must be a server error or something? is there a function disabled in the server?
    i couldnt find anything with max_allowed_packet in my convert.php file.

    dunno what to do?






  2. #2
    Corey's Avatar
    Corey is offline VPS Migration Professional Corey is a glorious beacon of lightCorey is a glorious beacon of light
    Join Date
    Dec 2004
    Location
    Northfield, NH
    Posts
    17,151

    Re: help with db conversion?

    You should upgrade your PHP version either way at http://x10hosting.com/login

    That is a MySQL error, I'll raise the packet size.
    Last edited by Bryon; 12-11-2007 at 01:56 PM.
    Corey Arbogast | CEO
    █ 888-X10-9668 - corey[@]x10hosting.com
    x10Hosting - Giving Away Hosting Since 2004
    Premium Hosting | VPS Services

  3. #3
    moogyness is offline x10Hosting Member moogyness is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    3

    Re: help with db conversion?

    thanks! it works now, but i'm not sure about this:
    Converting poll options...
    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8

    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8

    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8

    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8

    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8

    Notice: Array to string conversion in /home/spaces/public_html/convert.php(827) : eval()'d code on line 8
    Unsuccessful!
    This query:

    INSERT INTO `spaces_smf`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (1, SUBSTRING('I own a rio', 1, 255), 'Array', 1, 255), 'Array'),
    (2, SUBSTRING('Where do you live', 1, 255), '1', 1, 255), 'Array', 1, 255), 'Array'),
    (3, SUBSTRING(':P', 1, 255), 'Array', 1, 255), 'Array');

    Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Array'),
    (2, SUBSTRING('Where do you live', 1, 255), '1', 1, 255), 'Arr' at line 3
    what should I do now?

  4. #4
    adminkru is offline x10Hosting Member adminkru is an unknown quantity at this point
    Join Date
    Nov 2007
    Posts
    9

    Re: help with db conversion?

    Umm.... I'm just doing this because my account got suspended

  5. #5
    Russ's Avatar
    Russ is offline Retired ***** Russ is an unknown quantity at this point
    Join Date
    Sep 2007
    Posts
    3,162

    Re: help with db conversion?

    moogyness:



    ou need to login to www.x10hosting.com/login under the "PHP Details" Section, apply for the intermediate version of PHP. Changes take about 24 hours to fully complete. Once this is done, your issues should be solved.
    Edit:
    adminkru Don't do that.. Its not needed, to keep your account active you need to just login.. Not necessarily post..


    You can unsuspend yourself here http://staff.x10hosting.com/suspende...x.php?do=check
    Remeber in the future to login to the forums atleast once every two weeks and if you're going to be gone for an extended period of time, post in the forums. The admins may be able to do something to keep you from being suspended for a short time.
    Last edited by Russ; 12-10-2007 at 06:44 PM. Reason: Automerged Doublepost
    x10 Chat is now available! Live Support!

    DO NOT PRIVATE MESSAGE STAFF - WE ARE BUSY

  6. #6
    Bryon is offline Administrator Bryon has disabled reputation
    Join Date
    Apr 2005
    Location
    Northfield, NH
    Posts
    7,608

    Re: help with db conversion?

    Quote Originally Posted by rpope904 View Post
    moogyness:
    ou need to login to www.x10hosting.com/login under the "PHP Details" Section, apply for the intermediate version of PHP. Changes take about 24 hours to fully complete. Once this is done, your issues should be solved.
    The error that he is receiving has nothing to do with his PHP version. Please do not try to help others if you do not know what you're talking about. It just leads to confusion and time wasted.

    Moogyness: Did you edit any actual PHP code or any MySQL tables? Something is screwed up with your MySQL query. It is not related to your actual hosting account, but instead with SMF. Therefore, I'm moving this thread to the correct forum.

+ Reply to Thread

Similar Threads

  1. Ad free to Ad conversion?
    By southpark4602 in forum Free Hosting
    Replies: 1
    Last Post: 10-12-2007, 12:02 AM
  2. Free Online File Conversion!
    By Spartan Erik in forum Computers & Technology
    Replies: 2
    Last Post: 06-27-2007, 01:08 PM
  3. phpBB arcade to SMF Arcade conversion script
    By Christopher in forum The Marketplace
    Replies: 2
    Last Post: 05-23-2007, 09:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers