search

Gwyrdain / apprentices-workshop

Creative Commons Zero v1.0 Universal
5 stars 2 forks source link

Creating a Container #164

Open Cordir opened 7 years ago

Cordir commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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 notifications@github.com Date: 8/21/17 1:14 PM (GMT-07:00) To: Gwyrdain/apprentices-workshop apprentices-workshop@noreply.github.com Cc: Subscribed subscribed@noreply.github.com 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 #92https://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 GitHubhttps://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 threadhttps://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 commented 7 years ago

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 notifications@github.com 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 notifications@github.com Date: 8/21/17 1:14 PM (GMT-07:00) To: Gwyrdain/apprentices-workshop apprentices-workshop@noreply.github.com Cc: Subscribed subscribed@noreply.github.com 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 #92https://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 GitHubhttps://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 threadhttps://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 GitHubhttps://github.com/Gwyrdain/apprentices-workshop/issues/164#issuecomment-323843162, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKYs-c1uDgVhZfN3I8NzfNq4FzQGSfAWks5saecKgaJpZM4O9xrH.