Update Failure

Tim,  I tried to update the site to the current version and it crashed again.  Last time you help me fix it.  Something about unable to create a folder?

I can't get into my sytist admin now, so kind of a major problem currently.

Please Help!!  

- I have been trying to upload greenscreen backgounds and that hasn't been working.  Maybe related?

Thanks for your help!

Like your previous issue, the issue is your database is not letting it add more rows to the ms_language table and making the admin not load. 

Last time not a big deal, but this time it needs to be fixed.

This issue does not exist with any other installation, specific to your host.

The error message;  PHP Fatal error: Uncaught mysqli_sql_exception: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

What that means is you or your host will need to go into PHPMyAdmin and in the ms_language table change a lot of the fields (maybe about 20) that the type is VARCHAR to TEXT

Or see if your host can do something to increase the row size.

Once that is done, in the SQL tab in PHPMyAdmin, copy the following , paste it in the SQL section and click run: 

 ALTER TABLE `ms_language` ADD `_photos_selected_` TEXT NOT NULL;
UPDATE ms_language SET _photos_selected_='Photos Selected';
ALTER TABLE `ms_language` ADD `_removed_from_cart_` TEXT NOT NULL;
UPDATE ms_language SET _removed_from_cart_='has been removed from your shopping cart.';
ALTER TABLE `ms_language` ADD `_photo_added_to_package_` TEXT NOT NULL,  ADD `_photo_removed_from_package_` TEXT NOT NULL,  ADD `_remove_photo_from_all_products_` TEXT NOT NULL, ADD `_remove_photo_confirm_` TEXT NOT NULL ;
UPDATE ms_language SET _photo_added_to_package_='Photo added', _photo_removed_from_package_='Photo removed', _remove_photo_from_all_products_='Remove this photo from all products', _remove_photo_confirm_='Are you sure you want to remove this photo? ' ;
ALTER TABLE `ms_language` ADD `_photo_already_selected_as_download_` TEXT NOT NULL,  ADD `_photo_already_selected_` TEXT NOT NULL,  ADD `_select_photo_to_add_to_package_` TEXT NOT NULL;
UPDATE `ms_language` SET _photo_already_selected_as_download_='You already have this photo selected as a download.', _photo_already_selected_='You have already selected this photo',  _select_photo_to_add_to_package_='Please click/tap a photo to view then add it to your collection.';
ALTER TABLE `ms_language` ADD `_purchase_collection_extra_photos_` TEXT NOT NULL,  ADD `_purchase_collection_extra_photos_description_` TEXT NOT NULL;
UPDATE `ms_language` SET _purchase_collection_extra_photos_='Purchase Extra Photos For This Collection';
UPDATE ms_language SET _redemm_print_credit_add_photos_='Now when viewing your photos you will see the option to add photos at the bottom of the screen.'; 
UPDATE ms_photo_setup SET upload_type='';
ALTER TABLE `ms_language` ADD `_collection_no_extra_photos_` TEXT NOT NULL;
UPDATE ms_language SET _collection_no_extra_photos_='Sorry, there are no extra products available for this photo. You will need to use a photo that has already been selected for this collection.';
UPDATE ms_settings  SET sytist_version='4.7.3';

OK.  I have a message into the host.  Am I able to roll back the update so I can get into the admin page?  Is there anything I can do for a quick fix until the host helps me out which might be too long?  I don't think I have much access to the internal workings of the ms_language with the host. 

At this point, I'm kind of afraid to reset from a back up point because I might have new orders.

Thanks for your help and and suggestions you have.

Jeremy

Tim,  I am actually in PHPmyadmin and can see the ms_language table.  

I don't know really what to do, but if you have a second to help me, can we jump a quick DM or call?

Thanks, Jeremy

I am actually out of town until the middle of next week so I can't help you until then.

Tim,  When you are available,  myself and my host have some questions.  We have increased the row size and it crashed the database.  Now I can't access the admin panel of the site nor does the site work.  We were taking orders, payments were getting processed and now we are digging through the database trying to find things.  Way over my head.

But the big question is to safely restore and safely fix the underlying issue with the rows or VARCHAR to TEXT 

S.O.S. -when you are back in town.

Thanks, Jeremy

You will need to email me the link and login information for your HOSTING control panel.