Dellytoe Posted March 21, 2010 Share Posted March 21, 2010 Hai, I'm necommer in prestashop. I've tried to install prestashop and after reach step 3 I got the problem below. So any body can give on advice to solve this problem. thanksError while inserting data into the database:'INSERT INTO `ps_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (1, \'payment\', \'Payment\', NULL, 1), (2, \'newOrder\', \'New orders\', NULL, 0), (3, \'paymentConfirm\', \'Payment confirmation\', NULL, 0), (4, \'paymentReturn\', \'Payment return\', NULL, 0), (5, \'updateQuantity\', \'Quantity update\', \'Quantity is updated only when the customer effectively place his order.\', 0), (6, \'rightColumn\', \'Right column blocks\', NULL, 1), (7, \'leftColumn\', \'Left column blocks\', NULL, 1), (8, \'home\', \'Homepage content\', NULL, 1), (9, \'header\', \'Header of pages\', \'A hook which allow you to do things in the header of each pages\', 1), (10, \'cart\', \'Cart creation and update\', NULL, 0), (11, \'authentication\', \'Successful customer authentication\', NULL, 0), (12, \'addproduct\', \'Product creation\', NULL, 0), (13, \'updateproduct\', \'Product Update\', NULL, 0), (14, \'top\', \'Top of pages\', \'A hook which allow you to do things a the top of each pages.\', 1), (15, \'extraRight\', \'Extra actions on the product page (right column).\', NULL, 0), (16, \'deleteproduct\', \'Product deletion\', \'This hook is called when a product is deleted\', 0), (17, \'productfooter\', \'Product footer\', \'Add new blocks under the product description\', 1), (18, \'invoice\', \'Invoice\', \'Add blocks to invoice (order)\', 1), (19, \'updateOrderStatus\', \'Order\'\'s status update event\', \'Launch modules when the order\'\'s status of an order change.\', 0), (20, \'adminOrder\', \'Display in Back-Office, tab AdminOrder\', \'Launch modules when the tab AdminOrder is displayed on back-office.\', 0), (21, \'footer\', \'Footer\', \'Add block in footer\', 1), (22, \'PDFInvoice\', \'PDF Invoice\', \'Allow the display of extra informations into the PDF invoice\', 0), (23, \'adminCustomers\', \'Display in Back-Office, tab AdminCustomers\', \'Launch modules when the tab AdminCustomers is displayed on back-office.\', 0), (24, \'orderConfirmation\', \'Order confirmation page\', \'Called on order confirmation page\', 0), (25, \'createAccount\', \'Successful customer create account\', \'Called when new customer create account successfuled\', 0), (26, \'customerAccount\', \'Customer account page display in front office\', \'Display on page account of the customer\', 1), (27, \'orderSlip\', \'Called when a order slip is created\', \'Called when a quantity of one product change in an order.\', 0), (28, \'productTab\', \'Tabs on product page\', \'Called on order product page tabs\', 0), (29, \'productTabContent\', \'Content of tabs on product page\', \'Called on order product page tabs\', 0), (30, \'shoppingCart\', \'Shopping cart footer\', \'Display some specific informations on the shopping cart page\', 0), (31, \'createAccountForm\', \'Customer account creation form\', \'Display some information on the form to create a customer account\', 1), (32, \'AdminStatsModules\',\'Stats - Modules\', NULL, 1), (33, \'GraphEngine\',\'Graph Engines\', NULL, 0), (34, \'orderReturn\',\'Product returned\', NULL, 0), (35, \'productActions\', \'Product actions\', \'Put new action buttons on product page\', 1), (36, \'backOfficeHome\', \'Administration panel homepage\', NULL, 1), (37, \'GridEngine\',\'Grid Engines\', NULL, 0), (38, \'watermark\',\'Watermark\', NULL, 0), (39, \'cancelProduct\', \'Product cancelled\', \'This hook is called when you cancel a product in an order\', 0), (40, \'extraLeft\', \'Extra actions on the product page (left column).\', NULL, 0), (41, \'productOutOfStock\', \'Product out of stock\', \'Make action while product is out of stock\', 1), (42, \'updateProductAttribute\', \'Product attribute update\', NULL, 0), (43, \'extraCarrier\', \'Extra carrier (module mode)\', NULL, 0), (44, \'shoppingCartExtra\', \'Shopping cart extra button\', \'Display some specific informations\', 1), (45, \'search\', \'Search\', NULL, 0), (46, \'backBeforePayment\', \'Redirect in order process\', \'Redirect user to the module instead of displaying payment modules\', 0), (47, \'updateCarrier\', \'Carrier Update\', \'This hook is called when a carrier is updated\', 0), (48, \'postUpdateOrderStatus\', \'Post update of order status\', NULL, 0)'INSERT command denied to user \'newprodu_delytoe\'@\'localhost\' for table \'ps_hook\'(Error: : 1142) Link to comment Share on other sites More sharing options...
rocky Posted March 21, 2010 Share Posted March 21, 2010 It looks like the database user does not have permission to insert into the database. You need to edit the newprodu_delytoe@localhost user in your cPanel and give as many permissions as you can including INSERT. Link to comment Share on other sites More sharing options...
Dellytoe Posted March 21, 2010 Author Share Posted March 21, 2010 Thankyou for your info. i'll try it firts and return back the result asap. Link to comment Share on other sites More sharing options...
Dellytoe Posted March 22, 2010 Author Share Posted March 22, 2010 Thanks for your info. I’ve decided to delete all installed prestashop than reload again. I started from the beginning and installed satisfactorily. thanks.But between that installation guide I missed out the admin file. so I just copy the admin file only to the prestashop folder was installed. it worked ok. thanks a lot.Dellytoe Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now