Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

product_info ADD TO CART not adding!


marktoe

Recommended Posts

Hello everyone, i'm having a problem with product_info.php's add to cart button. I click on it and the item will NOT get added to my cart! It goes to the cart and it's empty!

 

THe odd thing is that i can add products to my cart from ALL OTHER PLACES, like the what's new section, buy now section, even the add to cart where it lists all the items in category. BUT when i go into product_info.php and try to add to cart it will not do it. And everything else on product_info works like ADD TO WISH LIST and REVIEWS!

 

Can anyone please help me? Thank you in advance!

Link to comment
Share on other sites

It is not a lost cause...it'll just take some debugging to get it corrected.

 

What is your site URL?

 

Install my debug contribution and then let's see what is being passed (and not passed). Once the problem is identified it should be a simple matter to correct.

Link to comment
Share on other sites

It is not a lost cause...it'll just take some debugging to get it corrected.

 

What is your site URL?

 

Install my debug contribution and then let's see what is being passed (and not passed).  Once the problem is identified it should be a simple matter to correct.

 

 

Hey man, first let me say great installation.html file. It was very clean and straight forward, nice job :). Here's the output i saw after. I went to product_info.php and added to cart, it went to www.mysite.com/shop/shopping_cart.php and it was EMPTY so i put ?output=1 in the end of it and it came out with this

 

Array

(

[QUERIES] => Array

(

[0] => select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[1] => select value from sessions where sesskey = '42d14cf4987452e2fce4f318a17d11b5' and expiry > '1101011898'

[2] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

[3] => select customers_firstname, customers_lastname from customers where customers_id = '5'

[4] => delete from whos_online where time_last_click < '1101011898'

[5] => select count(*) as count from whos_online where session_id = '42d14cf4987452e2fce4f318a17d11b5'

[6] => insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, http_referer) values ('5', 'Joe Wala', '42d14cf4987452e2fce4f318a17d11b5', '24.80.96.90', '1101011898', '1101011898', '/shop/shopping_cart.php?output=1', '')

[7] => select customers_selected_template as template_selected from customers where customers_id = '5'

[8] => select * from template where template_name = 'Pixame_v1'

[9] => select banners_id, date_scheduled from banners where date_scheduled != ''

[10] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

[11] => select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

[12] => select featured_id from featured where status = '1' and now() >= expires_date and expires_date > 0

[13] => select cd.categories_name from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1'

[14] => select last_modified from configuration WHERE configuration_key = 'DOWN_FOR_MAINTENANCE'

[15] => select display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_heading, box_template, box_heading_font_color from infobox_configuration where template_id = 4 and infobox_display = "yes" and display_in_column = "left" order by location

[16] => select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[17] => select count(*) as count from categories where parent_id = '22'

[18] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'

[19] => select categories_id from categories where parent_id = '22'

[20] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'

[21] => select categories_id from categories where parent_id = '33'

[22] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'

[23] => select categories_id from categories where parent_id = '34'

[24] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '31'

[25] => select categories_id from categories where parent_id = '31'

[26] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '32'

[27] => select categories_id from categories where parent_id = '32'

[28] => select count(*) as count from categories where parent_id = '23'

[29] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '23'

[30] => select categories_id from categories where parent_id = '23'

[31] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'

[32] => select categories_id from categories where parent_id = '38'

[33] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '39'

[34] => select categories_id from categories where parent_id = '39'

[35] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '37'

[36] => select categories_id from categories where parent_id = '37'

[37] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'

[38] => select categories_id from categories where parent_id = '35'

[39] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '36'

[40] => select categories_id from categories where parent_id = '36'

[41] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '30'

[42] => select categories_id from categories where parent_id = '30'

[43] => select count(*) as count from categories where parent_id = '24'

[44] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'

[45] => select categories_id from categories where parent_id = '24'

[46] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'

[47] => select categories_id from categories where parent_id = '40'

[48] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '41'

[49] => select categories_id from categories where parent_id = '41'

[50] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '42'

[51] => select categories_id from categories where parent_id = '42'

[52] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '43'

[53] => select categories_id from categories where parent_id = '43'

[54] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '44'

[55] => select categories_id from categories where parent_id = '44'

[56] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '45'

[57] => select categories_id from categories where parent_id = '45'

[58] => select count(*) as count from categories where parent_id = '25'

[59] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '25'

[60] => select categories_id from categories where parent_id = '25'

[61] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'

[62] => select categories_id from categories where parent_id = '46'

[63] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'

[64] => select categories_id from categories where parent_id = '47'

[65] => select count(*) as count from categories where parent_id = '26'

[66] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'

[67] => select categories_id from categories where parent_id = '26'

[68] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48'

[69] => select categories_id from categories where parent_id = '48'

[70] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'

[71] => select categories_id from categories where parent_id = '49'

[72] => select count(*) as count from categories where parent_id = '27'

[73] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '27'

[74] => select categories_id from categories where parent_id = '27'

[75] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '50'

[76] => select categories_id from categories where parent_id = '50'

[77] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'

[78] => select categories_id from categories where parent_id = '51'

[79] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'

[80] => select categories_id from categories where parent_id = '52'

[81] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'

[82] => select categories_id from categories where parent_id = '53'

[83] => select count(*) as count from categories where parent_id = '28'

[84] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '28'

[85] => select categories_id from categories where parent_id = '28'

[86] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'

[87] => select categories_id from categories where parent_id = '54'

[88] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55'

[89] => select categories_id from categories where parent_id = '55'

[90] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56'

[91] => select categories_id from categories where parent_id = '56'

[92] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'

[93] => select categories_id from categories where parent_id = '57'

[94] => select count(*) as count from categories where parent_id = '29'

[95] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '29'

[96] => select categories_id from categories where parent_id = '29'

[97] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '58'

[98] => select categories_id from categories where parent_id = '58'

[99] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '59'

[100] => select categories_id from categories where parent_id = '59'

[101] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'

[102] => select categories_id from categories where parent_id = '60'

[103] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'

[104] => select categories_id from categories where parent_id = '61'

[105] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'

[106] => select categories_id from categories where parent_id = '62'

[107] => select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'

[108] => select categories_id from categories where parent_id = '63'

[109] => select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10

[110] => select products_name from products_description where products_id = '49' and language_id = '1'

[111] => select products_price, products_model from products where products_id = '49'

[112] => select specials_new_products_price from specials where products_id = '49' and status

[113] => select categories_id from products_to_categories where products_id = '49'

[114] => select sale_specials_condition, sale_deduction_value, sale_deduction_type from salemaker_sales where sale_categories_all like '%,58,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0000-00-00') and (sale_date_end >= now() or sale_date_end = '0000-00-00') and (sale_pricerange_from <= '3.5000' or sale_pricerange_from = '0') and (sale_pricerange_to >= '3.5000' or sale_pricerange_to = '0')

