Advanced Search

Return to Snippet

Revision: 40285
at January 28, 2011 20:54 by JustMadMike
Initial Code 
SET FOREIGN_KEY_CHECKS = 0;
UPDATE `core_store` SET `store_id` = 0 WHERE `code` like 'admin';
UPDATE `core_website` SET `website_id` = 0 WHERE `code` like 'admin';
UPDATE `customer_group` SET `customer_group_id` = 0 WHERE `customer_group_code` like 'NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS = 1;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
After transferring a magento databse or restoring one, you'll most likely have to run this code to correct a few IDs that change automaticly.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Magento - Update admin IDs after DB Transfer

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
magento

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL