Hi, I have an ongoing issue with folders. I have a portfolio that uses three folders to display entries in sections. I have amended one of the folder titles and now entries from two of the entries show in the third folder. Any help or insight would be appreciated. I can provide the url via pm.

PS, if I change which folder an item is in I get this error the next time I load the master page:

Could not successfully run query: Duplicate entry '6-residential' for key 'couch_folders_Index02'

If I then clear my browser history and reload the page works with the amended changes.

Thanks,

Mark

[KK]

Hi Mark,

I think you are using statically defined folders (i.e. vis cms:folder tag). Right?
From what you described, it seems the folder configuration has messed up bad.

I suggest you please use 'dynamic' folders instead. You can find full info here -
http://www.couchcms.com/docs/miscellane ... lders.html

I'm sorry it'll mean a little rework for you adding the pages back into their respective folders but ,in the end, this method will prove to be much more flexible as you'll be able to create/modify/delete folders and move pages between them on the fly.

Hope it helps.

thanks, that looks like it will resolve the issue. I'll let you know how I get on.

Hi Mark,

I think you are using statically defined folders (i.e. vis cms:folder tag). Right?
From what you described, it seems the folder configuration has messed up bad.

I suggest you please use 'dynamic' folders instead. You can find full info here -
http://www.couchcms.com/docs/miscellane ... lders.html

I'm sorry it'll mean a little rework for you adding the pages back into their respective folders but ,in the end, this method will prove to be much more flexible as you'll be able to create/modify/delete folders and move pages between them on the fly.

Hope it helps.

That did the trick, thanks a lot!

[KK]

You are welcome

Hi, I thought that this issue was resolved. However, the client is now trying to edit text content and is getting this error:

Could not successfully run query: Table 'ghdecora_web.couch_fulltext' doesn't exist

It seems like the database has got a bit confused Any ideas?

[KK]

Could not successfully run query: Table 'ghdecora_web.couch_fulltext' doesn't exist

That is indeed weird and, yes, it suggests the database is corrupt.
I've seen this happen only on a couple of occasions and this happens when the host makes changes to the database server and messes up in the process (couch_fulltext is the only MyISAM table and is the most vulnerable. Rest of the tables are innoDB and have better chances of surviving).

Anyway, it is good we haven't lost all the tables else the only way forward would have been to use a saved backup of the site (hope you are taking those).

For now we can get away with a re-install of only the database.

To do so, we'll use the method described at http://www.couchcms.com/docs/miscellane ... erver.html which is normally done to migrate installation from one machine to another.

We'll use it to migrate only the database contents into new tables.
This is how we'll do it.

1. While logged-in as super-admin, type http://www.yoursitename.com/couch/gen_dump.php in the admin-panel's address bar (change the site name and admin folder as required).
2. Save the 'install_ex.php' thus produced into the existing admin folder of your site (usually the 'couch' folder)
3. This step is the most important - edit couch/config.php and put some prefix into the following setting e.g. 'new_'

// 7b.
// Needed only if multiple instances of this CMS are to be installed in the same database
// (please use only alphanumeric characters or underscore (NO hyphen) )
define( 'K_DB_TABLES_PREFIX', 'new_' );

4. Now access http://www.yoursitename.com/couch/ and you should see a prompt for new installation of Couch. Go ahead as this will create new tables and move the original data into them.

You should now have the same site as before.

Hope it helps.

Thanks for getting back to me. We take twice daily backups of the database and site root. I'll attempt a reinstall and report back.

Thanks,

Mark

Thanks KK,

that resolved the issue.

Regards,

Mark

[KK]

I'm glad, Mark. Thanks for letting us know.