My service provider switched server ip address - my forum is not working

[rkkota2002]

Dear Friends

Pls help, as my forum is not working and all of our 20000+ members effected.

Immediate help is very much apprciated.

here is the situation:

1) My hosting provider switched/moved everything to other server and
he has given me ipaddress of it.
And he told the forum database is also moved to this new server

2) I just updated my config file with new ip address:

// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = <I replaced this with new ip address>;
$config['MasterServer']['port'] = 3306;

I did not do any thing, but my forum is not working..
Is there anything i have to do still?

And an email is dispatched with the following content:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to MySQL server on 'newipaddress' (10061)
c:\WebSites\forums\includes\class_core.php on line 273

Do i have to do any thing else other than changing that one line in config.php file???

Pls help...

[Steve Machol]

Most likely the servername is wrong. 99 times out of 100 this should be left at 'localhost'. Did you try this?

[rkkota2002]

Hi steve - seems it helped a bit - but..

Hi steve - seems it helped a bit - but..

I changed to localhost
and now it is giving the following error::
Pls help me, you are the expert..
Error::-->>
There seems to have been a problem with the IMMIGRATION FORUMS database.
Please try again by clicking the Refresh button in your web browser.
An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.5.0:
Invalid SQL:
INSERT INTO vb_session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('d8e648bd2cc46889a042927e4f70c75a', 1, '67.188.84.56', '57c5039a2726d997cc97874ed5a0fafd', 1132897182, '/forums/login.php?do=login', 0, 0, 1, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Alexa Toolbar)', 1);
MySQL Error : Data too long for column 'useragent' at row 1
Error Number : 1406
Date : Friday, November 25th 2005 @ 12:39:42 AM
Script : http://websitename/forums/login.php
Referrer : http://websitename/forums/admincp/
IP Address : <ipaddress>
Username : admin
Classname : vB_Database
--------------------------

Hi stve, can you pls help with this situation...
Thanks alot for ur help..

[Steve Machol]

Try this query:

ALTER TABLE vb_session CHANGE useragent useragent VARCHAR(100) NOT NULL DEFAULT

[rkkota2002]

Hi Steve, I did that - here is error..

Seems it will work, if i can execute ur query on my database

I got some syntax error as below:

Error
SQL query:
ALTER TABLE vb_session CHANGE useragent useragent VARCHAR( 100 ) NOT NULL DEFAULT

MySQL said:
#1064 - 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 '' at line 1


Thanks alot for ur help..

[Steve Machol]

Can you check that field and table with phpMyAdmin?

[rkkota2002]

I did this frok phpmyadmin

Hi Steve

From PHPMYADMIN:

I chose the taeb "SQL" where i do not see any table/column to select
and i got the earlier error i have sent.

Now i went to tab "Query", where i could choose vbsession/useragent field from the drop down list and placed this query in "SQL query on database " field.

I even selected vb_session table in "Use Tables: " Field and submitted query.
It was showing the error:
You have to choose at least one column to display

I do not know steve, whether i am doing it correctly or not..

[rkkota2002]

Syntax - any suggestions

Hi Steve
I just got syntax spec for Alter table Change:

ALTER [IGNORE] TABLE tbl_name
alter_specification [, alter_specification] ...

alter_specification:
CHANGE [COLUMN] old_col_name column_definition
[FIRST|AFTER col_name]

I guess we missed this [FIRST|AFTER col_name]
Or is it optional ??

Thanks Alot Steve
Ravi

[rkkota2002]

Hi Steve i changed from phpmyadmin like this and it worked..

Hi Steve

I changed it from phpmyadmin

I changed length from default 100 to 150..

and it is working now..

ALTER TABLE vb_session CHANGE useragent useragent VARCHAR(150) NOT NULL DEFAULT

Thanks alot
I guess whatever i did is correct and does not make any trouble.

Ur expert comment helps me...
Thanks
Ravi