News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

"Unknown system variable 'SQL_MAX_JOIN_SIZE'"

Started by motu828, January 19, 2017, 10:37:31 AM

Previous topic - Next topic

motu828

 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!


vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828

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.  ::)

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828

Thanks.

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

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828


motu828

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

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828

Converting!.

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

motu828

The conversion seems to be  stopped at this point:

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


???

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828


vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828

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

motu828

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?  :-\



vbgamer45

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

alter table smf_boards add column modified_name varchar(255);
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

motu828

Thanks for your quick answer!.


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

motu828

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


vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: