Easy Populate error 1062:Duplicate entry '1369-1'.

[chadlly2003]

I brought a new template and upgraded my site to zencart 1.5.4 all categories and products are displaying correctly.

I have installed the latest version of easy populate. I can export fine, but when I import I am getting an error PHP Fatal error: 1062uplicate entry '1369-1'.

I believe the cause is when I upgraded my site and brought it over to the new database it is being looked at as a duplicate or something.


Can someone assist me or lead me the right direction in solving this issue.

[mc12345678]

Unfortunately there is/has been more than one version of EasyPopulate. Could you be more descriptive and provide possibly a link to the forum/download of the version installed? Also, it always helps those reading in the future to provide the specific version number as the issue may relate to someone else and they may not be able to tell without that information.

[chadlly2003]

the download url: https://www.zen-cart.com/downloads.php?do=file&id=868
version downloaded: easy_populate_csv_for_zencart_v1.5.x_v1.2.6

"mc12345678" do you have any ideas why I am having these issues

[mc12345678]

the download url: https://www.zen-cart.com/downloads.php?do=file&id=868
version downloaded: easy_populate_csv_for_zencart_v1.5.x_v1.2.6

"mc12345678" do you have any ideas why I am having these issues

So I don't know the specific reason for that error, but it appears that the software is attempting to populate the database with information that already exists. This issue is probably best addressed in the forum for this plugin.

Would also note that it appears the error message has been truncated and that there might be additional info that could help troubleshoot it. But remember when posting to not include YOUR_SECRET_ADMIN folder name or database password if present.

[chadlly2003]

"but it appears that the software is attempting to populate the database with information that already exists." This statement is true because of the upgrade process. I need to keep the same url and categories structure.......

Here is the full error

[21-Oct-2015 15:56:13 Europe/Berlin] PHP Fatal error: 1062uplicate entry '1369-1' for key 'PRIMARY' :: INSERT INTO products_description SET
products_id = '1369',
language_id = '1',
products_name = 'AXS Port OutBack Modbus/TCP Interface Device',
products_description = 'The AXS Port Modbus TCP, now OPTICS RE compatible, is a powerful and economical tool that allows installers and system owners the ability to monitor and control system status from any location.<br /><br />\n \n \n When paired with OPTICS RE, the AXS Port interface offers advanced monitoring and control features including\n <ul>\n \n \n <li>Real-Time PV/Solar System Performance Monitoring via Intuitive Dashboard Interface From any Internet-Connected Device</li>\n <li>Efficient Management of Multiple OutBack Power System Installations Under One Account</li>\n <li>Remote Troubleshooting</li>\n <li>Reduced Onsite Service Calls and System Downtime</li>\n </ul>\n \n \n The AXS Port makes it possible to create custom user interfaces for systems using the advanced API program development kit* and download system data logs using Modbus-read or FTP transfer. All user-configurable values are backed up with non-volatile memory, ensuring stable performance and system recovery. An optional remote temperture-sensing function provides a simple, low-cost tool for capturing and reporting ambient temperture or other critical thermal information records.<br /><br />\n\nThe AXS Port is a SunSpec compliant device**, which means it speaks the renewable energy industry\'s common language used to drive data and interoperability standards for plug-and-play operation between components and management systems.<br /><br />\n \n <strong>Product Highlights</strong>\n \n <ul>\n <li>Remote system control and monitoring via web interface with OPTICS RE</li>\n <li>SunSpec-compliant device for interoperability and plug-and-play and operation</li>\n <li>Over two years of data logging</li>\n <li>Accessories include MicroSD memory and DIN-rail mounting clip</li>\n <li>Product Specifications | <a href=\"http://www.invertersupply.com/media/data/axsport_specsheet.pdf\" target=\"_blank\" ><span class=\"d_link\">Download</span></a></li>\n<li> Product Manual | <a href=\"http://www.invertersupply.com/media/data/axsss_manual.pdf\" target=\"_blank\" ><span class=\"d_link\">Download</span></a></li>\n </ul>\n<table class=\"zebra\">\r\n<thead>\r\n<tr><th colspan=\"3\">AXS Port Specifications</th></tr>\r\n</thead>\r\n<tbody>\r\n<tr>\r\n<td colspan=\"2\">Power</td>\r\n<td>Supplied by Outback device</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Status Indicators</td>\r\n<td>Seven LED indicators</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Clock</td>\r\n<td>On-board real-time clock with battery backup</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Internet Standards</td>\r\n<td>TCP/IP, DNS, SMTP, FTP, DHCP, NTP</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"3\">Ports</td>\r\n<td>HUB/Device</td>\r\n<td>RJ-45</td>\r\n</tr>\r\n<tr>\r\n<td>Communications</td>\r\n<td>RJ-45</td>\r\n</tr>\r\n<tr>\r\n<td>Temperature Sensor</td>\r\n<td>RJ-11</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Communication Protocol</td>\r\n<td>Modbus TCP to the SunSpec standard</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">OutBack Device Interface</td>\r\n<td>OutBack Proprietary</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">PC Interface</td>\r\n<td>10/100 Ethernet</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Mounting</td>\r\n<td>DIN clip (provided) or surface mounting</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Environmental Rating</td>\r\n<td>Indoor Type 1 (IP 30)Non-condensing</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"2\">Temperature Ranges</td>\r\n<td>AXS Port</td>\r\n<td>-40C to 75C</td>\r\n</tr>\r\n<tr>\r\n<td>SD Card</td>\r\n<td>-25C to 75C</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"2\">Weight</td>\r\n<td>Unit</td>\r\n<td>0.5 lbs / 0.23 kg</td>\r\n</tr>\r\n<tr>\r\n<td>Shipping</td>\r\n<td>2.1 lbs / 0.95 kg</td>\r\n</tr>\r\n<tr>\r\n<td rowspan=\"2\">Dimensions H x W x D</td>\r\n<td>Unit</td>\r\n<td>1.29 x 3.5 x 4.99 / 3.3 x 8.9 x 12.7 cm</td>\r\n</tr>\r\n<tr>\r\n<td>Shipping</td>\r\n<td>3.25 x 9 x 13.5 / 19 x 22.9 x 34.3 cm</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">SD Card Size</td>\r\n<td>2 GB capacity</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Options</td>\r\n<td>Outback RTS</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\">Certifications</td>\r\n<td>FCC Part 15 subpart B, CE, RoHS, SunSpec</td>\r\n</tr>\r\n</tbody>\r\n</table>',

