Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by lamplats

  1. Dear aun4some1 The name of the module that causes the error is Gamification - customers expertise. This is a paid module and it gives discount rewards for your customers. The start day propaply is needed to tell how old a customer is, in order for him to get his reward (for being registered since that date). Now i cant test that module since it is a paid one but i found out the following: The file that causes the problem is modules / gamification / classes / Advice.php that file creates the array and access the db. Access your database and confirm that thers is an array named advice (ps_advice) and see if it has these columns: 'id_ps_advice' 'id_tab' => 'selector' => 'location' => 'validated' => 'start_day' => 'stop_day' => Now i understand that not being able to access backoffice is really important and that you need this problem fixed asap First take a backup via FTP and from the database. Then you have this options 1) Restore from the last backup before the update that gave you this problem.(recommended solution) or 2) Delete the module via FTP, access your backoffice and reinstall. or 3) Fix this array yourself and see if the problem continues or 4) Contact the aythor of this module via pm (http://www.prestashop.com/forums/user/132608-vekia/) Now that you know what the problem is you can start another topic naming the exact problem and get help from people that actually have this module and can test it(I dont have it and i cant get it so is hard for me to give you step by step directions) Please let me know the name of the new topic and if the author of this module helped you.
  2. I think i solved it. Open the file named offlinecardpayment.php which is in \modules\offlinecardpayment and change the ps_order_paymentcard to prstshp_order_paymentcard. Now the new orders are registering (as before, that wasnt the problem) but now i can also access them from the backoffice and i can change the status of the order. Remeber to take a back up of the file. That was my solution to my problem. Your problem is similar but not the same. As i can see you have this module that awards customers for certain behavior. That module tries to add a value to a column named start day into a db table. The problem is that it cant find that column. Access your database and confirm that (see also if there is a column named stop date). Maybe you can try to add tha column by your self(be very careful, i have a local instalation of my shop so i feel free to do this kind of changes) The file that tries to do that is in \modules\gamification and it is named gamification.php From my understanding this is a paid module so you can ask for support from the seller I am not an expert.
  3. Hi, When i go to my backoffice, orders i can see the old and new ordes and their status but when i click on any of them i get the following error: [PrestaShopDatabaseException] Table 'prestashop_5.ps_order_paymentcard' doesn't exist SELECT * FROM `ps_order_paymentcard` WHERE `id_order` ="20"; at line 605 in file classes/db/Db.php 599. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);600. }601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))602. {603. if ($sql)604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');605. throw new PrestaShopDatabaseException($this->getMsgError());606. }607. }608. 609. /** Now i have a table named `prstshp_order_paymentcard` that is empty and another named `prstshp_order_payment` that has 4 rows (2 of ican see in my bakoffice)My backoffice has a total of 20 orders.and this are store in the table named `prstshp_orders` How can solve this error?Thank you
  4. Δες εδώ http://www.prestashop.com/forums/topic/190624-404-error-when-editing-product/ http://www.prestashop.com/forums/topic/218336-solved-cant-save-an-edited-product-152-and-1531/
  5. Γεια σας, Το αρχείο για τις front office μεταφράσεις βρίσκεται στο φάκελο εγκατάστασης--->themes--->όνομα θέματος--->lang και λέγεται el.php. Πάντως το prestashop δίνει τη δυνατότητα για εισαγωγή και εξαγωγή του αρχείου γλώσσας μέσα από το backoffice σε gzip μορφή. Τα αρχεία για τις υπόλοιπες μεταφράσεις βρίσκονται στο φάκελο εγκατάστασης--->translations--->el
  6. Εντάξει Μάγε Μέρλιν Ευχαριστώ πολύ για την απάντηση
  7. Γνωρίζει κανένας πως μπορώ να μεταφράσω το μνμ λάθους κατά τη καταχώρηση διεύθυνσης ωστε να μην εμφανίζει τα αγγλικά Η διευθύνσεις σας Τροποποίηση διεύθυνσης "Η διευθυνση μου " Υπάρχουν 6 σφάλματα address (1) απαιτείται. city απαιτείται. Ευχαριστώ
  8. Hello, I would like my customers to be able to insert their VAT number at the Address Fields but i dont want that to be a required field. Can you help? I go to Localization > Countries > Edit, and there i try to edit the Address format by adding new fields but nothing seems to happen. If i add the "Address:vat_number" but dont check the option "Do you need a tax identification number?" it doesnt show up at the front office. Moreover not a single new field appears when i add it to the list but from the default fields if i remove one like "address2" it dissapears from the address registration form. The only additional field i managed to add is states if i edit the states country(Alabamas country is Greece). So it kind of works but not as is supposed to? Also when i go to Customers > Addresses my new added fields dont appear at "Set required fields for this section." Moreover whεn i add there the vat as a required field when a client inputs his address the vat number field doesnt appear but there a message that says vat number is required (but there is no field!!!!!) It would be so awesome if i could really add any of the fields that appear at Localization > Countries > Edit to the front office. Really really awesome and helpfull. Thank you
  9. I get the No payment modules have been installed message I have installed Bank Wire and Check. I tried uninstalling and installing them again I created new carriers At the Payment module restrictions everything is marked The currency is euro (default and only). The strange thing is that I got the No payment modules message for a certain carrier that I created (ok I figured, I must have done something wrong) but then I tried a default carrier, the payment modules appeared just fine and the next 5 minutes without changing anything!!!!!!! (really not a single thing) when I tried to test things again I got the No payment modules for that default carrier. Is my falling falling apart? Should I abandon it? Please help I really don’t know what to do Thank you
  10. Thank you very much for your replies. I downloaded the whole prestashop zip (the version i had) and then i uploaded the module folder via ftp. The problem was with the position of the slider so i pressed reset (mimic slider) and everything went back to normal. Thanks again
  11. I accidentally pressed reset on the top horizontal menu (in the modules category) and know the menu is gone. It is hooked at the top but it doesnt show Please help Now i deleted it. i cant find it anywhere to download it again i erased it from the server and installed it again and here is the problem i use mimic slider and as soon as i disable it, the menu reapears. What can i do please help
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More