View Full Version : eror conencting to database (locally)
astoller
15-Apr-2010, 07:44 PM
Hi
I just put up a test site in the test area and it worked ok online
But when i go to refresh the live site i am now getting connecting to database errors on my local computer
eg problem with database
operation : opening the setup table etc
any ideas?
thanks
art
Duncan Rounding
15-Apr-2010, 07:59 PM
Some questions may help diagnose what to do...
Do you mean you uploaded in test mode or did you upload to another webspace to test?
ie how did you transfer the site from the test area to the live site?
Is it on another computer or did you licence another site?
Did you create a snapshot to import into the live site database?
astoller
15-Apr-2010, 09:15 PM
I uploaded to the test area using test mode,
to the one and only site.yes.
I did not create a snapshot
astoller
15-Apr-2010, 09:21 PM
It seems to be a local problem on my computer. I cannot do a test network because actinic cannot find the connection, i cannot edit business settings etc etc
peblaco
15-Apr-2010, 10:34 PM
The message "operation : opening the setup table etc" sounds like a database problem. You haven't put the full message, but see this thread (http://community.actinic.com/showthread.php?t=43244) for some ideas for a similar error.
When you say put up a test site, is this an existing site that needs correction or a new blank site you are testing with?.
astoller
15-Apr-2010, 11:33 PM
It is an existing site which i am trying to upgrade to the latest version.
peblaco
16-Apr-2010, 07:08 AM
It is an existing site which i am trying to upgrade to the latest version.
What is the full error message?. The Housekeeping > Compact Databases menu sometimes works for small database issues, but this one if the full message is not the same as the other thread I linked to, could be something that needs repairing by Actinic support.
astoller
16-Apr-2010, 09:24 AM
Refreshed site and it ran ok but stopped at
merging files on server.
And said "the parameter is incorrect"
When visitng the shop and trying to click through to a product
this is what appears in browser:
A Series of hashes
http://www.onlineshop.co.uk/################ss000001.pl?SECTIONID=Jewellery_Displays.html&NOLOGIN=1
peblaco
16-Apr-2010, 10:30 AM
Refreshed site and it ran ok but stopped at
merging files on server.
And said "the parameter is incorrect"
Hi Arthur, Try these: Do the Web > Network settings past the test okay?. Are you using Enhanced FTP on that window?. Have you tried compacting the database? (Housekeeping menu > Compact databases > tick both > OK). However post 9 here: http://community.actinic.com/showthread.php?t=37741 points again to it possibly being a database error.
astoller
16-Apr-2010, 10:42 AM
There were 2 problems which you helped me solve.
Compacting the db fixed that one up.
The other was that i usually connect via ftp on an ip number rather than the domain name
Your link to another thread reminded me of that too
So now its working.
Thanks you for your help
arthur
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.