Previous Thread
Next Thread
Print Thread
Hop To
#261116 02/09/2018 11:05 PM
Joined: Jun 2016
Posts: 4
stranger
stranger
Joined: Jun 2016
Posts: 4
I have been able to install the forums software, but my forums will still not work. I created a new mySql database. Using install.php won't go beyond Step 3 and gives this message:

Step 3
Here we are checking your database connectivity and permissions. If any of these checks fail you will need to correct the errors in order to proceed.

Connecting to server

Going to my forums produces this message:

Warning: include(/libs/ver.inc.php): failed to open stream: No such file or directory in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

Warning: include(): Failed opening '/libs/ver.inc.php' for inclusion (include_path='.:/usr/share/php') in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /users/dark-poet.info/htdocs/forums/libs/mysql.inc.php:21 Stack trace: #0 /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php(92): sql->connect() #1 /users/dark-poet.info/htdocs/forums/ubbthreads.php(42): require_once('/users/dark-poe...') #2 /users/dark-poet.info/htdocs/forums/index.php(19): include('/users/dark-poe...') #3 {main} thrown in /users/dark-poet.info/htdocs/forums/libs/mysql.inc.php on line 21

All files are chmoded to the values given on the UBB installation page. I would appreciate any help/advice you will provide. Thank you much for your help and time.

Joined: Jun 2006
Posts: 16,355
Likes: 125
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,355
Likes: 125
The error message on the forums is because the configuration file hasn't been written to by the installer; it's looking for a variable (the path to the folder) which doesn't exist, so it's trying to load it anyway.

As it looks like the installer is stalling at the database steps, please ensure that your username, password, and database information are all correct; UBB.threads will not create a database for you, it will simply insert the forum information into the database to get you started.

As for the installer, could you try re-uploading the UBB.threads archive that you downloaded from UBBCentral; I just ran an upgrade with the files last night, and Isaac ran a couple of fresh installs prior to release, so it should work. If it cannot continue again, please check your hosting with the System Requirements Test.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,624
Likes: 84
Joined: Dec 2003
Posts: 6,624
Likes: 84
Remember that the forum will not run at all until you complete the install.php script.

You did create a mysql database and a database user with global permissions before you started the install.php script
Is this correct?
You will need that info as well as the server host usually locahost to enter into the install script when prompted

Another item is say you name the database 123 with a user name of me.
Some hosts attach a prefix to them such as it would become say
database domain_123
user domain_me

Also the install script is usually good figuring out your paths but not always 100% so don't just skip over them to the next step. Review them and correct them as needed.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Gizmo #261125 02/11/2018 12:39 AM
Joined: Jun 2016
Posts: 4
stranger
stranger
Joined: Jun 2016
Posts: 4
Alright then. The system requirements test passed. I started the install script and reached step 3 before receiving this message:


"Step 3
Here we are checking your database connectivity and permissions. If any of these checks fail you will need to correct the errors in order to proceed.

Connecting to server FAILED
Connecting to database FAILED

One or more of the above checks failed. Click the button below to return to the previous screen to verify your settings."


I have verified my server name, mysql database login and password. I have no idea how to determine the table prefix. I also assume that the database does not have global permissions. How do I set that, and how do I find the path to my database?

Last edited by Broadwing; 02/11/2018 1:16 AM. Reason: More Information Found
Joined: Jun 2006
Posts: 16,355
Likes: 125
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,355
Likes: 125
It looks like the database connection is being refused; please validate the correct MySQL database user, host, and password are correct. Some control panels have their user accounts as [site username]_[created database user] (ie siteuser_username), please validate that wherever the username is displayed that it is displayed EXACTLY as you're entering. If you are copying and pasting you'll want to make sure that you're not copying any " " blank characters (which tends to happen when copying from an email or a web page). You'll also want to make sure that the created MySQL user has been granted sufficient access to the new database that you've created.

Some control panels do not assign the same password to the MySQL database user as the FTP password; try going into your web hosts control panel and change the database password to what you think it already is.

The table prefix is simply what you'd like the table names prefixed with; if you have multiple installs in the same database you would set the prefix on install B as a different one from install A so that the databases can run along side eachother. The default is fine, and there is no validation necessary for this field.

I have just validated that the latest copy of the v7.6.1 install archive from the member area is capable of running a new install without any problems.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,624
Likes: 84
Joined: Dec 2003
Posts: 6,624
Likes: 84
the default database table prefix is ubbt_
Unless you changed it during the install.
You can look in phpmyadmin in your site control panel as well as see the full database name and users if your versions allow to see everything.
Otherwise go back to the main view of your site controlpanel and look for something like mysql. They are all a little different depending on what control panel your host provided but it would be where you created the database and user to begin with.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2016
Posts: 4
stranger
stranger
Joined: Jun 2016
Posts: 4
phpMyAdmin is not working. I've notified my host to get that fixed.

1) I created the database.
2) Set login and password exactly.
3) Ran the install script again.
4) Set permissions on the database to 777.
5) Received the message that connecting to server and database failed.

