I recently upgraded from 3.1.4 to 3.1.6. My members are now receiving an error when attempting to access their account information screen... MYSQL ERROR: Unknown column 'member_id' in 'where clause' in query: SELECT * FROM extremeb_coupon WHERE 1 AND member_id='9882' HELP!! Thanks
Getting same error here!!! MYSQL ERROR: Unknown column 'member_id' in 'where clause' in query: SELECT * FROM amember_coupon WHERE 1 AND member_id='1'
did you run the db update after uploading the new files? There's a sql file with the latest update which adds a "member_id" field to the coupon table.
Run: Code: \amember\admin\upgrade_db.php Please do check back and let us know if this fixes the issue for you.
hm....do you see a "member_id" field in the "coupons" table? I really can't think of anything else that would be causing that specific error except not having it. I'm not trying to be a smartass here but are you sure you had the sql file from the latest update in the root of your AMember folder when you ran http://yoursite.com/amember/admin/upgrade_db.php? I don't think it would be a caching problem but might want to clear the templates_c directory, too.
I experienced the same thing. Then went to admin and unchecked coupons and it works. At least for me, the issue appears related to coupons. I will wait for support (submitted ticket), and their fix, before checking (allowing) coupons again.
Same problem here. How do I implement this fix? Uploading the fixed files won't fix any database issues, because the upgrade_db script will think I am already on version 3.1.6. Maybe you could deliver an sql-script I can run to fix this problem.
How is this helping all the people who already downloaded and installed the original version 3.1.6? You should send an e-mail to all aMember PRO owners, to tell them about this problem and inform them how they can fix this. Proper version control does not allow you to make changes to an already distributed version without changing the version number.
Coupon related MySQL error Please let us know how to get the Coupon/Member_ID related MySQL fixed for the latest 3.1.6 upgrade for those that already downloaded the upgrade when the bug was still there. As it stands now, one has to disable Coupons to get login working. Please provide step-by-step instructions.
fixed? I am confused about which version no longer has this issue. Waiting for someone to confirm that this problem is fixed, and how to apply the fix...etc... I'm on version 3.09 and have yet to upgrade...I will wait until this gets fixed.
"Database version were not upgraded in common.inc.php" Alex had said it was a script problem, so uploading the new version should fix that error. David
could someone state clearly and step-by-step what to do if one has already upgraded to 3.1.6 and the coupon issue is causing fatal error for users to login? tried downloading the latest 3.1.4->3.1.6 upgrade and tried uploading that, login fails tried re-loading .sql and running the db update, the login still fails. tried re-loading common.inc.php, the login still fails. please state clearly what to do.... as such, coupons are not working (the coupon table entry does not have member_id, this is likely the cause, but how do we fix it)?
Here is how this can be fixed: 1. Download aMember PRO latest version or upgrade package that you used again. 2. reupload two files from that package : amember.sql and common.inc.php 3. Run /amember/admin/upgrade_db.php If this didn't help. 1. Rollback amember database version from phpMyAdmin using this query: update amember_config set value = '313' where name='db_version' Then run /amember/admin/upgrade_db.php or 2. Add filed member_id to amember_coupons table (int not null default 0) You can also contact us in helpdesk with "URGENT UPGRADE ISSUE" subject we will fix this issue asap.
Sampe problem I am having the same problem. I have tried what you mentioned here without lock. The other option about rollback is too technical for me. I issued a ticket but didn't have the URGENT heading you mentioned here. Please help. Ticke no. Ticket ID: ZGN-16787-341
uconcept, just to be sure: 1) Clear your browser cache and delete your previous downloaded version of the aMember code to your PC (NOT your server copy :-p) 2) Redownload the aMember Pro code 3) upload \amember\amember.sql and \amember\common.inc.php to your server 4) from your browser, run http://{yourdomain.com}/amember/upgrade_db.php Do you get an error message? If you still have problems, email me at my userid here @ hotmail.com and I'll do what I can to help.
I performed the above patches and all is now good. Wished I had waited longer next time to perform an upgrade.