Separate Pricing Per Customer Installation Issue

[ninthvector]

Attempting to integrate the separate pricing per customer contribution to an existing osCommerce store, I very carefully created backups of all applicable files, and then ok'd my database manager to run the spcc_v41_install.sql.

 

After making a routine update to application_top.php, I was no longer able to view the addresses of my customers in my admin. Similarly, my customers can not view their addresses when reveiwing their account info or checking out. The order process is working fine, however, with the lack of addresses, orders come through only displaying the products and total. With no addresses or customer information, the order is impossible to fulfill.

 

I have done everything from reverting to previous backups of the site, previous back ups of the database, and nothing will bring my customers' information back.

 

I can only imagine that somewhere there is a database function or script calling some non-existent SPCC tables. But I am unable to solve this issue. Any ideas would be welcomed!

[Jan Zonjee]

Attempting to integrate the separate pricing per customer contribution to an existing osCommerce store, I very carefully created backups of all applicable files, and then ok'd my database manager to run the spcc_v41_install.sql.

Very good.

 

After making a routine update to application_top.php, I was no longer able to view the addresses of my customers in my admin. Similarly, my customers can not view their addresses when reveiwing their account info or checking out. The order process is working fine, however, with the lack of addresses, orders come through only displaying the products and total. With no addresses or customer information, the order is impossible to fulfill.

What "routine update" was that. There are no "routine" updates to that file if you ask me.

 

I have done everything from reverting to previous backups of the site, previous back ups of the database, and nothing will bring my customers' information back.

If is was the change in application_top.php that caused it, that would explain it.

 

I can only imagine that somewhere there is a database function or script calling some non-existent SPCC tables. But I am unable to solve this issue. Any ideas would be welcomed!

If there are PHP errors your ISP might keep a log of them. Knowing about an error message is half the solution.

 

You could check if the changes in the tables needed for SPPC are there. First time I ever hear about such a strange error with SPPC so I'm not convinced there is a connection.

[ninthvector]

Re: routine update?

Thank you for the response JanZ. The osCommerce store we use has all of the filenames and and tables defined in application_top.php as opposed to filenames.php (I believe that's the name). I added some basic code (define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');) to my application_top.php file.

 

 

Very good.

 

What "routine update" was that. There are no "routine" updates to that file if you ask me.

 

If is was the change in application_top.php that caused it, that would explain it.

 

If there are PHP errors your ISP might keep a log of them. Knowing about an error message is half the solution.

 

You could check if the changes in the tables needed for SPPC are there. First time I ever hear about such a strange error with SPPC so I'm not convinced there is a connection.

[ninthvector]

In case anyone has been following this post, or ever experiences the same strange issue - the cause was in the database. The data for the following tables: customers_id and address_book_id was reversed in one of our many, many db backups. Tricky mistake to pinpoint - be careful when you're populating database tables!

 

Attempting to integrate the separate pricing per customer contribution to an existing osCommerce store, I very carefully created backups of all applicable files, and then ok'd my database manager to run the spcc_v41_install.sql.

 

After making a routine update to application_top.php, I was no longer able to view the addresses of my customers in my admin. Similarly, my customers can not view their addresses when reveiwing their account info or checking out. The order process is working fine, however, with the lack of addresses, orders come through only displaying the products and total. With no addresses or customer information, the order is impossible to fulfill.

 

I have done everything from reverting to previous backups of the site, previous back ups of the database, and nothing will bring my customers' information back.

 

I can only imagine that somewhere there is a database function or script calling some non-existent SPCC tables. But I am unable to solve this issue. Any ideas would be welcomed!