Jump to content

ejsolutions

Members
  • Content count

    87
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by ejsolutions

  1. ejsolutions

    osCommerce v4 Beta 2

    @osCommerce-Official I'm back looking at this and find I'm also unable to import Category images, which are stored in the old store at catalog/images/categories. I've tried a number of variations to the 2 defines, mentioned above. Looking for any more bright ideas.
  2. ejsolutions

    osCommerce v4 Beta 2

    A wee aside: I'm seeing the following in apps.log.. yii\base\InvalidRouteException: Unable to resolve the request "themes/basic/css/menu.css". in /home/osc4/public_html/lib/vendor/yiisoft/yii2/base/Module.php:543
  3. ejsolutions

    osCommerce v4 Beta 2

    Just an idea: supply a bz2 file that has the proper (755/644) permissions set. Zip files don't hold permissions. 🤓
  4. ejsolutions

    osCommerce v4 Beta 2

    Thanks for this; a few logs that I can look at.
  5. ejsolutions

    osCommerce v4 Beta 2

    I've tried this in oscb/compat/configure.php define('DIR_WS_IMAGES', 'images/images_big/'); define('DIR_FS_IMAGES', '/home/osc4osc/public_html/catalog/images/images_big/'); An example of what appears in images/products/missing_images.txt pid:11048:AncientWisdom/AW-BPAP05.jpg pid:11742:8Seasons/8S-B22974.jpg pid:11085:Craftime/Ct-AC9104X.jpg A quick check and /home/osc4osc/public_html/catalog/images/images_big/8Seasons/8S-B22974.jpg does indeed exist. In the new database products_image appears as 8Seasons/8S-B22974.jpg
  6. ejsolutions

    osCommerce v4 Beta 2

    This seems likely. I'll investigate in a wee while: perhaps prefix it in the oscb configure.php, after the standard includes? Also, I've just increased the products_image to varchar(255) in the new database, to accommodate the image path, which appears to be getting populated as expected. BTW, are products limited to 6 extra images, or extendable? Just curiosity at this stage.
  7. ejsolutions

    osCommerce v4 Beta 2

    Now this is becoming interesting! 😄 I've managed to import all the data types, though it looks as though I'll need to extend timeouts for the number of products (stopped with Ajax error: Row(s) Imported: 1235). @osCommerce-Official can you provide some insight as to how category/product images are handled/imported? Due to the quantity of images, the original site has them stored in per Category subdirectories of images. I recognise that I'm likely to need to import them manually but some understanding of how they are mapped in the database, to physical files would be useful. To partially illustrate, here's an example of the one of current Categories: Stitch and Sew /Knit and Crochet /Yarn /DK Yarn
  8. ejsolutions

    osCommerce v4 Beta 2

    Well, this was mad and only made a bit easier due to the flexibility of CWP. To be able to import, I needed to set different PHP versions at directory level. Docroot (public_html), new site = PHP7.4 catalog, old site = PHP5.3 catalog/oscb, importer = PHP7.4 Otherwise the importer throws up syntax errors. Hey, at least I'm moving forward: Brands = Row(s) Imported: 129 🙂
  9. ejsolutions

    osCommerce v4 Beta 2

    Jeez, obvious when you think about it: how did I miss that?! 😳
  10. ejsolutions

    osCommerce v4 Beta 2

    I have the (bogus?) mempeakusage message for Brands,Categories etc. PHP memory limits are set for both new & old sites as 256M. If it is of any relevance the new site is running PHP 7.4 and the old PHP 5.3 - though given zachris is experiencing the same (bogus?) message, it doesn't seem relevant. Unfortunately, I don't wish to allow access to the data that I'm testing with - it's a client's data, not mine. At this rate (lack of true debug messages), I'm likely to try a custom database only migration but it'll depend on how the db is structured, plus methodology for storing images. I haven't had the time to explore that, yet - I'm midway migrating a key VPS. Is there a way to better log errors and/or a place to find them?
  11. ejsolutions

    osCommerce v4 Beta 2

    Similar to @mfleeson (Hi!), I'm getting.. XML Error: memusage 14.000 MiB mempeakusage 14.000 MiB Mismatched tag at line 21 Done .. when attempting to import. I don't recognise that value at all, as I've set PHP memory to 256M.
  12. ejsolutions

    osCommerce v4 Beta 2

    I've reported this issue. The demo PNG images need to be replaced with non-interlaced versions (and optimised too ), then they will be more compatible with libraries.
  13. ejsolutions

    osCommerce v4 Beta 2

    This is a much better start - both servers/sites/configurations return (similar but different, of course) keys without errors. [Edit] Now at where Jack_MCS was - goes back a page to review..
  14. ejsolutions

    osCommerce v4 Beta 2

    oscb_secure_v32.zip per chance?
  15. ejsolutions

    osCommerce v4 Beta 2

    On a different server, using the default old install of catalog: PHP 7.4.25 (cli) (built: Oct 23 2021 21:53:50) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with the ionCube PHP Loader + ionCube24 v11.0.0, Copyright (c) 2002-2021, by ionCube Ltd. with Zend OPcache v7.4.25, Copyright (c), by Zend Technologies root@rn:/home/users/sa/www/catalog/oscb# php yii bridge/show-secure-key root@rn:/home/users/sa/www/catalog/oscb# PHP Notice 'yii\base\ErrorException' with message 'Undefined index: file' in /home/users/sa/www/catalog/oscb/compat/database.php:53 Stack trace: #0 /home/users/sa/www/catalog/oscb/compat/database.php(53): yii\base\ErrorHandler->handleError() #1 /home/users/sa/www/catalog/oscb/compat/database.php(84): tep_db_error() #2 /home/users/sa/www/catalog/oscb/compat/database.php(137): tep_db_query() #3 /home/users/sa/www/catalog/oscb/common/api/models/XML/Project.php(69): tep_db_perform() #4 /home/users/sa/www/catalog/oscb/common/api/models/XML/Project.php(41): common\api\models\XML\Project::createProject() #5 /home/users/sa/www/catalog/oscb/common/helpers/Init.php(70): common\api\models\XML\Project::checkLocalProjects() #6 /home/users/sa/www/catalog/oscb/commands/BridgeController.php(79): common\helpers\Init::IOInit() #7 [internal function]: app\commands\BridgeController->actionShowSecureKey() #8 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array() #9 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams() #10 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction() #11 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction() #12 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction() #13 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction() #14 /home/users/sa/www/catalog/oscb/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest() #15 /home/users/sa/www/catalog/oscb/yii(21): yii\base\Application->run() #16 {main}
  16. ejsolutions

    osCommerce v4 Beta 2

    Well, @Jack_MCS is getting farther than my attempts. I could only get something remotely close to working by keeping the original oscb directory name and moving the website from catalog to docroot. However, for that instance, I'm convinced the security key that displayed is for the new site, not the old one. For clarity, @osCommerce-Official which version(s) of PHP is the importer compatible with? I have older sites that only function properly on 5.3.29 for example, though I can 'push' them to 5.4 for transfer purposes. Also, the wiki says to have the importer extracted to the root directory - is this the docroot for the site or the catalog? Here's an example of some of the issues that I've been facing: # php -v PHP 5.4.45 (cli) (built: Jan 31 2022 17:27:38) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies # php yii bridge/show-secure-key PHP Notice 'yii\base\ErrorException' with message 'Undefined index: file' in /home/maxs/public_html/oscb/compat/database.php:53 Stack trace: #0 /home/maxs/public_html/oscb/compat/database.php(53): yii\base\ErrorHandler->handleError(8, 'Undefined index...', '/home/maxs/publ...', 53, Array) #1 /home/maxs/public_html/oscb/compat/database.php(84): tep_db_error('insert into io_...', 1406, 'Data too long f...') #2 /home/maxs/public_html/oscb/compat/database.php(137): tep_db_query('insert into io_...', 'db_link') #3 /home/maxs/public_html/oscb/common/api/models/XML/Project.php(69): tep_db_perform('io_project', Array) #4 /home/maxs/public_html/oscb/common/api/models/XML/Project.php(44): common\api\models\XML\Project::createProject('REDACTED_161...', Array) #5 /home/maxs/public_html/oscb/common/helpers/Init.php(70): common\api\models\XML\Project::checkLocalProjects() #6 /home/maxs/public_html/oscb/commands/BridgeController.php(79): common\helpers\Init::IOInit() #7 [internal function]: app\commands\BridgeController->actionShowSecureKey() #8 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array) #9 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array) #10 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/console/Controller.php(148): yii\base\Controller->runAction('show-secure-key', Array) #11 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/base/Module.php(528): yii\console\Controller->runAction('show-secure-key', Array) #12 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('bridge/show-sec...', Array) #13 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('bridge/show-sec...', Array) #14 /home/maxs/public_html/oscb/vendor/yiisoft/yii2/base/Application.php(386): yii\console\Application->handleRequest(Object(yii\console\Request)) #15 /home/maxs/public_html/oscb/yii(21): yii\base\Application->run() #16 {main}
  17. ejsolutions

    osCommerce v4 Beta 2

    Yikes! 😵
  18. ejsolutions

    osCommerce v4 Wiki

    Have added a possible entry for modsecurity settings in the Talk section, as wiki is read-only. Hope that helps and can be included.
  19. ejsolutions

    Installation osCommerce v4 Beta 2 - No Admin Page

    I've tried a number of installs now, with different combinations and had mostly errors post-installation. Try the following: Begin the zip extraction from your www or public_html (webroot) directory. Start installation from your browser and specify / as the starting point, not for example /catalog Specify Test for the Sales Channel and name it Test Do not add a suffix on the URL Include the demo data It won't give you a production ready site but does appear to set things up to be in a usable state. Additionally, check file and directory permissions are suitable for your environment - mine were set 'potty' during initial extraction and post installation. This can cause a 500 error at the worst, and error log warnings.. SoftException in Application.cpp:249: File "/home/osc4osc/public_html/index.php" is writeable by group HTH
  20. ejsolutions

    osCommerce v4 Beta 2

    This is great! Have already sent some preliminary feedback. Trying to get to grips with the Sales Channel stuff at the moment, then it's on to the import from existing stores. One major thing of note is the instruction to allow openbase_dir - this is a BAD idea on shared servers and will need enforcement of cagefs/jailed fs. Not allowing it may be the cause of a few installation 'quirks', so I need to do some testing with it unfortunately turned on. 😐
  21. Why the added complication of Composer? That's enough to put me off right away! It is absolutely horrendous working with the behometh Magento where Composer just creates adds to the bloat and code complexity/maintenance. As @Hotclutch has said poorly sized images are the biggest contributor to slow sites, though as the number of products/customers/orders increases to the thousands level, then the lack of correct database indexing comes into play.
  22. ejsolutions

    osCommerce v4 Wiki

    Chicken & egg situation? Can't write the content until we see what features are available. 😖
  23. Brilliant effort! One item stands out that really should've been a core inclusion, is an HTML editor for descriptions, IMHumbleO. Something like CKEditor, depending on suitability with jquery, PHP7/8 etc.
  24. ejsolutions

    osCommerce v4 demo

    Dinnae skim read, please! You're new here, so you won't know that I've been floating around the osC scene for quite some time (~15 years) and contributed code to a forked version of osC. I've also hosted and continue to host other e-commerce software. I was asking you specifically about osC v4 and Trueloaded. Not Edward. Regards, EJ (Coming across a peculiarity already during the installation of Trueloaded: "You don't have permission to access this resource." ... goes off to check logs and .htaccess.. mod_security block /usr/local/apache/modsecurity-owasp-old/base_rules/modsecurity_crs_41_xss_attacks.conf!)
  25. ejsolutions

    osCommerce v4 demo

    Thanks to @MFleeson I've been pointed to the demo of TrueLoaded, which I somehow managed to sidestep (I assumed an offshoot of the semi-commercial) CRE. Now, this looks encouraging and certainly from the admin perspective it appears to be very comprehensive. I'll try an install of True. What I'd like to know from the developers @osCommerce-Official is the following: Will osC 4 be a re-badging of True and will True now be consigned to history i.e. no more updates? If osC4 has a considerable difference to the code structure, then will there be a 'smooth' migration path from True to osC 4? I don't want to spend too much time, constructing a migration path from my current stores to True just for it to be mothballed, with no path to osC 4.
×