Thread: Logon problems
View Single Post
Old August 23rd, 2009, 03:26 AM   #1 (permalink)
drare
Member
Verified Customer
 
Join Date: Feb 2009
Location: Holland
Posts: 116
Logon problems

Chuck,

Last nigth (European time) our site has been transfered to another server on Midphase, as you may know we have PP and vb3 intergrated, login on to vb3 goes without problems, but when I go to PP galery I'm logged out and get this error message:

Quote:
An error was encountered during execution of the query:

SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,s.lastactivity,u.membergroupids FROM bb_user u LEFT JOIN bb_session s ON s.userid=u.userid WHERE u.userid=1lsXjfBfLXaugTauh2I-fxym7sdx6YJmGkqwFbugD7w.

The query returned with an errorcode of:

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
This I see when I try to logon to the PP admin panel:
Quote:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/wfcfoos8/public_html/forums/vb3.php on line 32
Midphase says this after the move (now 8 hours ago):
Quote:
Please note that your site will be down until DNS changes propagate across the internet
I can't find anything wrong in the admin panel of PP, any suggestions?
The site is up and running no other error appear, both PP and vb3 are working only logging on to PP is not working properly. I know that more people are experiencing this, but I also see people uploading photo's and seem not to have this problem, and I only get the database error for my ID (1) only.

When I clean all temp files, delete all cookies etc. I shut down IE of FF, start again with no browser history, logon in PP, I'm logged in, when I go ro VB I stay logged in, but when I go back PP I'm logged out!!! And vice versa, when I can login to PP and go to VB I'm logged out!! And this is for all users, I'm not sure anymore why and wat to do anymore, nothing has changed!

Cookies values are the same as in VB
I see people do get logged in, so this is strange.

Last edited by drare; August 23rd, 2009 at 07:53 AM.
drare is offline   Reply With Quote