Jump to content

techkoop

Members
  • Posts

    27
  • Joined

  • Last visited

Contact Methods

Profile Information

  • Location
    Rotterdam
  • Activity
    User/Merchant

techkoop's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. Hi Iam using 1.6.1.7 and eMagic one store manager prof version when i imort product or product updates and publish them to the web with eMagic store manager i get 6|1364; Field 'id_parent' doesn't have a default value INSERT INTO ps_category (`id_category`,`level_depth`,`nleft`,`nright`) VALUES ("23","2","3","4"),("24","2","5","6"),("12","2","7","8"),("13","2","9","10"),("15","2","11","12"),("17","2","13","14"),("16","2","15","16"),("18","2","17","18"),("20","2","19","20"),("21","2","21","22"),("22","2","23","24") ON DUPLICATE KEY UPDATE `level_depth` = VALUES(`level_depth`), `nleft` = VALUES(`nleft`), `nright` = VALUES(`nright`); i checked the raw table but these values are allready there: id_category id_parent id_shop_default level_depth nleft nright active date_add date_upd position is_root_category 1 0 1 0 1 26 1 22-9-2016 14:53 22-9-2016 14:53 0 0 2 1 1 1 2 25 1 22-9-2016 14:53 22-9-2016 14:53 0 1 12 2 1 2 7 8 1 11-10-2016 14:34 24-3-2017 17:15 0 0 13 2 1 2 9 10 1 11-10-2016 14:43 4-3-2017 19:39 1 0 15 2 1 2 11 12 1 11-10-2016 14:52 4-3-2017 19:39 2 0 16 2 1 2 15 16 1 11-10-2016 14:55 4-3-2017 19:39 4 0 17 2 1 2 13 14 1 2-11-2016 12:25 8-5-2017 06:15 3 0 18 2 1 2 17 18 1 14-11-2016 14:54 4-3-2017 19:39 5 0 20 2 1 2 19 20 1 3-3-2017 18:46 8-5-2017 06:18 6 0 21 2 1 2 21 22 1 4-3-2017 06:32 4-3-2017 19:39 7 0 22 2 1 2 23 24 1 4-3-2017 11:37 4-3-2017 19:39 8 0 23 2 1 2 3 4 1 25-3-2017 08:02 25-3-2017 08:02 0 0 24 2 1 2 5 6 1 8-5-2017 11:25 8-5-2017 11:25 0 0
  2. hi my prestahop is in 1.6.1.7 is there a module that will add a client automatically to a predifined client group once the client has logged in and filled the fields for entering a (valid) business registration number? cheers suggestions can be send to [email protected]
  3. weet iemand of er iets bestaat om iemand die inlogt met een geldig KvK automatisch onder een klantengroep te laten vallen? ik heb prestashop 1.6.1.7 als het hier niet in kan kan het in 1.7? mail: [email protected]
  4. Hello I was trying to solve the issue why i could not get access to my modules through the menu modules and services in the bakoffice of my 1.6.1.7 prestashop. Thats why i changed the cofig.ini file and put the parameter on true: 1. remplace define('_PS_MODE_DEV_', false); par define('_PS_MODE_DEV_', true); once i done this i got these errors Warning op lijn 2134 in bestand /home/barberspullen.nl/www/classes/controller/AdminController.php [2] file_put_contents(/home/barberspullen.nl/www/config/xml/default_country_modules_list.xml): failed to open stream: Permission denied Warning op lijn 2138 in bestand /home/barberspullen.nl/www/classes/controller/AdminController.php [2] file_put_contents(/home/barberspullen.nl/www/config/xml/modules_native_addons.xml): failed to open stream: Permission denied Warning op lijn 2147 in bestand /home/barberspullen.nl/www/classes/controller/AdminController.php [2] file_get_contents(/home/barberspullen.nl/www/config/xml/default_country_modules_list.xml): failed to open stream: No such file or directory Warning op lijn 2148 in bestand /home/barberspullen.nl/www/classes/controller/AdminController.php [2] file_get_contents(/home/barberspullen.nl/www/config/xml/must_have_modules_list.xml): failed to open stream: No such file or directory Warning op lijn 4006 in bestand /home/barberspullen.nl/www/classes/controller/AdminController.php [2] file_put_contents(/home/barberspullen.nl/www/config/xml/tab_modules_list.xml): failed to open stream: Permission denied
  5. Als ik in de back end klik op "modules en services" gebeurt er niets behalve dan dat je de ziet dat hij bezig is (alsof je op F5 hebt geklikt). Mijn versie is 1.6.1.7 en ik heb tot nu toe geen problemen gehad. Hij zou eigenlijk naar AdminModules moeten gaan maar dat gebeurd dus niet. Ik zie diverse topics in het forum hierover voor een bugfix in presta 1.7 RC3. Maar die hebben niet veel opgeleverd voor de plaatsers van de topics. Ik hoop op een simpele oplossing. Ik wil dus als dit is opgelost mijn modules upgraden want de shop heeft even op onderhoud gestaan vanaf eind december 2016 tot en met heden en ik had er al een tijdje niet naar omgekeken. Concreet: hoe kom ik weer bij mijn modules?
  6. hi i have been searching to all the forums and communities. Everyone seems to have the same problem with 1.6.1.4. Tables do not exist,in the database, db-files do not have indexes,and simple apps like adding a product do not work in admin. Which version of prestashop 1.6 X should i install to work with a fresh and clean prestashop on localhost? I prefer to manage my shop on local host and use c:/xampp package. i work with a 64 bit machine with windows 10 home and 16Gb RAM, i used ports 8000 and 8433 for apache, blocked 80 and 433 in skype to be sure of a good database creation. It didn't help. The project is to get a shop suitable for one click upgrades. It's first stage will contain 3300 products divided over a lot of categories and with a lot of cool and comprehensive filters in the front end shop. Second stage will be over 50.000 products. I am really a fan of prestashop since the possibilities are endless but with all these errors i do not now if its still the best platform for me. Please get me a clean and working admin with an errorfree database. Greetz techkoop.nl
  7. Hi i amusing XAMPP and a stand alone download of prestashop 1.6.1.4. My phpadmin is version 4.5.1A. I tried to add a product which does not work (made a category allready). So i checked the database. Seems the index is missing in ps_manufacturer. Also all colomns seem to be empty. So on localhost when trying to open a colomn gives this message: Notice in .\libraries\sql-parser\src\Parser.php#371 Trying to get property of non-object Backtrace .\libraries\sql-parser\src\Parser.php#324: SqlParser\Parser->parse() .\libraries\controllers\TableStructureController.class.php#347: SqlParser\Parser->__construct(boolean false) .\tbl_structure.php#48: PMA\Controllers\TableStructureController->indexAction() Notice in .\libraries\controllers\TableStructureController.class.php#352 Undefined offset: 0 Backtrace .\tbl_structure.php#48: PMA\Controllers\TableStructureController->indexAction() And in the prestashop back end when trying to open or "manufacturers" this message: Foutieve SQL query Table 'prestashop.ps_manufacturer' doesn't exist in engine How to solve this? Any other bugs in 1.6.1.4 i need to fix? When is the release of a fully working and tested 1.6.2? version. Do you have a good tutorial how to fix this on utube?
  8. Wich values would you recommend for max_input_time: ? max_execution_time: ?
  9. Well ithink i have managed to create a workaround in my test version which will be live after the release and uprgade to 1.6.11 step1 create Customer group B2BNL and B2B and a taxrule 0% "tax excempt : tax is defered to customers invoice country" step2 create a B2B category step 3 when customers land on the B2B category they will find a message that they should sign in with their company details and a link step 4 i then manually chech their VAT number step 5 i allocate them to the right customer group step 6 copy all products to the wholesale category for B2B customers with the new taxrules Access granted to the wholesale category: B2B Customers only Products in the wholesale category will be in twice: one for B2B Domestic Customers only with local VAT and one time visible to B2B not domestic customers with 0% rule. Unsigned in customers or customers with no viable VAT number will not have access to the wholesale section for B2B. Cheers Peter
  10. also maybe you need advance stockmanagement ,and i suppose when a customer only can buy 1 product + 300 products and not say f.e. 200 products than you should have intervals in the moq's : this is a workaround its not supported by prestashop as far as i know. your sollution to work with product combinations is okay, but then again i think the customer can not check two boxes and order two combinations (like combination 1 product and combination 300 products) at once only as two seperate orders in the card.
  11. i've posted the issue also in the section where one can vote for ideas. PWC has a global VAT Checker for only EUR 3.000,- single license, which - in my opinion - is handy but really a lot of money. Nothing in life comes cheap i guess.
  12. My developer has a test version on a different server available of my shop. I have multiple issues to solve. Not only B2B but regarding a wide variety of business and programming problems. I'll try to be creative and search for a solution,when i found one i'll post or maybe sell it as a module
  13. Het beste is prestashop als "extracomptabele" administratie te houden en de aansluiting te maken via de bank. Als je sisow hebt met een saldo kan je wel "refunden".
  14. Hoi Fiscaal werkt het zo: 1. Consumenten betalen 21%. 2. Bedrijven uit Nederland betalen 21%. 3. Bedrijven uit het buitenland met een geldig BTW nummer betalen 0% --> pas op zeer ingewikkeld in prestashop ! Zie ook belastingdienst.nl zoek op BTW verleggen naar het buitenland.
×
×
  • Create New...