[115] => select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '38') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '67') and tr.tax_class_id = '0' group by tr.tax_priority

[116] => select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10

[117] => select configuration_key as cfgKey, configuration_value as cfgValue from newsdesk_configuration

[118] => select configuration_key as cfgKey, configuration_value as cfgValue from newsdesk_configuration

[119] => select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url,

p.newsdesk_image, p.newsdesk_date_added, p.newsdesk_last_modified,

p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description

pd WHERE pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 ORDER BY newsdesk_date_added DESC LIMIT 5

[120] => select configuration_key as cfgKey, configuration_value as cfgValue from faqdesk_configuration

[121] => select c.categories_id, cd.categories_name, c.parent_id from faqdesk_categories c, faqdesk_categories_description cd where c.catagory_status = '1' and c.parent_id = ''

and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[122] => select c.categories_id, cd.categories_name, c.parent_id from faqdesk_categories c, faqdesk_categories_description cd

where c.catagory_status = '1' and c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

[123] => select count(*) as count from faqdesk_categories where parent_id = '1'

[124] => select count(*) as total from faqdesk p, faqdesk_to_categories p2c where p.faqdesk_id = p2c.faqdesk_id and p.faqdesk_status = '1' and p2c.categories_id = '1'

[125] => select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by f.featured_date_added DESC limit 10

