News:

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

Main Menu

Problems with the IPB2 to SMF Converter. Need help desperately!

Started by JRSofty, January 25, 2007, 05:47:49 AM

Previous topic - Next topic

JRSofty

The problem I'm having is that I'm getting strange SQL errors. Basically an SQL statement gets LIMIT 0, 500; tacked onto it for no reason.

My current sticking point is the SQL statement:

DELETE FROM `ipbsmfcon`.smf_permissions
WHERE ID_GROUP > 8
LIMIT 0, 500;

The error it sends back is:

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 ' 500' at line 3

When I look at the converter files I find the sql statement:

DELETE FROM {$to_prefix}permissions
WHERE ID_GROUP > 8;

And this is the only one I find. So where is this LIMIT 0, 500; coming in at?
Rebooting the SMF AI Bot see Project link below for details

http://jrsofty1.stinkbugonline.com
http://www.galahtech.org

SMF Bot Project

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JRSofty

It was the one that could be downloaded from the Download section.

I've since used your version for the IPB 2.2 and it worked without too much problem.

Thanks sorry I didn't post this sooner.
Rebooting the SMF AI Bot see Project link below for details

http://jrsofty1.stinkbugonline.com
http://www.galahtech.org

SMF Bot Project

Advertisement: