• Welcome to Simple Machines Community Forum. Please login or sign up.
January 16, 2022, 06:15:49 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[SMF Converter] SimpleBoard 1.0 and 1.1

Started by JayBachatero, January 26, 2007, 09:25:01 AM

Previous topic - Next topic

JayBachatero

January 26, 2007, 09:25:01 AM Last Edit: July 18, 2009, 02:57:09 PM by TE
Software: SimpleBoard (JoomlaBoard)
Version: 1.0 and 1.1

This is the official support topic for SimpleBoard converter.  Use this topic to ask for support for this converter.

Changelog
! Escape special characters in the preg_match when converting posts. (simpleboard_to_smf.sql)
! Typo in avatar conversion. (simpleboard_to_smf.sql)

convert.php
Use this convert.php with the .sql file attached in this topic.
Follow me on Twitter

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

babylon

hello,

with your mysql file and convert.php it converts without any text errors now...
but main bug still excist.....
all replies show    0

Any ideas ?

JayBachatero

Follow me on Twitter

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

babylon

hi,

yes replies are there but funny thing is...if you go to the forum itself it shows replies   0
but the actual replies are there...

but thats not all...

some forums actual show the number of replies....
thats so weird....

but before i continue a few things i need to know....

will this realy work together with joomla ?
or do people have to login seperate for the forum?
and what if i use community builder ?







JayBachatero

Go to Admin > Forum Maintenance > Recount Board Stats.  Does that fix it?
Follow me on Twitter

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

babylon

nice i dea but how i get to the stats ?
cause when i login on front i dont see any admin functions...

JayBachatero

You saying that the admin account is not being transfered?
Follow me on Twitter

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

babylon

well....as far as i can remember when i first installed smf yesterday i saw admin functions on frontpage...
is that correct ?
after converting that was gone....

want me to try again ?

babylon

i installed it again ,iim logged in and admin stuff shows....
continue to converst again.... ;D

babylon

ok thats clear then...as soon as you run convert the admin doesnt show anymore as soon as i login under the created administrator name....

babylon

well i give up.....
but this is bull...

and im gonna have 2 logins instead of one....as i understand its not a full integration..

JayBachatero

Umm it should convert the admins.  Can you please go to phpMyAdmin and tell me what does the usertype column in the users table say for your user name?
Follow me on Twitter

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

babylon

Quoteusertype column in the users table
?  ?

there is no such thing....
smf doesnt have a users table , only smf_members , nor is there a user-type...

were discussing smf here so i assume your talking about the smf tables...

so if you want me to check something please tell me exactly what to look for...

JayBachatero

No I'm talking about the SimpleBoards users table.  In SMF it's prefix_members.
Follow me on Twitter

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

babylon

yeah i looked there...
but there's no usertype column in the smf_members table.

im in there as user admin with id 62 and with the name i registered with....
that should be admin from the start when i installed it....
both names work as login but non of them gets admin functions.

JayBachatero

I know that there is no usertype column in SMF's members table.  I'm asking you what is the value for the usertype column in the SimpleBoard users table.  If it superadministrator or administrator?
Follow me on Twitter

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

babylon

well maybe its me and im just stupid but what your asking me is very confusing....

you say you know there's no usertype column ,but still you ask me..what is the value for the usertype column  ?    ?

i have a smf_members table...
admin and my registered name...
they have id 62 and 63 .....
there is no other id or whatever....

And just in case you cant remember them all.... ;D

Here's the list of fiels of smf_members...

So ?  ?  ?

ID_MEMBER
memberName
dateRegistered
posts
ID_GROUP
lngfile
lastLogin
realName
instantMessages
unreadMessages
buddy_list
pm_ignore_list
messageLabels
passwd
emailAddress
personalText
gender
birthdate
websiteTitle
websiteUrl
location
ICQ
AIM
YIM
MSN
hideEmail
showOnline
timeFormat
signature
timeOffset
avatar
pm_email_notify
karmaBad
karmaGood
usertitle
notifyAnnouncements
notifyOnce
notifySendBody
notifyTypes
memberIP
memberIP2
secretQuestion
secretAnswer
ID_THEME
is_activated
validation_code
ID_MSG_LAST_VISIT
additionalGroups
smileySet
ID_POST_GROUP
totalTimeLoggedIn
passwordSalt



JayBachatero

Quote from: JayBachatero on January 26, 2007, 07:02:02 PM
I know that there is no usertype column in SMF's members table.  I'm asking you what is the value for the usertype column in the SimpleBoard users table.  If it superadministrator or administrator?

I said in the SimpleBoard users table.  Not SMF.  I've been saying that.
Follow me on Twitter

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

babylon

mmm, ok ...
its Administrator

i tried to change the username admin to Administrator (in smf) ,just to try....but then the login fails...

JayBachatero

Is it Administrator or administrator?  Notice the case.
Follow me on Twitter

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

Advertisement: