Parts Of My Store Have Stopped Working.

Hello All -

I woke up the other day to notice that parts of my Zen Cart have stopped working. I originally thought that it was an Easy Populate issue, but it seems little more widespread. Here are the Server Details:

Server: PHP 5.4.30, MySQL 5.6.16
Zen Cart: 1.5.3 (most recent update).
Easy Populate: 1.2.57c

Issue #1: I am unable to add any categories or products. I get no errors or warnings, they are simply not there after I create them.

Issue #2: In Easy Populate I get two banners across the top that state:

• Strange but there is no default language to work... That may not happen, just in case...
• Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Now with that Easy Populate error, I am not trying to do anything. I am simply just clicking the tools -> Easy Populate menu button. I have deleted all the previous uploads in the temp directory, in case they were causing an issue.

Issue #3: When I try and download the EP .CSV file, it no longer downloads, but pushes me to a page with the column headers and no info in it (as opposed to downloading the actual csv file.

I am the only person with access to the admin side of the site. I have not made any changes prior to the issue happening. The front end appears to be working fine.

I can not be 100% sure that my host did not make any changes or have issues, but of course I am getting the "we didn't cause this" response from them. Also, and I not 100% sure on this part, I feel like the login page has changed. I could have sworn that I used to just go to domain.com/zenadmin/ and it worked. Now I have to enter domain.com/zenadmin/index.php to get the login. This is what started to get me thinking the host changed something on the server.

Any thoughts would be wonderful.

Any indication as to when pHP went to 5.4? Had EP been tested after upgrading to 1.5.3? Having worked with a different version of Easy Populate on ZC 1.5.3, the presenece (absence) of $languages was identified. As a result of that variable not being defined in the admin, it may need to be defined prior to it's first use. Also, this was the error that was seen when the other version I've worked with was attempted on ZC 1.5.3 requiring the software to be updated to work with the new version.

The other part, existence/absence of categories and products is more than likely a result of using Easy Populate in one regards or another. More than likely data in some of the tables has gotten crossed and is causing what you are seeing there.

May need to restore a backup to resolve, otherwise need to work through the various tables and assignments to determine what is missing, why it's missing, etc...

Thank you for the response MC.

I honestly can not say when the server upgrade happened. We honestly do not do much with zen cart right now, so I am not in it enough to notice when this problem actually began. Do you think I should restore the entire site (web side) and the database from the back up? We have not made many changes since the backup, so that is not a huge issue (other than time).

DMickle:

Thank you for the response MC.

I honestly can not say when the server upgrade happened. We honestly do not do much with zen cart right now, so I am not in it enough to notice when this problem actually began. Do you think I should restore the entire site (web side) and the database from the back up? We have not made many changes since the backup, so that is not a huge issue (other than time).

So, the languages issue would be corrected through either a restoration back to 1.5.1 (and accompanying pHP downgrade for the most part); however that certainly would involve a slew of other issues. It also could be resolved through validation of using the most recent version of the EP product in use that complies with ZC 1.5.3. The other problem(s) ie missing items/categories would/could be addressed through either a restoration of the database, or by narrowing down what category/products are not being displayed and then identifying how some/what is conflicting. I think there is also a "reset" like option in the store manager under tools that might help resolve this. It's been a while since I have seen someone having this issue and I know of a few people that helped detangle it, but I can't recall specifically how.

But, it doesn't seem like restoring the files of the current installation will help unless there is some indication in your logs folder of a file problem.

I've got the same problem, but I'm running
php 5.3.28
MySQL 5.5.37
And, the latest ZC & module.

So, it's not just the php issue -- the module hasn't been updated to play with 1.5.3, 1.5.1 being the latest -- I haven't found the fix, but narrowing down that I don't think it's a PHP issue, but more related to the ZC version.

One other clue is looking in the debug file -- Here's the error being produced:
MySQL error 1045: Access denied for user 'nwcsewin'@'localhost' (using password: NO)
When executing:
select languages_id, name from zpz_languages where code = 'en'

DMickle:

I woke up the other day to notice that parts of my Zen Cart have stopped working. I originally thought that it was an Easy Populate issue, but it seems little more widespread. Here are the Server Details:

Server: PHP 5.4.30, MySQL 5.6.16
Zen Cart: 1.5.3 (most recent update).
Easy Populate: 1.2.57c

Issue #1: I am unable to add any categories or products. I get no errors or warnings, they are simply not there after I create them.

Issue #2: In Easy Populate I get two banners across the top that state:

• Strange but there is no default language to work... That may not happen, just in case...

• Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

Now with that Easy Populate error, I am not trying to do anything. I am simply just clicking the tools -> Easy Populate menu button. I have deleted all the previous uploads in the temp directory, in case they were causing an issue.

Issue #3: When I try and download the EP .CSV file, it no longer downloads, but pushes me to a page with the column headers and no info in it (as opposed to downloading the actual csv file.

OregonBum:

I've got the same problem, but I'm running
php 5.3.28
MySQL 5.5.37
And, the latest ZC & module.

So, it's not just the php issue -- the module hasn't been updated to play with 1.5.3, 1.5.1 being the latest -- I haven't found the fix, but narrowing down that I don't think it's a PHP issue, but more related to the ZC version.

One other clue is looking in the debug file -- Here's the error being produced:
MySQL error 1045: Access denied for user 'nwcsewin'@'localhost' (using password: NO)
When executing:
select languages_id, name from zpz_languages where code = 'en'

If using ZC 1.5.3, calls to mysql_ functions will fail and typically have a response similar to above. In ZC 1.5.3 the database access has been changed to mysqli_ related functions which require in some cases completely different functions in others to have the mysql_ simply replaced with mysqli_ and to include the $db->link as appropriate/necessary... Another important factor unfortunately is the origin of the ZC 1.5.3 version as there have been some autoinstallers distributed that do not contain/maintain the same core functionality. Have seen some that will keep an admin user logged in indefinitely, others won't install, etc., etc.., etc...

There was a lengthy discussion of someone having a similar issue, and I don't recall the final resolution. I know it was suggested that they reinstall ZC as an upgrade, but I think it was that an autoinstaller had been used and that led down the wrong path for operation...

Ahhh found it... A URI rewriter incorrectly modified includes/classes/db/mysql/query_factory.php for ZC 1.5.3 and therefore was causing problems.... (http://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1256709#post1256709)