I recently followed advice found online to copy a store to a new domain, which will then be updated as needed. The problem is, although the config and admin/config files were updated with the new domain name as instructed, and the database name updated to another database, when trying to login to the new domain store admin using the correct username and password, updated and doubled checked in phpMyAdmin, it just keeps reloading the Admin Login page.
Can someone please suggest what might be the cause of this?
UPDATE:
Subsequent to the above, I gained some advice to make a full copy of the initial store folder via my host company, which I did. I then updated the two config.php files again, uploading with security settings at 444, and ensured the database name and prefix were changed too. I also tried using the database name and prefix of a second Database. Sadly, none of this made any difference and the admin is still not accessible. I also noted that images and extensions are missing on the homepage of the new (copied) store.
Not sure if it's relevant, but I have attached a copy of the error_log contents after viewing the site and attempting to log in to Admin.
Am I missing something?
Can someone please suggest what might be the cause of this?
UPDATE:
Subsequent to the above, I gained some advice to make a full copy of the initial store folder via my host company, which I did. I then updated the two config.php files again, uploading with security settings at 444, and ensured the database name and prefix were changed too. I also tried using the database name and prefix of a second Database. Sadly, none of this made any difference and the admin is still not accessible. I also noted that images and extensions are missing on the homepage of the new (copied) store.
Not sure if it's relevant, but I have attached a copy of the error_log contents after viewing the site and attempting to log in to Admin.
Am I missing something?
Attachments
Not sure if relevant, but here's a copy of the error_log contents
You are hopefully aware of the fact, that certain DB-Content is related to 'absolute' http;//-values, like:
I don't know, what are trying to do, by changing everything around,like valid DB-Prefixes !?
And why the database name and prefix were changed too, in the first place?
You better go to your Admin Server Console, and use the MySql-admin, to clear out all Table Content, before doing anything else, then, try again.
Good Luck
Ernie
PS: One more thing, what in the world is this??:
Code: Select all
customer_id`, `url`, `referer`, `date_added`) VALUES ('85.3.93.62', '0', 'http://www.hitline.info/shop/index
`date_added`, `date_modified`) VALUES ('1', '1', 'INV-2013-00', '0', 'Your Store', 'http://www.hitline.info/shop/', '1', '1', 'Benjamin', 'Jacob',
text-align: center;">\r\n\t<img alt="" src="http://images.openshop.li/shop/imag
The whole DB is full of such data, how do you expect such to function?I also tried using the database name and prefix of a second Database.
And why the database name and prefix were changed too, in the first place?
Code: Select all
oc_banner_image_description
INSERT INTO `oc_category`
INSERT INTO `oc_blog`
Good Luck
Ernie
PS: One more thing, what in the world is this??:
Code: Select all
1425730693: /home4/opticey1/public_html/buymythings/ssv3_installer_payload-nNZo9FzdJ0.php startup
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Hi Ernie, and thank you for the welcomed response.
Sadly, I was not aware of the points you raised, and in fact I assume the individual whom offered the initial instructions may have been unaware also. I simply followed the advice in good faith that a copied store will operate on another domain, using another Database (as per the instructions I was given). The reason the Database name and prefix were changed was purely again down to following instructions given.
Would it be possible to search and replace domain name references within a Database, or would you suggest creating a new blank Database? As you can tell, I am very novice in my understanding, but am learning as I go with input from good people like yourself.
Sadly, I was not aware of the points you raised, and in fact I assume the individual whom offered the initial instructions may have been unaware also. I simply followed the advice in good faith that a copied store will operate on another domain, using another Database (as per the instructions I was given). The reason the Database name and prefix were changed was purely again down to following instructions given.
Would it be possible to search and replace domain name references within a Database, or would you suggest creating a new blank Database? As you can tell, I am very novice in my understanding, but am learning as I go with input from good people like yourself.
> The reason the Database name and prefix were changed was purely again down to following instructions given. <
To COPY/PASTE- type install a working, and possibly enhanced, Copy of a Shop Software, technically PLACED on
the same Server, in a multi-domain Hosting-Contract, under a COMMON (virtual) Server Path,
such as:
one DOES NOT 'really' have to add another, new, DB, just to test a new Shop.
Therefore, one should leave the following config.php - Info, as it is:
and ONLY change ALL the PATH's, in BOTH config.php Files,
from, like i.E.:
to:
or:
ecetera......
As well as ALL the HREF-Links, change:
to:
or:
ecetera......
and so on, to test the newly implemented shop on one of those new URL's..
BUT LEAVING:
and:
as they have been in the working Shop/DB!
---
Regarding Database-Modification, if you use Notepad++ or another 'well done'
enhanced Code/Text-Editor, you could easy edit a DB, just, make another FULL backup first.
Just use Notepad to search for anything, related to old server Paths and/or href-links.
Image Links don't matter so much, if you use such, in contrary, remote image placement
is even used to speed up larger shops! You can find/replace as well with Notepad, but piece after piece,
just be very careful.
BUT always make sure, with Notepad++, to use the correct Page-Code: UTF-8, without BOM,
when playing/saving around with OC-Documents and 'written' Files. And in xx-tpl and xx.php Files, containing a
?>
as beeing last two Page Line Characters, NEVER leave an empty space, or even linebraek, open after the last character. Many ''whitespace-Error' problems have already been experienced, because of such a little dumb Gizmo-Thing.
Try to copy-export the entire DB into another DB File-Name, planned to be used by the new Shop,
on the Server, as described/visible below, by use of the MySQL Admin Tool. Then, you already
have your working DB, you then just have to delete the Table Content, so, all (former) Tables exist,
on the NEW DB in empty stage, and then, you upload/import your revised and cleaned out Backup-Version.
---
I tried to import a 'full' DB Back-UP into an empty DB, without Tables, and it did not work, that's,
why I had to try in different ways, possibly there is a 'default' way, to create ALL Tables directly from a Backup,
but I have not yet 'involved' myselfs to such DB-specific things...
Took my a few try's, but finally, it worked...
Good Luck
Ernie
hitline.info/os/
To COPY/PASTE- type install a working, and possibly enhanced, Copy of a Shop Software, technically PLACED on
the same Server, in a multi-domain Hosting-Contract, under a COMMON (virtual) Server Path,
such as:
Code: Select all
/home/servers/www/ipc_li/shop/
/home/servers/www/hitline_info/shop/
/home/servers/www/bigmax_ch/shop/
Therefore, one should leave the following config.php - Info, as it is:
Code: Select all
define('DB_HOSTNAME', 'ernesto.mysql.db.internal');
define('DB_USERNAME', 'ernesto_shop');
define('DB_PASSWORD', 'ernestopass');
define('DB_DATABASE', 'jacob_ch_ernestoshop');
from, like i.E.:
Code: Select all
define('DIR_APPLICATION', '/home/servers/www/ipc_li/shop/catalog/');
Code: Select all
define('DIR_APPLICATION', '/home/servers/www/hitline_info/shop/catalog/');
Code: Select all
define('DIR_APPLICATION', '/home/servers/www/bigmax_ch/shop/catalog/');
As well as ALL the HREF-Links, change:
Code: Select all
define('HTTP_SERVER', 'http://www.hitline.info/shop/');
Code: Select all
define('HTTP_SERVER', 'http://www.ipc.li/shop/');
Code: Select all
define('HTTP_SERVER', 'http://www.bigmax.ch/shop/');
and so on, to test the newly implemented shop on one of those new URL's..
BUT LEAVING:
Code: Select all
define('DB_DRIVER', 'mysqli');
Code: Select all
define('DB_PREFIX', 'oc_');
---
Regarding Database-Modification, if you use Notepad++ or another 'well done'
enhanced Code/Text-Editor, you could easy edit a DB, just, make another FULL backup first.
Just use Notepad to search for anything, related to old server Paths and/or href-links.
Image Links don't matter so much, if you use such, in contrary, remote image placement
is even used to speed up larger shops! You can find/replace as well with Notepad, but piece after piece,
just be very careful.
BUT always make sure, with Notepad++, to use the correct Page-Code: UTF-8, without BOM,
when playing/saving around with OC-Documents and 'written' Files. And in xx-tpl and xx.php Files, containing a
?>
as beeing last two Page Line Characters, NEVER leave an empty space, or even linebraek, open after the last character. Many ''whitespace-Error' problems have already been experienced, because of such a little dumb Gizmo-Thing.

Try to copy-export the entire DB into another DB File-Name, planned to be used by the new Shop,
on the Server, as described/visible below, by use of the MySQL Admin Tool. Then, you already
have your working DB, you then just have to delete the Table Content, so, all (former) Tables exist,
on the NEW DB in empty stage, and then, you upload/import your revised and cleaned out Backup-Version.
---
I tried to import a 'full' DB Back-UP into an empty DB, without Tables, and it did not work, that's,
why I had to try in different ways, possibly there is a 'default' way, to create ALL Tables directly from a Backup,
but I have not yet 'involved' myselfs to such DB-specific things...
Took my a few try's, but finally, it worked...

Good Luck

Ernie
hitline.info/os/
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
I decided to bite the bullet and try the copy process again, and for some unknown reason, this time I have access to the copied store, which I can now alter within Admin. I have no idea what happened as I followed the initial process exactly to the letter, but there we have it, success!
Thank you for your assistance, which is very much appreciated.
Thank you for your assistance, which is very much appreciated.
Who is online
Users browsing this forum: Majestic-12 [Bot] and 10 guests