# \[ANN\] Simpler reorder extension

**URL:** <https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664>\
**Category:** Radiant CMS\
**Created:** [November 19, 2007, 4:58pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664 "2007-11-19T16:58:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [November 19, 2007, 4:58pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/1 "2007-11-19T16:58:02Z")

</div>

With Adam’s permission, I have replaced the reorder extension in the  
Radiant repository with the simpler one I developed recently. Instead  
of adding a separate view with drag-and-drop, it adds up/down/top/bottom  
buttons to the sitemap.

You can use Subversion to download it from:

[http://dev.radiantcms.org/svn/radiant/trunk/extensions/reorder](http://dev.radiantcms.org/svn/radiant/trunk/extensions/reorder)

Enjoy!

Sean

---

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [November 21, 2007, 8:50pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/2 "2007-11-21T20:50:52Z")

</div>

Hey Sean,

Upon trying to run “rake production db:migrate:extensions” I am  
getting the following error:

## undefined method `page’ for #Radiant::AdminUI:0x40804734

Any idea why? This is a gem install of version 0.6.4 with the Shards  
extension from the trunk installed.

Thanks,

–  
Travis B.  
Not sent from my iPhone.

---

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [November 21, 2007, 9:33pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/3 "2007-11-21T21:33:06Z")

</div>

Yup, that did it.

Thanks,

–  
Travis B.  
Not sent from my iPhone.

---

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [November 21, 2007, 10:13pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/4 "2007-11-21T22:13:07Z")

</div>

I seem to be getting an error when I try and delete pages with the  
Reorder extension enabled. The log reports the following:

## ActiveRecord::StatementInvalid (SQLite3::SQLException: SQL logic

error or missing database: UPDATE page

Any idea? The second I disable the Reorder extension, I can delete  
the page just fine.

Thanks,

–  
Travis B.  
Not sent from my iPhone.

---

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [January 1, 2008, 12:09am UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/5 "2008-01-01T00:09:36Z")

</div>

I had this problem as well.

Checking the logs and running the SQL in the console gave this error:

sqlite\> UPDATE pages SET “created\_at” = ‘2007-12-31 22:43:04’,  
“meta\_keywords” = ‘’, “meta\_description” = ‘’, “layout\_id” = NULL,  
“virtual”  
= ‘f’, “position” = NULL, “updated\_by” = 1, “title” = ‘Bob’‘s Page’,  
“published\_at” = ‘2008-01-01 11:43:04’, “created\_by” = 1, “breadcrumb” =  
‘Bob’‘s Page’, “class\_name” = ‘Page’, “parent\_id” = 1, “updated\_at” =  
‘2007-12-31 22:53:32’, “status\_id” = 100, “lock\_version” = 2, “slug” =  
‘bobs-page’ WHERE id = 14 AND “lock\_version” = 1;  
_SQL error: pages.position may not be NULL_

---

<div class="post-metadata">

**Author:** ![smc7000](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ed655f/32.png) [@smc7000](https://www.ruby-forum.com/u/smc7000)\
**Post date:** [November 21, 2007, 9:13pm UTC](https://www.ruby-forum.com/t/ann-simpler-reorder-extension/120664/6 "2007-11-21T21:13:07Z")

</div>

That generally occurs when you don’t have the loading order set in  
config/environment.rb of your project. It should look like this:

config.extensions = [:shards, :all]

Alternatively, you can rename the vendor/extensions/shards directory  
to vendor/extensions/00\_shards.

Sean