Converter fields question

[sashap13]

Looking at the converter,

Path to SMF:   autofilled

MySQL database used by Snitz:   what is the format here?
   
Is it www. site. com/ folder /  database.sql  or same format as path to smf which shows as: D:\Hosting\7077161\html\forums and change forums to folder with the sql file?

Please help!

[margarett]

It is just the database name, as it shows in phpmyadmin

[sashap13]

I have is it supposed to be in phpadmin? I didn't see that in the steps for using the converter. I have it in directory of my site.

[margarett]

No, the converter is a php script that needs to be put inside SMF installation folder. But the data if fetched from a database. And you need to tell the converter what database is that.

[sashap13]

Do i need to have the database loaded on a local server then? (i have apache on my win machine) because i was hoping to point it to the file where i have it uploaded on site. I'm new to servers/mysql so guidance on what i should be doing would be appreciated.

[margarett]

Did you check this:
Converting to SMF
?

You need to install SMF (and then run the converter) in the same server as you current forum is running. Please take a moment to read that and let us know if you can't understand something

[sashap13]

So finally got the database uploaded to same domain as SMF. Trying to run the converter and getting http://dogousa.org/forums [nofollow]

Connection Problems

Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

I used the database name as shown by the host and the password is right, I even reset it to make sure.

[margarett]

Did the converter run? Or haven't you tried yet?
Is SMF installation accessible? That just seems that SMF cannot connect to its database and, as such, it can't run

[sashap13]

That's the error i get when i try to run the converter. The converter.php is in the mail folder where forums are.   

Just tried to access the forums alone, and got same error??

[margarett]

Yup. First your basic SMF install should be running

[sashap13]

Ok, uninstalled, reinstalled. Log in to forums fine. Now i go to converter and when i click run, i get:


Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Snitz Forums. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'dog1403002234483'@'ip.ip.ip.ip' for table 'FORUM_MEMBERS'

[PhuriousGeorge]

Make sure your new mysql user has access to read the DB you're converting from. You should be able to change this in user permissions management in phpmyadmin

[sashap13]

would you be able to point in right direction of what tab and what fields and how should be filled out? thank you! (new)

[PhuriousGeorge]

That's quite alright (new), I've only been around about a year myself

I know phpmyadmin differs from versions and is dependent on settings, but I believe you'll be able to find what you need...

-Should be a menu button at the top "users"
-select "edit priviledges" next to the user you're using for your new forum

then (you'll have to excuse me, my phpmyadmin suddenly changed to some foreign language (darn you UwAmp!)...

-There should be a drop-down I believe, where you choose a DB you want to add the user to about half way down the page.

Hopefully you can get to where you need to go from there....I've got to try to find the language option in mine....so strange...

[sashap13]

I don't have a users tab   

[margarett]

Actually I think that tab is only available in the "full version". In a shared host, the user/db permissions are usually set via cPanel.

[sashap13]

   With GoDaddy, no cPanel. What are my options? I'm also waiting for tech support to call me from them, what should I tell them? Thank you!!!!!!

[margarett]

There should be a database manager, or something like that...

Or, you have just one user, period. Honestly, don't know. I have only seen the panel from GD on random occasions, never used it for myself...

Just remember... Are you starting with this service? Did you had any other forum running there before (Snitz?) I think that you might just have an issue with the database server. In GD, it's usually not localhost IIRC... But you must ask them, really...

[sashap13]

Ok, so got cpanel, got the user for both, now back to Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

[sashap13]

Ok, so finally made it past that screen, now getting:

Converting members... Unsuccessful!
This query:
CREATE TABLE IF NOT EXISTS `dogousa_smf1`.smf_convert (
old_id_topic int(10) unsigned NULL default '0',
old_id_msg int(10) unsigned NULL default '0',
msg_date bigint(20) unsigned NULL default '0',
type varchar(80) NOT NULL default ''
) TYPE=MyISAM;
Caused the error:
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 'TYPE=MyISAM' at line 6