Jump to content

SQL variables and queries displaying on home page


Guest topdotter

Recommended Posts

Guest topdotter

Hi,

I've searched in the CC4 threads for SQL and didn't find an answer to my question so I'm posting here. Hope it's not a double post.

On my front page, cubecart is displaying code at the bottom, right before the "Powered by CubeCart" text. It's like this (edited for security)

$_POST Variables:

No Data!$_GET Variables:

No Data!$_COOKIE Variables:



Array

(

	[__utmz] => VALUE

	[__utma] => VALUE

	[PHPSESSID] => VALUE

	[ccUser] => VALUE

	[ccAdmin] => VALUE

)



$basket Variables: (unserialize($cc_session->ccUserData['basket']))

No Data!$cc_session->ccUserData Variables:



Array

(

	[sessId] => VALUE

	[basket] => 

	[timeStart] => 1190040831

	[timeLast] => 1190046655

	[customer_id] => 

	[location] => /index.php

	[skin] => 

	[lang] => 

	[currency] => 

	[ip] => VALUE

	[browser] => Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6

	[email] => 

	[password] => 

	[title] => 

	[firstName] => 

	[lastName] => 

	[companyName] => 

	[add_1] => 

	[add_2] => 

	[town] => 

	[county] => 

	[postcode] => 

	[country] => 

	[phone] => 

	[mobile] => 

	[regTime] => 

	[ipAddress] => 

	[noOrders] => 

	[optIn1st] => 

	[htmlEmail] => 

	[type] => 

)



MySQL Queries (78):



Array

(

	[0] => SELECT array FROM CubeCart_config WHERE name = 'config'

	[1] => SELECT array FROM CubeCart_config WHERE name = 'gift_certs'

	[2] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='30'

	[3] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='8'

	[4] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='22'

	[5] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='12'

	[6] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='23'

	[7] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='13'

	[8] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='14'

	[9] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='16'

	[10] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='20'

	[11] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='19'

	[12] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='18'

	[13] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='15'

	[14] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='21'

	[15] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='10'

	[16] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='26'

	[17] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='28'

	[18] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='27'

	[19] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='9'

	[20] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='3'

	[21] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='25'

	[22] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='2'

	[23] => SELECT cat_name, cat_id, cat_father_id FROM CubeCart_category WHERE cat_id='24'

	[24] => SELECT name, image, productId FROM CubeCart_inventory WHERE cat_id > 0 ORDER BY RAND(6049) LIMIT 1

	[25] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='20'

	[26] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='20'

	[27] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='52'

	[28] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='5'

	[29] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='3'

	[30] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='63'

	[31] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='28'

	[32] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='27'

	[33] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='19'

	[34] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='14'

	[35] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='62'

	[36] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='25'

	[37] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='86'

	[38] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='85'

	[39] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='87'

	[40] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='83'

	[41] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='84'

	[42] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='88'

	[43] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='89'

	[44] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='6'

	[45] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='9'

	[46] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='14'

	[47] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='1'

	[48] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='5'

	[49] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='7'

	[50] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='8'

	[51] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='6'

	[52] => SELECT doc_name FROM CubeCart_docs WHERE doc_id='9'

	[53] => SELECT langArray FROM CubeCart_lang WHERE identifier = '/en/home.inc.php'

	[54] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='43'

	[55] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='43'

	[56] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='44'

	[57] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='44'

	[58] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='61'

	[59] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='61'

	[60] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='81'

	[61] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='81'

	[62] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='72'

	[63] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='72'

	[64] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='66'

	[65] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='66'

	[66] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='52'

	[67] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='52'

	[68] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='67'

	[69] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='67'

	[70] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='39'

	[71] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='39'

	[72] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='80'

	[73] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='80'

	[74] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='60'

	[75] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='60'

	[76] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='47'

	[77] => SELECT productId, name, cat_name, CubeCart_inventory.cat_id, cat_father_id FROM CubeCart_inventory INNER JOIN CubeCart_category ON CubeCart_inventory.cat_id = CubeCart_category.cat_id WHERE productId='47'

)

where "VALUE" replaces sensitive information. The store is now offline for security purposes but I'd appreciate if someone can give me some advice and possibly look at it. This happens whether or not SQL caching is enabled.

Thanks,

Shmuel

Link to comment
Share on other sites

  • 4 months later...

Guest Maclady

Hi,

I've searched in the CC4 threads for SQL and didn't find an answer to my question so I'm posting here. Hope it's not a double post.

On my front page, cubecart is displaying code at the bottom, right before the "Powered by CubeCart" text. It's like this (edited for security)

