Hi,
I have v.1.5.8 and made all of my customizations and installed my addons in Wamp server on my local computer to make necessary adjustments and insure that everything works well.
I have now uploaded this version to my website inside a subfolder. After integrating my current database, when I go to Admin->Tools->EZ Pages none of them are showing in there and I do not have a button to create a new EZ Page.
When looking in my database, both the EZ Pages and EZ Pages content are there and have all of the right information in there.
In looking at my logs, I have this error:
PHP Fatal error: 1060uplicate column name 'pages_title' :: SELECT count(*) as total FROM (SELECT e.*, ec.pages_title, ec.pages_html_text FROM zen_ezpages e INNER JOIN zen_ezpages_content ec ON (e.pages_id=ec.pages_id AND ec.languages_id = 1) ORDER BY e.toc_chapter, e.toc_sort_order, ec.pages_title) countresults ==> (as called by) /home/mysite/public_html/new158/myadmin/includes/classes/split_page_results.php on line 220 <== in /home/mysite/public_html/new158/includes/classes/db/mysql/query_factory.php on line 667.
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.
If someone could please point me to what this error is referring to and how to fix this, I would appreciate it.
Thanks in advance,
Jeff
Bookmarks