Need help with SPPC - PLEASE, live site

[aguzman]

I installed the SPPC newest version 413. I uploaded all the files and uploaded the sql file. Everything went fine but I get errors when I view a customers details in the admin section. Error is

 

1054 - Unknown column 'customers_groups_id' in 'field list'

 

select customers_groups_id, customers_groups_name from customers_groups order by customers_groups_name

 

[TEP STOP]

 

Then in my catalog main page I have the error

 

1054 - Unknown column 'g.customers_groups_discount' in 'field list'

 

select g.customers_groups_discount from customers_groups g inner join customers c on g.customers_groups_id = c.customers_groups_id and c.customers_id = ''

 

[TEP STOP]

 

Please, is there any advice any one can give me. j I really need this contribution, I backed everyting up and can reload my backed up files but I really need this to work.

[♥Monika in Germany]

I installed the SPPC newest version 413. I uploaded all the files and uploaded the sql file. Everything went fine but I get errors when I view a customers details in the admin section. Error is

 

1054 - Unknown column 'customers_groups_id' in 'field list'

 

select customers_groups_id, customers_groups_name from customers_groups order by customers_groups_name

 

[TEP STOP]

 

Then in my catalog main page I have the error

 

1054 - Unknown column 'g.customers_groups_discount' in 'field list'

 

select g.customers_groups_discount from customers_groups g inner join customers c on g.customers_groups_id = c.customers_groups_id and c.customers_id = ''

 

[TEP STOP]

 

Please, is there any advice any one can give me. j I really need this contribution, I backed everyting up and can reload my backed up files but I really need this to work.

 

are you 150% sure you let the sql file run in the correct database? The expression "uploaded" makes me wonder ...

[aguzman]

are you 150% sure you let the sql file run in the correct database? The expression "uploaded" makes me wonder ...

 

 

I'm not sure if I follow you but I imported or ran the spcc_v41_install.sql file in phpMyAdmin for the new installation of sppc that came with the contribution download.

 

Before that I uploaded all the files that came with the download in the correct folders.

 

Last month I did install Group_Discount contrib but that contribution doesn't do what I'm looking for. I need SPPC.

 

Please any advice/help would be great.

[Jan Zonjee]

I installed the SPPC newest version 413. I uploaded all the files and uploaded the sql file. Everything went fine but I get errors when I view a customers details in the admin section. Error is

 

1054 - Unknown column 'customers_groups_id' in 'field list'

 

select customers_groups_id, customers_groups_name from customers_groups order by customers_groups_name

Looks like you have code of the group discount contribution still on that page, since SPPC uses customers_group_id and customers_group_name in that table, not customers_groups_id and customers_groups_name.

 

Then in my catalog main page I have the error

 

1054 - Unknown column 'g.customers_groups_discount' in 'field list'

 

select g.customers_groups_discount from customers_groups g inner join customers c on g.customers_groups_id = c.customers_groups_id and c.customers_id = ''

 

[TEP STOP]

Looks like you deleted the database table but somewhere have code left of the discount contribution (could be in a box or a module, doesn't need to be in index.php).

[♥Monika in Germany]

I'm not sure if I follow you but I imported or ran the spcc_v41_install.sql file in phpMyAdmin for the new installation of sppc that came with the contribution download.

 

Before that I uploaded all the files that came with the download in the correct folders.

 

Last month I did install Group_Discount contrib but that contribution doesn't do what I'm looking for. I need SPPC.

 

Please any advice/help would be great.

 

Hi Al,

 

the error message says you have no column with that name, so I'd open phpmyadmin and check it.

[aguzman]

Hi Al,

 

the error message says you have no column with that name, so I'd open phpmyadmin and check it.

 

Ok, I have the admin section all fixed but the catalog still displays the error

 

1054 - Unknown column 'g.customers_groups_discount' in 'field list'

 

select g.customers_groups_discount from customers_groups g inner join customers c on g.customers_groups_id = c.customers_groups_id and c.customers_id = ''

 

[TEP STOP]

 

Please where can I find this file to change from customers_groups_id to customers_group_id. I doulbe checked the sql files and they are all correct and the admin section of the site is working fine, it has to be a php file that is still calling the old customers_groups_id and not SPPC's customers_group_id.

 

I need help locating this file. You can see the error at www.nespapool.org/osCommerce/catalog

[♥Monika in Germany]

Ok, I have the admin section all fixed but the catalog still displays the error

Please where can I find this file to change from customers_groups_id to customers_group_id. I doulbe checked the sql files and they are all correct and the admin section of the site is working fine, it has to be a php file that is still calling the old customers_groups_id and not SPPC's customers_group_id.

 

I need help locating this file. You can see the error at www.nespapool.org/osCommerce/catalog

 

Hi, it breaks your code in the what's new box ... that's where you need to look for it.

[aguzman]

Ok, I'm going to upload the sppc files agai and see what happens.

[aguzman]

Ok, I'm going to upload the sppc files agai and see what happens.

 

I uploaded all the files again but the error is still there. I don't know where the problem is.

 

:(

[Jan Zonjee]

I uploaded all the files again but the error is still there. I don't know where the problem is.

Check your includes/column_left.php. Where a default osC installation has: require(DIR_WS_BOXES . 'whats_new.php'); you might include another file since the html of the What's new box is not standard osC (just guessing).

[♥Monika in Germany]

I uploaded all the files again but the error is still there. I don't know where the problem is.

 

:(

 

please post your what'd new box file.

[aguzman]

please post your what'd new box file.

 

This is what I'm doing now, I downloaded a fresh clean copy of osCommerce and will replace the files that were altered by Group Discount, then reupload all the sppc files again.

 

By looking at the php files from both contributions - GroupDiscount and SPPC - they alter different php files within osCommerce. So I will replace the GroupDiscount files with clean copies.

 

Hope it works, the admin section is ok, everything works.

[aguzman]

Monika in Germany

 

Thanks for your help. My plan worked and I figured out that the files

currencies.php and shopping_cart.php located in catalog/includes/classes was causing the problems.

[aguzman]

OK, new problem. I want to be able to allow people to sign up for some events that we run. I put up a golf event and set the price for $125. the problem is how do I turn off the shipping costs for this but leave it on for my other items that require shipments?