Printable View
Totally off topic (sorry folks): rem'd out reminds me of the language BASIC I used early in the 80's on a fleet of container ships to calculate stability :cool:Quote:
Originally Posted by nick02895
Please don't hook on to this, don't want to hijack this thread but could not help but noticing......
Cheers / Frank
It was Chadd that expressed the suggestion of IH4, but something I was in agreement with. If you haven't made any changes to the files associated with IH4, then it will make the changes necessary upon install. If you have made changes, then incorporate them into the files that IH4 will load, and off it goes. Otherwise,it's probably one of the easier programs to install that makes modifications to the cart. Numinix programs are also pretty robust; however, after installation other install scripts may need a little work to cooperate.Quote:
Originally Posted by FoodSourceDirect
Yes, you will find that case is important in almost everything related to operation. Variable names, fields, pictures, even the web address. Action often needs to be taken to ignore case. Regarding the fields in EP4, I think that case sensitivity should remain and it is yet another reason that it is suggested to export a file or two before attempting to import so that one can see how things should be entered prior to uploading. :) Be prepared to continue learning and try to help others where you can even if it's a gentle nudge to provide more information about a topic (posting guidelines for example.)
Great!Quote:
Originally Posted by nick02895
While commenting out (REMing) those two lines won't disable EP4, if I remember correctly incorporating mbstring into your php.ini will bring that function into the system load. If I also remember correctly, this all was added to force input/output to be converted to/from UTF-8 and unfortunately may disuade others from using this plugin. Perhaps we could incorporate a check and if the function is not reachable, provide some guidance on how to enable or perhaps some form of description as to the effect of not enabling that "feature".
I don't have the line numbers, but if you look in admin/easypopulate_4.php, there are some comments associated with each of the mods(code existing elsewhere in the store from which EP4 waas run). The associated field appears to be related to Google Merchant Center as of 2011. I personally can not account for it's continued need/use asi have not worked with that field/code to know of it's importance/usage.Quote:
Originally Posted by retched
Thank you for the feedback. In the time since my last post I have changed to responsive theme. I am still trying to figure out how to "personalize" it. And, finally, this morning I managed to successfully install IH4. It works!! Now I have got to figure out how to install Tabbed Pro without breaking the site.
Good. I'm going to withhold further discussion to take place on appropriate threads, but if nothing else, hopefully these changes you're making are first on a backup of your site, and not initially on your live site. This way you can make a mistake without affecting current business or future business.Quote:
Originally Posted by FoodSourceDirect
Oops. I did do the changes on the actual site. You make a good point. Ok, going to fix that.
Hi Nick,Quote:
Originally Posted by nick02895
Glad you got this working. Yes, those function calls are part of working with UTF-8 encoding for multi-byte (mb_) languages. Most english will encode in 1 byte, but some can take up to three if memory serves me correctly... Just be cautious with your string lengths as they may not get calculated correctly.
if that happens, and I'll use Manufacturer as the example, then you can end up with multiple truncated entries in the database:
So, Manufacturer's name exceeds database lenght:
"Hill Billy Manufacturing and Supplies Corp" is entered in your CSV file.
EP4 goes to add this to the database because it's new, but the string is truncated to the length in the database ( you'd see that in phpMyAdmin)
"Hill Billy Manufacturing and Supplies Corp" now becomes "Hill Billy Manufacturing an" in the database.
On the next line you have another item for this Manufacturer.... EP4 does a search on the manufacture's table and does not find a match, so it add that manufacturer AGAIN, and AGAIN it's truncated.... If you have 50 items with the same manufacturer, you end up with 50 entries in your manufacturer's table....
Not so damaging... BUT, this can also happen with Category Names! So please be careful to not exceed your database's field lengths.
Chadd,Quote:
Originally Posted by chadderuski
Good explanation. To confirm though, if mbstring is used as originally incorporated, could you elaborate how this all would happen? (I don't want to guess and cause confusion.)
Hello, I did a new install of Easy Populate 4.0 on a fresh install of Zen Cart 1.5.3. It installed correctly, shows up in Tools and also in Configure, but when I click on it to configure it, it can't find the page, it's a 404 error. It goes to mystore/myadmin/configuration.php?gID=53. Does this sound like a familiar problem that anyone else has had? Any ideas on how to fix it? Thanks!!
While hopefully others will also respond, I did a similar action this last weekend, to both a 1.5.3 and 1.5.1 cart with no issues. Are you able to access the tools menu option, uninstall and then select the install option at the top again. Should be presented with an error about the existence (absence) of the temp directory, unless you have that directory in your store's path.Quote:
Originally Posted by BlackOrchidCouture
The gID=53 part of the path, merely indicates the number assigned to that menu option. Are you able to access other configuration settings? Ie under My Store or product Layout, for example?
Thanks for answering so quickly! Oh, interesting, I was able to access other configuration settings earlier, and just assumed that the only one I couldn't access was Easy Populate since that was the one I was trying to access, but just tried others and they all go to a 404 error as well. I fixed the error about the missing directory when I first installed Easy Populate, just created a temp folder (but called it the name it said that I was missing). I was able to get all the errors to go away. I can access it in Tools, so I'm going to try your uninstall/install suggestion....
Uninstalled and installed again successfully, but still can't access any configurations....
Yeah, you did all that before I could reply to indicate that since your other configuration options are not working is that somehow your store/admin/configuration.php file has something wrong (totally unrelated to EP4), either it isnot present or has been renamed or something. EP4 does not modify that file. It simply is used to access the various options thaat are set in the database (table configuration).
I checked both configure.php files and they are both there, and they both still have the last modified date as the same date I installed the new Zen Cart, so they haven't been modified. Whatever error happened came about after I installed Easy Populate...
Please review what I typed and what you did. Notice the path I identified, it was not a mistake, also the filenames we are talkiing about are different. You mentioned configure.php, I stated configuration.php. There is only one of the file I mentioned. It is located in the root of the admin directory not in the includes directories.Quote:
Originally Posted by BlackOrchidCouture
You were right, the configuration.php file was gone! I restored it and now configure works for everything. I have no idea how that happened, all was well earlier. Anyway, thanks for recognizing the issue!!
Welcome, I would suggest though that you investigate a little to determine why/when/how that file was removed. Maybe it has been moved to a neighboring directory if say it was clicked and dragged during upload of the EP4 files if that was done relatively recently?Quote:
Originally Posted by BlackOrchidCouture
Will do, it shouldn't be too hard, I just installed the Zen Cart 4 days ago, then a bunch of plugins. I had tried to install FEC and it wasn't showing up in Admin, so I deleted all the files it may have happened then. Thanks again!
Good to know, like said before EP4 does not overwrite any core files. While I don't know if Fast and Easy Checkout overwrites the configuration.php file, if it does, remember as you rebuild your cart, just because a file was a part of a plugin, it may also be a modified necessary file for the store. Uninstall may require restoration of a backup of the file. :)Quote:
Originally Posted by BlackOrchidCouture
Aha, FEC does have admin/configuration.php included in the files to upload, so I did delete it when I deleted all the files! The weird thing is though this file is a core file, I don't remember any files being overwritten when I first uploaded FEC, and the instructions don't mention any overwrites. Well, hopefully this all will help someone else in the same situation!
I have read through this entire thread looking for a different answer than the missing $ update, but even after uploading and installing the latest version, and even copying and pasting the code from GitHub, I am still getting EP4 FATAL ERROR: No default language set, even though just a few days ago, Easypopulate 4 was working perfectly on my site. Has anyone come up with any different reasons for this, and/or fixes?
Just on a whim, I tried this in easypopulate_4.php
as you can see, I commented out the dreaded fatal error else code, around line 153, and voila, that worked like a charm.Code://else {
//exit("EP4 FATAL ERROR: No default language set."); // this should never happen
//}
Sorry folks. Although that got rid of the error on tools->easypopulate, it broke several of the other ep4 pages.:blush:Quote:
Originally Posted by wtashby
I'm just going to try starting over. If anyone still has found a fix for this that doesn't break other things, please, let me know.
Please identify the versions being used (ZC. And EP4). There was that problem which prompted the latest change.Quote:
Originally Posted by wtashby
Zen-cart v1.5.3 and EP4 v4.0.23Quote:
Originally Posted by mc12345678
As I stated before, it was working just fine a couple of days ago. I even successfully uploaded products. Now, clicking on tools->easy populate 4 kicks out that error.
What version PHP?Quote:
Originally Posted by wtashby
PHP Version: 5.3.28Quote:
Originally Posted by mc12345678
Fyi, now that I have a moment. To. Write, it was these exact symptoms that identified the need to update the code to work with 1.5.3. All of the same "tests" were performed.Quote:
Originally Posted by wtashby
May I suggest reuploading the files? But before doing that, going to tools, developer's toolkit, in thelower left corner inserting: easypopulate_4, then the drop down select admin and do a search. Identify what appears in the firstline of the various files that come back. Sounds like may have had the. Right files initially,but something isn't right now. :/
includes/languages/english/extra_definitions/easypopulate_4.php is v4.0.21Quote:
Originally Posted by mc12345678
includes/languages/english/easypopulate_4.php is v4.0.21
includes/functions/extra_functions/reg_easypopulate_4.php is v4.0.21
easypopulate_4_split.php, v4.0.21
Everything else is v4.0.23
Those version numbers appear correct for the way the files have been updated. Have you had any success with the installtion?Quote:
Originally Posted by wtashby
It wouldn't make sense, but I even tried to find out if there was a conflict of this version of php with mysqli_ type commands. Here's another thought if you are still having difficulties, andmay have a follow-on question, when inur admin panel, in the upper right is a version button. Towards the bottom of the resulting screen's top part, what version information is there about your ZC? Also, what type of system is this being used on? Something still doesn't seem to be adding up since you said you were able to use this a few days ago, and now there is a problem. :/
None of what you are asking me about has changed. None of this explains why, one day it's working perfectly, then suddenly, this. Since EP doesn't effect any of the core files, and no other plugin or module effects EP4 files, what on earth could be causing this?Quote:
Originally Posted by mc12345678
When easypopulate_4.php does a query for the default language, does it do so directly to the database, or does it call another file in zen-cart first? I ask because I'm wondering if maybe I have a corrupted language file somewhere, or something like that.
Good questioning attitude, perhaps you have struck on what the issue may be or how to fix this issue.Quote:
Originally Posted by wtashby
It accesses the database directly (most of the functions in EP4 do that, which is partially why it does not count on too much of the ZC files). It looks for the default language by use of the constant DEFAULT_LANGUAGE. When looking at Localization->languages, the default language (if there is one) should have the word (default) next to the Noun name of the language. Take note of the code (typically two letters) next to the language that is/should be the default. Then go verify that the constant DEFAULT_LANGUAGE is set by going to any configuration section, and change the gID to 6.
Then when the Default Language field is selected for edit, enter/verify entered the code noted above.
What do you mean "any configuration section"? In the database? A file? What is a gID?Quote:
going to any configuration section, and change the gID to 6
Admin panel, configuration (far left), select for example My Store.Quote:
Originally Posted by wtashby
If you look at the URI in your browser you see (typically): mysite/MY_secret_admin/configuration.php?gID=1.
Change the 1 to a 6 and "goto" that page...
Ok, I understand. I just did that, and my selected default language is correct. enQuote:
Originally Posted by mc12345678
Should it be something different?
It could be, but the important thing is that you also have en in the localization->languages area... Is it listed more than once?Quote:
Originally Posted by wtashby
Could try running the following script in myPHPadmin prepending your table prefix to the word in red if there is a table prefix.
and identify what/how many rows are returned and the value of languages_id.Code:SELECT languages_id, name FROM languages WHERE code = 'en';
Running that returned one result, and it was correct. My localization->languages is correct, every thing seems correct. Is there any way to un-install EP4 even though I can't get to the page to click the link? Maybe if I can completely remove all things EP4 and start over, something might fall into place.Quote:
Originally Posted by mc12345678
and if you look in the following file at approximately that line number, is this present in your store's directories?
Nevermind, the above post indicates that there is no issue with this constant.Code:
includes/database_tables.php
Line #52 : define('TABLE_LANGUAGES', DB_PREFIX . 'languages');
I just realized I may have edited my previous response a little too soon. The test run did not validate that ZC had the correct setting/variable. It validated that if the correct query was sent to the database then the right information would come back. So now it is necessary to validate the query is providing the correct information to ensure that it is not returning with a blank entry. I wonder if anything UTF8 relates to this issue and whether the mb_string aspect has been bypassed and potentially added to this?Quote:
Originally Posted by wtashby
Well, the uninstall process that is a part of EP4 only addresses the database and the actions taken to access the configuration settings and the settings on the configuration page. Ideally, the files should be reuploaded through FTP, or in reverse removed one by one.
You can try:
but that won't adjust anything related to the data of the returned SQL statement.Code:yourstore/youradmin/easypopulate_4.php?epinstaller=remove
Don't recall if this was asked before, but do you have any error logs in the store/logs folder?
Yes, there are lots of them, all about the time I started having trouble with EP4. Also, when I tried to run the uninstall link you provided, I got the same language error. I deleted all the files, re-uploaded them, and, well, again, the same error. Nothing seems to work. But yes, I have several log files.Quote:
Originally Posted by mc12345678
So, please feel free to post them here; however, also please obscure your admin folder name which is undoubtedly included. No need to show duplicate errors unless they support some sort of timeline of events.Quote:
Originally Posted by wtashby
It may be best to start with the earliest of those logs and don't just focus on ep4 issues.
Quote:
Originally Posted by mc12345678
This is the error log that is generated each time I try to access EP4 vial tools.Code:[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_character_set_name() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/easypopulate_4.php on line 138
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home/my_admin_directory/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[12-Aug-2014 22:21:15 America/New_York] PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/my_admin_directory/easypopulate_4.php on line 172
So, I said there was one other "question" to follow up on... It looks like (and not sure why yet) that the identification that the version of ZC you are using is not coming back as 1.5.3 when the Major and minor project version information is put together.Quote:
Originally Posted by wtashby
So, I had asked about information that came back from using Version in the admin panel. I don't recall seeing it, it should look something like:
Zen Cart 1.5.3
Database Patch Level: 1.5.3
Found just below the logo image that is centered in the screen. The other place to look is: in the version.php file located at:
includes/version.php.
I have this sneaky suspicion that my original thought of the "fix" for this was too narrow sited. What I have in my 1.5.3 vanilla install is the following:
What does yours have/where did you get your copy/when possibly?Code:<?php
/**
* version.php
* Defines the project version details
* Specifies what version the PHP fileset relates to.
* Also declares what version the database "should" reflect if properly maintained and kept in sync.
*
* THIS FILE SHOULD NEVER BE EDITED MANUALLY !!!!!!!!
*
* @package general
* @copyright Copyright 2003-2014 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version GIT: $Id: Author: DrByte Thu Apr 24 14:58:48 2014 -0400 Modified in v1.5.3 $
* @private
*/
define('PROJECT_VERSION_NAME', 'Zen Cart');
define('PROJECT_VERSION_MAJOR', '1');
define('PROJECT_VERSION_MINOR', '5.3');
define('PROJECT_VERSION_PATCH1', '');
define('PROJECT_VERSION_PATCH2', '');
define('PROJECT_VERSION_PATCH1_SOURCE', '');
define('PROJECT_VERSION_PATCH2_SOURCE', '');
define('NEW_VERSION_CHECKUP_URL','http://ping.zen-cart.com/version_id.txt');
define('EXPECTED_DATABASE_VERSION_MAJOR', '1');
define('EXPECTED_DATABASE_VERSION_MINOR', '5.3');
Fyi, the interpretation of all that, is that the non mysqli_ functions were called it seems.Quote:
Originally Posted by wtashby
Literally, nothing about your store was puposefully changed the time between when it last worked and when it was noticed not to work? No server restores, no files renamed? And any renamed files do not have php as the last part of their extension?
Can you verify your version of PHP and MySQL?Quote:
Originally Posted by wtashby
In the admin, click "Version" on the right side of the menu.
Look for:
PHP Version
Database
Zencart Version
Database Patch Level
and then do a search for "mysqli" and ensure that it's active. You'll see something like:
mysqli
MysqlI Support enabled
Client API library version 5.5.37
chadderuski - Thanks for staying with this thread. I don't see 4.0 in the zen plugin library. Can you put a link to it in your signature? I'm looking for the latest version to add to a clean install of 1.5.3. Thank you.
It's in the same location it has been all along, go to the first post of this thread, there is a link to the current version of EP4 on github, which has been updated to work with 1.5.3 as well as continuing to work with the previous versions. As noted in the change log(s), ZC 1.5.2 was not considered for incorporation.Quote:
Originally Posted by athena
As for the download option from ZC, the instructions are under development and the primary hold up on why this has not been submitted as an official ZC plugin.
I am part of that problem as I incorporated some functionality to support a version of Stock by Attributes and need to write applicable instructions for it's use.
Appreciate the quick response and explanation. I'm going for it... Thanks again,
Zen Cart 1.5.3Quote:
Originally Posted by chadderuski
Database Patch Level: 1.5.3
v1.5.3 [2014-08-05 18:29:06] (New Installation)
v1.5.3 [2014-08-05 18:29:06] (New Installation)
Server OS: Linux 2.6.18-471.3.1.el5.lve0.8.72 Database: MySQL 5.5.32-cll-lve
HTTP Server: Apache
PHP Version: 5.3.28 (Zend: 2.3.0) PHP Memory Limit: 168M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 32M POST Max Size: 128M
Database Data Size: 1,199 kB Database Index Size: 820 kB
Code:mysqli
MysqlI Support enabled
Client API library version 5.5.32
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Client API header version 5.5.32
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
Thank you for that information I hope it will help identify what has happened. Another question, is your site being loaded by an ip address or by a uri?Quote:
Originally Posted by wtashby
You can click on my signature for that answer. I only use uri's. I never use ip addresses.Quote:
Originally Posted by mc12345678
Welcome! Also I've seen some comments in the forum that there are possibly already several variations to this program and a suggestion to merge them.Quote:
Originally Posted by athena
I. Personally think this is the most robust of the Easy Populate versions and could be the one to bring in the functionality of the other versions.
I've begun looking into what is necessary to produce froogle related files to address one of the strains. Then I'd like to see what is different about this versions csv file creation as compared to the one that is supposedly excel file friendly. Looking at the downloads section, only one appears to have been updated in the last year or so unfortunately. Perhaps those other versions aren't as independent of Zen Cart functionality as this one. It could be made to rely more on the zc code, but then the error log functionality would basically be lost as instead the ZC error logging process would come into play and that probably would require incorporating the display error log plugin.
I've already been able to incorporate another popular ZC plugin into EP4 and plan to complete all currently desired aspects in the next couple of weeks with other work allowing. In the mean time there may be some other minor updates to this in the near future to address some other efficiencies and functionality.
Hmm, okay wasn't sure, at least that's not the issue.Quote:
Originally Posted by wtashby
So, I was doing some looking today based on the error log that is generated. One of the comments associated with that error is that perhaps the query is coming back empty. Wondering if the query were replaced with the hard coded information that was used in myphpadmin to at least eliminate that possibility. The line is just above line 990 in the youradmin/includes/functions/extra_functions/easy_populate_4_functions.php file (may have the file name slightly wrong, sorry working from memory.)
This looks current.Quote:
Originally Posted by wtashby
wtashby:
At this point my best suggestion is to create a subdirectory on your site, and do a clean install of zencart there, install EP4 and see if it work normally.
You will have to create a separate database in CPanel. Be sure to also install Dr. Bytes MySQL Backup tool.
I'm sorry I can't offer a better solution. Returning to the core manual install often helps identify if the issue is server related or not.
This has been the case when someone used their CPanel auto installer to install Zencart instead of uploading the files and running the install manually.
-chadd
A few comments on MC's comments - just as general discussion :p
EP4 is VERY robust, but to achieve this some things had to be changed from Langer's version.Quote:
I. Personally think this is the most robust of the Easy Populate versions and could be the one to bring in the functionality of the other versions.
1. Separate upload from import/export (no streaming data up or down)
2. Us PHP's built in CSV file reading and writing functions
3. Ability to turn off "verbose" feedback
These changes made it possible for EP4 to do MASSIVE imports very quickly. I was working with an electronics parts store with over 900,000 product sku's. Even on a dedicated server, the old EP code would time out, and run out of memory.
After the above re-writes, I could easily upload the full 900,000 item csv file, use the split utility to break into blocks of 50,000
records, and import the 50,000 records in about 12 seconds.
First:Quote:
I've begun looking into what is necessary to produce froogle related files to address one of the strains. Then I'd like to see what is different about this versions csv file creation as compared to the one that is supposedly excel file friendly. Looking at the downloads section, only one appears to have been updated in the last year or so unfortunately. Perhaps those other versions aren't as independent of Zen Cart functionality as this one. It could be made to rely more on the zc code, but then the error log functionality would basically be lost as instead the ZC error logging process would come into play and that probably would require incorporating the display error log plugin.
MS Excel has been very frustrating to work with... to many versions, to many variations of CSV files, and the inability to set
your language type. Don't forget the limit of 256 character in a cell (maybe a recent version of Excel has fixed this?). OpenOffice creates a standard CSV without these limitation, and has the ability to set your language source at import and export.
Also, PHP's built in CSV read/write functions have no problems with Open Offices exported CSV files, but strange things happen
when you use Excel (which I believe puts different info in the header of the file), but this is dependent on the version of excel and the type of CSV you create.
Langer's old code manually processed the text file. It worked, and was perhaps more forgiving, but it was also incredibly slow.
So I replaced all that convoluted mess with a single php function call ....
Second:
I had already begun to work on mappable export/import files. If you look in the code, you'll see it commented out. It was just a start for something more flexible and robust, but it's quite doable.
Having the ability to use custom products fields (done) with mappable import/export would be much better than hard coding support for specific plug-ins. This has been my ultimate goal with EP4, but life intrudes and I've not met my goals.
MC's help in supporting and expanding EP4 is really appreciated. He's helped keep EP4 alive for well over a year now!Quote:
I've already been able to incorporate another popular ZC plugin into EP4 and plan to complete all currently desired aspects in the next couple of weeks with other work allowing. In the mean time there may be some other minor updates to this in the near future to address some other efficiencies and functionality.
Buy him some coffee or a nice dinner, he deserves it! :p
-chadd
Wtashby,
Don't know where in the process of suggestions thathavebeen made. If the "original" site is still available, is EP4 the only option on your admin panel that is not accessible at this point? Information in your admin's catalog is the same as on the store's side? (Ie, the configure.php files effectively match the same directories and database? This may become more evident when the above install suggested by chadderuski is performed and the files reviewed. (These could be different than expected if it was thought thaat they were saved but the write permissions were not changed to allow writing before trying to save.)
I realize that there seems to be a problem, but there have been several that have installed this to 1.5.3 and having equivalent settings thathavent had the same problem.the thingis to find the cause and perhaps incorporate some sort of solution up front to more clearly explain what is going on and possibly a solution.
Can I export a google merchant feed with this mod too? What would I have to do?
I actually want the merchant feed in tab delimited as I want to use it for Amazon product ads upload. Can this be done?
For export only, there are three files you will need to modify: admin/easypopulate_4.php, admin/easypopulate_4_export.php, and admin/includes/functions/extra_functions/easypopulate_4_functions.phpQuote:
Originally Posted by mydanilo
The first file will need a menu option and an $ep_dltype name added, related data will need to be captured in the other two files, then in the functions file need to modify the function that includes set_filetype to identify the fields that will be desired to be exported as well as a sql function to kick off the creation of the information. Then the export file will do the processing of the data returned from the filetype function, so if wanting to get all products, will want that sql to effectively return at least all of the products to be processed. The full function does that as an example. If you want to change the delimiter from comma to tab there is a place to do that I think in the export function.
That's a rough discussion of how easy chadderuski has made this.
Well thank you but I think that might be over my head. I was hoping that it was a pretty simple config or that somebody already use this to create a google merchant feed and would be willing to share?
Ahh, gotcha. Well I was just about to see what the expected output would be and maybe incorporate it into this version. But if someone alreadyhas/knows, then great.Quote:
Originally Posted by mydanilo
Well, I guess if anything, the research to know what is expected/required seems to be a sticking point at the moment. I somewhat thought that I might be able to pull from another's code, but haven't found such an example yet really not one that will provide a quick (next hour or so) solution. But looks like it is possible, just need to know what data and header is expected.Quote:
Originally Posted by mc12345678
Maybe I can help there. The Amazon Product Ads Upload File template might help to identify what is needed. I've put it my drop box for you to look at:
https://db.tt/7At3BkNV
Or the Google Merchant Center Feeder, or Amazon Inventory Loader from Numinix could shed some light to what is needed.
It just would be great to have the ability to generate a usable feed from this mod.
Looking a bit further into what the sample feed looks like, it should not be too difficult to just hand match the headers up with what I get from the regular full export of my product listing. I shall give it a shot and post my findings.
Matching up header is not too difficult but I've discovered that I don't have the products URL in my exported file. I need this for the Amazon feed. Any suggestion how this could be added to the exported file?
Are you using standard ZC URIs? Regardless would want an additional $row[] to receive the uri, then some point after most/all of the data has been collected, within the while loop for the row data, construct a standard uri, say possibly with the zen_href_link function.Quote:
Originally Posted by mydanilo
Few functions to help build the uri:
Zen_get_info_page($prodID) returns the portion of: main_page=
Zen_get_product_path($prodID) to get the cPath as cat1_cat2_cat3.
And then would concatenate the products_id= with $prodID
I think though the cat number is already a part of the data, the info_page can be obtained through the above function and the $page that is applicable for the zen_href_function is FILENAME_DEFAULT.
So uri:
The false is to prevent adding the session_id onto the uri.Code:$new_uri = HTTP_SERVER . DIR_WS_CATALOG . zen_href_link(FILENAME_DEFAULT, 'main_page='. zen_get_info_page($prodID) .'&cPath='. zen_get_product_path($prodID) .'&products_id='.$prodID,,false);
I use Ceon URI Mapping module, do you think that will work? Where would I have to put the above code please?
All I really need is the URI added to the export file. The rest I can map myself manually with the Amazon template.
I have a version of EP4 that does that on my website, but if you look in the export file in your admin folder, in the section that checks if the ep_dltype is full, I would put it somewhere after the product id is assigned. The variable names may be different, and I think you'd have to assign a new filelayout item to end up with the data exported to the file. I'm working from memory at the moment, so I may have missed something, but that's the jest of it.Quote:
Originally Posted by mydanilo
As far as CEON URIs, those going to the uri generated from the above code will end up seeing the CEON URI equivalent, but I do not know the effect of say "rankings" of providing the ZC standard uri for uris that are rewritten to a more human understandable version.
Was thinking about it some more, you could also use a similar set of data to query the ceon_mappings database for the uri of the product(s) as they currently are and with the same site information prepended to the database result submit that uri. Code would still be in the same location, just would have a database query to accompany it.
Hello,
Can someone please help me or point to the correct post where i can find the solution here? (someone suggested I post this here for help instead of the Dual Pricing thread)
I'm trying to add wholesale pricing to my Easy Populate spreadsheet.
I added the below line to the admin\includes\languages\english.php file as instructed but no luck >>>
define('EASYPOPULATE_CONFIG_CUSTOM_FIELDS', 'products_price_w'); //Easy Populate
Does anyone have any solutions for this? I am unable to update my wholesale products and I have more than 5000+ items.
I am having the same issue on a client's website that is 1.5.3.
PHP Version: 5.4.30, used the latest files at https://github.com/chaddro/EasyPopulate-4.0
Mod worked the day I installed it and generated a file. Yesterday it stopped working and gave the error below.
I checked easypopulate_4 in developers tool kit - got 188 match lines in 10 files.
Any help would be appreciated! THANKS SO MUCH!
Quote:
Originally Posted by wtashby
In the file YOUR_ADMIN/easypopulate_4.php at line 177 that reads:Quote:
Originally Posted by stellarweb
Change to read:Code:exit("EP4 FATAL ERROR: No default language set."); // this should never happen
And please repost the resulting error message.Code:exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen
If you are trying to export an additional field that is located in your products table and you are using EasyPopulate ver 4, that is not the way to do it. If you look in the admin panel, configuration, Easy Populate 4. There is a custom field text box. In that text box, enter the field name which appears to be products_price_w. Then on export/import that field will populatein both directions. If you need more than one field added, then separate the field(s) with a comma.Quote:
Originally Posted by nesum18
Hi guys
I have easypopulate working very well for imports and exports but want to import 3 values. My websites serves downloads of PDF ebooksso these are needed .
So the values I want to import are
products_attributes_filenames Sample Data would be \Books\Harrypotter.pdf
products_attributes_maxcount
products_attributes_maxdays
They are all stored in the table products_attributes_download
Is it possible to access these values with an import in Easy populate ?
Thanks Paul
Yes this is possible through the existing coding of EP4. Do an export of the basic products attributes and the detailed products attributes to see how they canbe worked together to add/modify attributes associated with your product(s). The specific data that you are looking to use/modify would be in the detailed version. But first the product(s) would need to be built up to have/know that there is such an attribute to be considered.Quote:
Originally Posted by Hasher
EP4 FATAL ERROR: No default language set. Table: languages Code: en is set
Above is the new error after making the change
Quote:
Originally Posted by mc12345678
Try this if you wouldn't mind after line 171, add the following:Quote:
Originally Posted by stellarweb
Ie:between these two lines:Code:$epdlanguage_query->store_result();
Code:$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {
Done
Now get blank white page. Error log generated as follows
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 895
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_character_set_name() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/easypopulate_4.php on line 138
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 12:06:11 America/Denver] PHP Warning: mysqli_errno() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
[21-Aug-2014 12:06:11 America/Denver] PHP Fatal error: Call to a member function store_result() on a non-object in /home3/beadins1/public_html/bI1544+/easypopulate_4.php on line 172
Quote:
Originally Posted by mc12345678
Ami correct that the three lines read:
In that sequence?Code:$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
$epdlanguage_query->store_result();
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {
Here's what I have found regarding the way this has gone. Prior to the use of mysqli_, it seems that although possible, not as frequent that the returned data would be unbuffered and therefore when a function such as num_rows was called, the value returned would either be 0 (unbuffered) or the number of rows that actually exist(ed). It appears that the two reported occurrences of this have been more of the result of the return of zero rows even though the data could be enumerated. I have two alternative tests I'm working on for you to try which may need to happen in the functions file or in the main base file. The above error list is similar to what I observed when updating EP4 to work under ZC 1.5.3. Though I want to be sure that the above code is in the correct sequence before continuing down that alternative path. Also, wanted to verify that the test(s) that were requested in the original notification of this problem were also run with equivalent results. (Ie, verification that performing the sql query in myphpadmin had a successful result.)
Some of the next "solution" is to identify in how many places the additional "correction" would be needed. I thought that the num_rows function was only used the one time and all other actions were based on straight forward pull and check type routines, not necessarily a "hey how many" type call.
Lines 171 to 180
$epdlanguage_query = ep_4_query("SELECT languages_id, name FROM ".TABLE_LANGUAGES." WHERE code = '".DEFAULT_LANGUAGE."'");
$epdlanguage_query->store_result();
if (($ep_uses_mysqli ? mysqli_num_rows($epdlanguage_query) : mysql_num_rows($epdlanguage_query))) {
$epdlanguage = ($ep_uses_mysqli ? mysqli_fetch_array($epdlanguage_query) : mysql_fetch_array($epdlanguage_query));
$epdlanguage_id = $epdlanguage['languages_id'];
$epdlanguage_name = $epdlanguage['name'];
} else {
//exit("EP4 FATAL ERROR: No default language set."); // this should never happen
exit("EP4 FATAL ERROR: No default language set. Table: ".TABLE_LANGUAGES." Code: ".DEFAULT_LANGUAGE." is set" ); // this should never happen
}
Quote:
Originally Posted by mc12345678
Two different thoughts for solution...Quote:
Originally Posted by stellarweb
Okay, try removing the new line 172 from admin/easypopulate_4.php
And add in admin/includes/functions/extra_functions/easypopulate_4_functions.php at line x:
The other thing I can think of trying is to still remove 172 in the above file, then replace the if statement that follows with:the below and comment out the line that follows that.Code:$result = ($ep_uses_mysqli ? mysqli_query($db->link, $query, MYSQLI_STORE_RESULT) : mysql_query($query));
Code:if (($epdlanguage = ($ep_uses_mysqli ? mysqli_fetch_array($epdlanguage_query) : mysql_fetch_array($epdlanguage_query)))) {
//$epdlanguage = ($ep_uses_mysqli ? mysqli_fetch_array($epdlanguage_query) : mysql_fetch_array($epdlanguage_query));
A third option if the first aabove is a no go is to place a line at 991 og the functions file, similar to what was added in line 172 in the main file with the appropriate variable substitution.
This would be something instead of 1 or 2. So suggesting to implement only one of these three at a time for now.
My reasoning behind all this is the following.
The query function is supposed to default to the store option suggested in the first option; however, it is possible that this version of php on the host could have something incorrectly configured/compiled and does not default to that constant. Next is that the constant could be incorrectly assigned and not accounted for in the query function. If so, the first option above won't resolve the issue. The second option above is suggested in the event that the query is coming back with a result, but the num_rows function isn't returning a value until either the result has been completely stepped through, or a result has been tested, so the second modification should identify if the query returned with something because if it did then the language should be assigned in the if statement. If the query comes back with more than one result, well we rent worried about that and justuse the first returned result. The third revision identified in this post is to further account for the reason(s) why the first option was unsuccessful and to force the action of storing the result, but doing so while the result is still in memory, where the previous attempt at line 172 may have been performed when the data was already lost.
Unfortunately, the environment(s) in which this has been tested have not produced the troubled results seen by the two of you.
The next thing I can see to do is to look through the ZC code for the db class and see how queries under mysqli_ style calls are handled. It may be that some query preparation needs to be performed although it appears that none of the data into EP4 really is subject to malicious action. Hmm, maybe the query in line 171 where the single quotes are used need to be escaped for the query to work? Or the single quotes removed from around the returned variable(s). Although I had already suggested hard coding the query (not using variables) to see if that would be successful, not directly to you, but as an attempted solution.)
Not being able to reproduce the issue makes it difficult to suggest solutions. Between the time of it working and now when it doesn't, nothing was added to the cart code? No template changes? Anything that could cause something to load as a part of kicking off the code that could interfere or modify the expected response(s) of the system?
I tried the second solution - still the same problem.
Please know I am not a coder, nor do I play one on TV :cool: so I do not know what you mean by the "line x" in the following statement:
"And add in admin/includes/functions/extra_functions/easypopulate_4_functions.php at line x:"
Quote:
Originally Posted by mc12345678
Oops, sorry that line was supposed to be changed to modify line 990 to read like the code that was suggested in the line above.Quote:
Originally Posted by stellarweb
You're doing well. With regards to making the change using option 2 above, was the result still that no language was defined?
If so (response still was to not have a. Language installed), I wouldn't worry about restoring that area of the code in admin/easypopulate_4.php. Can if you have, don't think you need to. If some other error occurred, then I would set it back, but not if the response was that the language is not installed. I'm somewhat thinking that the code should go to that anyways.Quote:
Originally Posted by mc12345678
Based on the previous comment of not being a programmer (but following directions very well), here is the code suggested to be added between lines 990 and 991 of the functions file. (Ie immediately following the assignment of the query to the variable result.)Quote:
Originally Posted by mc12345678
Code:$result->store_result();
Thanks! I am trying to help the best I can not knowing my head from a hole in the ground when it comes to coding! :shocking:
I did it a couple of ways:
1. Kept the code changes from the last post in admin/easypopulate_4.php, then I changed line 990 in admin/includes/functions/extra_functions/easypopulate_4_functions.php with the code you just provided and got EP4 FATAL ERROR: No default language set. Table: languages Code: en is set
2. Then I reverted admin/easypopulate_4.php to its original code and I changed line 990 in admin/includes/functions/extra_functions/easypopulate_4_functions.php with the code you provided and now get EP4 FATAL ERROR: No default language set.
Quote:
Originally Posted by mc12345678
So, have you tried all three options then? Could you post what you have at/around 990 of the functions file? Please enclose in [ CODE] [/ CODE] tags with the space(s) removed.Quote:
Originally Posted by stellarweb
Nothing added that I can remember. I believe the EP was the last mod to be added. The only other thing that was done was changing a file for linkpoint payment module....
Quote:
Originally Posted by mc12345678
Do you happen to know/remember in which directory the file modified was in? (Don't need to know the file name, just trying to think if in the sequence of loading things, if there is something that has an effect on the variables used in EP4. If so, then the eP4 variables can be renamed to avoid that potential conflict. It's a long shot, but there have been two people that have expressed having a problem using this, both obtaining the same error message, though the cause has not been pin-pointed.Quote:
Originally Posted by stellarweb
Ok.... here goes....
1. I changed admin/includes/functions/extra_functions/easypopulate_4_functions.php and added the code in between lines 990 and 991 as follows:
2. I made sure all other files were at their original stateCode:$result = ($ep_uses_mysqli ? mysqli_query($db->link, $query) : mysql_query($query));$result->store_result();if (($ep_uses_mysqli ? mysqli_errno($db->link) : mysql_errno())) {
RESULTS: Blank white page and the following in the error log that was generated:
[21-Aug-2014 16:40:08 America/Denver] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 990
[21-Aug-2014 16:40:08 America/Denver] PHP Fatal error: Call to a member function store_result() on a non-object in /home3/beadins1/public_html/bI1544+/includes/functions/extra_functions/easypopulate_4_functions.php on line 991
Now I am really showing my AGE!! Sorry - that was another client I was thinking about - not this one.
The only changes made on this site was in includes/modules/pages/page/header_php.php - as found in this post http://www.zen-cart.com/showthread.p...=1#post1256039
Quote:
Originally Posted by mc12345678
Okay, so to be sure the situation is/was understood, this site has never had EP4 fully functional? (Ie, wasn't a situation where it worked for a while then suddenly stopped working?Quote:
Originally Posted by stellarweb
It worked when I installed it on 8/14- it generated an ep file as it should have. A few days later, the client went to use it, and got the error and emailed me.
Thanks for your PM - I will check into that and get back with you.
Quote:
Originally Posted by mc12345678