Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Access - MySQL Conversion
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 December 2006 :  09:24:59  Show Profile  Send ruirib a Yahoo! Message
Well I suggest that you do and redo the import again. No doubt that you will have more problems if you don't do that.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 30 December 2006 :  09:38:54  Show Profile  Visit spyderuk's Homepage
So lets say I use MySQL-Front for importing the tables data. Would I need to run set-up.asp first? Then to run the setup for all the mods? I have tried this but obviously getting errors because tables do not exist for the mods.

or

Could I create the tables by importing the text file created by Access-to-MySQL. Then use MySQL-Front for transfering from the access tables to the tables in MySQL?

Sorry for being a bad newbie

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 December 2006 :  09:43:41  Show Profile  Send ruirib a Yahoo! Message
Run setup.asp and then all the dbs files for mods and then import the data.

Using info from Access is useless for proper table creation.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 30 December 2006 :  09:48:15  Show Profile  Visit spyderuk's Homepage
quote:
Originally posted by ruirib

Run setup.asp and then all the dbs files for mods and then import the data.

Ok this is where I get stuck. can the dbs files be run through the browser or only through the admin panel? If only through the admin panel then I would have to replace all forum files with unmodified files to run the dbs files, then overwrite with the original forum files?

Also, I do not have the old version setup.asp but i presume the new version would still create the same tables?

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 December 2006 :  11:10:15  Show Profile  Send ruirib a Yahoo! Message
Yeah, you can use the setup.asp file for 3.4.06, no worries. I would use a default 3.4.06 install for running the dbs files. Just set it up in another folder. It's the easiest way to do that, believe me.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 01 January 2007 :  12:57:33  Show Profile  Visit spyderuk's Homepage
Rui I tried the method recommended but ran into a few problems with sql errors. I cannot recall the errors now so canot post. Anyway they were to do with importing the members tables. As the fields were mixed up due to the order of running the DBS files from last time with 1 column missing. I manually added this column and rearranged exisitng columns to match with my Access details.

EDIT. All errors were from active users 4 mod.

To top things off, MySQL-Front kept crashing with weird error messages in a language that was not English but reffering to memory.

I've sent you email

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

Edited by - spyderuk on 01 January 2007 13:15:02
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 January 2007 :  14:34:35  Show Profile  Send ruirib a Yahoo! Message
I've replied, Roger.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 01 January 2007 :  16:50:44  Show Profile  Visit spyderuk's Homepage
quote:
Originally posted by ruirib

I've replied, Roger.

Did you just reply or replied by the email address I sent to you? I need to update my email in snitz. Will do that now.

EDIT.. Updated

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

Edited by - spyderuk on 01 January 2007 16:52:27
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 01 January 2007 :  18:47:09  Show Profile  Send ruirib a Yahoo! Message
My mistake, sorry. You should have it by now.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07