
Black RL
Members-
Posts
10 -
Joined
-
Last visited
Everything posted by Black RL
-
That's not the problem, the search weight of all that is set to zero. Anyway, I've done multiple SQL queries to the database and I've come to some conclusions, they aren't has robust as I would like them to be, but they make some sense, so for this example: 61623ABF0113/6162379091/61623CR017 All words are in the spp_search_word database but not in the spp_search_index database (only the first one 61623ABF0113), the fix is changing them too: 61623ABF0113 /6162379091 /61623CR017 Or 61623ABF0113, 6162379091, 61623CR017 It seems PrestaShop indexing doesn't like big words, that's the only explanation I have for this, it works now, that's what matters to me.
-
Hi, I'm running some tests, and the only explanation that seems plausible, is that search has a limit for word size, here are some search tests: pingente, returns c/pingente and pingente, OK sapelly, returns mogno/sapelly and sapelly, OK But working with 61623ABF0113/6162379091/61623CR017 I get mixed results: 61623ABF0113/6162379091/61623CR017, returns correctly, OK 61623ABF0113, returns correctly, OK 6162379091, no results, NOT OK 61623CR017, no results, NOT OK You could say it's because the word is at the middle/end, but it worked for the first examples, so something different is happening here, word size limit? Other? Note: Search within word: OFF Search exact end match: OFF Can someone shed some light on this? Thanks!
-
Hi, I've searched a lot but I didn't find a definitive answer, I don't know if I should activate the last cache option of PrestaShop or not, the one under advanced>performance, some people say that if OpCache is enabled then it should't be activated, others say the more the better, this is what I have: SERVER OpCache on Full compression including GZip on PRESTASHOP Smarty with cach on ......... Cache off Should I activate it? And if yes can you please help me choose the best option? Memcached? Thanks. http://doc.prestashop.com/display/PS16/Performance+Parameters
-
I've tried a couple more things and I was able to make the backoffice work! I was inspired by this topic: https://www.prestashop.com/forums/topic/259761-move-from-server-to-localhost/#comment-1298566 But I did it slightly different (note that frontoffice doesn't work for me): 1) Install a fresh PS on local (so I created a DB on local) 2) When installation finishes you get a link to the backoffice/admin area, save it! 3) Delete all tables from data-base 4) Import all the tables downloaded from your on line web-store data-base in the local data-base 5) Search for table "yourprefix_configuration", then search for this names: "PS_SHOP_DOMAIN", change value to localhost "PS_SHOP_DOMAIN_SSL", change value to localhost Search for table "yourprefix_shop_url", edit (column name): "domain", put localhost "domain_ssl", put localhost "physical_uri", put /yourfolder/ 6) Couldn't login so I followed this instructions to reset password: https://www.hostinger.com/tutorials/prestashop/how-to-reset-prestashop-admin-password Done!
-
Hi, I've google search and found several topics, I've spent several hours trying to figure out what I'm doing wrong but I'm having difficulties, so I need your help, I just want a copy of my site in a local machine so I can use more hardware (database is what matters the most). I installed WAMP, download the site using FTP, backup database and restore it using phpMyAdmin, can't make it work. So I've decided to do it in another way, fresh PrestaShop 1.6.1.12 install (same version of live site) and new database with the same name and prefix, this works! Then I imported the site database and changed their names so I can "fool" PrestaShop into using the one I want, I also made the following edits to the site database: Search for table "yourprefix_configuration", then search for this names: "PS_SHOP_DOMAIN", change value to localhost "PS_SHOP_DOMAIN_SSL", change value to localhost Search for table "yourprefix_shop_url", edit (column name): "domain", put localhost "domain_ssl", put localhost "physical_uri", put /yourfolder/ I've copied the above data from the working database, so at least that settings are the same, but when I try to go to the store I get "We can’t connect to the server ", what am I missing? This is driving me insane, please help, thanks!
-
show only products without images
Black RL replied to vietnam's topic in Configuring and using PrestaShop
This is an old thread but I had a similar problem with product cover image, here's an adaptation to find products without cover: SELECT * FROM ps_image WHERE cover IS NULL AND position = 1 Note that you might have to change position = 1 to 2, 3 or other depending on your setup, you might also try without that line: SELECT * FROM ps_image WHERE cover IS NULL But this might not be the best solution if you have multiple images per product, because this will return all images that are not flagged as cover. Note: note that you have to substitute ps_ with your table prefix- 7 replies
-
- admintracking
- customisation
-
(and 5 more)
Tagged with:
-
Hi all! I'm having a very strange problem that is infuriating! Costumer status is changing from active to inactive without my input, the strange thing is that this is only happening to one of the active ones (so far, I'm not opening the gates because of this). I log to backoffice and I change costumer account to active (directly or indirectly by editing the costumer) The costumer uses the account (he uses latest Firefox), everything seems fine A couple of days pass and the status changes "automatically" to inactive, without my input! Any clues of what can be happening? Help? Many thanks! Note: I've searched the web for a couple of days and I couldn't find a similar problem Artimol - configuration.pdf