Hey SMF folks -
I have a forum installed on one website and like it a lot. Help get me up an running on this new one and I promise I'll become a charter member!
So, here's the deal:
I was going through the /install.php procedure, and after entering the login data for step one, I hit proceed and... the instal got stuck - the progress bar went to about 50 percent and, stayed there. I waited an hour no changes, so I quit the browser and went back to /install.php.
Now it jumps me to Step 2 with the following message:
Forum Refreshed:
While installing, the installer found that (with the details you provided) one or more of the tables this installer might create already existed.
Any missing tables in your installation have been recreated with the default data, but no data was deleted from existing tables.
Then it prompts me for my Forum username and passwords - after entering that, I get the following red message:
Cannot connect to the MySQL database server with the supplied data.
If you are not sure about what to type in, please contact your host.
Any advice on steps I can take to get this fixed?
Thanks!
QuoteCannot connect to the MySQL database server with the supplied data.
Did it ask you to enter your mysql information? Also what version are you upgraded to and from.
1) it went down just as I described: I went through the install step 1, which asks for the sql info, then got stuck after I entered "Proceed"
2) This is not an upgrade, it is a cold install. It is the latest version downloaded from the SMF site.
Verify that all the information you have entered is correct. Some of the information you have entered to complete your install is not correct.
I can't get to that information to verify using SImple Machines, at least not using the install wizard, because of the situation described above.
You can PM me the URL and the install info and I will have a look.
Sarge,
I am having the same issue.
We have just moved to a new server. I used the whm to creat the account. Then uploaded that latest full install of smf. Went into the mysql created the databse needed and then went to the install php and after hitting proceed get the same messege as above.
I know all info is correct but for the life of me can't figure out why I'm getting this messege. I have installed smf for 2 other sites in the past 2 of which were moved to this same server and had no issues or error messeges.
Due to this server move the site I am doing this fresh install for has been offline for about 3 months and I would really like to get things going for the install as we have a ton of work ahead for downloads and other goodies we have to complete before putting the site online
If it's possible, delete the entire database that the forum was installed on (If you delete the entire database, be sure to recreate the new empty replacement before you try to install!), if not delete all tables with the planned prefix that you had entered in the installer. After that, try to run your install at /install.php?step=0&overphp=true (Make sure to copy and paste/type it in right.)
Not sure if it'll work, but it might. It worked for me one time, when I had to abort part-install.
Thanks SilentX tried that and still no luck.
anyone else have any ideas??
Quote from: Yellowrose on August 01, 2007, 04:36:35 PM
Thanks SilentX tried that and still no luck.
anyone else have any ideas??
Is http://www.zooadmin.net/Smf/ where your forum is at? Note that the forum directory name starts with a capital S, which is different from the lowercase s.
If you want, you can PM me your account info (cPanel/phpMyAdmin and FTP details) and I'll see what I can do.
Thanks Sarge PM is on it's way
Well with a little prodding from an insider I managed to fix my error problem.
For those of you who also posted the above error hopefully the answer I give help you ll out as well.
when on page 1 of the install php here is what you need to enter
Forum name: Whatever name you are giving your forum
Forum URL:http://www.your (http://www.your) site/forum or YOUR directory folder name
MySQL Server Settings
MySQL server name: Leave as is - usually localhost
MySQL username: username you created for your database
MySQL password: the password you set for the database user
MySQL database name: the name you gave your database
MySQL table prefix: smf
always try to remember when you create your database that a prefix will be added to both your database name and your database username
example
username of yogibear will become *****_yogibear
database name of yogibear will become *****_yogibear
This added prefix must be added when entering information in the install php or you will get the error.
This is what solved my problem and hopefully it will also help you out as well.
About the install issue that vaughn771 was having:
1) It's a GoDaddy account. It looks to me like GoDaddy pends (queues) creation of databases and thus they take some time to be created. This may explain why the progress was so slow during the first time the install was run.
So your safest bet is to create the database through your account's control panel and proceed with the SMF install after the CP reports that the database has been set up -- it shouldn't take long, I think.
2) The "MySQL Server name" field in the first install page needs the server IP instead of the hostname (and it's neither localhost nor 127.0.0.1).
vaughn771, I'm marking ths topic as solved. If you need any more assistance with this, simply reply here.
To other members: please start a new topic if you experience similar issues.
Quote from: Sarge on August 03, 2007, 09:26:59 PM
2) The "MySQL Server name" field in the first install page needs the server IP instead of the hostname (and it's neither localhost nor 127.0.0.1).
He can see the "MySQL Server name" at the phpmyadmin. All he needs to do is click at the database that he has created for the installation of the smf, and it will be showen on the top left corner, where it says: '' Server:........'' ........ stands for the name of the "MySQL Server''
Quote from: babjusi on August 03, 2007, 09:31:45 PM
Quote from: Sarge on August 03, 2007, 09:26:59 PM
2) The "MySQL Server name" field in the first install page needs the server IP instead of the hostname (and it's neither localhost nor 127.0.0.1).
He can see the "MySQL Server name" at the phpmyadmin. All he needs to do is click at the database that he has created for the installation of the smf, and it will be showen on the top left corner, where it says: '' Server:........'' ........ stands for the name of the "MySQL Server''
Yes, I forgot to mention it, that's how I found out the correct value.