Copying one store to another

[themarcomgroup]

Been having trouble lately copying one store to another without running into errors.

 

Process: I have made multiple mod's to one of our stores, including mod'ing the mysql db with additional tables.

 

Now. Because some of these mod's required some chmod's and chown's, I tarballed the catalog/ dir using the perms switch and copied the tarball over to the new /home/user/public_html/ dir

 

I unzip the file and the catalog runs fine, obviously because the configure files havent been changed. I change the config files to point to the new users directories and db and go into mysql and dump the db from where I got the original user and create the new db with the additional table structure.

 

Here is where I run into issues. On the catalog and admin side I have received these two errors when viewing the site in my browser.

 

Fatal error: Failed opening required 'includes/languages/.php' (include_path='.:/usr/local/lib/php') in /usr/home/coreabstraction/public_html/catalog/admin/includes/application_top.php on line 210

 

now, line 210 in the app_top file is this line:

require(DIR_WS_LANGUAGES . $language . '.php');

 

I have tried multiple things with that issue. I have tried chmod'ing the dir and files in languages to all sorts of perms and I have tried chmod'ing the dir and files to the user and to nobody and a combo, still no luck. Now aside from the dumping of the db and creating and the config files, I have not made one single mod to any files regarding the catalog, so I do not see how this can happen

 

 

OR I get this issue

 

1064 - You have an error in your SQL syntax near 'MAX_RANDOM_SELECT_NEW' at line 1



select products_id, products_image, products_tax_class_id, products_price from products where products_status='1' order by products_date_added desc limit MAX_RANDOM_SELECT_NEW



[TEP STOP]

 

Obviously has to do with the DB I would imagine.

 

 

Any help or suggestions would be extremely grateful. I know I can just install a fresh copy of oscom and plug in the mods again, but when dealing with new clients on a daily basis, it would be a time saver if it could just be a simple copy, paste, mod two files and bam it's done.