nbarber

does anyone know how to access the siteadmin area? what url do I use?

thanx

noobie to UH and very impressed so far

Nigel

silver

Have you tried http://www.domainname/admin ?

pursuit

unforutnately, on UH servers it has to be:

http://www.domainname/admin/index.php

unless you change the folder name of the osc admin to something else, ie, anything but admin.

nbarber

Thanx for those replies, support also appears to be as good as the forums here at UH.
However I am having the problem now that when I try to access the admin area I get this error

1146 - Table 'razamatazjewellery_co_uk_1stbase.administrators' doesn't exist

select id from administrators limit 1

[TEP STOP]

any further assistance would be much appreciated as I desperately need to get my site configured as my domain name has now propogated thru the network and I need to get the site up and running ASAP

Nigel

pursuit

you are probably using a new osc admin version but an old osc database - the administrator table is introduced only in the latest RC versions - a mismatch between admin file set and the database, something which is a bit strange. where you got your osc from and how you install it?

nbarber

the database I exported from was V5 using compatability mode and UH imported for me to there V4. However they have reinstalled site to a new database for me. I will just have to install products manually!

I love the support here they are so fast and helpful as are the forums

cheers for the help

pursuit

compatability mode? No, as far as osCommerce is concerned, no need to use any 'mode' at all. My local server is running mysql 5, I do this import/export between my server and UH server all the time and i never even think about it. there's never been a problem. depending on which host you exported it from sometime yo do need to choose the right character set when you import it or your £ will become a question mark but that is easy to fix - change it back in the currencies table (the order total table as well for all the old orders if you care).

install products manually?? again, why? you simply extract the products related tables (products, categories, products description, categories description, products to categories, and if you have product properties (options) then a few ( 3 or 4) products options tables, and maybe the two manufacturers tables if you use them. then you just drop these tables and run/import the extracted sqls. it wont take more than a few minutes.

by the sound of it, what you actually needed to do is get the administrator table from somewhere (with a known user name and password in it or you may get into an 'egg or chicken, which first' situation). I could actually post the sql here if needs be.

Vger

I think that what may have happened is that when the db was backed up one of the Compatibility modes was selected in phpMyAdmin, and then it does make a difference as to which version of MySQL it is re-installed on.

But if there are tables missing then the idea of adding products manually means using phpMyAdmin for everything - not really practicable.

Vger

__________________
Working with computers is a bit like getting old - the longer you're around the more wrinkles you find!