Forum What should I do?
 

I'm paying someone to move my 3.6.4 version to a new server so that I can upgrade it to version 4....this is becuase of the PHP and MySQL requirements.

The new server is running PHP 5 and MySQL 4.....

The old server is not.....so thus the move...



OK...so now everything from my 3.6.4 has been moved to the new server.....and now I want to test....so I'm accessing via the IP address because the site is not live and the DNS has not been moved.

I go to the site I see my VB CLOSED MESSAGE!!!!

So I try to get to my ADMIN CP to log in..

I put in the URL to the ADMIN CP...and I get the log in page.

I put in my username and password and it say welcome back Kirk Voclain and you are going to be re-directed.

It does and then I get re-directed BACK to the ADMIN LOG IN PAGE with no username and password.....

I put it in again and now I get this database error message:

Quote:
“Invalid SQL:
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM subscriptionlog AS subscriptionlog, subscription AS subscription
LEFT JOIN user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != ‘0’ AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = 151 AND subscriptionlog.expirydate < 1286817944
ORDER BY subscriptionlog.expirydate ASC LIMIT 5;
MySQL Error : Unknown column ‘subscriptionlog.userid’ in ‘on clause’”
This is because mysql 5 doesn’t allow a join using comma anymore. It can be fixed by modifiyng
“FROM subscriptionlog AS subscriptionlog, subscription AS subscription” to
“FROM subscriptionlog AS subscriptionlog JOIN subscription AS subscription”.

So...I just go to the HOME PAGE...and try to log in there....put in my username and password and it's trying to send me back to the ACTIVE URL...not the IP URL.....could this be why I'm getting the above message?

I'm dead in the water here......because now the SiTE MOVERS are saying they think that the 3.6.4 version of VB is not compatable with the upgraded PHP and MySQL and want to do the upgrade with out testing and getting this thing working first.

WHAT DO YA'LL RECCOMEND?????

HELP...I'm trying like crazy to get this working again and the clock is ticking!!!!

Thanks in advance for all your suggestions.

Kirk