CMS Made Simple Forums

Does anyone know if there's a limit on the maximum number of pages allowed per directory?  I tried to import 489 pages into one directory on my CMSMS site by importing CSV data into my database.  When I did, I couldn't see any pages at all in the CMSMS Admin Panel.  I did a lot of guessing and checking to find out that pages started to show up in the Admin Panel again when I reduced the number of pages just a little to around 480 pages.  I wondered if creating the last few remaining pages through the Admin Panel would also cause the pages to disappear from the Admin Panel, and it did.  So it seems that there's simply a limit to the number of pages that can be handled in a single directory before breaking the CMSMS Admin Panel.  Does anyone know if this is true or if there's a way around this problem?

I am using CMSMS 1.0.8 "Kona" and phpMyAdmin 2.8.0.1.  I imported data from an Excel spreadsheet that was converted to CSV format.  I was very careful to observe and figure out how to properly place data into columns that matched the database, so I'm reasonably certain that I correctly imported data.

Sure it's not a database size problem, can you check in the database interface to see how much....

I'm a database noob, so you'll have to explain what you mean more explicitly, mark.  Are you saying I should I should look at something in phpMyAdmin?  If so, where do I look?

In my hosting site Admin I have a link to the Database part, on that page I get an overview of my DB and how much space I'm using, I get 100mb and none of my sites have come close to it, 3.8mb on some...

stevehong wrote: I am using CMSMS 1.0.8 "Kona" and phpMyAdmin 2.8.0.1.  I imported data from an Excel spreadsheet that was converted to CSV format.  I was very careful to observe and figure out how to properly place data into columns that matched the database, so I'm reasonably certain that I correctly imported data.

Hello Steve,

I guess several people would like to know this mass import tip. Can you please provide a link or a howto ?

Pierre M.

Mark, the sum of my table sizes seems to be 699.5KB as reported by phpMyAdmin, and my hosting disk usage is 171MB out of 1000MB available.  I also had a chat with my host's tech support and they said there's not a limit on my database size.

I did some more guess and check and found that my problem is not limited to the number of pages in a single directory.  It seems I can't create any new pages in my parent directory or the root directory either.  In short, I seem to have reached the limit of total pages I can create without breaking the CMSMS Admin Panel.  The magic number seems to be 480, at any directory level.

I don't think that's a natural limitation of CMSMS, as I'm sure people have probably created large sites with more than 480 pages in CMSMS before.  Therefore, there must be something peculiar about the way I added these pages.  Maybe there's something else in my database that I overlooked updating/modifying.  I only modified the following tables: cms_content, cms_content_props, and cms_content_seq.  Do I need to change something in any other tables?

Anyone else have any ideas?

P.S. Pierre, I'd be happy to provide a How To posting about importing content from an Excel spreadsheet, but I'll wait until I work out the problems I'm experiencing so I don't lead anyone astray.

mysql> show tables like 'cms_content%';
+------------------------------+
| Tables_in_cms (cms_content%) |
+------------------------------+
| cms_content                  |
| cms_content_props            |
| cms_content_props_seq        |
| cms_content_seq              |
+------------------------------+
4 rows in set (0.00 sec)


which suggests that you also need to set cms_content_props_seq table to proper value for next id..

tsw, I noticed the cms_content_props_seq table before, but I don't know what it does.  I see one row with an id column set to a value of 15.  Unlike the id in the cms_content_seq table, this one doesn't seem to increment or change at all when I create new pages through the Admin Panel.  Should the id values in both of these tables be the same?  New pages created in the Admin Panel seem to assign the correct id values in cms_content_props, so I really don't understand what cms_content_props_seq is for.

What is the proper way to edit the cms_content_props_seq table?

We discussed what do with cms_content_seq in this other recent post about another issue I was having:
http://forum.cmsmadesimple.org/index.php/topic,14037.0.html

* The colors are merely for clarity of discussion to distinguish the similarly named tables.

stevehong wrote: P.S. Pierre, I'd be happy to provide a How To posting about importing content from an Excel spreadsheet, but I'll wait until I work out the problems I'm experiencing so I don't lead anyone astray.

Thank you Steve. You want quality. This is nice.
Early experience sharing may also provide more eyes for a problem review.

Pierre M.