Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can't pull up my catalog to make changes.


Aye Poppin

Recommended Posts

Posted

All I get is this.

 

Categories / Products Status Action

Mens Tees

Womens Tees

1054 - Unknown column 'p.products_bimage' in 'field list'

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_bimage, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

Posted

Looks like you have a speelink mistoike in your sql statement.

 

The field products_bimage does not exist in the table products.

 

Try changing it to products_image

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Posted

Did you by chance add the Big Images contribution?

 

If so it seems you forgot to run the SQL query to update the database.

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

k now I am geting this on the site itself.

 

1146 - Table 'osdb.TABLE_COUNTER' doesn't exist

 

select startdate, counter from TABLE_COUNTER

Posted

ok defined a counter in the above post and it has left me with tthis.

 

Warning: main(includes/database_tables.php): failed to open stream: No such file or directory in /home/httpd/vhosts/ayepoppintees.com/httpdocs/admin/includes/application_top.php on line 47

 

Warning: main(includes/database_tables.php): failed to open stream: No such file or directory in /home/httpd/vhosts/ayepoppintees.com/httpdocs/admin/includes/application_top.php on line 47

 

Fatal error: main(): Failed opening required 'includes/database_tables.php' (include_path='.:/usr/share/pear') in /home/httpd/vhosts/ayepoppintees.com/httpdocs/admin/includes/application_top.php on line 47

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...