SmartyLo

Good day! This problem started few days ago - sometimes server just goes down. Once it happens at night (so it probably doesnt depends of visitors). My VPS server is pretty good, on dashboard on ISP panel there is no more 5-10% usage of RAM and other. But sometimes it becames up to 100%. I cant find the reason. Maybe somebody already faced with such problem. Here's what I found in mysql.log file (the time is the exact time of server ram overflow) So i decided that reason is smarty cache (but it's disabled, i'm using expressCache module). I tried to drop this table (according to ref. link advice), but there is no ps_smarty_cache table in phpmyadmin. Please, help. 161215 17:11:29 InnoDB: Error: table 'prestashop/ps_smarty_cache' InnoDB: in InnoDB data dictionary has tablespace id 815, InnoDB: but a tablespace with that id does not exist. There is InnoDB: a tablespace of name ./prestashop/ps_smarty_cache.ibd and id 3089, though. Have InnoDB: you deleted or moved .ibd files? InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. InnoDB: Starting in background the rollback of uncommitted transactions 161215 17:11:29 InnoDB: Rolling back trx with id 103AC0F, 1 rows to undo 161215 17:11:29 InnoDB: Waiting for the background threads to start InnoDB: Rolling back of trx id 103AC0F completed 161215 17:11:30 InnoDB: Rollback of non-prepared transactions completed 161215 17:11:30 InnoDB: 5.5.52 started; log sequence number 772964991 161215 17:11:30 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 161215 17:11:30 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 161215 17:11:30 [Note] Server socket created on IP: '127.0.0.1'. 161215 17:11:31 [Note] Event Scheduler: Loaded 0 events 161215 17:11:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.52-0+deb7u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) Killed 161215 17:50:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 161215 17:50:52 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. 161215 17:50:52 [Note] /usr/sbin/mysqld (mysqld 5.5.52-0+deb7u1) starting as process 2821 ... 161215 17:50:52 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 161215 17:50:52 [Note] Plugin 'FEDERATED' is disabled. 161215 17:50:52 InnoDB: The InnoDB memory heap is disabled 161215 17:50:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins 161215 17:50:52 InnoDB: Compressed tables use zlib 1.2.7 161215 17:50:52 InnoDB: Using Linux native AIO 161215 17:50:52 InnoDB: Initializing buffer pool, size = 128.0M 161215 17:50:52 InnoDB: Completed initialization of buffer pool 161215 17:50:52 InnoDB: highest supported file format is Barracuda.

Yeah, Thats true. As I know, customer can't change already submitted order.

Good day, I faced with a problem: Free delivery starts from, for example, 100$, but sometimes customers asks to remove 1 or few products from their confirmed order (so I do in back office), and sum becames les then 100$, but in invoice and backoffice it shows me that delivery is still free. How can I make it paid again?

Hello, I was trying to modify invoice number generator (actualy just tying to replace it with order reference), after replacing OrderInvoice.php in prestashop/classes/order folder. I tried to submit new order from Front Office, but catched error 500 and page with only an error, so I returned back this OrderInvoice.php file (backuped), but later I saw that order was submitted - on Orders page in BO it was displayed, but without current status- it was just "--", and order status filter doesnt works, In php my admin I changed status of this order, later - deleted this order from ps_orders table, but filter is still unavailable. what is the best way to solve this problem? I have pretty old database backup, so I cant replace the whole database. Thank you!

Thank you for promt reply! Well, such code doesnt work - name of invoice file is still incrementing value(+1 to previous values, but reference number is much bigger now), and in invoice file it doenst display invoice number now, there is white space. Is the "$order->reference" global variable?

I tried to paste this code into return value like this: return sprintf($format, Configuration::get(.$order->id.'#'.$order->reference;); It doesnt work, but it caused other problem - I submitted new order, it returned 500 error page, but was done and I can see it on backoffice. And now I cant apply order state filters anymore (the state of this order was 0, in phpmyadmin I replaced it to 3 - normal value, but there is still no any filters. What I have to do? I am in panic, because it wasnt "testing: shop. I replaced back OrderInvoice.php, but filters are still unavailable. Please, help.

Hello, In my shop order reference consists of only numbers, and I need that order invoice number would be totaly same as order reference number. I found where invoice number generating, but it's complicated to replace it with other value. Here what I have in OrderInvoice.php file: public function getInvoiceNumberFormatted($id_lang, $id_shop = null) { $invoice_formatted_number = Hook::exec('actionInvoiceNumberFormatted', array( get_class($this) => $this, 'id_lang' => (int)$id_lang, 'id_shop' => (int)$id_shop, 'number' => (int)$this->number )); if (!empty($invoice_formatted_number)) { return $invoice_formatted_number; } $format = '%1$s%2$06d'; if (Configuration::get('PS_INVOICE_USE_YEAR')) { $format = Configuration::get('PS_INVOICE_YEAR_POS') ? '%1$s%3$s/%2$06d' : '%1$s%2$06d/%3$s'; } return sprintf($format, Configuration::get('PS_INVOICE_PREFIX', (int)$id_lang, null, (int)$id_shop), $this->number, date('Y', strtotime($this->date_add))); } Thanks.

Well, this problem is solved. Actually, I downloaded once again clear prestashop, and replaced classes/pdf files, there was some file size mismatches, and when ps genereted one more invoice - everything was ok.

Actually, as I see, this problem was before installing of this module, because I found my first test orders and this problem was already exists. Where could be the problem? In Classes/pdf files?

Hello, I'm using third-party OPC module by PresTeamShop.

Hello, I'm using prestashop 1.6.1.6 with one page checkout module(if it's important) I faced that invoices are generating without information about delivery address. It have some "delivery address" header, but no information below. But delivery invoice (which has ferry's logo on it ) has this information, but it's a bit complicated - use 2 invoces. How can I add displaying of address in general invoice? In invoice.tpl I found that it contains the following code, but it doesnt work properly. <td colspan="12"> {$addresses_tab} </td> Thank you!