raelrigs Posted August 9, 2010 Posted August 9, 2010 Hi there, i am looking to employ some one to help me with this problem. i am trying to install This Package from the addon section http://addons.oscommerce.com/info/1279. i have come to the end of my ability and would like to pay some one to finnish this off. the part i am having problems with is mergeing the database from the zip file with my shop database. anyone who thinks they can do this please contact me with a quotation for the above. you can PM me your details and i will be in touch. i would like this done very soon. my shop is live. Ray.
artful Posted August 9, 2010 Posted August 9, 2010 Hi there, i am looking to employ some one to help me with this problem. i am trying to install This Package from the addon section http://addons.oscommerce.com/info/1279. i have come to the end of my ability and would like to pay some one to finnish this off. the part i am having problems with is mergeing the database from the zip file with my shop database. anyone who thinks they can do this please contact me with a quotation for the above. you can PM me your details and i will be in touch. i would like this done very soon. my shop is live. Ray. Hello Ray, If you are using Oscommerce it is easy to add a contribution to your database : First backup your database : go to admin and under Tools you have backup. Do it and the by clicking on the left side of the newly made backup file you can download a copy to your computer for safety sake Then go to the FCK add-on sql file - copy it, open your database, click on the database name to show the files in the right hand side and on the tabs above those files you will see "SQL". Click that tab and paste youe sql from the add-on in the window and then hit the button to execute the sql and your database is updated for the contribution! If you need more help let me knwo. Barbara
raelrigs Posted August 9, 2010 Author Posted August 9, 2010 Hello Ray, If you are using Oscommerce it is easy to add a contribution to your database : First backup your database : go to admin and under Tools you have backup. Do it and the by clicking on the left side of the newly made backup file you can download a copy to your computer for safety sake Then go to the FCK add-on sql file - copy it, open your database, click on the database name to show the files in the right hand side and on the tabs above those files you will see "SQL". Click that tab and paste youe sql from the add-on in the window and then hit the button to execute the sql and your database is updated for the contribution! If you need more help let me knwo. Barbara Hi Barbara. Every time i try an load this file either via import or the above method i get this back Error SQL query: INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '112', 'WYSIWYG Editor 1.6', 'HTMLArea 1.6 Options', '15', '1' ); MySQL said: #1062 - Duplicate entry '112' for key 1 i understand there is a duplicate entry. i just dont know enough about sql databases to fix it without breaking somthing. i was told to change key 1 to somthing else but i would not know how to do that. any help? would be apreciated. am not above paying for this to be done for me. i think i would rather a pro do the job for me. can you do that for me if i provide all the details for my database.
raelrigs Posted August 10, 2010 Author Posted August 10, 2010 Hi Barbara. Every time i try an load this file either via import or the above method i get this back Error SQL query: INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '112', 'WYSIWYG Editor 1.6', 'HTMLArea 1.6 Options', '15', '1' ); MySQL said: #1062 - Duplicate entry '112' for key 1 i understand there is a duplicate entry. i just dont know enough about sql databases to fix it without breaking somthing. i was told to change key 1 to somthing else but i would not know how to do that. any help? would be apreciated. am not above paying for this to be done for me. i think i would rather a pro do the job for me. can you do that for me if i provide all the details for my database. Its ok. i have done it. im amazed with my learning ability. Thanks for your help
artful Posted August 10, 2010 Posted August 10, 2010 Its ok. i have done it. im amazed with my learning ability. Thanks for your help Sorry Rael, With a thunderstorm I had to shut down and could not answer, but congratulations on figuring it out! In the future when you have a sql statement to add, always compare the configuration_group number in the add-on with the ones in your database before installing. Sometimes the number is already taken by something else, sometimes you have already run the code without realizing it. A simple verification will help avoid errors as for example if your sql overwrites something valuable you will be up the creek! Just be sure to always backup first before changing the database. Barbara
Recommended Posts
Archived
This topic is now archived and is closed to further replies.