EZ Pages Not Showing In Admin Panel

[swguy]

This is a known bug in Zen Cart. For older databases with prefixes, some of the updates failed.
Fix is easy; see

https://www.zen-cart.com/showthread....72#post1390772

[carlwhat]

This is a known bug in Zen Cart. For older databases with prefixes, some of the updates failed.
Fix is easy; see

https://www.zen-cart.com/showthread....72#post1390772

...
Not sure where I have gone wrong.....It appears from this error that I have a duplicate column name, but have checked in my database to see and there is only 1 column titled 'pages_title' in EZ Pages and EZ Pages Content tables.
...

swguy, the known bug that you mention refers to a duplicate column in the ezpages table:

ALTER TABLE ezpages DROP COLUMN pages_title;

the OP states that he checked both tables. which is why i made my recommendation.

[NWCE]

Hi carlwhat,

Thanks very much for passing this along! I have run the SQL statement and it has corrected my issue where I can now see my EZ Pages and also have the button back to Add New.

Thanks again for sharing this,

Jeff

[swguy]

You're welcome. Thanks for confirming that it was the database upgrade issue, as I suspected. This bug has been fixed but users with prefixes who have already upgraded will have to take the manual step you did.