[sw45859]

i was told to move over to a new thread so i have done that, anyone who needs help with ccc9 please post here.

[John Doswell]

hi there,
i am trying to implement the construbution to my osc but when i go to admin/ccc_add.php i can chose a product to add (radio button), but it will not refresh and it does not show up a update button, how do i add products to the database?
looking on your site it is also not possible to add products to database.

Please help!!!

Merry x-mas John

[Gotmallz]

Im getting an error of no admin/table_template.php and I searched the files there is not one what should I do???
BTW this is in CCC Version 9

[sw45859]

on adding the products to the database, when you click the radio button the side menu refreshes showing that the product has been added to the queue, the click on queued products in the ccc side menu and that will show you the screen for choosing where the product is allowed, i will be creating a tutorial with screenshots after the holidays to help along with the process of learning to use the creator.

[John Doswell]

if i click the radio button the page does not refresh and does not add the product to the database. i checked the database tables and its all there.
also i get a error on the catalog side

AMD & INTEL Prebuilt System  
 

Warning: main() [function.main]: Unable to access admin/table_template1.php in /localhost/www/htdocs/newshop/build.php on line 73

Warning: main(admin/table_template1.php) [function.main]: failed to create stream: No such file or directory in /localhost/www/htdocs/newshop/build.php on line 73

Warning: main() [function.main]: Failed opening 'admin/table_template1.php' for inclusion (include_path='') in /localhost/www/htdocs/newshop/build.php on line 73

Merry X-Mas John

[jessicasy]

From my previous post on that other thread

Quote

I noticed something strange in the admin part where you have to add products. The 'onclick=submit()' part on line 209 in ccc_add.php does not show up when I browse to the category making it impossible to add products. Is this just me or has anyone else experienced this behaviour as well?

I also noticed that this works fine in stephen's shop, so I'm not sure if this was something ommited from the contribution.

Stephen, that's exactly what I'm talking about, I mean what folks above are experiencing as well - The refresh of the page when a products check box is clicked on. For some reason the onclick=submit() part that I mentioned above does not show up... Any ideas?

(The only diff. with my php setup is that I receive no errors)

This post has been edited by jessicasy: 24 December 2003 - 05:57 PM

[Kristofor]

hey,

im bout to install it, i wonder if im gonna get this problem aswell,

[jessicasy]

Kristofor, on Dec 24 2003, 06:18 PM, said:

hey,

im bout to install it, i wonder if im gonna get this problem aswell,

All I can say is that I tried it on a few different TEP versions MS1, CVS and MS2 and get the same issue on all of them - But, I guess if you really wanted to confirm that, try it out and report back to us here

--jess

[Mibble]

Anyone know what is supposed to be contained in ccc_temp_products (size, etc), as this table is called however it is not in the sql statement when installing.

[sw45859]

Mibble, on Dec 24 2003, 11:53 PM, said:

Anyone know what is supposed to be contained in ccc_temp_products (size, etc), as this table is called however it is not in the sql statement when installing.

that table for the most part will constantly stay empty, it is for the queued products in the admin area

[sw45859]

sorry i just read the error message, i will post code shortly.

This post has been edited by sw45859: 25 December 2003 - 03:02 PM

[sw45859]

ok for the table_template problem, in build.php on line 73 replace that line with.

include('/table_template'.$template['template'].'.php');?></td>

[discovery]

So this is just an empty table then? or are there values for the fields?

[Unified]

Hello Stephen

I tried the code above to resolve the error - but it did not work - So i just copied the template files from the catalog directory into the admin directory and it works fine now.

One problem that I cannot sort out is with the listing of the components in checkout_confirmation.php , shopping_cart.php , account_history_info.php etc

All I get is the title "Custom Computer" without the list of components that have been selected.

Any ideas why this may be happening? I have tried to fiddle with the following line but do not know what to do as I do not know where the names of the components are being called from:

... $order->products[$i]['name'] . '<small><i>' . $order->products[$i]['description'] . '</small></i>'

This is a major problem as I will not know what the customers have ordered - Nor they!

Cheers mate!

Regards,

Jiten

This post has been edited by Unified: 25 December 2003 - 09:42 PM

[sw45859]

sorry guys, i hope you understand that with the size of this contribution i keep missing stuff i have forgotten that i edited, with that said, in catalog/includes/classes/order.php line 104 you should see:

      $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
      while ($orders_products = tep_db_fetch_array($orders_products_query)) {
        $this->products[$index] = array('qty' => $orders_products['products_quantity'],
                                 'id' => $orders_products['products_id'],
                                        'name' => $orders_products['products_name'],
                                        'model' => $orders_products['products_model'],
                                        'tax' => $orders_products['products_tax'],
                                        'price' => $orders_products['products_price'],
                                        'final_price' => $orders_products['final_price']);

replace it with:

      $orders_products_query = tep_db_query("select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'");
      while ($orders_products = tep_db_fetch_array($orders_products_query)) {
    //CCC
       $description_query = tep_db_query("select products_description as desc_info from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = " . $orders_products['products_id']);
              $description_info = tep_db_fetch_array($description_query);
     //DONE
        $this->products[$index] = array('qty' => $orders_products['products_quantity'],
                                 'id' => $orders_products['products_id'],
                                        'name' => $orders_products['products_name'],
 	 //CCC 
          'description' => $description_info['desc_info'],
 	 //DONE
                                        'model' => $orders_products['products_model'],
                                        'tax' => $orders_products['products_tax'],
                                        'price' => $orders_products['products_price'],
                                        'final_price' => $orders_products['final_price']);

[sw45859]

discovery, on Dec 25 2003, 03:13 PM, said:

So this is just an empty table then? or are there values for the fields?

that table is empty yes, no values are supposed to be in it until you queue a product for database entry.

[Unified]

Hello Stephen,

I just tried the changes that you have made. Unfortunately nothing has changed. The listing of components is still not appearing in checkout_confirmation.php , shopping_cart.php , account_history_info.php etc. The same problem still persists - all you see is "Custom Computer" .

I tried to rearrange the your code snippet by putting the "$description_query" before the "while" statement and that had no effect either.

Am I the only person with this error? All your instructions have been followed correctly?

Again thank you for your hard work

Regards

Jiten

[sw45859]

do you have a page set up that i can look at, or some code from those files, specifically the areas i said to edit.

and the query does have to be in the while statement or it will not pick up all products listed

This post has been edited by sw45859: 26 December 2003 - 01:16 PM

[sw45859]

also look in your database under the table products_description and see if the very last product has the description there.

[sw45859]

dangit, i forgot another area in the order.php,

around line 223 replace:

        $this->products[$index] = array('qty' => $products[$i]['quantity'],
                                        'name' => $products[$i]['name'],
                                        'model' => $products[$i]['model'],
 	 'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),
                                        'tax_description' => tep_get_tax_description($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),
                                        'price' => $products[$i]['price'],
                                        'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']),
                                        'weight' => $products[$i]['weight'],
                                        'id' => $products[$i]['id']);

with

        $this->products[$index] = array('qty' => $products[$i]['quantity'],
                                        'name' => $products[$i]['name'],
                                        'model' => $products[$i]['model'],
 	 //CCC
                                        'description' => $products[$i]['description'],
            //DONE
          'tax' => tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),
                                        'tax_description' => tep_get_tax_description($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']),
                                        'price' => $products[$i]['price'],
                                        'final_price' => $products[$i]['price'] + $cart->attributes_price($products[$i]['id']),
                                        'weight' => $products[$i]['weight'],
                                        'id' => $products[$i]['id']);

sorry