socomtactical Posted August 25, 2017 Share Posted August 25, 2017 Hi guys any ideas how to stop this issue? We have ghost products showing on our website when i click on it it says product 88 but we dont have this in our admin section? Please view Screenshot Link to comment Share on other sites More sharing options...
olkuznw Posted August 25, 2017 Share Posted August 25, 2017 Hi! Try to sort order in admin panel for example by price (from sales to height) to make sure that this product is really absent. You can share with site link on this product, it will more informative. Link to comment Share on other sites More sharing options...
Scully Posted August 25, 2017 Share Posted August 25, 2017 (edited) For me it looks like you have inconsistencies in your database. - Since when do this ghosts exist? - Did you recently upgrade your shop? - What is your prestashop version? Edited August 25, 2017 by Scully (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted August 25, 2017 Share Posted August 25, 2017 Ghost products are due to wrong removed products on database, so exact what scully told: inconsistences in your database. Did you cleared/deleted products on your database with a tool or manually ? 1 Link to comment Share on other sites More sharing options...
socomtactical Posted August 26, 2017 Author Share Posted August 26, 2017 Hi latest version have only installed a few weeks. We havnt deleted any products yet as still adding products no upgrades yet as was a fresh install Link to comment Share on other sites More sharing options...
selectshop.at Posted August 26, 2017 Share Posted August 26, 2017 Hi latest version have only installed a few weeks. We havnt deleted any products yet as still adding products no upgrades yet as was a fresh install Latest version of which major version ? 1.6. ? 1.7 ? Products added manually each one by itself, or via import ? Link to comment Share on other sites More sharing options...
socomtactical Posted August 26, 2017 Author Share Posted August 26, 2017 (edited) PrestaShop version: 1.7.1.2 we added them manually Edited August 26, 2017 by socomtactical (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted August 26, 2017 Share Posted August 26, 2017 Which php version in use ? Which SQL ? mySQL? MariaDB ? Your database should be checked for inconsistent tables/crashed tables. If there are some than repair them. If you don't know how, ask your provider for assitance. Seems that your database has some missing data. Link to comment Share on other sites More sharing options...
socomtactical Posted August 26, 2017 Author Share Posted August 26, 2017 Server information: Linux #1 SMP Fri Oct 21 11:58:14 EDT 2016 x86_64 Server software version: Apache/2 PHP version: 7.0.22 Memory limit: 512M Max execution time: 30 Upload Max File size: 32M DATABASE INFORMATIONMySQL version: 5.6.36-cll-lve MySQL server: localhost MySQL name: MySQL user: Tables prefix: ps_ MySQL engine: InnoDB MySQL driver: DbPDO Link to comment Share on other sites More sharing options...
selectshop.at Posted August 26, 2017 Share Posted August 26, 2017 max_execution_time is too slow. This means that when something is written and script not terminated, you will have some inconsistencies in database, cause server stops the writing and omit the rest of what is open. max_input_time and max_execution_time should be 300 and not only 30 seconds. Database: surely a mySQL, but this is not the problem. For to correct your product id88 which seems to be not written completely it is necessary to analyze your database by a Prestashop expert and repair the problem. A remote forum help is not recommended. Link to comment Share on other sites More sharing options...
socomtactical Posted August 26, 2017 Author Share Posted August 26, 2017 Thanks ill have a look max input is showing a -1? Link to comment Share on other sites More sharing options...
selectshop.at Posted August 26, 2017 Share Posted August 26, 2017 Value -1 is ok. Link to comment Share on other sites More sharing options...
socomtactical Posted August 26, 2017 Author Share Posted August 26, 2017 Ok changed the max ex time to 300 just checked my other site which runs oscommerce and same setting but have no issue. Will see if this resolves issue Link to comment Share on other sites More sharing options...
selectshop.at Posted August 26, 2017 Share Posted August 26, 2017 OSC is old technique and don't need the same server ressources like Prestashop or Magento. You cannot compare. Are completely different worlds in coding architecture. Link to comment Share on other sites More sharing options...
Scully Posted August 26, 2017 Share Posted August 26, 2017 After the configuration change I'd install and run the PS Cleaner Module with option 3. Link to comment Share on other sites More sharing options...
socomtactical Posted September 1, 2017 Author Share Posted September 1, 2017 Hi Scully Where do i find the ps cleaner module sorry i looked on mod store couldnt see it? Link to comment Share on other sites More sharing options...
Scully Posted September 1, 2017 Share Posted September 1, 2017 Search in modules, cleaner or pscleaner. Link to comment Share on other sites More sharing options...
socomtactical Posted September 1, 2017 Author Share Posted September 1, 2017 Thank you Link to comment Share on other sites More sharing options...
socomtactical Posted September 1, 2017 Author Share Posted September 1, 2017 Looks like its fixed at the moment lets see if any more pop up thanks for all your help! Link to comment Share on other sites More sharing options...
Scully Posted September 1, 2017 Share Posted September 1, 2017 You're welcome. Add SOLVED to the topic title if appropriate. Link to comment Share on other sites More sharing options...
socomtactical Posted December 16, 2017 Author Share Posted December 16, 2017 Hi guys sorry having issue again and its stopping me doing a SEO url rewrite as it says duplicate product i have tried ps cleaner and still not removing and at the moment the 3 products are not showing in admin section Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now