1146 Error In Specials.php - Table 'shop.table_customers_groups' Doesn't Exist

[jptechnical]

in specials.php when adding a new special I get the following error:

 

1146 - Table 'shop.TABLE_CUSTOMERS_GROUPS' doesn't exist

select customers_group_name, customers_group_id from TABLE_CUSTOMERS_GROUPS order by customers_group_id

[TEP STOP]

 

I have recently battled the 1054 errors because of the PHP and MySQL upgrades. I have it working at present, but it took lots of diff'ing to make it work at all. I think it has to do with the price per customer mod, I had to comment this out in other places. I can't find the reference to the database call in the file. My coding skills are little more then hacking something to fit, I don't KNOW php.

 

I just need to get this to work for another couple weeks till I finish my upgrade to the newest OSC.

 

Any ideas how I can fix this, even if it is temporary?

 

Thanks!

[Jan Zonjee]

in specials.php when adding a new special I get the following error:

 

1146 - Table 'shop.TABLE_CUSTOMERS_GROUPS' doesn't exist

select customers_group_name, customers_group_id from TABLE_CUSTOMERS_GROUPS order by customers_group_id

[TEP STOP]

 

I have recently battled the 1054 errors because of the PHP and MySQL upgrades. I have it working at present, but it took lots of diff'ing to make it work at all. I think it has to do with the price per customer mod, I had to comment this out in other places. I can't find the reference to the database call in the file. My coding skills are little more then hacking something to fit, I don't KNOW php.

 

I just need to get this to work for another couple weeks till I finish my upgrade to the newest OSC.

 

Any ideas how I can fix this, even if it is temporary?

If the table exists you must have forgotten to add the defines for that table to admin/includes/database_tables.php. Installing contributions only half and then try to fix errors you introduce by not finishing the job is not a good idea IMHO.