HELP! - Error in SQL syntax Live Server?

Hi.

I have uploaded a website I built (Social Network) too 2 different servers... it works fine on 1 hosted with host gator.. the other (exactly the same files)

its giving me a 'Error in SQL syntax' error and a white screen on every page.. all the connections file is correct.. whats happening?

Please see Below for more info

I'd have to look at the code on the page, and probably need ftp access to completely debug it. Is it possible the database table names are different?

Yes Please!

This makes no sense

I have tried various different things...

These same exact files work fine on another domain.. and the database connection is fine as I tested that on another page...

The database is also fine...

I really dont see what this could be unless there is an issue with the web host or as i read in another post on here... perhaps and issue with the webassist mysqli rsobj file?

Any help really would be great!

This is a connection error. I've debugged and see the error (listed in private area since it includes your username)

This post has been deleted.

There is nothing wrong with that syntax... it means the username and/or password are incorrect. Go to php myadmin and make sure that those are the correct credentials you area able to use to log in.

If you still can't fix it, then post back a link to your admin back end so I can log into php myAdmin and I can take a look.

Hi,

Thank You!

It works... I am not sure what happened... I created a user and added all the need privileges.. but for some reason it didn't take affect...

I just created a new user and added them to the database and it works....

Anyway...

thanks for the push in the right direction :)