[126] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[127] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '22' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[128] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '32' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[129] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '33' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[130] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '31' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[131] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '34' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[132] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '23' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[133] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '39' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[134] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '37' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[135] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '36' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[136] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '38' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[137] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '30' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[138] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '35' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[139] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '24' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[140] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '40' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[141] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '41' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[142] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '42' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[143] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '45' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[144] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '43' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[145] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '44' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[146] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '25' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[147] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[148] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '47' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[149] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '26' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[150] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '48' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[151] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '49' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[152] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '27' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[153] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '53' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[154] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '51' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[155] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '50' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[156] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '52' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[157] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '28' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[158] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '54' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[159] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '57' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[160] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '55' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[161] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '56' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[162] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '29' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[163] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '58' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[164] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '59' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[165] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '60' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[166] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '61' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[167] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '63' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[168] => select c.categories_id, cd.categories_name from categories c, categories_description cd where parent_id = '62' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

[169] => select display_in_column as cfgcol, infobox_file_name as cfgtitle, infobox_display as cfgvalue, infobox_define as cfgkey, box_heading, box_template, box_heading_font_color from infobox_configuration where template_id = 4 and infobox_display = "yes" and display_in_column = "right" order by location

[170] => select amount from coupon_gv_customer where customer_id = '5'

[171] => select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

[172] => select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10

[173] => select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '7' and languages_id = '1'

[174] => select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '5' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit 6

[175] => select products_id, products_name from products_description where products_id in (39) and language_id = '1' order by products_name

[176] => select customer_id from whos_online

[177] => select customers_firstname from customers where customers_id = '5'

[178] => select startdate, counter from counter

[179] => update counter set counter = '3235'

[180] => select count(*) as total from sessions where sesskey = '42d14cf4987452e2fce4f318a17d11b5'

[181] => update sessions set expiry = '1101013338', value = 'cart|O:12:\"shoppingcart\":6:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";s:5:\"75995\";s:12:\"content_type\";b:0;s:13:\"total_virtual\";i:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:4:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:3:\"SSL\";s:3:\"get\";a:1:{s:6:\"osCsid\";s:32:\"42d14cf4987452e2fce4f318a17d11b5\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:5:\"cPath\";s:2:\"24\";s:6:\"osCsid\";s:32:\"42d14cf4987452e2fce4f318a17d11b5\";}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:11:\"52?output=1\";s:6:\"action\";s:11:\"add_product\";}s:4:\"post\";a:3:{s:11:\"products_id\";s:2:\"52\";s:1:\"x\";s:2:\"74\";s:1:\"y\";s:1:\"7\";}}i:3;a:4:{s:4:\"page\";s:17:\"shopping_cart.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:6:\"output\";s:1:\"1\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}affiliate_ref|N;affiliate_clickthroughs_id|N;new_products_id_in_car

t|s:2:\"52\";SESSION_SSL_ID|s:64:\"F506DF3B59820AC87694B1572942E0C8E419DC334753F123B3EB0B7D89D64EEE\";customer_id|s:1:\"5\";customer_default_address_id|s:1:\"5\";customer_first_name|s:3:\"Joe\";customer_country_id|s:2:\"38\";customer_zone_id|s:2:\"67\";' where sesskey = '42d14cf4987452e2fce4f318a17d11b5'

)

 

[TIME] => Array

