keat

Until an official fix is built, I ended up modifying the discounted Items, so we lost the 'red cross' feature for now. MIght be worth considering re-applying though now thatere a work around.

Interesting results. Two hard drives in identical external cases. 175gb SSD formatted NTFS with about 150gb of data, takes 2 seconds to mount. 250gb SATA formatted exFat, with the same data, takes 40 odd seconds to mount. Bearing in mind that the SSD was taking this time also when on exFAT. There's one hell of a performance boost between exFat and NTFS, it's a no brainer.

You'll need someone like Havenswift, Noodleman or Semperfi to write you a custom api at a guess.

I left the SSD data copying when i came out, so I'll know for certain later if indeed exFat is the issue, although I'm 99% convinced it is. On the spare drive, I formatted NTFS, dumped a number of files on there and suffered no buffering issue, I then reformatted exFat, copied a similar amount of files and suffered some buffering The tablet just doesn't provide enough power unfortunately, so it's all hooked up to a standard USB hub, connected to a 12v to 5v step down convertor.

I have a Nexus7 with a custom rom and custom kernel, in a car build, hooked up to a SSD, and a few other USB devices. Despite the kernel being able to, I've never been able to get it to mount the SSD, so I've been using StickMount app, it works, but it's flakey. I discovered last week, that the reason the kernel wont mount of it's own accord, is that Windows creates a hidden partition. Of course Windows is where I built the partition. The drive is formatted exFat. Using a Linux app, I deleted the hidden partition and now Android can see it, the data on there and it finally works as expected. Yay The problem is, everytime the tablet wakes up, is removed from the dock, the the ignition is recycled or the car cranked, the tablet loses the drive, which results in some sort of initialisiation routine when it comes back up. This takes about 30-50 seconds. (i'm utilising .nomedia files) Last night (using a spare HDD), I experimanted with an NTFS partition. Low and behold, the NTFS partition doesn't go through the same drive scanning routine. The LED blinks once, takes 2 seconds, the drive is mounted and ready to go. I think it's unlikely to the difference between the two drives, the exFat drive is an SSD, the NTFS is an old mechanical drive out of a laptop. I don't understand why NTFS is instant and exFat takes 30+ seconds, and can't seem to find an answer. Especially when everywhere I've read suggests using exFat

Not Cubecart related. I've scoured the net for 3 days trying to find a solution to a problem, I can't find the answer anywhere, even joined a forum to ask but no luck. Then last night I stumbled on the answer through trial and error. Does anyone know anything about Android, NTFS, exFat and SSD drives.

enable debugging, lets see if i generates a debug error. maybe also create a file ini-custom.inc.php in the root of your store and poulate it with the following code. <?php # Custom initialization commands # Filename: ini-custom.inc.php # File location: main CubeCart folder ini_set('memory_limit', '256M'); ini_set('max_execution_time', '60'); ini_set('error_log', 'error_log'); ini_set('log_errors', 'on'); ?> This should create an error.log file in the root of your store, which may also give some clues.

I'm back on lockdown, thanks for taking the extensive time. We learned something at least.

i can't see why not, i'll PM you some details.

I've been running the query whilst in the actual database, and not from the root of PHPMyAdmin. I had to modify the above query slightly to get it to run (remove the cc6_ prefix), nothing much changed, still took 13 seconds or more, and 'explain' didn't look any different. Thinking that maybe I ought to be running in the root of PHPMyAdmin, i readded the dbsname_cc6_ prefix, but then got the following error. 3 errors were found during analysis. Unrecognized keyword. (near "FORCE" at position 298) Unrecognized keyword. (near "INDEX" at position 304) Unrecognized keyword. (near "FOR" at position 310)

It seems to work OK on mine.

Al. Could we have the edit button back please. I've fat fingers (or old age),

opening statistics still took around 30 seconds or more. id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ALL PRIMARY NULL NULL NULL 4378 Using temporary; Using filesort 1 SIMPLE O ref cart_order_id,product_id product_id xxx.I.product_id 97 1 SIMPLE S eq_ref cart_order_id,status cart_order_id 56 xxx.cart_order_id 1 Using where And running the single query still took 13 seconds.

Are we 100% vertain that this isn't just related to sheer volume of data. Order summary id is showing 59,683, so potentially 59,000 orders to trawl through.

http://www.cabletiefan.co.uk/webimages/sumcartid.jpg http://www.cabletifan.co.uk/webimages/orderinv.jpg the forum doesn't seem to want to add all the images, so you may have to click and collect (so to speak) http://www.cabletiefan.co.uk/webimages/orderinv.jpg this having no edit feature is annoying. http://www.cabletiefan.co.uk/webimages/orderinv.jpg

In structure view, they are displayed as horizontal, so I'd suggest rows. However in browse view, they would be columns. :-)

Looking in order_summary on the clean 6.1.7 install, it has 47 rows. The live site has 63. ???

Best do this on a copy first .. (says nervously) I've taken a snap shot of the indexes on order_sum and order_inventory. I'm unable to drop the existing promary key. sql complains about one auto column, must be defined as a key.

I just spotted that order_inventory on the live site has an index Keyname for productId (note no underscore and uppercase I) The clean copy is product_id. Didn't seem to help with the speed though. 1 SIMPLE I ALL PRIMARY NULL NULL NULL 4378 Using temporary; Using filesort 1 SIMPLE O ref cart_order_id,product_id product_id 4 xxx_ccv6.I.product_id 97 1 SIMPLE S eq_ref cart_order_id,status cart_order_id 56 xxx_ccv6.O.cart_order_id 1 Using where

I created a clean install of 6.1.7 and then compared the indexes side by side. I did find a few issues. The customer table had no unique index for email, and I had to remove a number of duplicates to create this index. Options_matrix although had an options identifier, it was tagged as a second entry under ProductID and the reviews table was missing every index, so I copied the table from the clean install. Other than that, i could spot any issues, and none of this fixed the problem. Its taking about 35 seconds to open the statistics tab. id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE I ALL PRIMARY NULL NULL NULL 4378 Using temporary; Using filesort 1 SIMPLE O ref productId,cart_order_id productId 4 xxx_ccv6.I.product_id 96 1 SIMPLE S eq_ref cart_order_id,status cart_order_id 56 xxxx_ccv6.O.cart_order_id 1 Using where

I'm a little confused, would it create a URL. ? I've just created a test newsletter, and it arrived as an email. Surely, the PHP script creates the email based on the database contents. or am i missing your point ?? Whilst on the subject of newsletter, I'm really paranoid about myserver being blacklisted, so for this reason, I use mailchimp. Mailchimp offer a free service if your'e emailing to less than 2000 recipients. Worth a look.

did you make any file changes to 6.1.7. I have a few sites on this version and have no such issues.

There are at least two very good plugins available to populate the category pages with options. @bsandall Where is this option please.

Ultimately, I guess the data will be in the database under Cubecart_newsletter

You can change the phrase "Choose Payment Method", to include the additional text you may require, but I see that you may have already changed this anyway. I'l hazard a guess that any edits would need to be in skins/yourskin/templates/content.gateway.php but this only a guess on my behalf i'm afraid