Thread

This question may be related to a resolved thread.

We had this issue again, CommArts was our developer for the site and we’ve been running smoothly since the handover a few months ago. 

The program pages URI information has been deleted again - 9/20/11

I’m restoring a 12 gig daily backup so hopefully we won’t be forced to manually create a few hundred entries.

What do we need to do to relieve ourselves of this problem in the future?

Thanks

Thomas

Thomas,

It would seem that you are running into the storage limits as outlined in the previous thread. I’m going to escalate this concern to the Devs to see if they can offer a way to increase the storage size on the appropriate database field.

Cheers,

This question may be related to a resolved thread. 

The thread above is about our current website, CommArts is the company we utilized to create our new mpbonline.org

This issue has happened again and has forced us to stop posting new pages and news stories to our site.

I need some help to get us to resolve the issue.

Thanks,
Thomas

Ah- yes, I’d avoid using pages for every uri.  But it should be a simple matter to make the field take more data.  Backup your exp_sites table and be sure you’re comfortable rolling back.  Then I’d just change it to a longtext field a la

ALTER TABLE exp_sites MODIFY site_pages LONGTEXT NOT NULL;

You can run that in phpmyadmin or in ‘Tools- Data- SQL Manager’- longtext will give you more room than I can ever imagine needing.

Do be sure to backup, though.  Always backup before manipulating the db directly!

I have a good back up in place, so I’ll try this.

Thanks

from Tools- Data- SQL Manager I click on Manage Database Tables , select the tick box for exp_sites then browse but I don’t see where to make any changes to the field type or the table.

After a bit of experimenting, found the query field and this seems to have worked.

Thanks.  I’ll post if the issue continues.

Hi Thomas,

I’ve put together a quick video showing where it is that you need to go to :

Database Query Form

Hope that helps a bit.

Mark

the larger issue is what is a better way to handle the pages - how do we handle this recommendation?

“Ah- yes, I’d avoid using pages for every uri”

Thomas,

ExpressionEngine’s standard URL handling scheme should be use in most cases. That is determined in a pattern that resembles template-group/template/entry-title. Perhaps a look at Understanding EE URLS can shed some light on the process. The crux of it is, you can use template-group/templates to mimic folder/file structures, for example: http://yoursite.com/news/article/headline_title

Let us know if you have any further questions.

Cheers,

Is there anything else we can do to help, Thomas?