help with db conversion?

moogyness

New Member
Messages
3
Reaction score
0
Points
0
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?





 

Corey

I Break Things
Staff member
Messages
34,551
Reaction score
204
Points
63
Last edited by a moderator:

moogyness

New Member
Messages
3
Reaction score
0
Points
0
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?
 

Russ

<b>Retired *****</b>
Messages
3,168
Reaction score
2
Points
38
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/suspended.page/index.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:

Bryon

I Fix Things
Messages
8,149
Reaction score
101
Points
48
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.
 
Top