MarcC

Yes, it's the same error. Edit: Oh, I see--you mean depending on the table. Missed that. Some data are different from other data Let's try it...

I wonder if this is due to the collation being off. The old DB is latin1. :-/ (Edit: Seems the new one is too, so this isn't a problem)

Thanks Nik--that seemed to work with description, but it complains about `data`: Error SQL query: CREATE TABLE `field_body` ( `pages_id` INT( 10 ) UNSIGNED NOT NULL , `data` MEDIUMTEXT NOT NULL , PRIMARY KEY ( `pages_id` ) , KEY `data` ( `data` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8; MySQL said: #1170 - BLOB/TEXT column 'data' used in key specification without a key length [ And then I changed to FULLTEXT... ] Error SQL query: CREATE TABLE `field_display_specialty_footer` ( `pages_id` INT( 10 ) UNSIGNED NOT NULL , `data` INT( 11 ) NOT NULL , `sort` INT( 10 ) UNSIGNED NOT NULL , PRIMARY KEY ( `pages_id` , `sort` ) , FULLTEXT KEY `data` ( `data` , `pages_id` , `sort` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8; MySQL said: #1283 - Column 'data' cannot be part of FULLTEXT index

I exported from an existing PW site (using SQL Buddy) and I'm having troubles importing the data to PHPMyAdmin on a separate server. I get a bunch of errors like the following. Does anyone have advice on fixing this? This comes from a working PW site, but for some reason it's not importing. Unfortunately I no longer have access to the original PW site, just this SQL file. Here's the error--any help would be appreciated. ErrorSQL query: CREATE TABLE `field_content_images` ( `pages_id` INT( 10 ) UNSIGNED NOT NULL , `data` VARCHAR( 255 ) NOT NULL , `sort` INT( 10 ) UNSIGNED NOT NULL , `description` TEXT NOT NULL , PRIMARY KEY ( `pages_id` , `sort` ) , KEY `data` ( `data` ) , KEY `description` ( `description` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8; MySQL said: #1170 - BLOB/TEXT column 'description' used in key specification without a key length

Did the admin use bold, all-caps text in the body field of the home page? If so, show the "site-wide alert" field. ...nah

Wow, I actually said stuff while I watched this video but it came out like "aaaaaah" and "ohhhhhh" rather than "I've felt the need for this on several occasions! Bravo Ryan!" Thanks for sharing it with us.

OK...I don't understand that yet...has_parent!=2, so I guess has_parent is returning the ID of the parent? And the admin pages' parent is 2...how does that relate to being published or not?

Wow. I even tried "status>1" but I had no idea about include=all. Thanks!

<?php include("./index.php"); /* Template changes in bulk -- let's publish all events */ $pa = wire("pages")->find("template=event"); foreach($pa as $p) { $p->setOutputFormatting(false); $p->removeStatus(Page::statusUnpublished); $p->save(); echo "Done with {$p->title}; {$p->status}<br>"; } The result of the code above is "Done with [event title]; 1" for every already published page, and no unpublished pages have been touched. What am I doing wrong? I'm trying to publish every page with the event template. This is modified code from a bulk editing thread. I noticed that somebody else said he couldn't get a similar thing to work because a module was causing problems. I wonder which one? Thanks.

Have you looked at any of the others here? http://codecanyon.net/search?utf8=%E2%9C%93&term=quiz

Strange. Usually in the command line the double-pipe has a meaning like, "if the first part didn't work, do this next part." So like, "succeed at doing A, OR do B."

I use Freemind and Inkscape for basic brainstorming and planning. I planned a pretty big server migration by charting it out in Inkscape and zooming in / working on each part of the chart as work proceeded. The chart ended up looking pretty cool, and it really helped put a large piece of work behind me fast. I own a copy of Illustrator but Inkscape is better IMO as a quick vector sketchbook / illustration tool. I use a little shell script to play a sound every 20 minutes so I know to look 20 feet away for 20 seconds (20/20/20 rule). My eyes have been dry so it's helpful, and a good reminder to review what I'm working on to see where I'm at and where I need to be. I use KeePassX to store passwords, which I save in a cloud-based file hosting service so the encrypted password file is synced up on my other devices as well. I use iTerm2 instead of the default Mac OS X terminal application, and fish instead of the normal shell (csh?). I like fish so far. I use nvALT for tons and tons of journaling and note-taking. I am seeking a Mac OS equivalent of Zim Wiki though, with an enforced parent/child structure visible in the sidebar. Finally I use Blender to make animated intros for videos for my clients from time to time, and Art of Illusion to sketch out ideas for rearranging furniture in my office.

I think I see what you mean. I don't want to give the idea that I'm against it, either--having created pages like that both in and outside of the admin area. But I had a few experiences where I made really weird decisions until I understood how Ryan's experience added up to a big picture where you get a system that seems to scale really well when it comes time to tweak the original tweaks.

Hm, yeah, just making the tab is dead easy. I just made a new page under the hidden "Admin" page, published it, and I had a new tab. But it is asking for a process to associate with. So what I would recommend next is reading Soma's post, here: http://processwire.com/talk/topic/1272-new-page-nav-in-admin/#entry11276

Welcome! That's a really good & interesting question. One thing I'd suggest is to read this article and Ryan's comments below it: http://gadgetopia.com/post/7242 He talks about "bucket" CMS software, which is really part of what you're talking about, if I'm reading you right. So read what he says about how he prefers to arrange data and see what you think. It could be that you end up writing a really neat system on top of ProcessWire, and I've actually spoken about other CMS developers on that subject, but I think it's a good idea to understand ProcessWire's aims & successes first. I'll hold off on admin tab advice because it's been a while since I've done that and my knowledge may be outdated.

I like it! I personally prefer single-column layouts or maybe 1+sidebar for this sort of information, because my lazy brain tries to gain a sense of hierarchy really fast. But I think the color scheme is great and you're on the right track for a fun personal site-type logo. *ahem* I have at least three. I would write more but I'm afraid you'll realize I'm stealing all your secrets you'll steal all my secrets.

Ohhh...that would make sense. Thanks.

I have no problem looking in the source. Maybe I'll just do that. Thanks.

I tried "-1 day" on a whim and it worked, so I'm curious where I can find other selectors for date fields? I tried searching the forums, cheat sheet, and selectors page on the main site. Thanks!

Nice one, Ryan! Thanks for the tip on echoing before save, too.

The functionality doesn't seem like it would be hard to write yourself as a (really) short module, but I'm not sure if a module would be necessary (i.e. it might already be in core somehow).

Does this help? http://processwire.com/talk/topic/3719-other-permissions-like-page-publish/

Thanks Alessio!

I have this task: For any page with "event" template and a date field that is showing a date older than date N, unpublish the event. I need this to happen fairly regularly--is this a good task for lazy cron? Thanks!

Thanks Ryan! This is really great and a huge timesaver. Also learning new stuff about 2.3 this way is ideal.