1.5.6 ezpages split table structure

[welshop.com]

Testing new install of 1.5.6 - database upgrade worked fine but noted that easypage data from 1.5.1 was missing.

Checked 1.5.6 database tables and there are now two tables that relate to ezpages - ezpages & ezpages_content whereas 1.5.1 only has a single table for ezpages.

So it seems the Database upgrade did not split populate the tables - is this something that has to be done manually?

Cheers
Brinley

[mc12345678]

The upgrade process looks to copy over/move the ezpages content that is to be removed. The sql is:

INSERT IGNORE INTO ezpages_content (pages_id, languages_id, pages_title, pages_html_text)
SELECT e.pages_id, l.languages_id, e.pages_title, e.pages_html_text
FROM ezpages e
LEFT JOIN languages l ON 1;

What does the install log(s) say about executing this operation if anything? Note that may need to do the database upgrade again on the backup copy of the older database to generate the log(s) now that the admin has been accessed.

[DrByte]

When the database-upgrade steps works properly (evidently it didn't with yours), it correctly creates the associated multi-language table, and moves the necessary data into that table, leaving it fully functional.

I've no idea why yours didn't do that. And if it skipped those particular SQL upgrade steps, then it probably skipped several dozen others too.

[welshop.com]

The DB upgrade didn't come back with any errors when it ran and I'm haven't looked yet to determine whether there are any other table issues.

Is there an easy way to compare tables in 2 databases?

[mc12345678]

The DB upgrade didn't come back with any errors when it ran and I'm haven't looked yet to determine whether there are any other table issues.

Is there an easy way to compare tables in 2 databases?

When you say "no errors" do you mean on screen no errors were provided or that there were no debug logs generated or both?

Export both databases as a csv file, as necessary in the export change the table prefix to be the same in both, use your favorite text comparison utility to compare the two files. Win Merge, Beyond Compare, etc...

[welshop.com]

No errors on front end - but will run the install on the old database again to see what errors it brings up.
Will also do the csv compare.

It will be tomorrow now as have a house full soon.

[welshop.com]

Created a test db and upgraded - log files came back with this
[26-Dec-2018 11:50:36 Europe/London] PHP Fatal error: 1146:Table 'brinleyw_156_db_test.zen_ezpages_content' doesn't exist :: SELECT e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.toc_chapter, ec.pages_title

[welshop.com]

Full error

[26-Dec-2018 11:50:39 Europe/London] Request URI: /, IP address: 1.111.111.11
#1 trigger_error() called at [/home/*****/luckiespuppy.co.uk/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/*****/luckiespuppy.co.uk/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/*****/luckiespuppy.co.uk/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/*****/luckiespuppy.co.uk/includes/modules/ezpages_bar_header.php:28]
#5 include(/home/*****/luckiespuppy.co.uk/includes/modules/ezpages_bar_header.php) called at [/home/*****/luckiespuppy.co.uk/includes/templates/template_default/templates/tpl_ezpages_bar_header.php:17]
#6 require(/home/*****/luckiespuppy.co.uk/includes/templates/template_default/templates/tpl_ezpages_bar_header.php) called at [/home/*****/luckiespuppy.co.uk/includes/templates/template_default/common/tpl_header.php:102]
#7 require(/home/*****/luckiespuppy.co.uk/includes/templates/template_default/common/tpl_header.php) called at [/home/*****/luckiespuppy.co.uk/includes/templates/template_default/common/tpl_main_page.php:84]
#8 require(/home/*****/luckiespuppy.co.uk/includes/templates/template_default/common/tpl_main_page.php) called at [/home/*****/luckiespuppy.co.uk/index.php:97]
[26-Dec-2018 11:50:39 Europe/London] PHP Fatal error: 1146:Table '*****_156_db_test.zen_ezpages_content' doesn't exist :: SELECT e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.toc_chapter, ec.pages_title
FROM zen_ezpages e, zen_ezpages_content ec
WHERE e.pages_id = ec.pages_id
AND ec.languages_id = 1
AND e.status_header = 1
AND e.header_sort_order > 0
ORDER BY e.header_sort_order, ec.pages_title ==> (as called by) /home/*****lluckiespuppy.co.uk/includes/modules/ezpages_bar_header.php on line 28 <== in /home/*****/luckiespuppy.co.uk/includes/classes/db/mysql/query_factory.php on line 171

[JNR345]

This looks similar to the issue I'm having, 1.5.6 upgrade said it was successful but it didn't add the tables or data. Still don't know how to fix this.

[mc12345678]

Those are the logs generated by accessing the site. What about the logs generated by performing the install/upgrade? Some/most of these get deleted (from what I've read from DrByte) once the admin is accessed.

The logs above also further agree with the results some others have seen.

What php version is being used?
What mysql version is being used?
If/when you do access the admin, please go to the version link at the top, and paste in here the information provided below the admin menu and up to and including the database version history.