Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Need Help


raelrigs

Recommended Posts

Posted

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.

Posted

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

Posted

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.

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...