tallinn

Det er et gammel shop (1.6.0.14) som jeg vil gerne upgradere til den nyeste (1.6.1.7) og slet alle moduler. Jeg kan ikke set op et development environment fordi der er alltid noget som gör galt. Det vil være meget sjovt hvis jeg kan tale med nogen som har erfaring. Måske har du set det fra min skriv, men jeg kommer ikke fra Danmark Håber du forstår hvad jeg skriver.

Hej. Er der nogen som har tid til at hjælpe mig lidt med et migration via Skype eller lignende? Jeg kan godt købe kaffe eller øl efter hjælpen

Hi. I am wondering with all the hosting companies out there which one is the best when you specifically need to host a PrestaShop? Doing a Google search gives me these: hostbuddy.com Cheap - unlimited bandwidth - cPanel - cheap (from 3$ a month) inmotionhosting.com Recommended by PrestaShop - unlimited bandwith etc. - a bit more expensive at around 10$ per month I specifically want to be able to develop new features for the shop. Price around 20-30 dollars per month is acceptable. Regards

Alright. Thanks. I will try this later today.

Ahh yes. That must be it. I imported data from an old version of PrestaShop to this database. I guess this column was not present in the older version. Now another question pops up. If I simply add the column it will not have a meaningful value. What should I do about that?

Alright thanks. Is there any explanation as to why it does not contain this column in the first place?

Hi. When trying to load my local shop I get this error: [PrestaShopDatabaseException] Unknown column 'image_shop.id_product' in 'on clause' And at line 791 in file classes/db/Db.php if ($webservice_call && $errno) { $dbg = debug_backtrace(); WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { if ($sql) { throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); } throw new PrestaShopDatabaseException($this->getMsgError()); } } I had an error before this that I solved. The previous error was simply because I had not set a theme. Then I set the theme and this error started showing up. Image_shop table does not have this column id_product in my database. My PrestaShop version is 1.6.1.6. EDIT: Here is more info from the error: DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2343 - classes/Product.php] - [1 Arguments] ProductCore::getNewProducts - [line 102 - modules/blocknewproducts/blocknewproducts.php] - [3 Arguments] BlockNewProducts->getNewProducts - [line 144 - modules/blocknewproducts/blocknewproducts.php] BlockNewProducts->hookdisplayHomeTab - [line 587 - classes/Hook.php] - [1 Arguments] HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments] HookCore::exec - [line 41 - controllers/front/IndexController.php] - [1 Arguments] IndexControllerCore->initContent - [line 189 - classes/controller/Controller.php] ControllerCore->run - [line 367 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 28 - index.php] Should I simply add this column?

Non of these scripts are working for me I have got all of the individual tables from the shop in .sql files. I can import them one at a time if that is what it takes but I do not know which ones I should import and which ones I should not. This link: http://doc.prestashop.com/display/PS16/Fundamentals+of+PrestaShop+Development has the overview of the database. It is pretty overwhelming. But I guess for example that I should import all of the tables in the Customer part because I would like to keep the customers from the website intact. I also want the products so I should probably import all of the tables in the Product part. In fact here is an exhaustive list of all the parts, a description of it, and whether I should import it to my new shop or not. Maybe someone can help me with the details of the different parts: 1. Stock This keeps information about the available stock in the shop. I should import this since I want to preserve that data. 2. Customer All the data about the customers that have made an account in the shop. I should import this since I want to preserve that data. 3. Product All the data about the products that are being sold in the shop. I should import this since I want to preserve that data. 4. Prices & taxes Closely related to the product part. Information about the price of individual products and tax information. I should import this since I want to preserve that data. 5. Warehouse The different warehouses for the shop? I should import this since I want to preserve that data. 6. Module Information about different modules that are installed in the shop. I should NOT import this since I am starting from scratch and one of them might be the culprit. 7. Order All of the orders that have been made are kept here. I should import this since I want to preserve that data. 8. Base tables No idea what this is. Should I keep? 9. Employee Information about the different employees in the shop. I should import this since I want to preserve that data. 10. Supplier The different suppliers for the shop? I should import this since I want to preserve that data. 11. Carrier Not sure what this is. Should I keep it? 12. Cart The current cart for the specific customer. I do not think I need to keep this one. 13. Stats Statistics. I think I will leave this out for now. 14. New layer (dark green) No idea what this is. Should I keep? 15. New layer (grass green) No idea what this is. Should I keep? 16. Scene No idea what this is. Should I keep? 17. Solo tables No idea what this is. Should I keep? 18. Configuration Not sure what kind of configuration is kept here. Should I keep it? 19. Meta Not sure what this is. Should I keep? 20. Web service I can create the web services again. Yes, they will have different keys but whatever. 21. Theme Definitely NOT keeping this since it is one of the things that might be causing the problems. 22. Manufacturer Information about the manufacturers. I should import this since I want to preserve that data. KEEP: 1-5, 7, 9, 10, 22 NOT KEEP: 6, 20, 21, Unsure: 8, 11-19 What do you guys think? After I have imported the ones I want to keep I am wondering what will be missing. The products will be missing the images for example. What more?

Hi. That is good news. I already started on importing data from my old store to the new one by using musicmaster's method from post #4. If you could send me your module then that would be awesome as I would like to try it out as well. electriz, thanks for the tips. Appreciate it. Thanks for the link. I am trying to use your method now. It is a bit more complicated than I had hoped for but I am till giving it a go.

Hi. I am having trouble with setting up a local version of a shop I am managing. This is a shop that has been managed by some IT people and they were doing a marginal job so the owner decided to try something new. That is where I come in. I have no experience in PrestaShop but am eager to learn. I have an open post about the troubles I am having setting up the local development environment and it is causing headache. Specially since the problems I am having are being reported in the live version as well. So the other day I wondered if re-doing the whole shop would be a viable option. That is what this post is for. So my plan is to install a new instance of the PrestaShop onto my local machine. Import the minimal amount of data into the sql server. Install the minimum amount of modules (preferably non to begin with). And then take it from there. Sounds easy Is there anything I am missing? Is it a harder task than I assume it is? The goal of this: I am new to PrestaShop. I would like to get my hands dirty with everything involved in starting a PrestaShop and maintaining it. The website is currently pretty unstable and there are some complaints from customers about that. I would like to fix that. Cheers!

Ops. Sorry. That is the option I tried. So in my previous post: "I have tried to disable ALL of the modules in the Advanced parameters -> Performance tab in the back office. " Was supposed to be: I have tried to disable ALL of the overrides in the Advanced parameters -> Performance tab in the back office. That had the effect described in my previous post. Sorry for the imprecise description.

I have tried to disable ALL of the modules in the Advanced parameters -> Performance tab in the back office. This stops the errors from being shown but the page still refreshes infinitely. So maybe it is best to figure that one out first with all the modules disabled. There must be some setting that I am overseeing...

What I have done now is to make sure that ps_shop_url reflects my setup. domain: localhost domain_ssl: localhost physical_uri: /projects/mystore/ And from ps_configuration: ps_shop_domain: localhost ps_shop_domain_ssl: localhost Now the problem is those error messages and the constant refreshing. The website never finishes loading. It just keeps doing something and the browser never reports the website finishing loading. @selectshop.at I made sure that these were set the way you suggest. I am not sure about three of them though: cURL - installed/on for external payment services like Paypal mod_rewrite = on mod_security = off I did not find those. @musicmaster Okay. I have 110 modules installed, 16 disabled, and 56 modules to update. What steps do you suggest I take? Now you need to find out which module installed those files. You can do that by looking into those files (like \override\classes\Product.php) and see whether you can find some indication in their header. I am not sure how I would go about doing that. I do not know what I am looking for. In the product.php file there are just a bunch of methods like: getAnchor($id_product_attribute) getNewProducts($id_lang, $page_number = 0, $nb_products = 10, $count = false, $order_by = null, $order_way = null, Context $context = null) getPricesDrop($id_lang, $page_number = 0, $nb_products = 10, $count = false, $order_by = null, $order_way = null, $beginning = false, $ending = false, Context $context = null) getAttributesParams($id_product, $id_product_attribute) getCopyColorAttributes($where, $id_lang, $page_number, $nb_products, $count, $order_by_prefix, $order_by, $order_way, $front, $context) And that is about it. Alternatively you can experiment with disabling modules one by one and looking what happens. I notice that they are categorized. Some are front end and some are backend. The backend modules are probably fine since the admin console works (for now) fairly well. Should I disable one after the other with a refresh of the website after each? @electriz Here is the offending code around line 79. $setdatawithcolor = array(); foreach ($result as $getproductgh){ if($getproductgh['id_product_attribute'] > 0 &&$getproductgh['id_attribute_group'] == 8){ if(!$setdatawithcolor[$getproductgh['id_product']][$getproductgh['id_attribute']]){ $setdatawithcolor[$getproductgh['id_product']][$getproductgh['id_attribute']] = $getproductgh['id_product_attribute']; } }else{ $setdatawithcolor[$getproductgh['id_product']][0] = NULL; } } Line 79 is now the offender, not 93 as previously. And it is from the Category.php not Prodcut.php. I also regenerated my .htaccess file by turning friendly url off and saving, then turning it back on and saving. In the SEO and URLs from the backoffice.

I checked my SEO and URLs. In the ADMIN console they are set to: Shop domain: localhost SSL domain: localhost Base URI: /projects/mystore/ And that is also what I see when I look in the database. Although I do not see the Base URI in the database. After setting the dev mode to true I am getting some error messages that might lead to somewhere. Here are some of them. This is the first: WARNING: INVALID ARGUMENT SUPPLIED FOR FOREACH() IN C:\XAMPP\HTDOCS\PROJECTS\MYSTORE\CLASSES\PRODUCT.PHP ON LINE 3437 Then a bunch of these: NOTICE: UNDEFINED OFFSET: 197 IN C:\XAMPP\HTDOCS\PROJECTS\MYSTORE\OVERRIDE\CLASSES\CATEGORY.PHP ON LINE 79 Then some of the webpage layouts and pictures are displayed. It takes a lot of time for it to load. It is still like it is always redirected in a loop or something. Sometimes this error pops up: The localhost page isn’t working localhost redirected you too many times. Try clearing your cookies. ERR_TOO_MANY_REDIRECTS Sometimes I am actually redirected to the actual website where it is hosted with the hosting company. More errors: Notice: Undefined variable: products_ids in C:\xampp\htdocs\projects\mystore\override\classes\Product.php on line 93 Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\projects\mystore\classes\db\DbPDO.php on line 91 This has to be some sort of error when importing the database or something right? Like half of the database got imported maybe.

That I have done. I have set them to the appropriate value pointing to my localhost folder within XAMPP. I will double check when I get home today but I am pretty sure that this is what the Preferences -> SEO & URL changes. I am not sure that I am in dev mode. I did not know I had to be in dev mode to get results. I mean, I thought that just getting the website running in a local environment would not be such a hassle. I am trying to run the shop locally so I am the host I mentioned that the Admin console does not cause problems. When trying to view the shop as a customer then all hell breaks loose. Thanks for the suggestions, I will check them out when I am home today. Any other suggestions are welcome. Maybe someone has done this before and can provide a step by step guide? Cheers!