|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Hello. I am trying to install a UBB Forum for a friend of mine whose hosting has just gone down. I am from a .net background (hopefully this doesn't count against me) and I'm struggling with the config somewhat. The old version was running from 6.1 and mysql 4.0. I have mysql 4.1 and 5.0 running on my machine and I have a copy of ubb 7 installed at this location - http://www.talkmorgan.co.uk/forums/ubbthreads.phpI have the old database, or at least I think I have, installed into the mysql 5.0 folder and I can query the contents from the command prompt. So my question is how can I get the new ubb 7 forum to see the old mysql data. Thanks very much for your help. Yours, Dave
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
I'd think that each mysql process has its own port on the same server, if so then it's just a matter of updating the configuration file to read from one location vs the other.
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Hi.
Is the configuration file you are referring to you includes/config.inc.php?
If so, which property should I be editing? If not, which config file are you referring to?
Thanks again. Dave
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
There is only one config file: includes/config.inc.php
The top area should deal with connection information; I'm not entirely sure if Rick allows specifying a specific port in the configuration however... if it doesn't then you may have to edit the mysql lib file.
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
Before I say anythimg more, i figure I should ask, how do you connect to the OTHER mysql server? is it a seperate port, or a seperate hostname, or what?
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Hello.
I have the error message up now - Table 'morgan.w3t_user_profile' doesn't exist
This is presumably because there is database schema changes in ubb 7?
I seem to be going round in circles. Have you any advice about how I can best get the old forum up and running?
Thanks, Dave
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
Umm, you're not just throwing up the new files and trying to shove in the old database info are you?
IIRC UBB6 uses w3t as the standard table prefix, whereas UBB7 uses ubbt, hence the question.
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
I think a better question is, what version of the UBB is your "old" database? Is it UBB7 or UBB6?
If it's UBB6 you'll need to install the latest 6.5.5 then import to UBB7 as there has been a complete rewrite from the ground up.
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Yes. The old database is version 6.
I tried doing it this way round initially but was told at the end of the installation that ubb 6 does support mysql 5.
So basically I need to install ubb 6.5.5 to mysql 4x and then upgrade?
Thanks, Dave
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Yep
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
You will have to install UBB.Threads 6.5 to the MySQL 4 server, then do the migration to UBB.Threads 7 to the MySQL5 server. I have an upgrade guide here.
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Hello. Thanks loads to those who helped me out. However I have a couple of further problems now that I have managed to get the forum to actually appear. This is my url - http://www.talkmorgan.co.uk/forumsThese are my problems: 1) I can't manage to configure the mail send-outs. I am well aware from searches on this forum and google searches that this isn't a new issue, but I can't seem to find a good fix for my specific error - SMTP server response: 550 must be authenticated. Can anyone shed any light on this? 2) Session state doesn't appear to be functioning. When I log in, I am immediately logged out? Please let me know if it would be more convenient to post these issues are separate threads. Thanks, Dave
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
If you need to authenticate to your SMTP server then currently you'll need to edit the libs/phpmailer/class.phpmailer.php file. In there you'll see a section dedicated to SMTP variables, a couple of them being SMTPAuth, Username and Password
As for the session state. I'd try manually clearing out any cookies from your site. It could be an older cookie before the move causing problems.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
After looking at your forum, I see your running 6.5.5 still. Unforunately you need to disregard my previous statement. In that version there is no way to handle SMTP Autentication.
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Hello again.
Many thanks again for your assistance.
I now have the forum running 7.1 and I can see already it is very much improved.
How can I import my 6.5 stylesheet though? Or do I need to make it again?
Thanks, Dave
|
|
|
|
Joined: Mar 2007
Posts: 19
stranger
|
stranger
Joined: Mar 2007
Posts: 19 |
Actually,
I thought I had answered by own question when I found the import style option in the control panel. However, when I try the import I get this error:
Parse error: parse error in E:\Inetpub\wwwroot\talkMorgan\public_html\forums\styles\2.php on line 11
Any ideas?
Thanks, Dave
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
Visit the style sheet forum, import a 7.1 template style sheet as a base to work from. I doubt you old style sheet will work at all
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
UBB.T6 and UBB.T7 themes are not compatable; you will need to remake the them for UBB.T7.
|
|
|
1 members (rootman),
641
guests, and
112
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|