Login shows Database Query error after upgrade

I upgraded from 7.0.0 to 7.0.1 and the only way I can login is using the /administration/ login.

Once I login there, I can browse and use the site. But if I log out and try login with any account on the public side, it will show a DATABASE QUERY ERROR and I cannot get in.

Any suggestions?

Richard

Check your bug report email, it should have sent you the complete error details about what caused the database error, please post it here....

I have checked and no emails or bug report are being generated.....

Richard

I have also now installed the 7.0.1 upgrade and then the 7.0.2 upgrade and still get a DATABASE QUERY ERROR when trying  to login from the public side and the member.php tries to load.

I can go to the Administration login page, use an admin login, and browse the entire site including my DASHBOARD and have no hiccups.

Any hints as to why it would not load through the public login but will be OK when you go through the Admin side and then browse the site and account pages without any issues?

Richard

The big difference is the page it loads after logon. From the back-end it loads the admin page after logon. From the front end it loads member.php

So its possible that member.php from the upgrade may have been corrupt during upload, which seem unlikely it would happen twice considering member.php exists in both upgrades. The other possibility is if you have any mods that add additional information or blocks to the member page, that might be it. A mod not compatible with the upgrade.

We need more info on the database error.

Open inc/classes/BxDolDb.php and find this line.

define( 'DB_FULL_DEBUG_MODE', false );

Change it to this.

define( 'DB_FULL_DEBUG_MODE', true );

That should provide a more detailed error message.

We only need to see the mysql error, not the backtrace info after it.

Found error in the file '/home/couples2/public_html/member.php' at line 683.
Called 'db_res' function with erroneous argument #0.

I find that the error comes from DeeEmm IP capture mod...

http://www.boonex.com/unity/extensions/entry/FREE_MOD_DeeEmm_Record_user_ID_with_IP_address

My syntax is exact as the mod instructs, but something is wrong in the SQL

$sInsertSQL = "INSERT INTO `sys_ip_members_visits` SET `From`='{$sCurLongIP}', `DateTime`=NOW(), `UserID`