MySQL Error when upgrading from 5.3.2 to 5.3.3.1
Permalink
I had a website built on Concrete 5.3.1. I needed to install an addon available only for 5.3.3 and up, so I went on to install the latest 5.3 release.
I upgraded from 5.3.1 to 5.3.2, like specified. The process was easy, everything went smooth. I tested the whole website afterwards, it worked flawlessly.
I then upgraded from 5.3.2 to 5.3.3.1. At first I had memory issues which I fixed using a solution I found in the forums. But now, everytime I try to open a page, I get this error.
—
An unexpected error occurred.
mysql error: [1146: Table 'danieldo_concrete.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
—
What am I supposed to do? Redo the website?
—
EDIT : I have looked through the database in phpmyadmin, and the table called FileAttributeKeys that Concrete seems to be looking for is nowhere to be found. Why?
I upgraded from 5.3.1 to 5.3.2, like specified. The process was easy, everything went smooth. I tested the whole website afterwards, it worked flawlessly.
I then upgraded from 5.3.2 to 5.3.3.1. At first I had memory issues which I fixed using a solution I found in the forums. But now, everytime I try to open a page, I get this error.
—
An unexpected error occurred.
mysql error: [1146: Table 'danieldo_concrete.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
—
What am I supposed to do? Redo the website?
—
EDIT : I have looked through the database in phpmyadmin, and the table called FileAttributeKeys that Concrete seems to be looking for is nowhere to be found. Why?
I have exactly the same issue with a 5.3.3.1 upgrade to 5.4
Anyone? Please? I'm in a bit of a panic here.
Can no one answer this question?? I have 7 sites I would like to upgrade to version 5.4 but can't run the risk if this is going to happen to all of them!
Would you believe it? After days of messing around and nothing much happening, I have solved this problem. My issue was that the 'Home' page of my site had an asmiller gallery image on it that was causing the problem.
Whenever I visited the site, because it was my home page, I got this error!
How i fixed it was to type in a URL to another page that did not have the asmiller gallery on ithttp://u10girls.hawkwellfc/index.php/contact...
Once there, I logged into the site and from the 'add functionality' link in the dashboard, I simply removed all instances of the asmiller galleria package from my site.
It is a lot less painfull to add galleries back rather than to re-do the entire site!!
Hope this helps.
Whenever I visited the site, because it was my home page, I got this error!
How i fixed it was to type in a URL to another page that did not have the asmiller gallery on ithttp://u10girls.hawkwellfc/index.php/contact...
Once there, I logged into the site and from the 'add functionality' link in the dashboard, I simply removed all instances of the asmiller galleria package from my site.
It is a lot less painfull to add galleries back rather than to re-do the entire site!!
Hope this helps.
Do you know what danieldo refers to? Was it a custom block? If it's installed. Try uninstalling it and or reinstall. have you cleared you Concrete5 cache in the dashboard before attempting to do the upgrade?
lol, i see you posted just as i did. glad you fixed it! Sounded like a block specific problem...
Hi
Have the same problem just upgraded my site from 3.2 to 5.4. Following error if I try to add a asmiller gallery block:
An unexpected error occurred.
mysql error: [1146: Table 'zczh2009_cms.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
How can I solve it?
Have the same problem just upgraded my site from 3.2 to 5.4. Following error if I try to add a asmiller gallery block:
An unexpected error occurred.
mysql error: [1146: Table 'zczh2009_cms.FileAttributeKeys' doesn't exist] in EXECUTE("SELECT fakID FROM FileAttributeKeys WHERE akName = 'height' LIMIT 1")
How can I solve it?
