.png.022b5452a8f28f552bc9430097a16da2.png)
Search the Community
Showing results for tags 'db'.
-
Hi, I noticed in the back end that some orders gave € 0.00 on the label: "total paid from registration" even if the order is complete and shipped. Via query on the db: SELECT * FROM ps_orders WHERE reference = "ordernumber"; and I found a field called "valid" the value was 0....
-
Hello everyone! I need some help please... I want to create a subdomain for my website (PS 1.7.5) and copy all the files there and then do some theme modifications through custom.css files. But I need to keep the same database connected for the new subdomain and my main domain. Is this possibl... -
Dears, I'm looking for someone able to re-install a clean PS version and: -install the modules - migrate the modified files - Import products and associated data to the new version from the old one? Please send me your time and price estimation? Kr, M.
-
Hi, I have a problem with the taxe rules. Sometimes, and totally randomly, automatic duplication and reassignment of the group rules is performed, even in db. Has anyone already had anything to do with it? Thanks! -
dopo l'aggiornamento mi ritrovo questo problema quando richiamo la schermata dei clienti nel bo. An exception occurred while executing 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (... -
When i go to the new url: http://calcemi.com it redirects in some way to localhost/prestashop. I think it is not a server error but somethinh on the prestashop files, i looked the db from top to bottom and i don't see any configuration beside the one which mentions the prestashop migrating tutorial... -
Checkout broke a couple of days (at least that's when I noticed it) in my webshop runnning on PS 1.7.7. Since the error was connected to the PayPal-module I reset its settings and tried again, but get the following error-message: [PrestaShopDatabaseException] Table 'myshop.ps_mailal...
-
Hello, I'm dealing with a website, running 1.6x that has some quite large tables ps_connections_source : 2,1 Go ps_connections : 840 Mo ps_guest : 571 Mo ps_sekeyword : 120 Mo ps_cart : 16 Mo ps_customer : 10 Mo ps_mail : 9 Mo etc ...... -
Hi... I am developing a module for prestashop and I have some issues with DB class. I want to retrieve the id of a table ($table) with email ($condition). I get that id with the getRowFromElement function, which returns an array. Since there is only one entry with any given email, the array has only...
-
Hi guys, I am struggling to fin the maintenance under the performance page while I am trying to disable shop in order to perform upload back_up version of the DB. I ma using PrestaShop 1.7.3 That's what it says in documentation on the PrestaShop when creating the back_up...
-
Hola a todos, He recibido un aviso de mi hosting informando de que mi base de datos ocupa demasiado espacio, por lo que he truncado las tablas ps_guest; ps_connections; ps_connections_page; ps_connections_source; ps_page_viewed, pero aún así ocupa mucho, y he visto que la tabla ps_layered_price... -
Hi, I'm trying to generate a custom reference, but I found a problem, and I don't know if I'm doing something wrong. When I generate a reference, I want to check in the DB the last number generated for a year, to create a reference in the format "YEAR/0/ORDER_COUNT/W" (200001W), I want t...
-
Hello everyone, I have a problem, it turns out that a product that has been indexed and published on August 18, has been indexed with the date I published it, as a rich snippet in google, and that seems very blog style . I would like to eliminate that. I looked at the code and the only thing I...
-
Hi, I'm tying to extract from my Prestashop 1.6 the following info for every first customer order: ID customer sex age order date total amount spent product category Newsletter subscription yes or not using VAT yes or not Using coupon yes or not payment method device or OS... -
Hello, everyone! I have a multistep modal taken from here. I have input fields, checkboxes and dropdowns. Also I have put the product attributes code in the modal, so the user can select them from inside. I have made every step of the 3-rd modal in the link to be a form. Each "Continue" button... -
Have any good solution, that convert Database prestashop 1.6 to 1.7 version. I have already worked store on 1.6 version. I need transfer all data to 1.7 version. And save all ID indexes. Have this solution?
-
Hello everyone! I need some help please... I want to create a subdomain for my website and copy all the files there and then do some theme modifications through custom.css files. But I need to keep the same database connected for the new subdomain and my main domain. Is this possible? Any idea...
-
Hi all. i need to add a new database connetion to my project, for exemple on product detail page, i need to get my product from "prestashop_DB" and the description from "the_external_DB" (i reash to make a new connection by a new function in "classes/db/Db.php" called "getInstance2"...
-
Hi, I am building a PrestaShop module and can not save the product data to the DB (AJAX). Characteristics of the module: - PrestaShop version: >= 1.7.4.x - Data is added to each of the products. - Data input form is on the product page in the tab "Module". - Form data should be... -
Hello guys, i have a situation where i want to keep central server for Authentication, where all customer credentials information stored and different server for Prestashop shopping site to manage rest of all things. So basically 2 different DB and servers. How this can be achieved and if it is so ,...
-
Bonjour, pour optimiser les performances de notre Prestashop 1.6.1.4 il nous est conseillé d'utiliser le cache memcache (ou autre) par contre lorsqu'on l'active les résultats sont inutilisables en production. Après analyse du code, il s'avère que les requêtes sql sont cachées par la classe DB,... -
Hello, when I was searching something in my PS db I've looked in ps_configuration table and find: Few days ago I've made update from 1.7.2.4 to 1.7.4.3 should I do something with it or leave it? I think that everything works fine...
-
I use two functions in my custom code lets say function Query and function QueryLang The first one returns db::getInstance()->executeS($sql); In the second one after I prepare my query to include the respective _lang table, I call the first one but in bux fixing when I was doing var_dump($...
-
Hi, guys! I'm an intern at a web development company. With other interns we're working with Prestashop. We've never seen it before and it causes us a lot of problems. We are usually told to modify something simple within CSS or a .tpl file, but recently we started to get tasks that are a bit too...
-
Hola. Como va? creo este tema porque me di cuenta que al actualizar a Prestashop 1.7, no se volvio a cargar mi base de datos, por lo que le faltan tablas a la misma. Mi pregunta es si en algun lado Prestashop guardo la copia de seguridad automática que crea antes de actualizar (si es que lo ha...
