Jump to content

grafis

Member
  • Posts

    93
  • Joined

  • Last visited

Everything posted by grafis

  1. Thanks! I was hoping to stop whatever is generating the logs but stopping the logging helps a bit. Wholesale only
  2. Thanks I was suspecting the Plugin and wow, that's an interesting way to hide prices. Where do I hide the 'trigger_error'? Cache->tidy only exists in the log file. Is it line 133 in cach.class.php > public function tidy() { Mod wise - what we really want is this Approve customers before they can use the site (Wholesale only) http://cc3.biz/cubecart-mods/cubecart-4-mods/customer-approval-cc4/prod_247.html
  3. That worked! Here's the log: 21:38:32UTC - 06/16/13 0 => / 1 => 66.249.73.111 2 => ------------- Cache_Controler::tidy at 0 index.php (line 13) Index_php5.3_enc_zend.php->require_once('/home/mysite/public_html/index_php5.3_enc_zend.php') at 1 index_php5.3_enc_zend.php (line 4) Controller.index.inc.php->include('/home/mysite/public_html/controllers/controller.index.inc.php') at 2 controller.index.inc.php (line 88) Gui->displayCommon() at 3 gui.class.php (line 284) Gui->_displaySessionBox() at 4 gui.class.php (line 1136) Class.gui.display_session_box.php->include('/home/mysite/public_html/modules/plugins/GWorks_Privacy_Manager/hooks/class.gui.display_session_box.php') at 5 class.gui.display_session_box.php (line 1) Class.gui.display_session_box.php(1) : eval()'d code->eval() at 6 class.gui.display_session_box.php(1) : eval()'d code (line 1) Class.gui.display_session_box.php(1) : eval()'d code(1) : eval()'d code->eval() at 7 class.gui.display_session_box.php(1) : eval()'d code(1) : eval()'d code (line 1) Class.gui.display_session_box.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code->eval() at 8 class.gui.display_session_box.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code (line 24) Cache->tidy() at 9 cache.class.php (line 134) ->dbg('Cache_Controler::tidy') -------------
  4. Wow - thanks! I've worked through all of your changes above. #1 - Cache. My only edits to CC code are a custom skin and adding some links to the Admin Navigation and that's about it. I'm also using the Privacy Manager plugin by GWorks (hides prices until you login) So far no dbg log file created after 5 cache refreshes of the /cache/skins folder. I place the function call like this: public function tidy() { if( function_exists('dbg') ) dbg(__METHOD__); trigger_error('Cleaning cached files...', E_USER_NOTICE); For #3 I had this URL which when tested redirects to the one you posted: http://www.cubecart.com/site/forums/index.php?act=rssout&id=1
  5. Whenever I FTP to my site I notice the Apache Error_Log file is huge (2,5,10,20,60.... megs). Currently the file is two days old and I already have 7,922 entries. It appears CubeCart is telling the system to log any action? This does not happen on the same host (Site5) with Wordpress, Drupal or CS Cart. Does anyone else see this issue? These are "errors" that have occurred over the last 36 hrs - an entry ever 15 seconds or so 24x7x365. 5,958 entries: PHP Notice: Cleaning cached files... in /home/mysite/public_html/classes/cache/cache.class.php on line 134 Looked at the code and poked around - the issue appears to be all files in /Cache/Skin are being deleted every 2-3 minutes. That can't be good! 774 entries: PHP Warning: Invalid argument supplied for foreach() in /home/luciasim/public_html/admin/sources/products.index.inc.php on line 348 351 entries: PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: Entity: line 1: parser error : Space required after the Public Identifier in /home/mysite/public_html/admin/sources/dashboard.index.inc.php on line 269 273 entries: PHP Notice: GD::gdLoadFile - Unknown file type in /home/luciasim/public_html/classes/gd.class.php on line 75 232 errors: PHP Notice: UPS Error for Canada Standard: The requested service is invalid from the selected origin. in /home/mysite/public_html/modules/shipping/UPS/shipping.class.php on line 210 147 entries: PHP Warning: implode() [<a href='http://docs.php.net/manual/en/function.implode.php'>function.implode.php</a>]: Invalid arguments passed in /home/luciasim/public_html/admin/sources/products.index.inc.php on line 1090 13 entries: PHP Warning: String could not be parsed as XML in /home/mysite/public_html/admin/sources/dashboard.index.inc.php on line 28
  6. I contacted CC support and they were able to resolve by modifying this file: /classes/ssl.class.php Not sure if it's okay to post that change here or not, PM me if anyone needs it. Support confirmed the change will be in the 5.2.3 release.
  7. The diff I believe is the CubeCart 5's new address book system - you can register but no address is required. The owners for this site want to send out print catalogs so addy's are very important to them. Customer doesn't have to put in an address when they register, there's no email notice when the customer registers, and you can't export Customer information or addresses... Thanks big time for the query, it's helped on a major issue for this little shop.
  8. State it was! We have 846 customers, 806 address book entries. The second query posted above pulls 806, looks very good!!
  9. Thanks that query returns exactly what we want! But only returns 71 of our 847 customers. I checked and at least 790 of the Customer ID's are in the Address book. Looking for why so few are returned.
  10. How can I export users with name, address and state information?
  11. Any help appreciated as Google is indexing items like so: /index.php?seo_path=xxxxxxxxxxxx I can't see anything with my setup or server that would be causing this
  12. Store is set to always use the same domain as is .htaccess, also set to always use WWW. SSL invokes for Login/Registration/Basket pages Store settings: Enable SSL: YES Force SSL mode on all pages: NO SSL root path: / SSL Store URL: https://www.domain.com Standard Store URL: http://www.domain.com Relevant .htaccess #Force WWW and account for https RewriteCond %{HTTP_HOST} !^$ RewriteCond %{HTTP_HOST} !^www. [NC] RewriteCond %{HTTPS}s ^on(s)| RewriteRule ^ http%1://www.%{HTTP_HOST}%{REQUEST_URI} [R=301,L] Edit - removed full .htaccess code as it wasn't the issue.
  13. Why would a visitor see this URL ? domain.com/index.php?seo_path=accessories/barrettes&PHPSESSID=1546683043a50ab14e8d7eedded7a668
  14. Issue: Customer spends time making a Basket which they can see but when they click "View Basket" to checkout they're presented with an empty Basket and all their work is gone. Two customers reported the issue this week - one had 48 products & 248 items total in their Basket which she was able to view using the back button and then copy paste to send in as an (angry) order. Is this something I've screwed up, an issue with 5.2.1 ? How it happens: appears there is a cookie set to last 1hr that I have no control over and the visitor has no knowledge of? Odd as in the past we've had this issue (with CC5, never CC4) and items would stay in the Basket for days and I swear i could log into another browser and see my Basket - currently I loose the basket immediately at logout, loose it between browsers and ultimately as I believe is happening to users when their session cookie expires. Admin > Settings > features > "Time before expiring pending orders" set to 1209600 seconds (two weeks - set that high after the last rash of Empty Basket) Visit Website - all visitors go to: http://www.domain.com (always HTTP except for login and basket/checkout (https), always WWW) Cubecart sets 5 cookies: PHPSESSID for www.domain.com set to expire in 1hr __atuvc for .domain.com set to expire in 2 days __utma for .domain.com set to expire in 2 days __utmb for .domain.com set to expire in 30 minutes __utmc for .domain.com set to expire "session" (when browser closes) __utmz for .domain.com set to expire in 23hrs ​Customer Logs in PHPSESSID cookie is updated to expire one hour from their login time Customers shops, adds items to their Basket Customer clicks "View Basket" and... punches screen. Notes: Custom Skin Mod - Privacy Manager by GWorks mod
  15. You sir are a rock star. As for the Housekeeping of images with the CubeCart DB.... wow. So databases never ever clean up what you want but if someone accidentally drags a folder within another folder, deletes a folder, renames a folder.... restores be damned you have no product images? Wow! This admin lost 841 images (according to phpMyAdmin) and thus had 841 products with no image, She was going to manually update them one at a time or just have me revert the entire site back 3 days and work from screenshots of new customers and purchases. You've got my vote to remove that housekeeping task! I was able to fix this in less than 10 minutes thanks to your post and a post I'd written after my last major CubeCart issue a few years back (webhost issue). http://www.gfisk.com/merge-data-from-two-databases/ 1. requested backup of /images/source folder & Database from webhost 2. restore images 3. review databases 4. run this code once for the filemanager table and once for image index table. Sucks any differences from the good database base and inserts them into the current database. INSERT IGNORE INTO `ccrt1`.`CubeCart_image_index` SELECT * FROM `ccrt1bak`.`CubeCart_image_index`
  16. A site operator accidentally deleted a folder with 750+images (images and many sub-folders). I restored a complete set from 4 weeks ago but it appears maybe half of them have lost their association with a product. Any ideas how deleting images can remove their association? (I would think the product would still be associated in the DB). And any ideas how to restore the associations? I have cleared all caches (SQL, Skins, content) and run 'Update File List". Thanks, g
  17. All errors are from 5.21 - I upgraded on 2/18. The 9,300+ errors were generated in the last 3.5 days. Since moving to 5.x I've been deleting the error log because it gets so large, 100K+ entries &15-20 megabytes in a month, 90% of it is from Cache files. If I didn't delete it it would eventually get us dinged by our web host for disk space so I'd definitely vote to remove the cache entries. Thank you for the details on the errors, very informative and helps with the concerns I had there.
  18. Thank you! and do I feel foolish, I've never noticed the Help link! In my defense (eh hem...) I must say neither myself nor the site operators have noticed ANY of those 6.5px links across the top of the pages. I had to add left column links as they kept asking me how to get back to the main dashboard. And I must add that I'd love a PDF or standard doc so I can view the options in whole not in a pop-up using Find for keywords. All said it;s still a PEBKAC issue, sorry for that. Per the help files (thank you again) these are the pertinent ones - I believe the second item here is leading to some of the confusion with the admins: "Order status for admin email notifications": Choose if you want the store administrators to receive the order notification email when the order is created (Pending) or after payment (Processing) "Don't check skipped order processing email": Check this if you do not want the email sent at the "Processing" status to be sent of the order is changed directly from Pending to Complete. This is area of concern - and your description helps, thank you.
  19. Hi bsmither - yes Authorize shows the transactions as successful. We had two more of these this week, one "pending" and one processing "processing" but both of them had been processed successfully by Authorize on submission, the admins received notices that the transactions were paid and only the Processing order shows up in the Transaction logs (pending order has no record). Perhaps confusion by the admins or myself as to how all the statuses work (pending, processing) is adding to the issue of seemingly random order statuses and the lack of transaction logs. It would be great of their was a guide for all admin settings, what they are and what they do. Of note - the error logs for the site are huge with 9,358 individual entries in 3.5 days, primarily cache logs. I've singled out repeat or critical errors below. Line 3 might explain why URLs sometimes "explode" and show the non SEO name plus PHP session ID strings? Line 29 is for the one 3rd party plugin we have (G-Works Privacy Manager). Lines 30-32 possibly shed some light on the other issue we have since upgrading to CC5 - magically disappearing shopping carts? I left out about 100 random UPS shipping errors (service does not exist to destination etc). 7,765 entries "Cleaning cached files... in /home/xxxx/public_html/classes/cache/cache.class.php on line 134" 180 entries "PHP Warning: No callback method defined. in /home/xxxx/public_html/classes/cubecart.class.php on line 231" 160 entries "PHP Fatal error: Call to a member function select() on a non-object in /home/xxxx/public_html/classes/seo.class.php on line 719" 95 entries "PHP Notice: UPS Error for Canada Standard: The requested service is invalid from the selected origin. in /home/xxxx/public_html/modules/shipping/UPS/shipping.class.php on line 210" 95 entries "PHP Notice: UPS Error for Worldwide Express: The requested service is unavailable between the selected locations. in /home/xxxx/public_html/modules/shipping/UPS/shipping.class.php on line 210" 85 entries "PHP Notice: GD::gdLoadFile - Unknown file type in /home/xxxx/public_html/classes/gd.class.php on line 75" 81 entries "PHP Warning: implode() [<a href='http://docs.php.net/manual/en/function.implode.php'>function.implode.php</a>]: Invalid arguments passed in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1072" 81 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1058" 81 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 1076" 63 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/classes/cubecart.class.php on line 1461" 64 entries "PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/imagick.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0" 57 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 342" 54 entries "PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: &lt;!DOCTYPE HTML PUBLIC &quot;-//IETF//DTD HTML 2.0//EN&quot;&gt; in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 263" 54 entries "PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: ^ in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 263" 63 entries "PHP Warning: ksort() expects parameter 1 to be array, null given in /home/xxxx/public_html/classes/cubecart.class.php on line 1488" 33 entries "PHP Notice: UPS Error for Next Day Air Saver: The requested service is unavailable between the selected locations. in /home/xxxx/public_html/modules/shipping/UPS/shipping.class.php on line 210" 28 entries "PHP Warning: in_array() expects parameter 2 to be array, null given in /home/xxxx/public_html/admin/sources/products.index.inc.php on line 373" 28 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/classes/ajax.class.php on line 163" 18 entries "PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: Entity: line 1: parser error : Space required after the Public Identifier in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 263" 23 entries "PHP Warning: Security Warning: Illegal array key "amp;PHPSESSID" was detected and was removed. in /home/xxxx/public_html/classes/sanitize.class.php on line 88" 18 entries "PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: Entity: line 1: parser error : SystemLiteral &quot; or ' expected in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 263" 18 entries "PHP Warning: SimpleXMLElement::__construct() [<a href='http://docs.php.net/manual/en/simplexmlelement.--construct.php'>simplexmlelement.--construct.php</a>]: Entity: line 1: parser error : SYSTEM or PUBLIC, the URI is missing in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 263" 18 entries "PHP Warning: String could not be parsed as XML in /home/xxxx/public_html/admin/sources/dashboard.index.inc.php on line 279" 14 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/classes/cart.class.php on line 261" 9 entries "PHP Notice: cURL Error (22): The requested URL returned error: 500 in /home/xxxx/public_html/classes/request.class.php on line 250" 8 "PHP Warning: Invalid Security Token in /home/xxxx/public_html/classes/sanitize.class.php on line 123" 5 entries "PHP Fatal error: Call to a member function delete() on a non-object in /home/xxxx/public_html/classes/seo.class.php on line 294" 2 entries "PHP Warning: Missing argument 1 for User::update(), called in /home/xxxx/public_html/classes/cubecart.class.php on line 2239 and defined in /home/xxxx/public_html/classes/user.class.php on line 784" 2 entries "PHP Warning: Invalid argument supplied for foreach() in /home/xxxx/public_html/modules/plugins/GWorks_Privacy_Manager/hooks/class.cubecart.display_category.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code on line 56" 1 entries "PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '98.209.242.167' New IP Address: '98.209.242.167' Old User Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.2)' New User Agent: 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.2)' in /home/xxxx/public_html/classes/session.class.php on line 634" 1 entries "PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '108.197.45.116' New IP Address: '108.197.45.116' Old User Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.12 Safari/537.31' New User Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.32 (KHTML, like Gecko) Chrome/27.0.1423.0 Safari/537.32' in /home/xxxx/public_html/classes/session.class.php on line 634" 1 entries "PHP Warning: Stored session data did not match DB record. Session aborted as possible session hijack. Old IP Address: '69.58.178.57' New IP Address: '69.58.178.57' Old User Agent: 'Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:14.0; ips-agent) Gecko/20100101 Firefox/14.0.1' New User Agent: 'BlackBerry9000/4.6.0.167 Profile/MIDP-2.0 Configuration/CLDC-1.1 VendorID/102 ips-agent' in /home/xxxx/public_html/classes/session.class.php on line 634" 1 entries "PHP Warning: Security Warning: Illegal array key "amp;_g" was detected and was removed. in /home/xxxx/public_html/classes/sanitize.class.php on line 88" 1 entries "PHP Warning: Security Warning: Illegal array key "amp;validate" was detected and was removed. in /home/xxxx/public_html/classes/sanitize.class.php on line 88"
  20. Thanks for the response. I Checked the database - orders are in the Order History table (multiple times, it appears to be one entry for each item?) but are not in the transaction log. No record of maintenance affecting the logs, and prior Orders (older) are still in the log. Prior to upgrading from 5.1.5 to 5.2.1 I did clear the cache (Cache, SQL, Language and Image caches) via the maintenance > rebuild tab.
  21. We're having issues with admins receiving Pending Order status'es - the Cart Admin shows there is an Order, but there is no corresponding Transaction Log order. The site processes both Print and Authorize credit card orders - they've had 2 Authorize orders with no Transaction log in the past 3 days, one with CC 5.1.5 and one after upgrading to 5.2.1. Due to this issue and the ongoing "empty cart" bug issue I disabled Caching last night prior to upgrading to 5.1.5 and left it off. Any other possible tips, configuration, hosting variables or other issue that would help?
  22. Upgraded from 5.1.4 to 5.1.5 and bravely used the "upgrade" button the admin. Worked like a charm. All systems are a go - no apparent issues with core functionality. Does anyone know how to leverage this change? - New admin/skins/default/templates/element.hook_form_content.php file to allow hook content to be easily added into admin forms for tab content. Does anyone know how to do this? - Ability to link externally to catalog export.
  23. I have the same issue - any way to require a customer be logged in for reviews? That seems logical to me anyhow to keep reviews a bit more on the up and up.
  24. I tried closing and re-opening Chrome with no affect - Basket still empty. Firefox still shows the same user with 7 items. And then in interesting development (to me...). I logged out of Google Chrome and logged back in - pow all 7 items in my basket re-appeared. I logged in using https and www in the URL as was my prior session.
  25. Joining this topic as I have a long time customer who emailed ".... this is my 4th attempt at placing this order. I was working on several things at once, so I would be away from this order for 5-10 minutes and when I came back to it the order was erased and I had to start over again. " I could not reproduce the issue until this morning. During testing I've had items stay in my Basket for days or weeks. BUT - At this moment I have Chrome and Firefox open to the account page for the same user with the exact same URL and Chrome shows an empty Basket and Firefox shows seven items. URL for both browsers is: https://www.luciasim....php?_a=account Sometimes the URL has the index.php?_a=account&PHPSESSID=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx The site uses SSL for the basket/checkout and Account pages.
×
×
  • Create New...