COWOA installation problem - Admin panel

[jawsbc]

Zen Cart Version: 1.3.9b
Template: Elegance-lite by 12leaves.com
Other modifications: changed name of admin page to improve security.
Searched FAQs, etc? Yes, for about 3 hours
COWOA add-on installed: 7/2/10 and 7/3/10.
SCREEN SHOT ATTACHED

Problem: I performed the COWOA add-on installation but it doesn't work. When I log into the Admin panel, I get this message in place of the usual statistics:

1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select count(*) as count from zen_customers WHERE COWOA_account = '0']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Additionally, under the Configuration section, there are supposed to be two COWOA related options that do not appear for me.

When going to try the checkout, there is no option for checking out without an account. (I wouldn't expect it to work, because I can't get to the COWOA Configuration options that need to be turned on.)

Attempts to fix the problem:

I have gone through every file in the list of updates and additions performed with the COWOA installation and made sure that they were all updated or added. I installed the SQL, then uninstalled it and reinstalled it when it didn't work the first time.

I have also restored the files from the backup and repeated everything. I am sure if I do this again I will be like the proverbial monkey, so I'm turning to this forum for help instead.

Notes:

I did be sure to change the name of the admin folder in the WOCOA add-on files, as well as the YOUR-TEMPLATE folder.

The site seems to be fine otherwise.

It seems to me that there is some problem with the Admin page (since that is where the odd message appears), and if I can get that resolved so I can turn on the COWOA options, maybe all will be fine.

Any help would be appreciated.

Thank you,

John

[JTheed]

Zen Cart Version: 1.3.9b
Template: Elegance-lite by 12leaves.com
Other modifications: changed name of admin page to improve security.
Searched FAQs, etc? Yes, for about 3 hours
COWOA add-on installed: 7/2/10 and 7/3/10.
SCREEN SHOT ATTACHED

Problem: I performed the COWOA add-on installation but it doesn't work. When I log into the Admin panel, I get this message in place of the usual statistics:

1054 Unknown column 'COWOA_account' in 'where clause'
in:
[select count(*) as count from zen_customers WHERE COWOA_account = '0']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Additionally, under the Configuration section, there are supposed to be two COWOA related options that do not appear for me.

When going to try the checkout, there is no option for checking out without an account. (I wouldn't expect it to work, because I can't get to the COWOA Configuration options that need to be turned on.)

Attempts to fix the problem:

I have gone through every file in the list of updates and additions performed with the COWOA installation and made sure that they were all updated or added. I installed the SQL, then uninstalled it and reinstalled it when it didn't work the first time.

I have also restored the files from the backup and repeated everything. I am sure if I do this again I will be like the proverbial monkey, so I'm turning to this forum for help instead.

Notes:

I did be sure to change the name of the admin folder in the WOCOA add-on files, as well as the YOUR-TEMPLATE folder.

The site seems to be fine otherwise.

It seems to me that there is some problem with the Admin page (since that is where the odd message appears), and if I can get that resolved so I can turn on the COWOA options, maybe all will be fine.

Any help would be appreciated.

Thank you,

John

First of all, you should have put this in the support thread located here : http://www.zen-cart.com/forum/showthread.php?t=156174 instead of starting a new one.
What your screen shot is showing is that the table in the database does not have this field (COWOA_account), which is in the SQL install of the mod. Did you copy and paste it in to the Admin SQL Patch section or did you browse for the file and upload it? Run the uninstall SQL file first thru the tools/admin/sqlpatch and then try installing the SQL file first by using the Tools/Admin/SQL Patch area, copy and paste it in making sure that it took, then add in the programs.
BTW, there has been a new release that hasn't been made available here but you can get it from My Mods Site.

[jawsbc]

Hi JTheed,

Thanks for your reply. Sorry for misplacing the thread.

Did you copy and paste it in to the Admin SQL Patch section or did you browse for the file and upload it?

I opened the sql file provided in the mod using "notepad.exe", copied everything in it (CTRL+C), and pasted it into the Tools/Install SQL Patch, then pressed SEND.

Run the uninstall SQL file first thru the tools/admin/sqlpatch and then try installing the SQL file first by using the Tools/Admin/SQL Patch area, copy and paste it in making sure that it took, then add in the programs.

Okay - but I have already added in the programs. So I understand that I will first uninstall the SQL patch, then restore the files from the backup to get everything the way it was, and then install the modification in the sequence you suggest (SQL patch first, then add programs).

BTW, there has been a new release that hasn't been made available here but you can get it from My Mods Site.

Thanks - sounds good!

[jawsbc]

I did everything according to your instructions with still no luck. The same error appears (it went away after I recovered from backup, but now it is back) and there are no settings in the Admin panel and there is no way to COWOA.

I think it may be that the SQL patch does not work. When I ran the uninstall patch, the error still appeared.

Rats.

[JTheed]

I did everything according to your instructions with still no luck. The same error appears (it went away after I recovered from backup, but now it is back) and there are no settings in the Admin panel and there is no way to COWOA.

I think it may be that the SQL patch does not work. When I ran the uninstall patch, the error still appeared.

Rats.

OK, lets start at the beginning. What are you running on, Windows or Linux or ? What version of PHP are you using?

After you install the SQL, do you get the Green Bar at the top of your admin screen saying that it installed OK?

Do you have a way to look at your database? If so, after you install the SQL file, look at your database and see if the COWOA_account is in the customers table.

Does your database have a prefix? It looks as though it does
'as count from zen_customers' perhaps it's not adding the prefix, although it did for me on one site, the rest I do not have a prefix.