Printable View
Ok so I had my live store running and set up the separate demo and test sites, and things seemed to be going well then I went to upload my database back up to the new file and all of a sudden the live site stopped working. What am I doing wrong?! Is it because the new database is a copy of the live site database? Should I rename the backup copy before uploading it to the blank database?!:dontgetit:rant::censored:
You need to check your error logs.
No longer have them. I uploaded the back-ups which did not work.
Couple of things. From what version are you upgrading?
How was the database backup loaded to the new database? Did you use something like mysql backup that does the restoration from your admin?
Is the DB_PREFIX between the two sites the same?
Are the database's referenced by the two filesets different?
When you say that the live site stopped working, can you elaborate? Error messages received? Maintenance mode? Blank screen?
Which backups were loaded? Database? Files?
To be able to understand what was done wrong need to have detail of what was done, but really just want to get these two locations back to where they were so that sales can continue while further development is done on the new files.
I am attempting to upgrade from 1.5.5f to 1.5.6, to up load the db back up I have to import it into the new db via phpmyadmin. The prefix for both sites were the same. The live site went blank although, I was not working on it at all. I don't have a picture of how the site looked before, but this is how it looks now without all of the sideboxes and enhancements: http://atmospherebooks.com I used Filezilla to upload the back up files, after I reloaded all of the files I used the restore feature of my cpanel to upload the db download, but it still did not work so I deleted it and tried again.
You have managed to get a glitch in the code that creates the Useful Links option in the Information Menu.
All is rocking along until the browser tries to draw that UL. The code MIGHT be in the database. Not familiar with that menu system.
My guess is that the useful links are ez-pages. In Zen Cart 1.5.6 they became multi-lingual, and your template is still using the old ez-page query
Well, in my frustration I deleted all of the work I was doing on the demo site. I am waiting for my hosting company to restore backups from 12/14/18 when I was blissfully unaware of the 1.5.6 upgrade. In the mean while I will download zipped copy of my last good back up files and use those to try more file comparisons using WinMerge. I expected there would be problems with my template, but I did not think working in a new site would affect the present live site.
If everything really is kept separate, there is no way that the work in one would have an effect on the other. It's almost like maybe a backup copy of the new database got loaded to the old or there was a file reference that didn't get updated and some "wire" got crossed. I say that because even if the "recent" backup of the old site were loaded to the wrong place, it would operate fine in the old fileset and cause a notification in the new fileset.
Still can't tell exactly how file backups had anything to do with the issue because again, if the two sites were being maintained independent than there should be nothing to restore on the old site and the new site would just likely go back to non-merged files.
I wonder if I did it wrong. I was fighting with the new file system, I got to step 2 and made the new database, but when I imported the db back up files it did not add the prefix so I deleted and did the import again. This looked right so I went to the zc_install step and my password would not work so I started working on that part. Somewhere, I messed everything up.
Ok, so now that my site has been restored, the main page is still not working properly. I am happy to be able to get into my admin area again. I do not think they restored the database as the last test purchase I made on the 19th is still showing, and correct me if I am wrong it would not be there had the database been rolled back to 12/14.
In the meantime, I have found 10 log files since the restore: perhaps someone can help me understand what these are saying so I can fix it.
There has been 10 episodes of that, it seems that it is as suggested earlier to have something to do with the ezpages.Code:[21-Dec-2018 03:11:02 America/Detroit] Request URI: /webstore/, IP address: 1.186.48.58
#1 trigger_error() called at [/home/sammirah/public_html/webstore/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore/includes/modules/becaberry/ezpages_bar_header.php:21]
#5 include(/home/sammirah/public_html/webstore/includes/modules/becaberry/ezpages_bar_header.php) called at [/home/sammirah/public_html/webstore/includes/templates/becaberry/templates/tpl_ezpages_bar_header.php:18]
#6 require(/home/sammirah/public_html/webstore/includes/templates/becaberry/templates/tpl_ezpages_bar_header.php) called at [/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_header_dropdown.php:201]
#7 require(/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_header_dropdown.php) called at [/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_header.php:93]
#8 require(/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_header.php) called at [/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_main_page.php:73]
#9 require(/home/sammirah/public_html/webstore/includes/templates/becaberry/common/tpl_main_page.php) called at [/home/sammirah/public_html/webstore/index.php:97]
[21-Dec-2018 03:11:02 America/Detroit] PHP Fatal error: 1054:Unknown column 'pages_title' in 'order clause' :: select * from zen_ezpages where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title ==> (as called by) /home/sammirah/public_html/webstore/includes/modules/becaberry/ezpages_bar_header.php on line 21 <== in /home/sammirah/public_html/webstore/includes/classes/db/mysql/query_factory.php on line 171
That is pointing out that your database is missing the pages_title field in the ezpages table, which is a result of having applied the v156 upgrade to your database, but you're using the v155 PHP code which still expects the older table structure.Quote:
Originally Posted by sammirah
Ok, so how would I fix this? Is it a matter of adding something to the table or can I use WinMerge to compare the old ezPages code to the new? should I address each file listed in this seperately?Quote:
Originally Posted by DrByte
The ideal fix is to finish upgrading to v1.5.6Quote:
Originally Posted by sammirah
A temporary fix could be to install the multilingual-ezpages plugin for v155, or at least use it as a reference for which files to merge.
Quote:
Originally Posted by DrByte
Ok, I finally managed to get the secondary site up and running. I have not upgraded the original site as I want to make sure I can replicate things in this 2nd area 1st. I got the database to respond, was able to run the upgrade completely using zc_install. However when I check the logs its still giving me the same error. So perhaps if I install the multilingual ezpages plugin it may help. Or better yet use it as a map for merging the files.
This is the primary site, how things are supposed to appear: http://atmospherebooks.com
This is the test site which I have upgraded: http://atmospherebooks.com/webstore2
Making progress...NOW THIS!
I installed the multilanguage ezpages plugin and although the front page is looking good, I can not access the EZPages in Admin and getting the following:Code:myDEBUG-adm-1545454703-461772.log [21-Dec-2018 23:58:23 America/Detroit] PHP Fatal error: Cannot redeclare zen_set_ezpage_status() (previously declared in /home/sammirah/public_html/webstore2/zcadmin/ezpages.php:13) in /home/sammirah/public_html/webstore2/zcadmin/includes/functions/general.php on line 3864
That means what the error message says:
Your admin includes functions general.php file declares the zen_set_ezpage_status function
but so does your admin ezpages.php file.
You only need it in one place.
If you're planning to stick with older v1.5.5 and the plugin, then keep the function in whichever file the plugin uses.
When you move to v1.5.6, keep the function in whichever file v1.5.6 puts it.
So here is where I am:Quote:
Originally Posted by DrByte
Completely upgraded to 1.5.6
Mutilingual ezPages Plugin Completely Removed down to the last file.
admin/ezpages.php - deleted and replaced from a fresh copy of ZC v. 1.5.6
The result: Site is starting to resemble itself, and I have access to EZPages in my admin area again although no files are showing just getting an error.Attachment 18209
And the following:
andCode:
myDEBUG-1545529210-146604.log ( ASCII text, with CRLF, LF line terminators )
[22-Dec-2018 20:40:11 America/Detroit] Request URI: /webstore2/index.php?main_page=index, IP address: 23.243.5.141
#1 trigger_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php:26]
#5 require(/home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php) called at [/home/sammirah/public_html/webstore2/includes/modules/column_right.php:32]
#6 require(/home/sammirah/public_html/webstore2/includes/modules/column_right.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php:159]
#7 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php) called at [/home/sammirah/public_html/webstore2/index.php:97]
[22-Dec-2018 20:40:11 America/Detroit] PHP Fatal error: 1146:Table 'sammirah_zenc945.zen_ezpages_content' doesn't exist :: SELECT e.*, ec.*
FROM zen_ezpages e,
zen_ezpages_content ec
WHERE e.pages_id = ec.pages_id
AND ec.languages_id = 1
AND e.status_sidebox = 1
AND e.sidebox_sort_order > 0
ORDER BY e.sidebox_sort_order, ec.pages_title ==> (as called by) /home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php on line 26 <== in /home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php on line 171
So, I have checked phpMyAdmin hoping to find the highlighted zen_ezpages_content table to no a avail. So how should I proceed do I just make a table and call it that. I am at a lost on how to proceed.Code:
myDEBUG-adm-1545533775-417078.log ( ASCII text, with very long lines )
[22-Dec-2018 21:56:16 America/Detroit] Request URI: /webstore2/zcadmin/ezpages.php, IP address: 23.243.5.141
#1 trigger_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore2/zcadmin/includes/classes/split_page_results.php:40]
#5 splitPageResults->__construct() called at [/home/sammirah/public_html/webstore2/zcadmin/ezpages.php:536]
[22-Dec-2018 21:56:16 America/Detroit] PHP Fatal error: 1146:Table 'sammirah_zenc945.zen_ezpages_content' doesn't exist :: select count(*) as total FROM zen_ezpages e, zen_ezpages_content ec WHERE e.pages_id = ec.pages_id AND ec.languages_id = 1 ==> (as called by) /home/sammirah/public_html/webstore2/zcadmin/includes/classes/split_page_results.php on line 40 <== in /home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php on line 171
So here is where I am:Quote:
Originally Posted by DrByte
Completely upgraded to 1.5.6
Mutilingual ezPages Plugin Completely Removed down to the last file.
admin/ezpages.php - deleted and replaced from a fresh copy of ZC v. 1.5.6
The result: Site is starting to resemble itself, and I have access to EZPages in my admin area again although no files are showing just getting an error.Attachment 18209
And the following:
andCode:
myDEBUG-1545529210-146604.log ( ASCII text, with CRLF, LF line terminators )
[22-Dec-2018 20:40:11 America/Detroit] Request URI: /webstore2/index.php?main_page=index, IP address: 23.243.5.141
#1 trigger_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php:26]
#5 require(/home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php) called at [/home/sammirah/public_html/webstore2/includes/modules/column_right.php:32]
#6 require(/home/sammirah/public_html/webstore2/includes/modules/column_right.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php:159]
#7 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php) called at [/home/sammirah/public_html/webstore2/index.php:97]
[22-Dec-2018 20:40:11 America/Detroit] PHP Fatal error: 1146:Table 'sammirah_zenc945.zen_ezpages_content' doesn't exist :: SELECT e.*, ec.*
FROM zen_ezpages e,
zen_ezpages_content ec
WHERE e.pages_id = ec.pages_id
AND ec.languages_id = 1
AND e.status_sidebox = 1
AND e.sidebox_sort_order > 0
ORDER BY e.sidebox_sort_order, ec.pages_title ==> (as called by) /home/sammirah/public_html/webstore2/includes/modules/sideboxes/ezpages.php on line 26 <== in /home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php on line 171
So, I have checked phpMyAdmin hoping to find the highlighted zen_ezpages_content table to no a avail. So how should I proceed do I just make a table and call it that. I am at a lost on how to proceed. BTW all of this is on my test site, so my active site is still working well on 1.5.5fCode:
myDEBUG-adm-1545533775-417078.log ( ASCII text, with very long lines )
[22-Dec-2018 21:56:16 America/Detroit] Request URI: /webstore2/zcadmin/ezpages.php, IP address: 23.243.5.141
#1 trigger_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore2/zcadmin/includes/classes/split_page_results.php:40]
#5 splitPageResults->__construct() called at [/home/sammirah/public_html/webstore2/zcadmin/ezpages.php:536]
[22-Dec-2018 21:56:16 America/Detroit] PHP Fatal error: 1146:Table 'sammirah_zenc945.zen_ezpages_content' doesn't exist :: select count(*) as total FROM zen_ezpages e, zen_ezpages_content ec WHERE e.pages_id = ec.pages_id AND ec.languages_id = 1 ==> (as called by) /home/sammirah/public_html/webstore2/zcadmin/includes/classes/split_page_results.php on line 40 <== in /home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php on line 171
After a good night's sleep, I took time to read things carefully and figured out where to get my table, after searching FAQs on how to create ad db table and reading https://www.zen-cart.com/content.php...ce-is-required I looked at every file in zc_install until I found:
I did a back up of my test site database then 1st imported that entire upgrade zencart sql to my db and when that didn't work I tested copying just the above code into myPHPadmin and hit GO. I got errors of course then it hit me, something DrByte mentioned earlier in this post about the prefixes, so I added prefixes to the lines that shot back the error and voila! I got a nice table and I can see all of the EZ-Pages in my admin area again.Code:## add support for multi lingual ezpages
CREATE TABLE IF NOT EXISTS ezpages_content (
pages_id int(11) NOT NULL DEFAULT '0',
languages_id int(11) NOT NULL DEFAULT '1',
pages_title varchar(64) NOT NULL DEFAULT '',
pages_html_text text NOT NULL,
UNIQUE KEY ez_pages (pages_id, languages_id),
KEY idx_lang_id_zen (languages_id)
) ENGINE=MyISAM;
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;
ALTER TABLE ezpages DROP languages_id, DROP pages_title, DROP pages_html_text;
ALTER TABLE ezpages ADD status_visible int(1) NOT NULL default '0';
But the main page is still not working properly again, as a matter of fact I am back at square 1 with that. So I checked the logs and this is what I found:
I know that means a column in the table pages_title is not suppose to be there but my brain is hurting too much to figure this out. My earlier chance encounters made me feel like a mad scientist! I honestly don't understand how you guys look at all this code all day, just a few lines and I can't function. Is there at least a point of reference to look at? I just wanna run my store...as a matter of fact when all of this is done I am updating the db and keeping the test site.Code:
myDEBUG-1545588857-132746.log ( ASCII text, with very long lines )
[23-Dec-2018 13:14:17 America/Detroit] Request URI: /webstore2/index.php?main_page=index, IP address: 23.243.5.141
#1 trigger_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/sammirah/public_html/webstore2/includes/modules/becaberry/ezpages_bar_header.php:21]
#5 include(/home/sammirah/public_html/webstore2/includes/modules/becaberry/ezpages_bar_header.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/templates/tpl_ezpages_bar_header.php:18]
#6 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/templates/tpl_ezpages_bar_header.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_header_dropdown.php:201]
#7 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_header_dropdown.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_header.php:93]
#8 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_header.php) called at [/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php:73]
#9 require(/home/sammirah/public_html/webstore2/includes/templates/becaberry/common/tpl_main_page.php) called at [/home/sammirah/public_html/webstore2/index.php:97]
[23-Dec-2018 13:14:17 America/Detroit] PHP Fatal error: 1054:Unknown column 'pages_title' in 'order clause' :: select * from zen_ezpages where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title ==> (as called by) /home/sammirah/public_html/webstore2/includes/modules/becaberry/ezpages_bar_header.php on line 21 <== in /home/sammirah/public_html/webstore2/includes/classes/db/mysql/query_factory.php on line 171
So the thing is. In the history of this thread, the statement has been made that the ZC 1.5.5 database was imported to the database accessed by ZC 1.5.6 and that after that, zc_install was used to upgrade the database...
It appears though that didn't happen, because 1 the table wasn't generated and 2, one of the fields that was to be added to an existing table didn't happen.
Now, there could be a number of reasons that perhaps it didn't happen; however, that information is expected to be in the zcInstall logs that should exist in the logs directory if all has been incorporated correctly.
Two ways come to mind to proceed, reupload the ZC 1.5.5 database to the ZC 1.5.6 site's database and do zc_install again and check the logs/attempt to access the test site.
Or go through the upgrade script you just used and one by one apply the changes in there. If you are doing so through the admin's tools->install sql patches, then the prefix is unnecessary. If doing it through phpmyadmin (or similar) then the database prefix needs to be applied/added to each table's name.
Ok I guess I read that wrong, I have searched all three db, and there is no table called pages_title...what am I missing here?!!!!Quote:
Originally Posted by sammirah
Ok, so I can try to run the mysql_upgrade_zencart_156.sql in the admin's tools>install sql patches to have it fix the tables?Quote:
Originally Posted by mc12345678
Wouldn't advise running the entire script at once, but instead one sql query at a time. There may end up being errors because one of the commands may have already been executed and then you would have to go back and figure out which one(s) executed...Quote:
Originally Posted by sammirah
The latest message is about a field in a table not existing. The table exists, but the field inside does not. That was one of the queries of doing the upgrade.
Ok, thanks. I have been using WinMerge on the individual files so far and that is working. I got it up and running so far, but I am testing each individual EZ-Page just in case.Quote:
Originally Posted by mc12345678
Note that there are other tables affected by the upgrade to using the ZC 1.5.6 files: configuration, orders related tables, products_options, image paths where images are used in a default install, and several others...Quote:
Originally Posted by sammirah
Remember that the overall goal is that you have this temporary site to help complete/do the upgrade of your live site, regardless of the state it is/was in. So, you'll want to practice making this new site look like/operate like you want based on whatever your current live database has in it. Unfortunately the live site's database isn't as it should have been for ZC 1.5.5, but all is still recoverable. :)
Yay Success!Quote:
Originally Posted by sammirah
Last steps were:
Using WinMerge compare and merge the following files:
includes/modules/becaberry/ezpages_bar_header.php
includes/modules/pages/page/header_php.php
Upload the results and the EZ-Pages problems is done and the test site looks great!