Duplicate Mysql query

[Pauls]

There appears to be a duplicate Mysql query executing with same field in the primary key I am not sure what is causing this problem, I have recently upgraged the site from 1.5.3 to 1.5.5a and I have recently installed the responsive theme sheffield blue ... so lots of potential for where the problem might be I guess. Here is the exact problem being logged by zencart admin.

PHP Fatal error: 1062: Duplicate entry 'zc_6f04dac868865df99eb25f13ecae29f6' for key 'PRIMARY' :: insert into cabdb_cache set cache_entry_name = 'zc_6f04dac868865df99eb25f13ecae29f6'

This happens lots of times by the way, hope somebody can help, thanks.

I am also getting a parse error
PHP Parse error: syntax error, unexpected $end in /public_html/includes/languages/english/schneiderstyle/time_out.php on line 19 - that (schneiderstyle) is in an older override folder I no longer use .... again any thoughts gratefully appreciated.

[lat9]

When you did your upgrade, did you pick up the change to /includes/classes/cache.php? In an as-shipped Zen Cart 1.5.5a file-set, there's no INSERT INTO the cache database table; it's been updated to an INSERT IGNORE INTO.

[mc12345678]

That issue of the duplicate key was resolved definitely in ZC 1.5.5 and I thought sooner (it at least made one of the known bugs list for one of the recent earlier versions.)

Suggest double checking the upgrade (how was it performed?).

As to the "random" override, either something else is purposefully loading that file or the template is considered active in your tools->template selection area. Or possibly the database entries in your configure.php files are incorrect (make sure that your DB_PREFIX is the same in both includes/configure.php and admin/includes/configure.php as well matches the same in your files of the store before upgrade.

[Pauls]

Hi lat9,
thanks for the quick response, here is what my current cache.php states
$sql = "insert ignore into " . TABLE_DB_CACHE . " (cache_entry_name, cache_data, cache_entry_created) VALUES (:cachename, :cachedata, unix_timestamp() )";

So I think that is how it should be if I understand you correctly.

[Pauls]

That issue of the duplicate key was resolved definitely in ZC 1.5.5 and I thought sooner (it at least made one of the known bugs list for one of the recent earlier versions.)

Suggest double checking the upgrade (how was it performed?).

As to the "random" override, either something else is purposefully loading that file or the template is considered active in your tools->template selection area. Or possibly the database entries in your configure.php files are incorrect (make sure that your DB_PREFIX is the same in both includes/configure.php and admin/includes/configure.php as well matches the same in your files of the store before upgrade.

This is a difficult one to answer MC ... I upgraded to the best of my ability .... and followed the instructions as much as possible, I could have made a mistake anywhere along the way ... and likely probably did ... could you help me narrow it down, where would you begin to look for the duplicate key error?

Will check through your suggestions for the override, thanks.

[mc12345678]

This is a difficult one to answer MC ... I upgraded to the best of my ability .... and followed the instructions as much as possible, I could have made a mistake anywhere along the way ... and likely probably did ... could you help me narrow it down, where would you begin to look for the duplicate key error?

Will check through your suggestions for the override, thanks.

Well, "from here" it would help to know which instructions. And even with that, did you load a complete fileset of the latest 1.5.5a to somewhere on your server (not overwriting the existing store), and then incorporate differences from your previous store, or did you copy all of the stores files and then incorporate the differences from ZC 1.5.5a into it? That type of thing.

I would however, suggest looking into the configure.php files as the primary suspicion. Wondering if they in part refeerence to the old store location that is still there and perhaps old data in the database that has gotten upgraded.

[Pauls]

Well, "from here" it would help to know which instructions. And even with that, did you load a complete fileset of the latest 1.5.5a to somewhere on your server (not overwriting the existing store), and then incorporate differences from your previous store, or did you copy all of the stores files and then incorporate the differences from ZC 1.5.5a into it? That type of thing.

I would however, suggest looking into the configure.php files as the primary suspicion. Wondering if they in part refeerence to the old store location that is still there and perhaps old data in the database that has gotten upgraded.

OK well, I uploaded the files needed for a ZC installation and followed the prompts from the ZC_install page thereafter ... this was if I recall correctly an 'upgrade' not a complete new site, which relied upon and still uses the previous 1.5.3 version database from which the site was previously running. Because you mentioned the config files I did take a look at them, and found that the 'define('SQL_CACHE_METHOD', 'database');' was set to database ... in the previous version I had that set to none ... so I have changed it in both configs includes, and admin/includes to 'none'. Not sure whether that will help but it may be relevant?

I am also getting a fair few of this error include(/public_html/includes/modules/responsive_sheffield_blue/product_listing.php) called at [/public_html/includes/templates/responsive_sheffield_blue/templates/tpl_modules_product_listing.php:
for various different pages in the template not just the one mentioned there ...

And this which I believe is not a template file but a zencart file, a fair few of these errors too.
PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total ==> (as called by) public_html/includes/classes/split_page_results.php on line 78 <== in /public_html/includes/classes/db/mysql/query_factory.php on line 167

regards

Paul

[mc12345678]

Okay, so first thing is to try working from your most recent error log, resolve that and then the most recent one after solving that, etc. Until no error logs are being generated.


Considering that the most recently posted logs relate to the responsive sheffield blue template, the place to start would be to look in the thread related to that template. Start from the end of the thread (a discussion related to the issues you've posted about has been had many times over and there is assistance associated to it.)

As to the configure.php files, that particular setting isn't normally expected to cause the error(s) identified.

As to the upgrade/rebuild, well, still not very clear about whether the new files were put into their own directory and other things added to them or if they were uploaded over top a copy or the original files. If the former, then other files wouldn't be "in the way", if the later (which it kind of seems like) then there are possibly files still around that were removed between ZC 1.5.3 and 1.5.5x.

One of the generally suggested instructions to perform an upgrade (which involves loading a fresh install of the files to some location/folder that is not immediately where the live site's files are and a copy of the database to do what is necessary to get the database updated, the needed plugins installed/upgraded and then repeating necessary actions against the live site. That is: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

[Pauls]

Thanks for the advice and logic MC will give it a shot and see what develops.

[lat9]

@Pauls, it would help if you would post the full debug-log contents. Zen Cart 1.5.5a includes the myDebug Backtrace handling that will display a backtrace (i.e. which PHP modules were in the calling sequence when the error occurred).

@mc12345678, The "duplicate key" issue that was corrected in Zen Cart 1.5.5a had to do with the sessions table, not the cache table.