Creating a Container

[Cordir]

Today, I attempted to create a container. It was takeable, reset closed.
The Workshop provided this bug:
`ActiveRecord::StatementInvalid in ObjsController#create
PG::InsufficientPrivilege: ERROR: permission denied for relation objs : INSERT INTO "objs" ("area_id", "cost", "created_at", "extra_flags", "keywords", "ldesc", "misc_flags", "object_type", "sdesc", "updated_at", "v0", "v1", "v2", "v3", "vnum", "wear_flags", "weight") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) RETURNING "id"

Extracted source (around line #92):
90
91
92
93
94
95

@obj.wear_flags ||= 0

if @obj.save
  @area.update(:last_updated_at => Time.now, :last_updated_by => current_user.id)
  redirect_to area_obj_path(@area, @obj), notice: 'Object was sucessfully created.'
else

Rails.root: /app

Application Trace | Framework Trace | Full Trace
app/controllers/objs_controller.rb:92:in `create'
Request

Parameters:

{"utf8"=>"✓",
"authenticity_token"=>"94PBT0HYKbMrSEypFOzGJrJ8pnyIaspFgEQEB0N8pGQ=",
"obj"=>{"vnum"=>"39",
"keywords"=>"rucksack",
"sdesc"=>"a stained and worn brown leather rucksack",
"ldesc"=>"One of the straps of this stained,
brown leather rucksack is partially torn.",
"object_type"=>"15",
"v0"=>"41",
"v1"=>"5",
"v2"=>"0",
"v3"=>"0",
"takeable"=>"1",
"glow"=>"0",
"hum"=>"0",
"evil"=>"0",
"invis"=>"0",
"magic"=>"0",
"nodrop"=>"0",
"anti_good"=>"0",
"anti_evil"=>"0",
"anti_neutral"=>"0",
"noremove"=>"0",
"inventory"=>"0",
"metallic"=>"0",
"good"=>"0",
"not_purgable"=>"0",
"flammable"=>"0",
"two_handed"=>"0",
"use_cost"=>"0",
"anti_unalign"=>"0",
"neutral"=>"0",
"no_hoard"=>"0",
"masked"=>"0",
"underwater_breath"=>"0",
"wear_flags"=>"16384",
"weight"=>"3",
"cost"=>"0"},
"obj_capacity"=>"38",
"ContainerKeyVnumRadioOptions"=>"3",
"commit"=>"Create Obj",
"area_id"=>"8"}
Toggle session dump
Toggle env dump
Response

Headers:

None`

[Cordir]

Since it didn't like me creating one, I tried copying an existing container. That also generated a crash/bug/issue.

ActiveRecord::StatementInvalid in ObjsController#new
PG::InsufficientPrivilege: ERROR: permission denied for relation objs : INSERT INTO "objs" ("area_id", "cost", "created_at", "extra_flags", "keywords", "ldesc", "misc_flags", "object_type", "sdesc", "updated_at", "v0", "v1", "v2", "v3", "vnum", "wear_flags", "weight") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) RETURNING "id"

Extracted source (around line #29):
27
28
29
30
31
32

  new_obj = base_obj.dup
  new_obj.vnum = @area.nextobjvnum
  new_obj.save

  base_obj.oxdescs.each do |oxdesc|
    new_oxdesc = oxdesc.dup

Rails.root: /app

Application Trace | Framework Trace | Full Trace
app/controllers/objs_controller.rb:29:in `new'
Request

Parameters:

{"copy_obj"=>"4699",
"area_id"=>"8"}
Toggle session dump
Toggle env dump
Response

Headers:

None

[abagby]

The database is full and nothing can be added until it's back under 10k lines or we upgrade. Regards, Adam J. Bagby

…