$_POST Variables:

No Data!$_GET Variables:

No Data!$_COOKIE Variables:

where "VALUE" replaces sensitive information. The store is now offline for security purposes but I'd appreciate if someone can give me some advice and possibly look at it. This happens whether or not SQL caching is enabled.

Thanks,

Shmuel

Hi Shmuel,

I am having this same problem, but I haven't found any answers here yet. I see that your store is up and running, so can you please let me know how you fixed this problem. (I googled this and found several stores with this same issue, but found no answers there either).

Thanks in advance for your help.

Nancy (aka Maclady)

Link to comment
Share on other sites

Guest Maclady

Your store is doing the same as here for me.

Hi Burgensteen,

I saw in another thread that you said:

"The store is working fine for me now.

Milos is the man. I dont think I have ever seen a problem this guy cant solve !!"

Can you tell me how?

BTW - cute dog!

Cheers

Nancy

Link to comment
Share on other sites

Your store is doing the same as here for me.

Hi Burgensteen,

I saw in another thread that you said:

"The store is working fine for me now.

Milos is the man. I dont think I have ever seen a problem this guy cant solve !!"

Can you tell me how?

BTW - cute dog!

Cheers

Nancy

Best to open a helpdesk ticket for. I am sorry unable to modify any store by request here, thank you.
Link to comment
Share on other sites

Guest Maclady

Your store is doing the same as here for me.

Hi Burgensteen,

I saw in another thread that you said:

"The store is working fine for me now.

Milos is the man. I dont think I have ever seen a problem this guy cant solve !!"

Can you tell me how?

BTW - cute dog!

Cheers

Nancy

Best to open a helpdesk ticket for. I am sorry unable to modify any store by request here, thank you.

I'm not sure I understand... modify any store? Are you saying I need to have the store modified to get things running? Shouldn't CC4 run OK without having to get it modified? I just did a standard install - no mods or hacks. Is this an issue with my server that I can have someone fix?... meaning that CC4 - out-of-the-box) may have incompatibility issues with some servers? Sorry, while I've had experience with CC3 and never experienced a single problem, this one is quite new to me. BTW - I haven't had the client buy the licence yet - waiting until I make sure it works, so I don't think I can get support from the help desk?

Thanks

Nancy

Link to comment
Share on other sites

I'm not sure I understand... modify any store? Are you saying I need to have the store modified to get things running? Shouldn't CC4 run OK without having to get it modified? I just did a standard install - no mods or hacks. Is this an issue with my server that I can have someone fix?... meaning that CC4 - out-of-the-box) may have incompatibility issues with some servers? Sorry, while I've had experience with CC3 and never experienced a single problem, this one is quite new to me. BTW - I haven't had the client buy the licence yet - waiting until I make sure it works, so I don't think I can get support from the help desk?

Thanks

Nancy

The code just at the bottom of the page is nothing else than debug info you already enabled. The modification mentioned is to AOL users related having an issue with basket content see the link burgesnteen posted :-)

Debug info disable -> CubeCart Admin >> General Settings >> Styles and Miscs >> Enable debug output?: No

Yes you must have an active support plan however issue to AOL users mentioned could be fixed quick but the final code is not known yet.

Link to comment
Share on other sites

Guest Maclady

I'm not sure I understand... modify any store? Are you saying I need to have the store modified to get things running? Shouldn't CC4 run OK without having to get it modified? I just did a standard install - no mods or hacks. Is this an issue with my server that I can have someone fix?... meaning that CC4 - out-of-the-box) may have incompatibility issues with some servers? Sorry, while I've had experience with CC3 and never experienced a single problem, this one is quite new to me. BTW - I haven't had the client buy the licence yet - waiting until I make sure it works, so I don't think I can get support from the help desk?

Thanks

Nancy

The code just at the bottom of the page is nothing else than debug info you already enabled. The modification mentioned is to AOL users related having an issue with basket content see the link burgesnteen posted :-)

Debug info disable -> CubeCart Admin >> General Settings >> Styles and Miscs >> Enable debug output?: No

Yes you must have an active support plan however issue to AOL users mentioned could be fixed quick but the final code is not known yet.

Thank you! Thank you! Thank you! I looked everywhere for the "debug"... found it in shipping and payments - but didn't see it in the general settings. DUH! You have made my day! Awesome - and such an easy fix - everything is A-OK now (except PayPal and Canadian store - a long story for another post in another area - LOL!)

Have a fabulous day!

Cheers

Nancy (aka Maclady)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...