chrometweaks.org

How do I access iPage homepages?

Click Here To View All Answers...


First question I have is How do I access iPage homepages? Looking forward for any answer or 2. Another question... I have used easy populate to upload 1000+ products to my site, this has now created about 90 manufacturers and 70 different catagories and sub catagories..

I would like to beable to enter a SQL command to update all the manufacturers and catagory images to a standard default setting without removing them all and doing it through easypopulate..

Does anyone know the database structure well enough to tell me which tables i'll need to update. I know the SQL code to use, just can't narrow down the tables easily and don't want to create any problems by changing the wrong fields..

Your help is appreciated..

If anyone wants to check the progress it's at www.jigsaw-computers.co.uk..

Comments (58)

Hmm... I need to find out myself. I don't know what is the right answer to your question. I'll do some research and get back to you if I discover an anything. You should email the people at iPage as they probably can help you..

Comment #1

Do you know where the sql databse is stored?.

I want to run SQL queries throguh excell and msquery, but it asks for an exact web address...

Comment #2

If you know the sql query, etc, then you should be able to find your database, it is listed in two places in your store...

Comment #3

I mustn't be feeling too clever today, all it is saying is localhost..

Comment #4

The database is located on your domain, whatever that may be....

Comment #5

I have used easy populate to upload 1000+ products to my site, this has now created about 90 manufacturers and 70 different catagories and sub catagories..

I would like to beable to enter a SQL command to update all the manufacturers and catagory images to a standard default setting without removing them all and doing it through easypopulate..

Does anyone know the database structure well enough to tell me which tables i'll need to update. I know the SQL code to use, just can't narrow down the tables easily and don't want to create any problems by changing the wrong fields..

Your help is appreciated..

If anyone wants to check the progress it's at www.jigsaw-computers.co.uk..

Comment #6

Backup before you do anything!!!!.

In MySQL, run this statement:.

UPDATE manufacturers SET `manufacturers_image` = 'XXX.gif';.

Then this one:.

UPDATE categories SET `categories_image` = 'XXX.gif';.

Replacing XXX.gif with the image name you want, of course..

Robert..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.