Jump to content

JulesInFrance

Member
  • Posts

    79
  • Joined

  • Last visited

Everything posted by JulesInFrance

  1. My configuration is Linux server running Apache version 2.2.17 and PHP version 5.2.16 and I am testing on FF / IE / Safari / Chrome browsers. I have changed the permissions to 0755, added and removed store logos - clearing all of the CC and browser caches - and all to no avail; all I ever see is the alternative text, never a logo (not even a default). If I point my browser to the ../images/logos/skin-name.php, it returns a "500 Internal server error" message instead of redirecting to and displaying just the logo. I don't know if the PHP header(Location:xxx) redirect is violating some other permission, or what. I can point my browser to the referenced file and see the logo; or, if I use Firebug and modify the generated html for the img src (inside the page_wrapper, account, header, quick_search div's logo class) to explicitly point to (rather than redirecting to) the logo file, it displays properly. Any suggestions as to what I might be missing, or what else I might try? I've been wrestling with this for several days now, so a fresh set of eyes would be greatly appreciated. Thanks. Depending upon the security settings for your server you will not be able to run scripts (that is to say any file with a .php extension if the permissions in the folder exceed the limit imposed by your administrators. Until you reduce the permissions on this folder far enough Error500 is the expected result - you might simply edit your scripts to point to the image file you need as a logo instead ... ? Jules
  2. I think I am going to start clean. I just wish the export of products kept the image associations. My dad has 1400 products or so and he is NOT that computer literate... and I do not have much time or energy outside of work since I am a Senior Software Engineer during the day. So, I am the webmaster even though I am a Linux C++ embedded applications programmer and only know enough html/php to get the job done. If I export the 4.4.5 products to excel... I will have to manually make the category row be something like category_id "1"... and then redo the categories in CC5... it would be hard to make the cat ids add up. I will import the excel sheet to CC5 and just make cat_id "1" be a temp category and then re-associate category 1 to whatever the new cat_id becomes. The CC4xx export routine simply isn't good enough to do clean export => import to CC500. We tried; it's horrible!!! We have over 4,000 inventory items and over 7,500 image files. We redo our inventory every 18 months or so and that involves reloading every item, rebuilding the descriptions and image files - the complete SEO shebang; sadly the last complete refresh, based on Google's last refresh, was only 5 months ago. I'm beginning to believe that upgrading (given the issues dev' has with server encoding and their own database upgrade scripts) is a lost cause and will probably wait until the next refresh cycle then start with a clean install. Jules
  3. ;-)) For my mind it's only a bug when it can be reproduced, there are too many variables otherwise. I took your previous advise and contacted Support via email. They came back with the charset explanation but until they get to the bottom of why the installer script generates unpredictable results (let's guess, it runs out of memory, or times out, on larger sites) they'll only be chasing half the problem and hiding from the issues. Still, let's not pre-judge. Jules
  4. Whilst I don't disagree with the explanation I'm still bemused by it. All my databases (since 4 years) have been had utf8-general-ci and all of my imports and exports have been uft8 because I run into trouble with european characters otherwise. i have seen it where i'm provided with php scripts for upload that are not utf8 but each one of the cc500 distribution i've looked at have been utf8. whilst i'm not using a production site to upgrade (i'm using a copy) i created my archive using cpanel (zip/unzip) on the server, created my own db+collation and had admin load using utf8 charset. so i'd be impressed to hear where this issue is coming from so far as i'm concerned there are so many missing columns in the database and the only stability i've found has been after i've hand-crafted changes to the db; so for me it's still, by a country-mile, a script issue that needs to be resolved first. When CubeCart_image_index should have `main_img` enum('0','1') NOT NULL, and `img` varchar(255) NOT NULL, yet only has `main_img` tinyint(1) unsigned NOT NULL, (no img column at all) and both CubeCart_inventory and CubeCart_order_summary are (fresh install versus upgrade) only very rough approximations of each other my instict is to start with the easy hits rather than the dark arts for a solution? Jules
  5. I think I should have been a little more clear; suPHP will allow files into the folder but will not allow scripts to run from that folder. If you have suPHP (without php.ini override) set your includes/extras folder to 0755 Create a file called info.php with the following code <?php phpinfo(); ?> Upload this file to includes/extras and from your browser run http://yourdomain.ext/includes/extras/info.php => it should run fine Now change permissions to 0777 and refresh the browser => it should throw up an Error 500 Server Misconfiguration. Now try to run your key.php file from the same location and you'll get the same Error 500. This may be why some of us are getting our configuration files wiped you; CC500 cannot see a license so de-configures the installation ... ? You can however access image files and I'm guessing cache files whether permissions are 0755 or 0777 Jules
  6. I'm still trying to get my head around CC500 and Language seems a good place to start. CC500 insists that Yank is the dominant language; I would prefer to remove it altogether (tomaato/tomarto etc). The question is, how? I tried Admin => Settings => Languages => (for USA) turn green tick into red cross => Save => Advanced => Maintenance => Rebuild => Cache => Clear language cache (select) => Submit But to no good effect (heaven knows what unintended effect this had; doubtless I'll find out unpredictably at some later point). Can anyone lead me through the steps necessary to remove a language, that hopefully does not involve deleting a file from the server ... ? Thanks Jules
  7. CC500 still has Dyfed as a Welch county even though Ceredigion took over years ago. Who determines the TLA for the counties and where can I find a TLA for Ceredigion, please? Jules
  8. The challenge is, how would anyone know ... My server uses suPHP so I have 755 on all my writable folders and the CC500 installer recognises all folders as readable. But I'm now getting blanks for Language too so it looks like this problem is widespread. Jules
  9. I was only asking because it has been noted that this action can cause users to lose their license and admin settings. Since moving my (suPHP-based server) folder settings to 755 and repairing the missing tables, indexes and keys in the database I am no longer getting this though (which is progress of sorts). Thanks for your help. Jules
  10. Why, on Rebuild => Cache does it always end up by logging admin out of the Control Panel? Jules
  11. Under suPHP files can ordinarily run at 0400 or 0600 and folders at no higher than 755. Generally suPHP will throw up an error 500 if permissions are set higher than that. Of course it needs to have a PHP script to achieve an error 500 so setting cache folders to 0777 can generate unpredictable results. Jules
  12. If I view a catalogue item I get a stupid data-less page (see image) If I try File Manager => Images I get a blank screen. Anyone else getting trashy results from feature as well? Jules PS - I have about 7,000 images in the ~/source folder
  13. I'll wager everyone who's seeing this is seeing it on an upgrade rather than new install. Another question might be, does the burp cause the data to go or does the burp cause the license code to go and that wipes the data? Jules
  14. Thanks for your thoughts and I'm glad it's working for you. For me sadly not (too many crashes and data losses. Jules
  15. HIya, #1 Thank you very much for clarifying that the structural value for AUTO_INCREMENT is the last value used rather than the frequency. Though I am shattered to think that the next value for sts_CubeCart_category_index => AUTO_INCREMENT=4502 => is 4,503! I'm also surprised that the base install of cc500 has in that case some quite high values when it's seen no data. But hey, what do I know? #2 I do take your point that when, say, the whole way catalogue images are handled and indexed is changed between versions then that will of necessity leave orphaned tables/columns/data in the database but other issues, when a field type in cc500 changes materially from that in cc443 and the changes are not carried over fails to inspire confidence in me. I already lost all of my settings yet found my metadata still appearing in the browser though erased from setting; whaddya-know that seo data is one of the tables/columns that has material variances between the cc500 pure format and the 443=500 legacy format. Like I saw, what do I know? #3 Key/Primary Key variations (excluding cc500 omissions) cc5_CubeCart_category_language has KEY `id` (`translation_id`), which has no equivalent after Upgrade cc5_CubeCart_currency has PRIMARY KEY (`currency_id`), which has not equivalent after Upgrade cc5_CubeCart_inventory has KEY `status` (`status`), which has no equivalent after Upgrade cc5_CubeCart_inventory Fresh Install has FULLTEXT KEY `fulltext` (`product_code`,`description`,`name`) whereas Upgrade has FULLTEXT KEY `fulltext` (`product_code`,`name`,`description`) cc5_CubeCart_inventory_language has KEY `id` (`translation_id`), which has not equivalent after Upgrade cc5_CubeCart_modules has KEY `module_id` (`module_id`) which has no equivalent after Upgrade cc5_CubeCart_option_assign has KEY `member_id` (`set_member_id`) which has no equivalent after Upgrade cc5_CubeCart_order_inventory has KEY `product_id` (`product_id`), which has no equivalent after Upgrade cc5_CubeCart_order_notes has KEY `admin_id` (`admin_id`,`cart_order_id`,`time`), for which the closest equivalent is KEY `admin_id` (`admin_id`), cc5_CubeCart_sessions has KEY `customer_id` (`customer_id`), AND KEY `session_last` (`session_last`) for which there are no equivalents after upgrade cc5_CubeCart_transactions has KEY `customer_id` (`customer_id`), which has no equivalent after Upgrade ERRORS AND OMISSIONS EXCLUDED #4 Other observations cc5_CubeCart_category_language column `seo_custom_url` text, has not equivalent after Upgrade cc5_CubeCart_customer column `verify` varchar(32), has not equivalent after Upgrade cc5_CubeCart_documents columns `seo_meta_description` text NOT NULL, AND `seo_meta_keywords` text NOT NULL, have no equivalent after Upgrade (note that cc443 columns `doc_metadesc` text NOT NULL, AND `doc_metakeywords` text NOT NULL, were orphaned by the changes) cc5_CubeCart_inventory column `image` varbinary(250), AND `stock_by_option` tinyint(1) unsigned NOT NULL, AND `updated` timestamp DEFAULT CURRENT_TIMESTAMP, have no equivalent after Upgrade cc5_CubeCart_inventory_language columns `language` varchar(5) NOT NULL, AND `name` varchar(255) NOT NULL, have no equivalent after Upgrade cc5_CubeCart_order_summary column `offline_capture` blob, has not equivalent after Upgrade ERRORS AND OMISSIONS EXCLUDED Jules
  16. Hi, I ran a difference checker between the database post 443 => 500 upgrade and a cc500 fresh install and have well over 2,000 structural differences. I'm sure the differences are all minor but as a non-techy/non-developer I was surprised to see Missing Tables in Fresh Install (so could have been in the Upgrade as a result of cc4xx Addons) Missing Columns in Upgrade Missing or mis-stated KEY and PRIMARY KEY values Multiple instances of numerous variations between column attributes in Upgrade; lots of missing 'unsigned', 'NOT NULL', 'tinyint', 'smallint', etc, etc (etc) => there's certainly 1.000+ of these Multiple variations between auto_increment values (After Upgrade I have one where ENGINE MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2363 COLLATE=utf8_unicode_ci ; whereas the Fresh Install has AUTO_INCREMENT=1 !!!! => There's certainly 500+ of these The order of many, many columns within tables is materially different. My guess is that If I was to attempt to make my Upgrade DB reflect the Fresh Install DB at approximately 1 minute per change would take me 40 hours work or around £2,000 of labour to resolve. I tried to lay them out here but the post was too big for the forum, I tried to attach the db structure files but the forum does not accept that file format. So you'll have to take my word for it. Jules PS I used CHANGES Version 1.5.6 (524) on Mac OSX for analysis
  17. ... and it asked me for License. Yes, yet again CC5 has deleted all of my settings. This is so frustrating as it requires that I dump the whole folder, copy over CC4 and the database, have server admin upload the database (this is a big store) and start the whole 4 hour upgrade process again. Just keep swimming, just keep swimming. Jules The same thank happened to me when i was testing v5 locally.. license got invalid and when i entered it again all my settings were gone.. The second time around I also noted that after adding the new license code and discovering that my Settings were nulled when I looked at the front page of my site I noticed two things. One list of products listed every product I had (might be logical if the error set the field to null) but part of the browser title was still there. All of the metadata fields were nulled but I still had meta values. How does that work then? Note that I still have the missing column as per; I came in this morning to find over 130 additional error messages so it's going to be a long morning of further beta testing the application ... ;-) Jules
  18. I tried this and yes, I was able to see my new template in the list. However and for the second time in three days when I updated by settings I got a message to the effect; ... and it asked me for License. Yes, yet again CC5 has deleted all of my settings. This is so frustrating as it requires that I dump the whole folder, copy over CC4 and the database, have server admin upload the database (this is a big store) and start the whole 4 hour upgrade process again. Just keep swimming, just keep swimming. Jules
  19. Thant's exactly what I did; remember to take a full backup before you start though as it's easy to do something wrong when copy/paste/delete gets going in ernest ... Jules
  20. Thanks for that. Initially I was little uncertain about the zend/php (2x admin + 2x index) files but they're not encrypted files so I'm going to use ASCII for them. Everything was sent as BINARY yesterday and I'm getting Error 500's on the ~/images/logos/skin_variant.php file so I'll replace them all using ASCII later today. Regards, Jules
  21. Thanks for elaborating on that point. You'll be pleased to know that the issues is way more likely to have been one with server support than CC500 so justice was done in the end. Regards, Jules
  22. I have my V4 site running at public_html/ccrt4 using my paid license. I have my V5 test install running at public_html/ccrt5 using a 45-day trial license. This is free and allows me to fully test ccrt5 before making a purchase commitment. Once I get it running and my templates rewritten I'll replace the trial with a full license, switch the copyright key and mothball ccrt4. Here's hoping it won't take 45 days ... ;D Jules
  23. I get confused between various softwares ... 1) Should all of the CC5 PHP scripts be uploaded as ASCII; and, 2) Are there any files like true-type font files (.ttf) or similar (for captcha, etc) that I need to be careful to upload as BINARY? Thank Jules
×
×
  • Create New...