Problem with customers.php (admin side)

[mobas]

Hello,

 

I'm fairly new to osCommerce. I'm trying to modify it so that I can have different user levels. I've added a column to customers (customers_u_level) and I'm using MySQL Server 5.0. The error I receive on customers.php is:

 

------------------------------------------

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

 

select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, customers_u_level, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '13'

 

[TEP STOP]

-------------------------------------------

 

When I run this query directly in MySQL Console or Navicat I get data.

 

I did some research and found that I had to run a MySQL script called "mysql_fix_privilege_tables.sql" because we recently upgraded to MySQL Server 5.0. I ran this script for both Server 4.10 and 5.0. This did not solve my problems. I then deleted the column from the table and re-created it using ALTER TABLE command...this also did not help.

 

Does anyone know why I might be getting this error? Any help would be much appreciated....

 

Thanks,

mobas

[♥Vger]

Had you thought about using the existing contribution called 'Admin access with levels'?

 

Vger

[mobas]

No, but I'm also trying to add different pricing levels based on user levels....would this add-on allow me to do this too?

[mobas]

Is there somewhere in osCommerce that I should add my new column to a 'field list' or something?

 

Or does this error seem like it's strictly MySQL - and nothing to do with osCommerce??