New Content not appearing on Current Pages

[tonyrap]

After upgrade from 1.2 to 1.4.1 new content doesn't appear in Current Pages list, even though "The content was successfully added to the database" message appears. Edits to existing pages work fine.

I ran debug and found just one error: "Error (1062): Duplicate entry '157' for key 1"

Any help would be appreciated.

[alby]

I ran debug and found just one error: "Error (1062): Duplicate entry '157' for key 1"

maybe don't work your [cms_]content_seq table

Alby

[tonyrap]

Thanks, Alby,

Do you have any suggestions about how to check or fix the table?

  –  Tony

[tonyrap]

I've tried a few more things with no luck:

I restored the files and database to v.1.2, got the same problem (I can edit existing content, but not add new content, even though the message "Content has been successfully created: appears: the new pages are not in the list or available on the site.

I installed v. 1.4.1 fresh, everything worked fine, then I imported my database: same problem.

Any help would be appreciated!

  –  Tony

[tonyrap]

I ran debug and got 1 error:

Debug: (0.126362) - (7986160)


(mysql): INSERT INTO cms_content (content_id, content_name, content_alias, type, owner_id, parent_id, template_id, item_order, hierarchy, id_hierarchy, active, default_content, show_in_menu, cachable, menu_text, markup, metadata, titleattribute, accesskey, tabindex, last_modified_by, create_date, modified_date) VALUES (154,'test','test','content','1','-1','20',20,'','',1,0,1,1,'test','html','','','','','1','2008-11-17 00:21:02','2008-11-17 00:21:02')
Error (1062): Duplicate entry '154' for key 1

Debug: (0.126427) - (7985528)

  –  Tony

[alby]

I installed v. 1.4.1 fresh, everything worked fine, then I imported my database: same problem.

With a SQL tool (ex: phpmyadmin):
- go in content table and look MAX content_id ( SELECT MAX(content_id) FROM cms_content )
- go in content_seq and check if you have same number

Alby

[tonyrap]

Thanks, Alby,

I couldn't find MAX(content_id) in the cms_content table. Could you tell me where that is?

My cms_content table has 106 rows. The cms_content_seq table has 2 rows.

When I display the cms_content_seq table, I see an error message that says, "No index defined!"

  –  Tony

[alby]

I couldn't find MAX(content_id) in the cms_content table. Could you tell me where that is?

It's a SQL query: select maximum value of content_id field from cms_content table
or order by content_id your table and look for maximum value

My cms_content table has 106 rows. The cms_content_seq table has 2 rows.

When I display the cms_content_seq table, I see an error message that says, "No index defined!"

no problem for index but BIG problem for 2 rows!!
In cms_content_seq table there is 1 row and id = maximum value of content_id in the cms_content table
Remove second row and update id with maximum value

Alby