You're upgrading from 5.3.2 right?

You may want to try removing the primary key on that table. The try the upgrade again.
Here's a query that will drop the the primary key.



After the upgrade completes, verify that the FileAttributeValues table has a new primary key.

thanks for help.. but after that I get a new errer:

An Unexpected Error occurred while upgrading: mysql error: [1054: Unknown column 'value' in 'field list'] in EXECUTE("select akHandle, value, akType from CollectionAttributeValues inner join CollectionAttributeKeys on CollectionAttributeKeys.akID = CollectionAttributeValues.akID where cID = '27' and cvID = '1'")

Dear all,

I get this error as well - I managed to surpass this one, and get yet another one to a neverending cascade of errors. There seems to be something more fundamental wrong - any ideas?

need to see what those errors are.
wouldn't hurt to see a call to phpInfo() so we know what your system looks like.

thx

I had the same error during upgrade, and I followed your suggestion and removed the primary keys from the table. I continued the upgrade process and it went smoothly. But now my Page Attributes are missing. I checked the table and there still is no Primary Key.

Any idea how to get them back?

When I did a clean install on a test site, the Page Attributes came in perfect.

Go to: Dashboard -> Sitewide Settings -> Debug -> Refresh Core database tables & blocks.

Take a peak in the db, see if your primary key is in there, if not add it back:

(or change to CollectionAttributeValues if that's the one you're having trouble with)

Then Re-Run the upgrade script by clicking the link in:
index.php/tools/required/upgrade.php

the "Refresh Core database tables & blocks" function is not there in 5.3.2...
Franz, I've included the phpinfo output from my server. Thanks for the help! André

This is my FileAttributeValues table before the upgrade (running on 5.3.2) - maybe this helps..

Upgrading from 5.3.2 to 5.3.3.1 and got the error...

An Unexpected Error occurred while upgrading: mysql error: [1062: Duplicate entry '9-1' for key 1] in EXECUTE("ALTER TABLE FileAttributeValues DROP COLUMN fakID")

In phpAdmin executed the following SQL code...

ALTER TABLE FileAttributeValues DROP PRIMARY KEY;

Reclicked on the Upgrade and it worked.

Thanks

Hi I had the same (1062 Duplicate entry.....) problem, and droped the primary key as suggested. I now have this error.

Any help appricated.

An unexpected error occurred.
mysql error: [1054: Unknown column 'ak_exclude_nav' in 'where clause'] in EXECUTE("select distinct p1.cID, if(p2.cID is null, pt1.ctHandle, pt2.ctHandle) as ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PageTypes pt1 on (pt1.ctID = p1.ctID) left join PageTypes pt2 on (pt2.ctID = p2.ctID) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID)) left join PagePermissions pp1 on (pp1.cID = p1.cInheritPermissionsFromCID) left join PagePermissions pp2 on (pp2.cID = p2.cInheritPermissionsFromCID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cvName != '' and (ak_exclude_nav = 0 or ak_exclude_nav is null) and p1.cParentID = '45' and cvIsApproved = 1 and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((pp1.cgPermissions like 'r%' and (pp1.gID in (2,3,1) or pp1.uID = 2)) or (pp2.cgPermissions like 'r%' and (pp2.gID in (2,3,1) or pp2.uID = 2))) order by p1.cDisplayOrder asc limit 0,99 ")

that it is only on the home page?
Also to let you know, I'm running this on WAMP localy.

Make sure that there is an attribute with the handle exclude_nav in:
Dashboard -> Pages and Themes -> Page Types -> Attributes

Then try running the search index job.

Hopefully that'll straiten it out

can see you know your stuff. Sorted.
Thanks.

Have now noticed this problem when copying a page in the sitemap.

Unable to load sitemap data. Response received: <br />
<b>Fatal error</b>: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'value' in 'field list'] in EXECUTE(&quot;select akID, cvID, value from CollectionAttributeValues where cID = '60'&quot;)
' in C:\wamp\www\www.oblossom.co.za\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78
Stack trace:
#0 C:\wamp\www\www.oblossom.co.za\concrete\libraries\3rdparty\adodb\adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'select akID, cv...', false, Object(ADODB_mysql))
#1 C:\wamp\www\www.oblossom.co.za\concrete\libraries\3rdparty\adodb\adodb.inc.php(998): ADOConnection-&gt;_Execute('select akID, cv...')
#2 C:\wamp\www\www.oblossom.co.za\concrete\libraries\3rdparty\adodb\adodb.inc.php(766): ADOConnection-&gt;Execute('select akID, cv...', Array)
#3 [internal function]: ADOConnection-&gt;Query('select akID, cv...', Array)
#4 C:\wamp\www\www.oblossom.co.za\concrete\libraries\database.php(73): call_user_func_array(Array, Array)
#5 [internal function]: Database-&gt;__call('query', Array)
#6 C: in <b>C:\wamp\www\www.oblossom.co.za\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php</b> on line <b>78</b><br />