(

[0] => 0.008710

[1] => 0.000681

[2] => 0.000408

[3] => 0.000365

[4] => 0.000626

[5] => 0.000436

[6] => 0.000360

[7] => 0.000295

[8] => 0.000396

[9] => 0.000229

[10] => 0.000182

[11] => 0.000401

[12] => 0.000378

[13] => 0.000601

[14] => 0.000272

[15] => 0.000424

[16] => 0.000281

[17] => 0.000200

[18] => 0.000240

[19] => 0.000289

[20] => 0.000173

[21] => 0.000176

[22] => 0.000179

[23] => 0.000190

[24] => 0.000192

[25] => 0.000175

[26] => 0.000267

[27] => 0.000235

[28] => 0.000178

[29] => 0.000177

[30] => 0.000190

[31] => 0.000262

[32] => 0.000158

[33] => 0.000164

[34] => 0.000179

[35] => 0.000234

[36] => 0.000148

[37] => 0.000179

[38] => 0.000142

[39] => 0.000164

[40] => 0.000159

[41] => 0.000202

[42] => 0.000178

[43] => 0.000284

[44] => 0.000196

[45] => 0.000241

[46] => 0.000186

[47] => 0.000167

[48] => 0.000164

[49] => 0.000170

[50] => 0.000172

[51] => 0.000167

[52] => 0.000209

[53] => 0.000236

[54] => 0.000252

[55] => 0.000155

[56] => 0.000150

[57] => 0.000144

[58] => 0.000168

[59] => 0.000177

[60] => 0.000199

[61] => 0.000187

[62] => 0.000207

[63] => 0.000238

[64] => 0.000206

[65] => 0.000184

[66] => 0.000204

[67] => 0.000177

[68] => 0.000179

[69] => 0.000163

[70] => 0.000173

[71] => 0.000174

[72] => 0.000186

[73] => 0.000279

[74] => 0.000262

[75] => 0.000400

[76] => 0.000268

[77] => 0.000210

[78] => 0.000190

[79] => 0.000174

[80] => 0.000167

[81] => 0.000196

[82] => 0.000181

[83] => 0.000188

[84] => 0.000277

[85] => 0.000300

[86] => 0.000304

[87] => 0.000322

[88] => 0.000315

[89] => 0.000572

[90] => 0.000208

[91] => 0.000207

[92] => 0.000193

[93] => 0.000176

[94] => 0.000275

[95] => 0.000282

[96] => 0.000219

[97] => 0.000198

[98] => 0.000172

[99] => 0.000199

[100] => 0.000174

[101] => 0.000182

[102] => 0.000174

[103] => 0.000184

[104] => 0.000174

[105] => 0.000185

[106] => 0.001134

[107] => 0.000238

[108] => 0.000265

[109] => 0.000313

[110] => 0.000783

[111] => 0.000272

[112] => 0.000211

[113] => 0.000228

[114] => 0.000618

[115] => 0.000466

[116] => 0.000377

[117] => 0.006232

[118] => 0.003461

[119] => 0.001914

[120] => 0.000498

[121] => 0.000240

[122] => 0.000261

[123] => 0.000227

[124] => 0.000193

[125] => 0.000330

[126] => 0.000327

[127] => 0.000226

[128] => 0.000228

[129] => 0.000221

[130] => 0.000211

[131] => 0.000239

[132] => 0.000231

[133] => 0.000175

[134] => 0.000189

[135] => 0.000195

[136] => 0.000188

[137] => 0.000196

[138] => 0.000199

[139] => 0.000249

[140] => 0.000206

[141] => 0.000226

[142] => 0.000167

[143] => 0.000228

[144] => 0.000200

[145] => 0.000185

[146] => 0.000216

[147] => 0.000200

[148] => 0.000198

[149] => 0.000225

[150] => 0.000213

[151] => 0.000234

[152] => 0.000227

[153] => 0.000362

[154] => 0.000199

[155] => 0.000228

[156] => 0.000211

[157] => 0.000243

[158] => 0.000214

[159] => 0.000210

[160] => 0.000158

[161] => 0.000189

[162] => 0.000236

[163] => 0.000200

[164] => 0.000166

[165] => 0.000220

[166] => 0.000205

[167] => 0.000207

[168] => 0.000220

[169] => 0.000529

[170] => 0.000225

[171] => 0.000267

[172] => 0.000334

[173] => 0.000212

[174] => 0.000239

[175] => 0.000232

[176] => 0.000405

[177] => 0.000312

[178] => 0.000406

[179] => 0.000287

[180] => 0.000581

[181] => 0.000440

)

 

)

Link to comment
Share on other sites

For future reference, only post the relevant parts. The only thing I can see from that is you need some serious query optimization. Do you realize you're at 182 queries to make that page? Your server must be on crutches...

 

Ooops...we need to change your performance.php file to look like this:

<?

   if (DISPLAY_PAGE_PARSE_TIME == 'true') {
   $time_start = explode(' ', PAGE_PARSE_START_TIME);
   $time_end = explode(' ', microtime());
   $parse_time = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);
   echo '<div align="center"><span class="smallText">Current Parse Time: <b>' . $parse_time . ' s</b> with <b>'.sizeof($debug['QUERIES']).' queries</b></span></div>';
