Jump to content

QuotesUK

Member
  • Content Count

    67
  • Joined

  • Last visited

Community Reputation

7 Neutral

Recent Profile Visitors

3,061 profile views
  1. QuotesUK

    open_basedir restriction in effect

    Thank you bsmither, the third article I read had a working solution. https://stackoverflow.com/questions/1846882/open-basedir-restriction-in-effect-file-is-not-within-the-allowed-paths Essentially, rather than specifying allowed paths you actually change open_basedir to "none" (service plan > php settings)
  2. My site is working (latest version, php7.2 etc) but my server logs are full of warnings like this... 2018-09-20 18:39:03 Warning 1.2.3.4 mod_fcgid: stderr: PHP Warning: file_exists() [<a href='http://docs.php.net/manual/en/function.file-exists.php'>function.file-exists.php</a>]: open_basedir restriction in effect. File(/opt/plesk/php/7.2/share/pear/smarty_internal_data.class.php) is not within the allowed path(s): (/var/www/vhosts/example.co.uk/:/tmp/) in /var/www/vhosts/example.co.uk/httpdocs/classes/autoloader.class.php on line 89 Apache error I am hosting on CentOS7 with Apache and Plesk. How do I fix this?
  3. QuotesUK

    Upgrading MySQL 5.1.73 to 5.5/5.6

    Thank you bsmither I am wondering about how far to go with the upgrade Is there anyone that can confirm whether a standard CubeCart installation works with MySQL 5.6?
  4. I have CubeCart v6.1.14 installed and my server is currently running MySQL v5.1.73 (even though cubecart.com says 5.5 minimum) I understand that you should not upgrade directly from 5.1 to 5.7, but should go 5.1 to 5.5, then 5.5 to 5.6, then 5.6 to 5.7. However Plesk does not yet support 5.7, so I won’t be going that far. 1/ What do I need to do with my CubeCart database if my server is upgraded from MySQL 5.1 to MySQL v5.5? and then... 2/ What do I need to do with my CubeCart database if my server is upgraded from MySQL 5.5 to MySQL v5.6?
  5. QuotesUK

    File Backups within Maintenance

    Manually upgrade what? The currently installed version is 6.1.14.
  6. QuotesUK

    File Backups within Maintenance

    I have already upgraded using the auto-setup tool (as a known issue I’m puzzled why it wasn’t squished at the same time) I assume this is source code issue rather than a setting or database value Is there a specific directory that I can swap out? e.g. perhaps "sources/maintenance/*" from the current version of source code? Thank you in advance
  7. I have found an error affecting two different CubeCart installs with different hosts, so I think this may be a bug When choosing the standard Files Backup button, with checkboxes off, the backup proceeds and is created but then it tries to find this file... /admin_ZZZZZZZ/sources/maintenance/indexbackup.inc.php - not found. Where ZZZZZ is a novel admin location - it doesn’t appear to have been used before and doesn’t match the current. In one situation (it may have been a checkbox difference) I was warned about cross-site scripting on the dashboard page It appears as is something is not going well for the Files Backup feature, and could do with looking at by the software development team (I am not that bothered personally, there are other backup methods available)
  8. QuotesUK

    How to Fix Database Index?

    Thank you - I have now cleared all the warnings from the maintenance section. It was time consuming, but I suppose it will now mean the server resources are used more wisely. I will just keep my fingers crossed that this upgrade issue is a one off, and auto upgrades will start working again. ...now onto my next CC install for more of the same!
  9. QuotesUK

    How to Fix Database Index?

    I now have the database warnings down to the following: CubeCart_category.cat_parent_id has no key set. Expecting KEY. CubeCart_inventory.popularity has no key set. Expecting KEY. CubeCart_inventory.status has no key set. Expecting KEY. CubeCart_reviews.approved has no key set. Expecting KEY. CubeCart_seo_urls.item_id has no key set. Expecting KEY. CubeCart_seo_urls.type has no key set. Expecting KEY. CubeCart_sessions.customer_id has no key set. Expecting KEY. CubeCart_sessions.session_last has no key set. Expecting KEY. and CubeCart_currency.currency_id has a key type KEY but expecting PRIMARY. CubeCart_modules.module_id has a key type KEY but expecting PRIMARY. I have taken some screengrabs and wonder whether you can give me a few pointers on what to enter. On the first image I have clicked on the Go button you suggested. The other two look a bit trickier because they are about changing something rather than add/delete. Someone at CubeCart might also want to make a note about the warning for using the table field name of "default".
  10. QuotesUK

    How to Fix Database Index?

    Thank you. The explanation helps. But where do I click? Are there any options I will be asked about?
  11. QuotesUK

    How to Fix Database Index?

    Okay, and for the benefit of anyone else following this, here is a new screengrab. I have used a red arrow to show you where to find this panel. The other two rows are now removed because I clicked on the word ‘Drop’ (just in case anyone is looking for a delete button). In my CubeCart admin panel this error is now cleared. Here is the other type of error: CubeCart_category.cat_parent_id has no key set. Expecting KEY. And my screengrab... how do we fix this sort, there are no onscreen prompts?
  12. QuotesUK

    How to Fix Database Index?

    Just found something. Just above the Information infopanel at the bottom is the word Indexes, which when you click on opens up some details...
  13. QuotesUK

    How to Fix Database Index?

    I am using phpMyAdmin and looking at the table - CubeCart_admin_user There are 23 database fields, starting with admin_id At the bottom are two infopanels - Space Usage and Row Statistics - nothing about column indexes What am I looking for? I can see the data, I can see the structure.
  14. Okay, so I have manually upgraded to v6.1.5 and I can see the database now has some issues - this was to be expected. However, I wasn’t expecting the link to a "database checker tool" to be just a link to a discussion elsewhere and the comments by Al Brookbanks aren’t much help... “Please use a tool such as phpMyAdmin to make any required changes” ... erm, yes, so how exactly? There appear to be two types of error message. This is what I am looking at: CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY. CubeCart_category_index.id has a key type KEY but expecting PRIMARY. CubeCart_category_language.translation_id has a key type KEY but expecting PRIMARY. CubeCart_category.cat_parent_id has no key set. Expecting KEY. CubeCart_currency.currency_id has a key type KEY but expecting PRIMARY. CubeCart_image_index.id has a key type KEY but expecting PRIMARY. CubeCart_inventory_language.translation_id has a key type KEY but expecting PRIMARY. CubeCart_inventory.popularity has no key set. Expecting KEY. CubeCart_inventory.status has no key set. Expecting KEY. CubeCart_modules.module_id has a key type KEY but expecting PRIMARY. CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY. CubeCart_reviews.approved has no key set. Expecting KEY. CubeCart_seo_urls.item_id has no key set. Expecting KEY. CubeCart_seo_urls.type has no key set. Expecting KEY. CubeCart_sessions.customer_id has no key set. Expecting KEY. CubeCart_sessions.session_last has no key set. Expecting KEY. CubeCart_transactions.id has a key type KEY but expecting PRIMARY.
  15. Does the ‘Force Upgrade’ button request the latest version? (it’s catch 22 - it asks me if I am sure to continue but how do I know what it will do??)
×