The sitemap copy bug has been reported by a couple other folks. We'll get that one fixed and release a maintenance release in a couple days.

mysql error: [1146: Table 'database_concrete5.collectionversionblockstyles' doesn't exist] in EXECUTE("SELECT bs.*, b.bID, cvb.cID FROM CollectionVersionBlocks AS cvb INNER JOIN Blocks AS b ON (cvb.bID = b.bID) LEFT JOIN CollectionVersionBlockStyles AS bs ON bs.bID=b.bID WHERE cvb.cID = '1' AND (cvb.cvID = '32' OR cvb.cbIncludeAll=1)").

Running a WIMP server (yah, yah I know) WinServer2008 Enterprise, IIS7, PHP5.2.9-1 and MySQL 5.1.37

Checking with phpMyAdmin, that table does NOT exist as the error message states. Checking my export files back several gens, don't see it. What now? I can create the table manually, but
don't know the data def for table nor what should be in it.

tried a clean install with empty DB. Now getting this MySQL error:

mysql error: [1366: Incorrect integer value: 'ASET_ALLOW_NONE' for column 'akCategoryAllowSets' at row 1] in EXECUTE("insert into AttributeKeyCategories (akCategoryHandle, akCategoryAllowSets, pkgID) values ('collection', 'ASET_ALLOW_NONE', NULL)")

I tried to run the insert into this table with phpMyAdmin. It failed with the same error. ran it again but changing the insert to

insert into AttributeKeyCategories (akCategoryHandle, akCategoryAllowSets, pkgID) values ('collection', '1', NULL)

worked for me. So accordingly the error states that for akCategoryAllowSets field the data must be type integer and the install is not using an integer.

So, upgrade fails, fresh install fails. In a holding pattern on this. Too bad, sounds like some of the enhancements are things I've been looking for, or trying to implement on my own.

Stop to high-jack this thread as the original topic is still not fixed.

were you able to figure out the issue? I am having the same problem.

A new version of Concrete has just been released. Have you tried it out yet? It might solve your issue

If anyone gets this duplicate key error it's caused by these renamed attribute tables:



So, if you're making a second attempt at an upgrade and you restore your original database make sure that those tables don't exist after your database is restored.

thanks for your help! Now I get the following error:

An Unexpected Error occurred while upgrading: mysql error: [1146: Table 'monobasic.CollectionAttributeKeys' doesn't exist] in EXECUTE("select akHandle, value, akType from CollectionAttributeValues inner join CollectionAttributeKeys on CollectionAttributeKeys.akID = CollectionAttributeValues.akID where cID = '27' and cvID = '1'")


Do you need a full db dump from me?
cheers

Has this issue ever been resolved?

Trying to upgrade from 5.3.2 to 5.3.3 and having the same issues. Tried dropping the primary key as suggested above, but when the upgrade script was run again, all of the page attribute information was missing. (and this customer has lots of pages and attributes :) ) Looking at the FileAttributesValues table, fID and fvID had the correct information, but akID and avID were all zeros. When I tried to re-add "Add primary key" to the FileAttributesValues table (as suggested above) I received another duplicate table entry error because the data looked something like this:

fID fvID akID avID
1 1 0 0
1 1 0 0
2 2 0 0
2 2 0 0

etc.

Is there another table where the correct akID and avID information reside so that we can copy it to this table? Unfortunately I don't even know if this is the only table that is messed up. This is the only one that seemed to give an error.

We have quite a few customers that require an upgrade so we need to get this issue resolved.

Thanks for your help!

Upgraded from 5.3.2 to 5.4.1.1

Okay this is what I had to do so far to fix this error. First roll back or restore you database back to the original.
Then empty 2 tables.
fileattributevalues
That fixes the first problem. However when I upgrade at this point once I get in to the dashboard and go to attributes on a folder in the Sitemap I get an error.
So then I cleared;
collectionattributevalues
Then that fixed that problem.

So to get it to work with out much error. Clear those two and then update. You will still get an error, but click run update again and it will go through.

HOWEVER this will delete all page attributes like exclude from nav, meta data ect.
After this was done I had to manually add back my Attributes options under Pages and Themes, then click Attributes.
If you can't find the originals look in the table collectionattributekeys
they're still there. exclude from nav and exclude from search index are check box's when you are making new ones.

By the way this is not a fix all. In the end this is just a crazy problem. I have a feeling the upgrade didn't do everything it was tasked to.

TheHinac