-------- Original message -------- From: Cordir <[email protected]> Date: 8/21/17 1:14 PM (GMT-07:00) To: Gwyrdain/apprentices-workshop <[email protected]> Cc: Subscribed <[email protected]> Subject: [Gwyrdain/apprentices-workshop] Creating a Container (#164) Today, I attempted to create a container. It was takeable, reset closed. The Workshop provided this bug: `ActiveRecord::StatementInvalid in ObjsController#create PG::InsufficientPrivilege: ERROR: permission denied for relation objs : INSERT INTO "objs" ("area_id", "cost", "created_at", "extra_flags", "keywords", "ldesc", "misc_flags", "object_type", "sdesc", "updated_at", "v0", "v1", "v2", "v3", "vnum", "wear_flags", "weight") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) RETURNING "id" Extracted source (around line #92<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Gwyrdain_apprentices-2Dworkshop_issues_92&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=ron1XdPmTmo7bCd9cHa8cSk4gHec6ttg88qFdcbDpnU&e=>): 90 91 92 93 94 95 @obj.wear_flags ||= 0 if @obj.save @area.update(:last_updated_at => Time.now, :last_updated_by => current_user.id) redirect_to area_obj_path(@area, @obj), notice: 'Object was sucessfully created.' else Rails.root: /app Application Trace | Framework Trace | Full Trace app/controllers/objs_controller.rb:92:in `create' Request Parameters: {"utf8"=>"?", "authenticity_token"=>"94PBT0HYKbMrSEypFOzGJrJ8pnyIaspFgEQEB0N8pGQ=", "obj"=>{"vnum"=>"39", "keywords"=>"rucksack", "sdesc"=>"a stained and worn brown leather rucksack", "ldesc"=>"One of the straps of this stained, brown leather rucksack is partially torn.", "object_type"=>"15", "v0"=>"41", "v1"=>"5", "v2"=>"0", "v3"=>"0", "takeable"=>"1", "glow"=>"0", "hum"=>"0", "evil"=>"0", "invis"=>"0", "magic"=>"0", "nodrop"=>"0", "anti_good"=>"0", "anti_evil"=>"0", "anti_neutral"=>"0", "noremove"=>"0", "inventory"=>"0", "metallic"=>"0", "good"=>"0", "not_purgable"=>"0", "flammable"=>"0", "two_handed"=>"0", "use_cost"=>"0", "anti_unalign"=>"0", "neutral"=>"0", "no_hoard"=>"0", "masked"=>"0", "underwater_breath"=>"0", "wear_flags"=>"16384", "weight"=>"3", "cost"=>"0"}, "obj_capacity"=>"38", "ContainerKeyVnumRadioOptions"=>"3", "commit"=>"Create Obj", "area_id"=>"8"} Toggle session dump Toggle env dump Response Headers: None` - You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Gwyrdain_apprentices-2Dworkshop_issues_164&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=ARgzyCzXRQpin6iRUvB2STiQJ_o7lmV1kTAYGEBzq6c&e=>, or mute the thread<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AQFxiTkBd552jzaokAKzFEGt867gnKQaks5saeU3gaJpZM4O9xrH&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=db7y-aopp5m7up_lkBkK1zQtu8BNbghPylyeSb3nL6U&e=>.

[Cordir]

Thank you for the reply 😊 I've deleted a couple very big zones... but that didn't seem to help. Tokugawa, if you have a copy of the Grand library up on the Workshop, could you delete it, now that it's installed, since it's a monster?

…

-c

________________________________ From: abagby <[email protected]> Sent: Monday, August 21, 2017 3:22 PM To: Gwyrdain/apprentices-workshop Cc: Cordir; Author Subject: Re: [Gwyrdain/apprentices-workshop] Creating a Container (#164) The database is full and nothing can be added until it's back under 10k lines or we upgrade. Regards, Adam J. Bagby

-------- Original message -------- From: Cordir <[email protected]> Date: 8/21/17 1:14 PM (GMT-07:00) To: Gwyrdain/apprentices-workshop <[email protected]> Cc: Subscribed <[email protected]> Subject: [Gwyrdain/apprentices-workshop] Creating a Container (#164) Today, I attempted to create a container. It was takeable, reset closed. The Workshop provided this bug: `ActiveRecord::StatementInvalid in ObjsController#create PG::InsufficientPrivilege: ERROR: permission denied for relation objs : INSERT INTO "objs" ("area_id", "cost", "created_at", "extra_flags", "keywords", "ldesc", "misc_flags", "object_type", "sdesc", "updated_at", "v0", "v1", "v2", "v3", "vnum", "wear_flags", "weight") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17) RETURNING "id" Extracted source (around line #92<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Gwyrdain_apprentices-2Dworkshop_issues_92&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=ron1XdPmTmo7bCd9cHa8cSk4gHec6ttg88qFdcbDpnU&e=>): 90 91 92 93 94 95 @obj.wear_flags ||= 0 if @obj.save @area.update(:last_updated_at => Time.now, :last_updated_by => current_user.id) redirect_to area_obj_path(@area, @obj), notice: 'Object was sucessfully created.' else Rails.root: /app Application Trace | Framework Trace | Full Trace app/controllers/objs_controller.rb:92:in `create' Request Parameters: {"utf8"=>"?", "authenticity_token"=>"94PBT0HYKbMrSEypFOzGJrJ8pnyIaspFgEQEB0N8pGQ=", "obj"=>{"vnum"=>"39", "keywords"=>"rucksack", "sdesc"=>"a stained and worn brown leather rucksack", "ldesc"=>"One of the straps of this stained, brown leather rucksack is partially torn.", "object_type"=>"15", "v0"=>"41", "v1"=>"5", "v2"=>"0", "v3"=>"0", "takeable"=>"1", "glow"=>"0", "hum"=>"0", "evil"=>"0", "invis"=>"0", "magic"=>"0", "nodrop"=>"0", "anti_good"=>"0", "anti_evil"=>"0", "anti_neutral"=>"0", "noremove"=>"0", "inventory"=>"0", "metallic"=>"0", "good"=>"0", "not_purgable"=>"0", "flammable"=>"0", "two_handed"=>"0", "use_cost"=>"0", "anti_unalign"=>"0", "neutral"=>"0", "no_hoard"=>"0", "masked"=>"0", "underwater_breath"=>"0", "wear_flags"=>"16384", "weight"=>"3", "cost"=>"0"}, "obj_capacity"=>"38", "ContainerKeyVnumRadioOptions"=>"3", "commit"=>"Create Obj", "area_id"=>"8"} Toggle session dump Toggle env dump Response Headers: None` - You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_Gwyrdain_apprentices-2Dworkshop_issues_164&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=ARgzyCzXRQpin6iRUvB2STiQJ_o7lmV1kTAYGEBzq6c&e=>, or mute the thread<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_AQFxiTkBd552jzaokAKzFEGt867gnKQaks5saeU3gaJpZM4O9xrH&d=DQMFaQ&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=U8HlXHAuaJQd10K1bAfk6chPsie69zIZXzfp-R-omd4&m=Fknn2ohqOK7_I7Y6tjGggiyG-TbGugfxruSiq-pCf5E&s=db7y-aopp5m7up_lkBkK1zQtu8BNbghPylyeSb3nL6U&e=>. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#164 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AKYs-c1uDgVhZfN3I8NzfNq4FzQGSfAWks5saecKgaJpZM4O9xrH>.