News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

"Unknown system variable 'SQL_MAX_JOIN_SIZE'"

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

Previous topic - Next topic

motu828

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

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

vbgamer45

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;
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

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

Attached the SFM_boards situatio ( just now)

motu828

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'


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

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)

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

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

motu828

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


vbgamer45

You had that issue before did you try the convert.php i posted before...
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

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

vbgamer45

upload the convert.php that i changed and just refresh the page...
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

now this appears again:

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

motu828

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

vbgamer45

Yeah that was a guess now i don't what else.
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

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.

motu828

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



vbgamer45

Not sure why that would occur i see that field in smf_messages and in your screenshot above.
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: