Mailing List Archive: Interchange: users

moving files to remote server, no root access

Index | Next | Previous | View Threaded

kerry at basicq

Jun 16, 2009, 6:28 AM

Post #1 of 3 (618 views)
Permalink

moving files to remote server, no root access

I moved files from my test server at home to the remote server I am using
to host the cart I am building. I had added many new fields to pricing and
a couple to products. I can access the tables from admin on the remote
server but I cannot see the new fields in the tables. I changed
pricing.mysql, adding the new fields in the table. I then deleted
pricing.sql and logged off and back on. This was what I could find on the
mailing list for instructions. Another thing I found in admin
administration is that the mysql database listed is from my test server as
are the directory and catalog name, and server name. Not sure how these
populated on the transfer or import function I used. Is there anyway short
of restarting mysql to get the new fields to show in the database?

Kerry

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Jun 16, 2009, 6:35 AM

Post #2 of 3 (570 views)
Permalink

Re: moving files to remote server, no root access [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of kerry [at] basicq
> Sent: Tuesday, June 16, 2009 4:29 PM
> To: interchange-users [at] icdevgroup
> Subject: [ic] moving files to remote server, no root access
>
> I moved files from my test server at home to the remote server I am
> using
> to host the cart I am building. I had added many new fields to pricing
> and
> a couple to products. I can access the tables from admin on the remote
> server but I cannot see the new fields in the tables. I changed
> pricing.mysql, adding the new fields in the table. I then deleted
> pricing.sql and logged off and back on. This was what I could find on
> the
> mailing list for instructions. Another thing I found in admin
> administration is that the mysql database listed is from my test server
> as
> are the directory and catalog name, and server name. Not sure how these
> populated on the transfer or import function I used. Is there anyway
> short
> of restarting mysql to get the new fields to show in the database?

Have you looked at your variables:
SQLDSN
SQLUSER
SQLPASS

to make sure they are correct on the remote server?

Also what do you mean with 'logged off and back on' ?
Does that mean you restarted Interchange?

Seeing other things that appear to be the same, again check your variables
(usually in products/variable.txt) to see if anything is on your local
server that should be changed to be used for the remote server.

What usually is done is the introduction of a products/site.txt which
contains things such as the SQLDSN and other variables that are different on
production servers compared to staging / development servers. Then when you
deploy you skip the site.txt file.

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Jun 16, 2009, 6:57 AM

Post #3 of 3 (558 views)
Permalink

Re: moving files to remote server, no root access [In reply to]

On 06/16/2009 06:28 AM, kerry [at] basicq wrote:
> I moved files from my test server at home to the remote server I am using
> to host the cart I am building. I had added many new fields to pricing and
> a couple to products. I can access the tables from admin on the remote
> server but I cannot see the new fields in the tables. I changed
> pricing.mysql, adding the new fields in the table. I then deleted
> pricing.sql and logged off and back on. This was what I could find on the
> mailing list for instructions. Another thing I found in admin
> administration is that the mysql database listed is from my test server as
> are the directory and catalog name, and server name. Not sure how these
> populated on the transfer or import function I used. Is there anyway short
> of restarting mysql to get the new fields to show in the database?

"Apply Changes" link in the Admin UI should do it.

Restarting the database won't help

Restarting IC will also pull in the changes, but Apply Changes should
work if you can't restart IC.

Also since you deleted pricing.sql it will actually drop the tables you
just changed and re-create them with the new fields and existing data.
This is usually not the behavior you want and if you don't want the
tables to be dropped and re-created then you should replace the .sql
files. Also if you *never* want IC to drop and re-create your tables
then it is a good idea to add the following line to your catalog.cfg file:

NoImportExternal Yes

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads