Simple Machines Community Forum

 I see this error when i just click to start the conversion:

"Unknown system variable 'SQL_MAX_JOIN_SIZE'"

I try to convert a phpbb 3.011 forum to SMF.  The empty SMF intalled is the 2.011

domain.xx/foro5
domain.xx/SMF

do u know what can be the problem?. Thanks!

Check out this topic
http://www.simplemachines.org/community/index.php?topic=528263.0

Thank you! . i remove this code. But know i get a empty screen when i execute convert.php
???

this file must be located on the /foro5 ( php path) or the /SMF ( SMF path) ?

well i tried on both and same result.  ::)

convert.php should be in the SMF path

Thanks.

im not sure if im removing correctly the code.. ???

Attach it here.

This is with the code removed .

This is without the code removed ( as the file come diretcly from the ZIP conversor files)

Try this one

Converting!.

Thanks mate. Ill let you know how it works finally.

The conversion seems to be  stopped at this point:

Converting...
Converting posts...
Duplicate entry '72155' for key 'PRIMARY'


???

Does it have a line number?

I attached what i see

hmm try this file

Hi mate,
i tried to re-beging without any change , before you send me the last convert.php file .

Now is still converting the posts .

243.600 post fo 634.000 ( total) .

Ill let you know how it finish..fingers crossed.

Thanks so much

After 3 hours converting the posts... it appears this message and stop it:

Converting...
Converting posts...
The database value you're trying to insert does not exist: modified_name

The converting stopped at this point on the URL:

URL:  /SMF/convert.php?step=1&substep=19&start=544800

Total post of the forum : 624.000


Screenshoot attached.

any help?  :-\

Keep it open on that page.
Then alter your SMF database try this query

alter table smf_boards add column modified_name varchar(255);


Thanks for your quick answer!.


ouch.. i dont know how to do this.
Is it on PHPmyadmin?

My phpmyadmin is in spanish, sorry. Should it be here and "execute query" buttom ( on the right)

Yeah try that

Ok, done.
What should i have to do? . The converter is in the same way(stopped)

Refresh the page.

I made a mistake run this query instead
alter table smf_messages add column modified_name varchar(255);
Then run
alter table smf_boards drop column modified_name;

So , now in this situation,  must i run this two queries?
Or just the last one?

Attached the SFM_boards situatio ( just now)

Ok, i understood. I ran these two queries.


alter table smf_messages add column modified_name varchar(255);
Then run
alter table smf_boards drop column modified_name;

refresh the page , and get this message:


Converting...
Converting posts...
Duplicate entry '570274' for key 'PRIMARY'

Run both then refresh again.

Done. refresh the page , and get this message:


Converting...
Converting posts...
Duplicate entry '570274' for key 'PRIMARY'

Must i have to run the queries with all the tables selected or just only the smf_messages and smf_boards?
(i did it only selecting these tables)

just those tables.

Ok. So, i did it well.get this message now on the converter :(

could be the problem becouse i run a incorrect query at first?

Any help?   :-\

You had that issue before did you try the convert.php i posted before...

well, not the last one, becouse the conver started well as i mentioned.
how i proceed now?

upload the convert.php that i changed and just refresh the page...

now this appears again:

Converting...
Converting posts...
The database value you're trying to insert does not exist: modified_name

There´s a "modified_name" colum on the SFM_messages table.

Yeah that was a guess now i don't what else.

Ill restart from the begining qith your last convert.php file.
Ill let you know which is the first messega again after that, in a few hours. Thank you.

I  started from the begining. I have this error:


Converting...
Converting posts...
The database value you're trying to insert does not exist: modified_name

Not sure why that would occur i see that field in smf_messages and in your screenshot above.

must i unistall any mod or theme?
only have talkpad mod.  :(

Quote from: vbgamer45 on January 19, 2017, 11:23:11 AM
Try this one

Need some help and don't know if this thread is being watched so here goes nothing...:)

Running a phpbb3 version 3.0.14 and trying to convert it to smf 2.0.14. I ran into the "SQL_MAX_JOIN_SIZE" issue as well. Tried the modified convert.php and it at least attempted to start converting but nothing happens. I looked in the error_log file and I see issues. None of which I know what to do to address. Looking for some help if I can get it. I have attached my error_log file

Thanks!

I would say if you have access to your mysql my.cnf try to raise the limit there SQL_MAX_JOIN_SIZE

total greenhorn when it comes to mysql....where do I find my.cnf?

If you have your own linux serer or vps /etc/my.cnf on linux servers.   or windows it's in my.ini

sorry....I am hosted on hostmontser.com. Don't have access to /etc/my.cnf. Any other ideas? Could I ask them to raise max? If they would what I need it raised to?