products_url = ''
==> (as called by) C:\xampp\htdocs\zencart.com\power\easypopulate.php on line 2009 <== in C:\xampp\htdocs\zencart.com\includes\classes\db\mysql\query_factory.php on line 155

[mc12345678]

This is a slightly different issue than I was thinking, but same problem.

I thought the issue was related to installation, not to operation...

If you do wish to continue using this version of easypopulate then the issue should be investigated by review of the above thread and if a solution is not already posted there, then to inquire further. The problem seen is that when the csv has data for an a product that exists in the database, the product information is attempted to be inserted instead of updated...

If you wish to use a different version, then may I suggest EasyPopulate v4?

[chadlly2003]

I downloaded your recommendation and have the same issue. It will export but will not import. When I do the import it says successfull but nothing happens..

"I thought the issue was related to installation, not to operation..." correct the products are already in the database I just cant update anything but i can export.

[mc12345678]

I downloaded your recommendation and have the same issue. It will export but will not import. When I do the import it says successfull but nothing happens..

"I thought the issue was related to installation, not to operation..." correct the products are already in the database I just cant update anything but i can export.

Sorry to be a pain aboout terminology, but different issue.

Are you sure you fully followed through? Upload is different that import. Also, the version currently available from the first post of that forum doesn't yet support import by products_id. There is a test version with that functionality available from http://github.com/mc12345678 and requires a few setting changes in the configuration panel to support such functionality.

Results of an import are provided at the bottom of the screen below the box of filenames.

[chadlly2003]

Okay you were right https://github.com/chaddro/EasyPopulate-4.0 this seems to work. The only thing now is I am getting an error regarding maximum execution time. I changed the necessary files in my php.ini and restarted server and still getting this error. "though we are getting close"

[21-Oct-2015 18:44:41 Europe/Berlin] PHP Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\zencart.com\includes\classes\db\mysql\query_factory.php on line 43

[21-Oct-2015 18:44:41 Europe/Berlin] PHP Fatal error: Maximum execution time of 60 seconds exceeded in C:\xampp\htdocs\zencart.com\includes\functions\sessions.php on line 55

[chadlly2003]

hmm i changed my max-execution time via the php.ini file and I am still timing out. Is this an issue with script or am i missing something hear.