snitz to phpbb, cant seem to locate anything on this,

Hello everyone.I have searched through the forum and cant seem to find anything like what I am hunting for. I am working on several web sites all at once and I would really like some help from someone if possible.
What I have is a snitz forum and since I have gone from a regular html site to php, well actually this is the new php nuke platinum that I am using on this site; I want to convert my database from access to php format.
I have tried to get the converter but seems the site is now down or something. I have already converted my access to sql with no problem but I need the converter to put it all together, Do I know what I am doing? Nope. But hey I have built many sites and learned as I went. Smiles, hope you all can help, if nothing else if someone can email me the program it would be helpful.

Sandy

Hi Sandy,

I've removed your email address from your post because email harvesters can easily get your email address from here and send you spam email.

I've also sent you the scripts we used to convert the mysql version of the Snitz db to phpbb.

I assume from your post that you've already converted the access database into mysql.

Yes I used mydbdump and converted it all into sql. its ready to go just needed the converter to finish well not finish but put it all together...I did however have to put it in two groups, the tables were in one and the replys were in a second one as it was to big for the upload. but it worked and there all up on the database and ready to go.
thank you so much for your help, and yes that was cool to remove the email. I had not thought about that...

Sandy

Sorry, but for the first time that I can remember, my ISPs mail server is having some problems and so the message probably hasn't got to you yet. I'm sure they'll fix it soon!

Laughs lightly, its all good no worries, I run servers here in my home so I know how things tend to be sometimes, will wait, thanks
Sandy

May I suggest that BEFORE you convert, you unarchive all your archived topics otherwise these will be lost forever.

There is a snitz mod to unarchive posts.

Also, I have a php script which you can run once you've made the conversion which will fix a lot of errors.... including BBcode, smilies, url's, colors, font sizes, etc

__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work

Hum had not thought of that. I am still waiting for the converter or scripts to come to me. I tried the link again today but it didn’t work and haven’t received an email either. I am not sure what order I should go in of doing things or exactly what I need to do but have scanned through the forums both here and phpbb and I think I got the jest of it. No one mention the archives. Ha, I forgot about them....

I would not know where to upload the mod for the archives. The new forums or the old one?

Am grateful for help on this,

Thank you

Sandy

Firstly... visit here:-
http://forum.snitz.com/forum/topic.a...hTerms=archive

Install that on your snitz forum and unarchive all the topics.

Next, convert your access database to MySQL (Has to be MySQL)

Now.... run the PHP scripts that Sirkent sends you... (when he sends them) which will transform the snitz data to PHPbb format.

Lastly... post back here and I'll give you a script which will fix many abnormalities that happen when converting from snitz.

__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work

Okay, step one is done, I unachieved the forums. Oh my gosh 38,375,424.... this is a very large database. Lots of messages. Will have to upload them in sections, not sure how but will move on to that step next. If only allowed 51,000 it will take me a while.

Is there possibly something I can use to upload it all at once after I convert from access to mysql or just do them one at a time?

Silly questions I know but this is really a learning experience for me too. One that I can pass on I am sure.

Thanks Rob for the help,

Will see what happens next. I did not realize I had so much in this database.

Sandy

Okay I have converted the data. still waiting on the converson stuff, but I have gone from access to mysql, I have uploaded all the files except one.
and I know this will sound dumb but if I am only allowed 51,000 up load then how do I get 7.22 mb of posts uploaded? do I have to break it down or is there a better way. that is 7,578,783 worth of files. this is a role play site i am working on and to lose any of the post could be a real mess. Any ideas?


thanks

Sandy

gotta break that file down into smaller chunks... sorry

__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work

Oh Rob that was the last thingy I wanted to hear, lol


okay, well guess I best get started then. Just not sure how, can I cut and paste it or what would you advice be?

if any besides Good Luck? lol

thanks hon for your help, I am driven to get this right,


Sandy

Just plod on.... lol

There is no shortcut for this..... we had to do it too!!

lol

__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work

Okay well I am running into a problem, It uploaded the first group of replys but now its rejecting everything else I am trying to upload to it, what I have done is made copys of the sql files and then because there is so many copy one and cut and past into it as I go, breaking it down so I dont lose my place. its not working. it refuses to take it saying>>>>

SQL-query:

INSERT INTO [FORUM_REPLY]
VALUES (

3, 11, 41, 5836, 0, 35, "(npc) *Miranda smiles and nods finding an empty room she quickly undresses and quickly showers and steps out finding clean clothes and shrugs assuming that a maid had put them there for her and yawns going downstairs to the kitchen to have something to eat*", "20030318083825", "203.46.236.197", 1, NULL , NULL , 0
)

MySQL said:

#1064 - 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 '[FORUM_REPLY] VALUES (
3,11,41,5836,0,35,"(npc) *Miranda smil


I dont understand it, I converted it all from access to sql and am uploading to the mysql database on the site for db1. that is as far as I have gotten. did I miss something?

Please tell me you've got the scripts I sent you? If not I'll resend them (a third time)!

As for your SQL problem - are you sure that the same fields exist and are of the correct type? Is this record in the same format as the previous records?

how bout I lie??? nope cant do that, I havent recived any email. so I been flying blind on this kindof...

yes its all the same the only difference is I cut out part of the posts and then uploaded it, going back and cutting more pasting it back to the one I did before after removing the original group and so on, this thing is over over 7 mg. and it was the only way I could figure to copy the files over,



I am trying really hard not to get lost...


smiles, thanks for the help though.
Sandy

just make sure you dont cut off SQL statments in the middle. it sounds like this may have happened.

__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work

Okay I lied, or something weird happen, I now have 47 mb of replys, I must have been reading something wrong somewhere, I just pulled it up in access again to look at it and it says its 47 mb.


you might be right. I could have broken the link somewhere, will go back and try again

Sandy

Oh my god I am soooo fricken blond, duh. all 14788 posts are up on the database. no wonder I got errors I did not thinkthat they would trasfer but they all did. there all there and when I was trying to break them down it would give me an error cause it was already there.

Have another cup of coffee.......lol

Okay so when and if I ever get the email I will be ready for the next step. snitz is compleatly uploaded on the database, phpbb is uploaded on its own database...

what comes next???

Sandy

YEAAAAAAAAAA
the email finally came. okay I did step one and step two... I even step 3.


but now my site says theres no forum. sniffles, okay you know what folks , gentlemen espically,

this is what I am running>>>> Congratulations, you have successfully installed PHP-Nuke Platinum version 7.6.0.

would it be a good idea to downgrade the php-nuke to an earlier version, this one has the phpbb incorporated into the whole package. Its not a stand alone. if you want I will email you the info on the site. I cant post it here since its a fresh install I have not deleated the access to create admin as of yet,

think I am starting to pull on my hair,

Thanks in advance for any help you can give,


Sandy