Installation problems

[gifted]

Hi,

I am trying to copy a test site to a new server, but I am having a few problems. I have followed all of the installation instructions but I am getting the following message on the site

1054 Unknown column 'CATEGORIES_ROOT' in 'where clause'
in:
[select cd.categories_name from categories c, categories_description cd where cd.categories_description LIKE '%-SITE_NAME-%' AND cd.language_id=1 AND c.parent_id = CATEGORIES_ROOT and c.categories_id = cd.categories_id and cd.language_id='1' and c.categories_status=1]

and I get the following messages in admin

Fatal error: Unable to read 108695 bytes in /var/www/vhosts/gadjits.com.au/httpdocs/catalog/includes/m1_export_main.php on line 1

can anyone help?

[kobra]

What version are you installing?
What are you server details?

[gifted]

Hi Kobra,

Thanks for your reply.

I am installing version 1.3.8a
Server details are as follows:

PHP Version 5.2.8
MySQL Version 5.0.45
OS Version CentOS 5 Linux 64-Bit
Plesk Version 8.6

[kobra]

PHP Version 5.2.8
MySQL Version 5.0.45
OS Version CentOS 5 Linux 64-Bit
Plesk Version 8.6

You are posting in the Windows Server area but stating that your server is running Centos which is a Linux OS

I am trying to copy a test site to a new server, but I am having a few problems. I have followed all of the installation instructions

Might outline what and how you have approached this Copy
What Zen ver was being copied?
New server is running 1.3.8a - was this installed first then test site copied to it?
Guess just outline what you have done

m1_export_main.php is not a default distribution file
List the addons you have installed also

[gifted]

You are posting in the Windows Server area but stating that your server is running Centos which is a Linux OS

Might outline what and how you have approached this Copy
What Zen ver was being copied?
New server is running 1.3.8a - was this installed first then test site copied to it?
Guess just outline what you have done

m1_export_main.php is not a default distribution file
List the addons you have installed also

Oops, my bad!

Installed fresh version of 1.3.8a on new server
Created backup of old database.
Copied old files and uploaded to new server
Created new database on new server
Installed Zen Cart on new server
copied old database to new database
edited configure.php files
then synched cache settings

I think that was it!

Mods I have installed on old server are:
Super Orders
Better Together
Recover Cart Sales
Monthly Sales & Tax Summary
Edit Orders
Reward Points - Full Suite
Confirm Email Address Entry
Image Handler 2
Supertracker
SEO URLs
MSRP
Multisite Tools
Magnetic One Export Tools

Not sure if I have missed any there.

[kobra]

Installed fresh version of 1.3.8a on new server
Created backup of old database.
Copied old files and uploaded to new server
Created new database on new server
Installed Zen Cart on new server

What are you using the "old" files for?
What set did you install from?

What was the old version?

[gifted]

the old files where the files i copied from the old server, as all i am trying to do is create an test site.
the old version was 1.3.8a, just on a different server.

Sorry not sure what you mean by "What set did you install from?"

[kobra]

I have followed all of the installation instructions but I am getting the following message on the site
Sorry not sure what you mean by "What set did you install from?"

If following the instructions - you would have downloaded a fresh distribution and installed from those files....
If this is what you did then I again ask what are you using the old files for?
The error you are getting is due to some procedure looking for some DB record and not finding it

[gifted]

Sorry if I seem a bit vague, I simply followed the instructions shown here https://www.zen-cart.com/tutorials/index.php?article=99

The "old files" are the files referred to in step 3 of the tutorial. If I want a copy of my site to use as a test site surely I will need an almost identical setup I have on my other server?