vidmarc Posted August 31, 2005 Share Posted August 31, 2005 I'm having a lot of difficulty setting up my first osCommerce store. Is there some sort of flow chart somewhere that talks newcomers through each of the stages in a simple manner? All I'm trying to do is set up a store which announces our company's DVD releases, as well as a separate list of productions we're working on (these won't be items you can purchase - more a sort of list of what documentaries we've made. When I add items to the product list and then click on them from the front page, the links aren't working and I am tearing my hair out trying to work out what I'm doing wrong. When I select an item form DVD I'm getting [TEP STOP] = what does this mean? www.nucleusfilms.com Link to comment Share on other sites More sharing options...
Winterchild Posted August 31, 2005 Share Posted August 31, 2005 1146 - Table 'db122375493.TABLE_PRODUCTS_EXTRA_FIELDS' doesn't existSELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM TABLE_PRODUCTS_EXTRA_FIELDS pef LEFT JOIN TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE pef.products_extra_fields_status = 1 and ptf.products_id=31 ORDER BY products_extra_fields_order [TEP STOP] This is the entire code you get on DVD (black text on black doesn't show :) ) This means you haven't defined the tables in database_tables.php yet. (catalog/includes/) Forum search Contributions search Documentation search (note: docs being adapted for MS3, may be different for MS2) 3 tips for better forum searching Want to post? Read this first: osCommerce for dummies Topic name etiquette Basics: Basics for design Right syntax to use near '-20, 20' Cannot re-assign $this Parse error Link to comment Share on other sites More sharing options...
♥Vger Posted August 31, 2005 Share Posted August 31, 2005 Well, your currency problem can be resolved by going to includes/languages/english.php, lookin for 'USD' and change to 'GBP' Make sure that 'Image Required' is set to 'True' and that when you add the product that the image file is actually being uploaded. Vger Link to comment Share on other sites More sharing options...
vidmarc Posted August 31, 2005 Author Share Posted August 31, 2005 Thanks for the quick answer, but you've lost me. What does this mean? This means you haven't defined the tables in database_tables.php yet. (catalog/includes/) When I installed the 'Product Extra Fields' contribution I followed the instructions, so I'm not sure what's gone wrong. Link to comment Share on other sites More sharing options...
Winterchild Posted August 31, 2005 Share Posted August 31, 2005 open catalog/includes/database_tables.php You added tables to the database? they aren't defined yet. Look at the file. You're missing something like: define('TABLE_PRODUCTS_EXTRA_FIELDS', 'products_extra_fields'); define all tables that aren't defined yet Forum search Contributions search Documentation search (note: docs being adapted for MS3, may be different for MS2) 3 tips for better forum searching Want to post? Read this first: osCommerce for dummies Topic name etiquette Basics: Basics for design Right syntax to use near '-20, 20' Cannot re-assign $this Parse error Link to comment Share on other sites More sharing options...
♥Vger Posted August 31, 2005 Share Posted August 31, 2005 If I remember correctly 'Products Extra Fields' is a contribution. If that's correct then you haven't completed the installation. Vger Link to comment Share on other sites More sharing options...
vidmarc Posted August 31, 2005 Author Share Posted August 31, 2005 I appreciate your feedback, but I'm new to all this and I haven't actually got a clue what I should do now. Any suggestions? I don't know how to define tables? Link to comment Share on other sites More sharing options...
Winterchild Posted August 31, 2005 Share Posted August 31, 2005 If you installed the Products Extra Fields contribution. Read the instructions because you missed something. You define the tableby typing define('TABLE_PRODUCTS_EXTRA_FIELDS', 'products_extra_fields'); and do the same for every other table (like for example TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS) The first part TABLE_PRODUCTS_EXTRA_FIELDS is the table define you use in the code the second part is the actual database table in the database. Forum search Contributions search Documentation search (note: docs being adapted for MS3, may be different for MS2) 3 tips for better forum searching Want to post? Read this first: osCommerce for dummies Topic name etiquette Basics: Basics for design Right syntax to use near '-20, 20' Cannot re-assign $this Parse error Link to comment Share on other sites More sharing options...
vidmarc Posted August 31, 2005 Author Share Posted August 31, 2005 OK, I'm checking through the installation guide now. Will let you know how I get on - and once again, thanks for your help. Link to comment Share on other sites More sharing options...
vidmarc Posted August 31, 2005 Author Share Posted August 31, 2005 I have just re-uploaded all the modified files and it now seems to be working (I think) - I still have a lot of work to do on this site as it looks a mess. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.