AlwaysSkint

I'll change the setting for PHP error reporting, to clean up the logs. Just thought it important to show the default behaviour.

Just checked my debain 9/ispconfig test VPS: lo & behold.. That explains why that one didn't go well either. 😕 I definitely think that you should emphasise that many installations will require a (manual) upgrade of mariadb, if not mysql.

An upgrade to mariadb 10.4 later and the above errors still appear. Any suggestions, folks?

I'm back! Part of my installation issues were due to trying to install within CentosWebPanel (CWP) and CentOS 7. By default, mariadb 10.1 is installed. I didn't notice the requirement that ClicShopping works near the bleeding edge - for e-commerce long-term stability is a thing. ;) It does explain how I managed to get further with DirectAdmin/CentOS 7, as that combination includes a mariadb 10.4 option by default. I installed/licensed Softaculous on the CWP server, which highlighted the version problem during the installation. This should really be a part of the standard setup routine, in my opinion. that would've saved me a lot of time/grief! I now have CWP upgraded to mariadb 10.3.. First failure: the ClicShoppingAdmin default .htaccess has invalid definitions, causing 500 errors - thankfully easily fixed. #Options -Indexes #Options +FollowSymlinks #Options -MultiViews The next set of errors is much more problematic On a fresh installation from Softaculous, with no demo data: [06-Nov-2020 12:14:34 America/New_York] PHP Notice: Undefined index: MessageStack_Data in /home/clic/public_html/shop/includes/ClicShopping/OM/MessageStack.php on line 35 [06-Nov-2020 12:14:34 America/New_York] PHP Notice: Trying to access array offset on value of type bool in /home/clic/public_html/shop/includes/ClicShopping/Apps/Orders/Orders/Classes/Shop/Order.php on line 591 [06-Nov-2020 12:14:34 America/New_York] PHP Notice: Trying to access array offset on value of type bool in /home/clic/public_html/shop/includes/ClicShopping/Apps/Orders/Orders/Classes/Shop/Order.php on line 592 ... [06-Nov-2020 12:14:34 America/New_York] PHP Notice: Trying to access array offset on value of type bool in /home/clic/public_html/shop/includes/ClicShopping/Apps/Orders/Orders/Classes/Shop/Order.php on line 601 [06-Nov-2020 12:14:34 America/New_York] PHP Notice: Trying to access array offset on value of type bool in /home/clic/public_html/shop/includes/ClicShopping/Apps/Orders/Orders/Classes/Shop/Order.php on line 602 [06-Nov-2020 12:14:35 America/New_York] PHP Notice: Undefined property: ClicShopping\Sites\Shop\Search::$checkManufacturer in /home/clic/public_html/shop/includes/ClicShopping/Sites/Shop/Search.php on line 408 I better try upgrading to 10.4 and see if that helps - Softaculous installer said 10.2, if I recall.

Unfortunately that syntax is beyond me. 😞 I figured out all I had to do was remove the non-working osCmax reference and add my own osCmax.php, based on the Oscommerce one. At the moment, I'm trying to figure out the differences between HTML::outputProtected and HTML::sanitized Example: 'products_description' => HTML::outputProtected($data['products_description']), I'm trying to allow addresses with a # symbol (American's use it for number) and descriptions that include styles, as examples. (My comment stands on the complex directory structure - osCommerce is/was bad enough. )

.. Got a custom osCmax migration, in development. There are various issues with the different database tables, though I do have the (simple) Categories one working. Some field names don't quite match up and date formats are throwing error, though I'm fairly hopeful that I'll get most of this fixed up. PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'customers_dob' at row 1 in /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php:136

A global search revealed this: $filename_array[] = array('id' => 'Oscommerce', 'text' => 'OscMax'); So my hunch was correct and this likely needs changed to match. The quest continues.. Blimey, this software has a convoluted/complex directory structure!

I'm back at this migration. 🤪 Presumably, even though it's listed the osCmax migration code isn't included. I'm going to try copying the osCommerce.php to osCmax.php and rename the class within it, to osCmax. This way I can tweak the new file, to match up database files. Am I missing something?

@Julie It's far from ideal and I'm taking numerous backups whilst 'tweaking' but at least I'm getting places. 😉 When/if I find time, I can hopefully streamline the installation process, assuming this software allows me to get the basics up & running. Now back to trying a migration.. (another thread.)

After MUCH messing around, tweaking permissions and manually importing the "ISAM" SQL file, as well as removing/re-adding the default clic_ prefix, I appear to have something up and running again. :-/ I've done a manual backup, plus let the automated backup run, before doing anything further. This may become my template for future installs - let's see. Thanks for at least trying @ClicShopping - I do hope my stress levels calm down a bit today. I'm too old for these unnecessary complications. :'(

Message sent with full login details to CWP account. Good luck!

Went with debian 9/ISPConfig/PHP 7.4.11 FPM this time,with the "version3.2145.zip'. Same/similar result,with step 4 halting, though this time resource://gre loaded. Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:82.0) Gecko/20100101 Firefox/82.0 Note: I didn't enter any SMTP details,if that's makes any difference.

I guess the first easy(?) question is what software to install, master.zip or ClicShopping_V3-version3.2145.zip ?

I dare say if I setup a basic webserver with little/no security then it'll install fine. I might find time to do that on a temporary not-for-production VPS. TBH, I'm getting a bit 'scunnered', having been doing this stuff for a few days now. I've got clients that would benefit from migrating their current stores to ClicShopping, if I can get a stable environment. In doing so, then it gives me impetus to give back to the community, even if only for feedback, suggestions and critique.

No disrespect intended.

Thanks, confused me for a bit. Especially as I created a new one.;)

