Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
I have a heavy load on my server so my server people suggested I get a second server and set up my forums Mysql database on it. After many days working on this here are their responses:

2006-01-13 / 13:20:27

Hi Rick,
I had masood working on the MySQL as he is more knowlegeable about it than I and he is saying that its a problem with the forums scripts. This surely throws a wrench in the works. He is suggesting you contact the developers of the script and see if they have any updates or fixes so remote databases can be used.

Please let us know if we can be of further assistance.

Regards,
Les


and

2006-01-13 / 13:05:37
Your forum is unable to work with a remote mysql database. You will need to check with developers of your forum software and find a fix for that. I have changed the mysql back to local server.

Let us know if you need further assistance.

Regards,
Masood


They previously suggested I move my forums over to vBulletin.

What can we do to get this to work?

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
This forum does not appear to be very busy. How much experiance do you folks have with busy forums?

Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
remote databases work well with ubb.threads, I work with a site now who hosts their scripts on one server and have their mysql db on another. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Yes, the forums are a bit slow - support is spread across several sites for the different scripts/apps.


- Allen
- ThreadsDev | PraiseCafe
Joined: Jun 2006
Posts: 93
A
journeyman
journeyman
A Offline
Joined: Jun 2006
Posts: 93
To use a remote database, just change the database connection settings in the configuration file.
Hostname, user, password

Or are they talking about a replication setup? If so, feel free to contact me. To use a replication, some changes to the code will ben necessary.


---
Take your community to the next level
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Look at your config file.

Where it says $config['dbserver'] = "localhost";

Change that to whichever server they want you to connect to. It's also in your control panel. It is also in your control panel, under database host.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Thanks David, Astaran & Allen,
Here is what my server guys tell me:
This still doesnt explain why UBB works fine for about an hour on the remote server and then decides to error out. We did exactly as the person you quoted mentioned and still after an hour of successfull board operation the errors begin.

It did seem to work fine for about an hour and then the boards would go down with errors that say the following:

Warning: mysql_query(): Unable to save result set in /home/fishingm/public_html/forum/mysql.inc.php on line 107 SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/fishingm/public_html/forum/mysql.inc.php on line 133


The above came up in the forums after an hour or so of smooth operation with the remote server.

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Any suggestions on how to make it work?

Joined: Jun 2006
Posts: 93
A
journeyman
journeyman
A Offline
Joined: Jun 2006
Posts: 93
Edit mysql.inc.php and change
$showerror = 0;

to
$showerror = 1;

Doing so will display the mysql error message to all users, so that your server folks will the what's the exact problem.


---
Take your community to the next level
Joined: Jun 2006
Posts: 346
J
enthusiast
enthusiast
J Offline
Joined: Jun 2006
Posts: 346
I'm betting the mysql settings are to low and it's choaking.


--
Website Development and Management
www.jcswebdev.com
Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
Do you use mySQL 5.x on the new databse server? Back to 4.x <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" /> I run my my forum on a server and the databse on another server. This works very well.


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Feb 2004
Posts: 86
K
journeyman
journeyman
K Offline
Joined: Feb 2004
Posts: 86
Zarzal is right - 5.x is still formally unsupported, so if you're running 5.x, you might try 4.x instead.


Kate Thaete
Groupee Guide: Scriptkeeper
Groupee, Inc.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 744 guests, and 147 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.0
(Preview build 20230217)