if ($_REQUEST['output'] == '0') $_SESSION['output'] = '0';
if ($_REQUEST['output'] == '1' || $_SESSION['output'] == '1')
 {
	 $_SESSION['output'] = '1';
	 echo '<b>QUERY DEBUG:</b> '
	 echo '<pre>';
	 print_r($debug);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>SESSION:</b> '
	 echo '<pre>';
	 print_r($_SESSION);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>COOKIE:</b> '
	 echo '<pre>';
	 print_r($_COOKIE);
	 echo '</pre>';
	 echo '<b>POST:</b> '
	 echo '<pre>';
	 print_r($_POST);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>GET:</b> '
	 echo '<pre>';
	 print_r($_GET);
	 echo '</pre>';
 } # END if request
   }
unset($debug);
?>

This will add the POST and GET data to the output script. This is the magic we need to get this done.

 

Change the performance.php file to the above code and reply back with your URL so I can check it out.

Link to comment
Share on other sites

Sorry...lines not terminated. Try this:

<?

   if (DISPLAY_PAGE_PARSE_TIME == 'true') {
   $time_start = explode(' ', PAGE_PARSE_START_TIME);
   $time_end = explode(' ', microtime());
   $parse_time = number_format(($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0])), 3);
   echo '<div align="center"><span class="smallText">Current Parse Time: <b>' . $parse_time . ' s</b> with <b>'.sizeof($debug['QUERIES']).' queries</b></span></div>';
if ($_REQUEST['output'] == '0') $_SESSION['output'] = '0';
if ($_REQUEST['output'] == '1' || $_SESSION['output'] == '1')
 {
	 $_SESSION['output'] = '1';
	 echo '<b>QUERY DEBUG:</b> ';
	 echo '<pre>';
	 print_r($debug);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>SESSION:</b> ';
	 echo '<pre>';
	 print_r($_SESSION);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>COOKIE:</b> ';
	 echo '<pre>';
	 print_r($_COOKIE);
	 echo '</pre>';
	 echo '<b>POST:</b> ';
	 echo '<pre>';
	 print_r($_POST);
	 echo '</pre>';
	 echo '<hr>';
	 echo '<b>GET:</b> ';
	 echo '<pre>';
	 print_r($_GET);
	 echo '</pre>';
 } # END if request
   }
unset($debug);
?>

Link to comment
Share on other sites


Sorry...lines not terminated.  Try this:

<?
........................
?>

 

It's okay man, thank you very much for your help and time :)

 

the URL to our site is http://www.thepinkcouch.com/shop

 

here's the new output:

 

SESSION:

Array

(

[cart] => shoppingcart Object

(

[contents] => Array

(

)

 

[total] => 0

[weight] => 0

[cartID] => 47283

[content_type] => physical

[total_virtual] => 0

[weight_virtual] => 31.58

)

 

[language] => english

[languages_id] => 1

[currency] => USD

[navigation] => navigationhistory Object

(

[path] => Array

(

[0] => Array

(


=> index.php

[mode] => SSL

[get] => Array

(

[osCsid] => 42d14cf4987452e2fce4f318a17d11b5

)

 

=> Array

(

)

 

)

 

[1] => Array

(


=> shopping_cart.php

[mode] => NONSSL

[get] => Array

(

[output] => 1

)

 

=> Array

(

)

 

)

 

)

 

[snapshot] => Array

(

)

 

)

 

[affiliate_ref] =>

[affiliate_clickthroughs_id] =>

[sESSION_SSL_ID] => 3449C322EA3338117179DDADAEB6B5F063A49D23CC5A75AE0AA95DB8EC5D4A35

[customer_id] => 5

[customer_default_address_id] => 5

[customer_first_name] => Joe

[customer_country_id] => 38

[customer_zone_id] => 67

[cart_address_id] => 5

[new_products_id_in_cart] => 58{1}3

[output] => 1

)

 

 

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

COOKIE:

Array

(

[osCsid] => 42d14cf4987452e2fce4f318a17d11b5

[cookie_test] => please_accept_for_session

)

 

POST:

Array

(

)

 

 

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

GET:

Array

(

[output] => 1

)

 

Sorry i paste it all because i'm not sure what you need to figure this out because i'm totally lost! :P

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...