Data not updating in Single section editors

3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 6, 2016   (RSS)

By mattbcd - January 5, 2016

Hi. I have an issue with single section editors in a new installation of CMSB.  I've never had this issue before, so it's confusing.

When I enter data and click save, the data definitely saves the first time (I get the 'record saved' dialog) but all the fields in the editor show as blank.  

Also, only the first set of data saved shows up - if I change the data in the fields, the MySQL Table count goes up by one increment, but the live content doesn't change.

Any idea what's going on? It's an identical install to what I've used before.

The dump from the Server info section is below, and I'm using Chrome v.47 (though it does the same in Firefox and in Safari)

---------------

Operating System Linux 2.6.32-573.8.1.el6.x86_64 (x86_64) Web Server Apache PHP Version PHP v5.6.16 - phpinfo >>

  • View PHP Error log >>
  • PHP is running as user:
  • PHP disabled functions: syslog, openlog, highlight_file, show_source, proc_nice, posix_kill, posix_mkfifo, posix_mknod, posix_setegid, posix_seteuid, posix_setpgid, posix_setsid, posix_setuid, posix_setgid, pfsockopen, pcntl_setpriority
  • php.ini path: /etc/php56/php.ini
  • Suhosin Detected: No

 Database Server MySQL v5.5.45 (Max Connections: 32) 

---------------

Thanks!

By ross - January 6, 2016

Hi everyone.

Matt and I got this one figured out and this post is and update for anyone else following along.

The issue we ran into is that the MySQL server for Matt's site had its auto_increment settings set at 2:

auto_increment_increment  => 2
auto_increment_offset => 2

Both these values need to be set to 1.  If you run into this issue, contact your host and ask them to make sure both these settings are "1".  

Note: you want to make sure the setting is made at the server level instead of just updating a table manually.  This way, all tables are created with the correct setting instead of you manually needing to update them individually.

Let me know any questions.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/