chrometweaks.org

Do any of you had a bad experience with iPage Hosting?

Click Here To View All Answers...


Quick question: Do any of you had a bad experience with iPage Hosting? Hoping for any response. Second question.. Nothing against my host, but they kinda screwed me.....

I tried to install the centershop contribution & got some errors, well they made some modifications to to the sql file & now I can't seem to find the tables that they had me insert..

How do I drop them? That's all I want! LOL!!!..

Comments (10)

That's a good question. I'm not sure what is the right answer to your question. I'll do some Googling and get back to you if I discover an answer. You should email the people at iPage as they probably can help you..

Comment #1

So there's no way that I can just add the tables that they had given me & add the word drop or something like that?..

Comment #2

Yea.

DROP TABLE 'table_name'.

I thought you didnt know what tables you were looking for?.

-Dennis.

This post has been edited by.

Dblake.

: 12 October 2004, 20:37..

Comment #3

So you want to add the tables then drop them.........you've lost me...

Comment #4

To figure out what tables do and dont exist, you can run a query like:.

USE 'database';.

SHOW tables;.

Once you figure out what you do or dont need, you can use the DROP TABLE syntax as posted above or use the CREATE TABLE if you need to add tables...

Comment #5

Basically, my host was having me test things & once they decided that it wasn't going to work, they told me that I was on my own..

I have the SQL file and I'm trying to figure a way out that I can find the stuff that's in there to drop the appropriate tables..

Make any sense?..

Comment #6

Do you mean drop information into the appropriate tables ?

Comment #7

Basically, I'm looking to remove these.

INSERT INTO configuration_group VALUES (16, 'Center Shop', 'Center Shop Module Integration', 16, 1);.

INSERT INTO configuration VALUES (200, 'Center Shop on/off', 'CENTER_SHOP_ON', 'on', 'Turn on/off CenterShop.', 16, 1, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, 'tep_cfg_select_option(array(\'on\', \'off\'),');.

INSERT INTO configuration VALUES (201, 'Shop width', 'CENTER_SHOP_WIDTH', '760', 'Shop Width.', 16, 2, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (202, 'Padding outside of shop.', 'CENTER_SHOP_PADDING', '10', 'Table Cellpadding', 16, 3, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (203, 'Outer background color.', 'CENTER_SHOP_BACKGROUND_COLOR_OUT', 'DFDFDF', 'Outer background color.', 16, 4, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (204, 'Border thickness.', 'CENTER_SHOP_BORDER', '1', 'Border thickness.', 16, 5, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (205, 'Border Color.', 'CENTER_SHOP_BORDERCOLOR', '000000', 'Border Color.', 16, 6, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (206, 'Thickness of cell walls', 'CENTER_SHOP_CELLSPACING', '0', 'cellspacing', 16, 7, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (207, 'Padding inside of cells.', 'CENTER_SHOP_CELLPADDING', '5', 'cellpadding', 16, 8, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

INSERT INTO configuration VALUES (208, 'Background color on/off', 'CENTER_SHOP_BACKGROUND_ON', 'on', 'Use Backgroundcolor?', 16, 9, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, 'tep_cfg_select_option(array(\'on\', \'off\'),');.

INSERT INTO configuration VALUES (209, 'Color between border & shop.', 'CENTER_SHOP_BACKGROUND_COLOR', 'FFFFFF', 'Cellpadding Color', 16, 10, '2004-02-25 14:34:58', '2004-02-25 14:34:58', NULL, NULL);.

Make sense?..

Comment #8

Ahh, those aren't tables, those are record. If you've removed the rest of the contribtuion, then these wont hurt anything..

If you *have* to remove them, you can use phpmyadmin to 'browse' the table, search for those records, and delete them..

Let us know if you still need further assistance...

Comment #9

Ah, ok... So if I want to try to do a fresh install of that particular contribution, I should be able to do it without any problems?..

Comment #10

As long as the SQL is the same as the SQL you already ran...

Comment #11


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