Trying to access my forums gives this message now:

"Warning: include(/libs/ver.inc.php): failed to open stream: No such file or directory in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

Warning: include(/libs/ver.inc.php): failed to open stream: No such file or directory in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

Warning: include(): Failed opening '/libs/ver.inc.php' for inclusion (include_path='.:/usr/share/php') in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

Database error only visible to forum administrators"


Line 9 of that script reads: include("{$config['FULL_PATH']}/libs/ver.inc.php");

libs is there as is the script called out.

Joined: Dec 2003
Posts: 6,624
Likes: 84
Joined: Dec 2003
Posts: 6,624
Likes: 84
Read My PM.
You don't even have a built database at this point, so it is a waste of time to try to keep running the forum till you
complete the install script.

If you get the phpmyadimn to work you will see there is nothing there.

The first thing is to fix the server connection issue to complete the install script or you are dead in the water.
The $config['FULL_PATH is not even set at this point in the config file again till you complete the install script.

Nothing will work at all till the install script completes.
It builds the database it creates the paths and settings to run the forum
So your database and config file are blank paths are blank at this point in time
Till you resolve your connection issue and complete the install script.
I offered to help in the pm ,but i would need access to your site control panel.

Last edited by Ruben; 02/12/2018 8:18 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2016
Posts: 4
stranger
stranger
Joined: Jun 2016
Posts: 4
Update: I purchased a domain through GoDaddy to try and do an install there. They confirmed they use PHP 5+ and are mysql_connect compatible. I had tech support there run a mySql diagnostic on the database I created for the forums. The test script was able to connect to the database using the database name, login, and pass. I then ran the install.php for UBBthreads. Step 1 passed. Step 2, I entered the correct connection information that had been verified by the test script. Step 3 gave me the message "Connecting To Server" and remained that way for nearly 40 minutes before I called it quits.

GoDaddy supports both mySql_connect and mySqli, other UBB forums run on their servers. The tech believes there is an error in the install script that prevents it from connecting to the database. He directed me to try to learn the steps needed to convert and allow mysql_connect to be used on machines using mysqli. Apparently, mysql is being deprecated. I have found several methods, but all involve the working scripts and not an install script.

So, I've tried installing at two vastly different hosting companies, one Unix and one Linux, and had the same result. I would appreciate someone looking into this now.

Joined: Apr 2004
Posts: 1,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
From your PM to me earlier today.
Originally Posted by Broadwing
I'm sorry to bother you with this, but I do need someone with expertise, patience, and a decent "bedside manner." If you would look over the history of my problem, at this thread mySql Problem then I would be grateful, sir.

Thank you for your time.

Its usually good practice to post support answers in the public forum, so others can also benifit from them.

Originally Posted by Broadwing
Step 1 passed. Step 2, I entered the correct connection information that had been verified by the test script. Step 3 gave me the message "Connecting To Server"

As Ruben and Gizmo has posted earlier, this sounds exactly like a DATABASE CONNECTION ISSUE on your web server. You'll need to get the database connection information directly from your server/webhost.

You mentioned that you downloaded the Test Script and used information from that script for connecting to the DB. If you are coming from an upgrade after moving to a new server, you are probably pulling in old server connection information from config files which are irrelevant to your new server.

Again, those details should be retrieved from your current server/webhost. Not from an old install.

My suggestions:

For a new install:
1) Download a fresh copy of the ubbthreads-7-6-1 archive from Member area.
2) Follow the directions listed here: https://www.ubbcentral.com/doc_install.php

For a forum upgrade:
1) Download a fresh copy of the ubbthreads-7-6-1 archive from Member area.
2) Follow the directions listed here: https://www.ubbcentral.com/doc_upgrade7.php
Attachments
2.database_info.png 3.database_check.png e3.database_check_error_check.png 4.paths_urls.png


current developer of UBB.threads php forum software
current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Apr 2004
Posts: 1,973
Likes: 154
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,973
Likes: 154
Also, reading the ERROR you've shared in your initial post,

Quote
Warning: include(): Failed opening '/libs/ver.inc.php' for inclusion (include_path='.:/usr/share/php') in /users/dark-poet.info/htdocs/forums/libs/ubbthreads.inc.php on line 9

it looks like you have an invalid path there:
".:/usr/share/php"

change to:
"/usr/share/php"

...or whatever the correct absolute path on your server should be.

And this is the reason why your initial install would fail.


current developer of UBB.threads php forum software
current release: UBB.threads 8.0.0 // wip: UBB.threads 8.0.1
isaac @ id242.com // my forum @ CelicaHobby.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Another error
by Baldeagle - 10/07/2024 9:08 PM
Is this a cookie issue?
by Baldeagle - 10/05/2024 2:01 PM
Search button not there
by ehill - 10/02/2024 2:56 PM
Change the Order of the buttons in a post
by Unixspot - 09/19/2024 10:04 PM
Purging logs does not work
by Baldeagle - 09/12/2024 5:16 PM
Who's Online Now
1 members (Gizmo), 648 guests, and 53 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)