Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by Nelly111s

  1. Brian, I did as you said and there was a lot of "guff" in the HTML in the Offline tab. I'll fix this for next time. There was no guff in the Copyright tab, just clean HTML. However, weirdly, I'd fixed the problem by switching to Chrome instead of Safari (on a Mac). I guess something to do with a cache since I don't use Chrome much.
  2. I turned "off" my site a few months ago by checking the "Disable Checkout" option. When I now go to uncheck this, it doesn't save the preference. I'm not sure which table this is kept in otherwise I'd use SQL/myPhPAdmin to alter it. However, I think that this may not be unique to this checkbox because I had a similar issue with the "Double Opt-in" checkbox for the Newsletters. So, I think something is stopping me saving presences - any thoughts?
  3. OK, I understand. I just logged out and back in again on Safari and the warning re new version popped up. I'll have to upgrade now! N
  4. I work on a Mac and use Safari more often than not, but I have both Chrome and Firefox loaded. I've noticed before and again today, that the two browsers report differently. Today, Chrome informed me via the Admin/dashboard page, that 6.4.3 was available and that PayPal commerce had an update available. Neither of these appear in Safari. From previous experience it may be a few days before Safari shows these things. Whilst its not a big problem, I'd like to understand what causes the problem and what I can do to change it. I'm sure it must be "something" to do with the way the cache works on each of the browsers, but ... An help would be appreciated
  5. Hey, don't apologise - you tried to help. Thats great - many people don't. N
  6. @Dirty Butter, @Claudia MThanks for your replies. I've not explained myself very well! The facility I want is for me to get a shipping quote (not the customer), for items which are not sold via the website (I do "catalogue" items and specials, not listed on the web). So I'm just using the Cubecart shipping table as a "lookup" to a number I input. My shipping table is "non-linear" since there are some lighter products that are >1m in length and have a shipping premium, so it would help me to have this facility rather than a simple paper copy pinned to the wall!
  7. I'm using a modified version of Foundation (mainly different colours) - store is www.olivewoodturning.co.uk The "Disable initial shipping and tax estimates" is not checked. This is exactly as you say - people know what they want an ring me up without going through the store (or even near it!). I deal with a few "old blokes" some of whom still use chequebooks, or in some cases people are ringing me for something different than that which is advertised. So I'm trying to find an easy way (a paper copy may be the easiest!) of being able to quickly calculate shipping for a random selection of goods, which I can weight (or already know the weight). Since I've already done the calculations for shipping to populate the "By Weight" module, re-using this info seems like the best way of doing this.
  8. I use the "By weight" shipping module and it works really well for what I need. However, I often get rung by people wanting to buy things and needing to know a shipping cost before placing an order. So, what I think I need is either a spreadsheet (I use Apple numbers on my phone at work) or a dummy page in Cubecart so that I can put a weight into it and the formula will work out what the shipping would be. I think all the information is in the By Weight module, in shipping.class.php. I guess I could use the code in this module and a code hook to produce another page in Cubecart that I could then use an input box to provide the data into the shipping.class code? I'm getting to the outside limits of my knowledge and experience on code hooks, so whilst this is the most elegant solution (it'll always work with the real data in Cubecart) it may not be the simplest way of getting what I need. Has anyone any thoughts on doing this, or done anything similar? Thanks N
  9. Well, I've got it going, but it's still not right. I created a virtual host (woodenstuff.home) and redirected to it in the hosts file on my Mac. I thought I'd do a clean install since I'd created a new directory, so loaded the files up. Decided to use Firefox and it worked, sort of. When the installation script got to the end, it didn't create a new admin directory, nor give me the usual clickable link to any admin directory. It gave me a 504 Gateway Time-out error. I checked and the database tables had been created and I was able to login via the admin username/password dialog OK. I can also see the front page OK. This is also the same if I use Chrome and Safari, but I have to make sure I type the http://, not just woodenstuff.home/admin.php. It's clear that the permissions issues are still not sorted OK and I'd probably like to get to the bottom of this. However, "I think" that for what I currently need, which is developing a script and more work on the design of the site, it should work ... Here's what Firefox reported from the Store Overview page in CubeCart CubeCart Version 6.4.2 PHP Version (7.3 Recommended) 7.3.16 MySQL Version 5.5.5-10.3.24-MariaDB Image folder size 92.85 KB Download folder size 0.00 KB Max. Upload filesize 32M Browser user-agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:88.0) Gecko/20100101 Firefox/88.0 Server Software Apache/2.2.34 (Unix) mod_fastcgi/mod_fastcgi-SNAP-0910052141
  10. OK. Thanks. I'll try it in the morning - off to watch the close of the Masters now!
  11. OK, so one of the cookies (the line highlighted) has this error "the set-cookie was blocked because its domain attribute was invalid". This was in the cookies tab. In the headers tab is this Server: nginx Set-Cookie: CC_421D0FD82C=ae45d98c88285d55836bc0da1eb8072f; expires=Sun, 18-Apr-2021 19:43:01 GMT; Max-Age=604800; path=/shop/CubeCart; domain=.; HttpOnly So clearly, running nginx! I'm not sure how to stop it, but I'll have a look.
  12. You're getting to the outer limits of my knowledge now (but don't stop, my limit is expanding) The image attached is the screenshot from the Network tab on Chrome developer tools. No obvious sign of cookies ... But as I said, I'm not 100% sure what I'm looking for. As far as Nginx or Apache, the Web control app in Synology says I'm using Apache 2.2 / php 7.3, but when I go into phpMyAdmin I get this Web server nginx/1.16.1 Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $ PHP extension: mysqlihttp:// curlhttp:// mbstringhttp:// PHP version: 7.3.16 I've tried to find out how I can switch off Nginx (becasue it appears to be running ...) and I can't find the right info. Are there any resources that would be worth me having a read to improve my knowledge and chances of fixing this. It won't beat me!
  13. OK, I created the ini-custom.inc.php file and put it in the root folder of the store. Tried to logon again, still no joy. I see that the CubeCart_sessions table is being populated - it creates entries when I try and logon. There was no error log created, either going into the normal store home page, or trying to logon to the admin page.
  14. OK, thanks. Thats first on the list for tomorrow !
  15. The info.php is still there. Is this the information I need? Session Support enabled Registered save handlers files user Registered serializer handlers php_serialize php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly 0 0 session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_samesite no value no value session.cookie_secure 0 0 session.gc_divisor 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.lazy_write On On session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /var/services/tmp /var/services/tmp session.serialize_handler php php session.sid_bits_per_character 4 4 session.sid_length 32 32 session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies 1 1 session.use_only_cookies 0 0 session.use_strict_mode 0 0 session.use_trans_sid 0 0
  16. I've found the session files in /var/services/tmp and located them via Terminal What next ...
  17. Im not sure where the PHP session files are on this NAS - I'll do a bit of research and find out. I can view the storefront, but can't keep anything in the shopping basket.
  18. So, I'm continuing to try and install a test copy of CubeCart 6.4.2 on a Synology NAS. I had a few problems with connecting to the site after the initial setup, but these were sorted, see here Error on line 42. I've now run into the same error as @jrjdegrooton this thread Can't Login to Admin Panel. My site is hosted at so I've looked at that thread and inserted this into my global.inc file $glob['storeURL'] = ''; $glob['standard_url'] = ''; $glob['ssl_url'] = ''; $glob['cookie_domain'] = ''; $glob['rootRel'] = '/shop/CubeCart/'; // Must have trailing slash! >? Which, I think, is the same as the other thread. But no joy. It's not a username / password issue, it just goes back to the same admin logon screen with no error. I note that each time I try to login, the "logins" column in the table "admin_users" gets incremented by 1, so the dB thinks that I'm logging in. Can anyone offer any further insight?
  19. I " think" I may have found the issue - need to add this line in globals.inc $glob['dbsocket'] = '/run/mysqld/mysqld10.sock'; It's connected and appears to be working OK ...
  20. The host was localhost. The host name for the database user in phpMyAdmin is also localhost. I presume that's what you mean by globals.inc.php lists $glob['dbhost'] = 'localhost'; It connected to the database OK during the setup process and made all the tables OK in the database.
  21. I've got a CubeCart store running happily on a web server, but I've just got a new Synology NAS and thought that I'd install CubeCart to do some work on an offline copy of the store. I uploaded the 6.4.2 zip file and unzipped it Used phpMyAdmin to create a new dB and user Ran setup (after making sure permissions on the folders were set) Setup ran OK, gave me the "green light" Now, if I try and access the site or the admin screen I get the error "Fatal error: No such file or directory in /volume4/web/shop/CubeCart/classes/db/mysqli.class.php on line 42" Ive checked through this forum and this always seems to be a username / password issue (or so I think). The setup script created the global.inc file, not me manually and it appears to be correct, so I'm really doubtful its this. However, it's not working and I'm stumped ... Just to confirm, php7.3 and this is a vanilla install, not a copy of the working store (yet).
  22. Sorry for the late reply. I did a bit more investigation and intitaly couldn't make it work. I then switched to Chrome from Safari, to see if it made a difference, which surprisingly it did. The catalogue mode now works as I would have expected! Next problem, why didn't Safari work ...
  23. I'm trying to "turn off" my website, or at least the ordering part of it on a temporary basis. I've tired checking the "Catalogue Mode" button, but it doesn't seem to have any effect and when I click "Save" at the bottom of the page in Settings, the checkbox defaults back to unchecked. Any tips as to what I'm doing wrong? Further to this, even trying to put the store into "offline" mode doesn't work. I have a gremlin somewhere. Any tips would be appreciated. Thanks
  24. I've wanted for a short while to export customer contact information into Google Contacts. From there, I can easily use the contact information in Quickbooks, my accounts package. I have cPanel access and using that and the phpMyAdmin, I went into the database and using the SQL below produced a query which I exported as a csv and imported without issue into. Google contacts. The SQL is below, should anyone wish to use it. I'm not a programmer etc - I learnt SQL ages ago briefly and it may be very crap code, but it works. Please don't ask me "how do I do this", "how do I modify to do this". I don't have the time to fix my own Cubecart site, never mind yours, so this code if offered as a service to those with the knowledge to use it. If you don't know how to do this, don't use this code! SELECT DISTINCT CONCAT(T1.first_name, ' ', T1.last_name) AS 'Name', T1.first_name AS 'Given Name', T1.last_name AS 'Family Name', '' AS Notes, 'Wooden Stuff ::: * myContacts' AS `Group Membership`, '* Work' AS `E-mail 1 - Type`, T1.email AS `E-mail 1 - Value`, 'Mobile' AS `Phone 1 - Type`, T1.mobile AS `Phone 1 - Value`, 'Home' AS `Phone 2 - Type`, T2.phone AS `Phone 2 - Value`, '' AS `Address 1 - Type`, '' AS `Address 1 - Formatted`, CONCAT(T2.line1, ', ', T2.line2) AS 'Address 1 - Street', T2.town AS `Address 1 - City`, '' AS `Address 1 - PO Box`, T2.state AS `Address 1 - Region`, T2.postcode AS `Address 1 - Postal Code`, 'United Kingdom' AS `Address 1 - Country`, '' AS `Address 1 - Extended Address`, T2.company_name AS `Organization 1 - Name`, 'Delivery Title' AS `Custom Field 1 - Type`, T2.title_d AS `Custom Field 1 - Value`, 'Delivery First Name' AS `Custom Field 2 - Type`, T2.first_name_d AS `Custom Field 2 - Value`, 'Delivery Surname' AS `Custom Field 3 - Type`, T2.last_name_d AS `Custom Field 3 - Value`, 'Delivery Company' AS `Custom Field 4 - Type`, T2.company_name_d AS `Custom Field 4 - Value`, 'Delivery Address Line 1' AS `Custom Field 5 - Type`, T2.line1_d AS `Custom Field 5 - Value`, 'Delivery Address Line 2' AS `Custom Field 6 - Type`, T2.line2_d AS `Custom Field 6 - Value`, 'Delivery Address Town' AS `Custom Field 7 - Type`, T2.town_d AS `Custom Field 7 - Value`, 'Delivery Address County' AS `Custom Field 8 - Type`, T2.state_d AS `Custom Field 8 - Value`, 'Delivery Address Postcode' AS `Custom Field 9 - Type`, T2.postcode_d AS `Custom Field 9 - Value`, 'Delivery Address Country' AS `Custom Field 10 - Type`, T2.country_d AS `Custom Field 10 - Value`, 'Delivery Phone' AS `Custom Field 11 - Type`, T2.phone AS `Custom Field 11 - Value`, 'Delivery Mobile' AS `Custom Field 12 - Type`, T2.mobile AS `Custom Field 12 - Value`, 'Delivery email' AS `Custom Field 13 - Type`, T2.email AS `Custom Field 13 - Value` FROM `CubeCart_customer` T1 INNER JOIN CubeCart_order_summary T2 ON T1.customer_id = T2.customer_id WHERE T1.customer_id > 001 Enjoy!
  25. It does seem to work. If I order two or three, the postage is still zero. If I add a single item that needs a shipping cost, only that cost is shown. I’m not sure why it wouldn’t rhough. The weight of the item is always zero and the packaging weight is a one off in the shipping module, no matter how many items are shipped.
  • Create New...