Thanks for trying but that's real basic stuff.

Arrgh! A frackin' video! What's wrong with text? Guess I'll take a quick look (with the volume down) and see if there's any hidden gems. 10 seconds, then realises a monkey could do that bit.

I host a few client sites around the World, most are e-commerce but some (yuk!) Wordpress. I manage both VPS and dedicated servers, using Proxmox on a couple dedicated ones and various control panels (cPanel/CWP/Directadmin/HestiaCP) on Cloudlinux, CentOS 7 and debian 9/10. Though I'm not a security specialist, my servers thankfully haven't been hacked (yet!), primarily by following good hosting practices. In short, I've been doing this stuff for quite a while. ClicShopping What a nightmare I've had trying to get this software to install/run! 😮 I've re-installed multiple times, on all the control panels mentioned above. On one instance (DA), the admin was horrendously slow, taking minutes to update each screen. Once, on a CWP install (after many attempts) I got things apparently running quite well but there were loads of errors appearing in logs. I've tried beginning from the master.zip download as well as ClicShopping_V3-version3.2145.zip - of which there are quite a few discrepancies; the lack of a shop directory being the main one. The supplied .htaccess files make a horrible default setting, which is often unacceptable in a secured environment. Options -Indexes Options +FollowSymlinks Options -MultiViews Any web server that is publicly accessible should be setup with as secure an environment as possible. Some commercially available shared hosting providers are poorly configured, so don't take those as a good baseline - why do you think so many websites get hacked?! Typically, Apache is configured to use suexec/suphp/PHP-FPM or a combination of these. It's a means to restrict what each user account can access on the server and prevents mistakes such as permissions of 777 on directories and 666 on files. These World writable permissions should NEVER be used and if you find they must be, in order to do something web-based then your server is configured wrong. Simple. In some stricter setups the maximum permissions are 750/640 but 755/644 is more commonly used/acceptable. Meanwhile.. I've tried installing with PHP 7.3 & 7.4 (7.4 is mentioned in the install instructions) and in all cases there have been some glitches. The stumbling block is in step 4 of the installation where the logo and top links appear and the rest of the page causes a 'hidden' 500 error. No error appears in either the domlog or Apache general log - very strange! Using Firefox debugging tools, I see that jquery and fontawesome codes are retrieved but resource://gre is blank. ExtensionContent.jsm seems to be the culprit, wherever that is intended to be fetched from.

Hi, I'll open a new thread, specifically on installation issues, hopefully to benefit others. I am liking the look of this software but, Jeez, it's a struggle to get working. Doing a cPanel install just now..

777 is fine for a 'server' hosted at home but is stupidly bad for any other situation. Trust me, I've been administering servers for over 30 years! When running under suexec/suphp/php-fpm php is run by the account user, whereby u+w is sufficient. So far, I've tried installing under DirectAdmin and repeatedly under CentOSWebpanel (my preferred option for various reasons) but I can also try HestiaCP and WHM/cPanel.

I may be some time. :-/ I've hosted/supported e-commerce software for more than 15 years but this is the most difficult one to get installed and running. There is no clear installation path/instructions and downright dangerous instructions. Permissions of 777 should NEVER, repeat NEVER be used, for example and is in fact impossible to use where suexec/suphp/PHP-FPM comes in to use. Using the master.zip directly extracted on the server, installed to web root and with file/directory permissions set correctly to 644/755. Step 4 of installation present a blank (500 error) screen. On a different server/control panel, I have managed to get something running but the admin is super slow = unusable. BTW: Thanks for the support, guys.

Nothing was imported. :'( I'm not happy about the various error messages that are appearing in the error log, so I'm going to re-install clicshopping (again!). The instructions for installing aren't very good though, so it sometimes takes a few attempts.

[30-Oct-2020 18:10:32 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'entry_zone_id' at row 1 in /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php:136 Stack trace: #0 /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php(136): PDOStatement->execute(NULL) #1 /home/clic/public_html/shop/includes/ClicShopping/OM/Db.php(374): ClicShopping\OM\DbStatement->execute() #2 /home/clic/public_html/shop/includes/Module/Hooks/ClicShoppingAdmin/ImportDatabase/Oscommerce.php(148): ClicShopping\OM\Db->save(':table_address_...', Array) #3 /home/clic/public_html/shop/includes/ClicShopping/OM/Hooks.php(63): ClicShopping\OM\Module\Hooks\ClicShoppingAdmin\ImportDatabase\Oscommerce->execute(NULL) #4 /home/clic/public_html/shop/includes/ClicShopping/Apps/Tools/ImportData/Sites/ClicShoppingAdmin/Pages/Home/templates/import_process.php(80): ClicShopping\OM\Hooks->call('ImportDatabase', 'Oscommerce') #5 /home/clic/public_html/shop/ClicShoppingAdmin/index.php(41): in /home/clic/public_html/shop/includes/ClicShopping/OM/DbStatement.php on line 136 [30-Oct-2020 18:12:41 UTC] PHP Notice: Undefined index: MessageStack_Data in /home/clic/public_html/shop/includes/ClicShopping/OM/MessageStack.php on line 35 [30-Oct-2020 18:12:41 UTC] PHP Notice: Undefined property: ClicShopping\Sites\Shop\Search::$checkManufacturer in /home/clic/public_html/shop/includes/ClicShopping/Sites/Shop/Search.php on line 408 Given the message stack error and manufacturer errors, I think I'll try a re-installation, from master.

This has now allowed it to "import" (list) 28 products, plus display "1867 Address book". I need to check what has actually imported.