database export/import problem

Author	« Topic »
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 10/16/2020 : 04:25:14 Hi I'm trying to move a clients website to another hosting company but when I try to re-instate the orders table I get the following error: ERROR 1118 (42000) at line 31: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. Thanks Eric
quadrant Ecommerce Template Guru United Kingdom 1099 Posts	Posted - 10/16/2020 : 05:56:29 Hi Eric, Do you have cPanel installed on both servers? If so I would use the transfer function which I have used a few times before and it basically clones the whole site onto a different server. Once you have tested the new setup to ensure everything is running correctly you can simply change the domains DNS to point to the new address. Regards, David
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 10/16/2020 : 06:05:53 Thanks David Unfortunately cPanel is only on one server. But after Googling the error I changed the structure of some of the columns, which would only have short strings in them from varchar 255 to text and that seems to have worked - I'm just about to find out! Eric Edited by - quantum503 on 10/16/2020 06:28:33
Vince Administrator 42465 Posts	Posted - 10/16/2020 : 11:58:33 Hi Eric I'm not sure what version they are on but we made some changes to the latest updaters so this shouldn't happen now. Is running the updatestore.php script a possibility? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 10/19/2020 : 00:50:39 Hi Vince They are on Ecommerce Plus PHP v7.2.3 I'm not exactly sure what the very latest version is. If I run the updater again now, is it likely to undo the changes that I made to the column type, or would it fail in any way? Eric
Vince Administrator 42465 Posts	Posted - 10/19/2020 : 00:56:13 Hi Eric v7.2.3 should already have the changes for this but another way around would be to just not use InnoDB as the database structure. Do you have access to phpMyAdmin for the site and can you change this? Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
quantum503 Advanced Member United Kingdom 230 Posts Pre-sales questions only (More Details...)	Posted - 10/19/2020 : 02:28:54 Hi Vince I have phpMyAdmin but I don't seem to have access to change the database structure. The columns that I changed from varchar to text are ordExtra1, ordExtra2, ordShipExtra1, ordShipExtra2, ordCheckoutExtra1 and ordCheckoutExtra2. Are you saying that this will prevent me running an updtate script in future? Eric
Vince Administrator 42465 Posts	Posted - 10/19/2020 : 02:54:32 Hi Eric No, that should be fine actually and if you're happy with that change, all is good. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
	« Topic »