EasyPopulate 4.0 Support Thread

[wtashby]

Can you verify your version of PHP and MySQL?

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

Zen Cart 1.5.3
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

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

[mc12345678]

Zen Cart 1.5.3
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

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?

[wtashby]

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?

You can click on my signature for that answer. I only use uri's. I never use ip addresses.

[mc12345678]

You can click on my signature for that answer. I only use uri's. I never use ip addresses.

Hmm, okay wasn't sure, at least that's not the issue.

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.)

[chadderuski]

Zen Cart 1.5.3
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

mysqli
MysqlI Support	enabled
Client API library version 	5.5.32

This looks current.

[chadderuski]

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