Hi, I'm using stager to my new project and I find some error on data copy from query:
INSERT INTO destination_name SELECT * FROM source_name

Afeter some debug I find that the original and stager generate tables have the same structre, but with field into different order. This causate some error on data transfer from the tables, and system stop data copy and the system crash.

CommentFileSizeAuthor
#1 stager_error_in_data_copy-1269074-1.patch2.93 KBmavimo

Comments

mavimo’s picture

mavimo commented
StatusFileSize
new stager_error_in_data_copy-1269074-1.patch2.93 KB

Patch into attachment.

This patch:

  1. Copy table data using field from table schema definition to fix error defined above
  2. Generate a function to centralize check on required table sync
  3. Add capabilities to NOT synck backk (from stage to production) some table, specified into stager_ignore_tables variable (that variable contain array off table to exclude). This variable can be set on settings.php file, exapmle:
    $conf['stager_ignore_tables'] = array(
  'webform_submissions',
  'webform_submitted_data',
);

TO-DO:

  1. Improve doc to describe this feature.
swentel’s picture

swentel commented
Status: Active » Fixed

Wow, thanks! Committed and pushed. Also added some info into README.txt with information about the stager_ignore_tables variable.
Once your 2 issues are set to closed by d.o itself, I'll push out a new release. Thanks!

mavimo’s picture

mavimo commented

Thanks to add docs

swentel’s picture

swentel commented
Status: Fixed » Closed (cannot reproduce)

Pushed out a new release.

swentel’s picture

swentel commented
Status: Closed (cannot reproduce) » Closed (fixed)

Euh, better status