Content pages can disappear

[junkyard]

There is a little scary bug in 1.1.6 (maybe 1.1.7 too?) related to saving Design/Content pages  ( SQL tables 'contents' and 'content_descriptions').
It happens this way.  Sometimes, when updating existing pages contents, occasionally you may have a field error related to certain field's validators like:
  Required Data has not been entered. Check for field errors!
  Content Title must be between 2 and 64 characters!
  Content must be more than 1 characters!
  etc..

So, you follow the instruction and modify the Title (or the Content, etc) properly and hit on Save... and after it says something like "Success: You have modified a page!", what you see is Content Manager blank, cause the page you were editing just disappeared from both Admin and Store altogether!

You start checking db and discover, the page is still present in the 'content_descriptions' and 'pages' and 'page_descriptions' tables, but  was wiped out from the 'contents'. You can insert into 'contents' values manually in mysql and you will be able to see the page but the bug is still there, and intermittently hampers editing pages deleting them  from 'contents'

Basically, when any error (be it the 64 characters Title limit; or Content > 1 character; or any other error like the Allowed memory size from http://forum.abantecart.com/index.php/topic,1285.0.html ) occurs, it somehow interrupts the page editing process in the Content Manager, drops the reference to 'contents' table stored in the memory, and after pressing on Save to the bottom it is gone.

[abantecart]

Content section was updated on 1.1.8. There is a big possibility that this issue is fixed.
If you can try it and see if you can get the same problem, would be awesome.

https://github.com/abantecart/abantecart-src/archive/1.1.8.zip

[junkyard]

Thanks for the sources!  We've checked the Content Manager files like
  core/lib/content_manager.php
  admin/controller/pages/design/content.php
and seeing a lot of changes indeed, but replacing these two files only appears potentially unsafe for trying over existing online content.
Since we are not yet ready for full 6->8 upgrade at this time, we'll wait till it can be arranged on our side after 1.1.8 release.
Will surely let you know if it gets fixed by that version.

[abantecart]

Well, it would helpful if we know ahead of time, before release. We still have time to fix the issue.

[junkyard]

Yeah, if only there was a way to update the Content Manager only.. We've got some customisations and cannot upgrade the system before we are ready.
Additionally, we used to carry out upgrades via the cart's Update Manager in the admin panel to track any possible errors,  as this is highly sensitive process!
Anyway, here's how the issue can be repeated easily on any abantecart installation:

1. Create any quick content page as usual, title and some content, save it.
2. Modify page's Title to be 65 characters, and attempt to save it with the "Save" button at the bottom of the page, to generate warning:
  Content Title must be between 2 and 64 characters!
It is important to use that specific button at bottom because the JQGrid's button near the Title would skip validator and save it ok regardless.
3. After you saw the red warning, correct the Title back to <=64 chars to comply, and once again press the "Save" at the bottom.
You should now have the page disappeared.

[eCommerce Core]

Thank you for steps to replicate.

See this fix in 1.1.8
You can copy these file now or wait for an update.
https://github.com/abantecart/abantecart-src/commit/4350cf327c86748aa242b1ea1ece74e298aae6f0

[junkyard]

Thanks a ton!!   We've integrated the change into our  admin/controller/pages/design/content.php  and it works great!

[abantecart]

Glad I can help