Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007604opensim[GRID] Robust Serverpublic2015-06-06 12:012015-06-25 08:04
ReporterGavin Hird 
Assigned To 
Statuspatch includedResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0007604: DeleteClassifiedRecord exception PGSQL
DescriptionDeleting a classified record from a user profile throws the error message below when running with the PGSQL database and the classified is not deleted from the database.

20:49:56 - [PROFILES_DATA]: DeleteClassifiedRecord exception Npgsql.NpgsqlException:
syntax error at or near ":"
Severity: ERROR
Code: 42601
  at Npgsql.NpgsqlState+<ProcessBackendResponses_Ver_3>d__a.MoveNext () [0x00000] in <filename unknown>:0
  at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject () [0x00000] in <filename unknown>:0
Steps To ReproduceDelete a classified from the avatar profiles when the backend database is PGSQL.
Additional InformationI get this response when using Singularity. Kokua does not seem to even get that far, but classifieds in general don't seem to work much at all in version 3 based viewers. Probably needs to be looked further into.
TagsNo tags attached.
Git Revision or version number
Run Mode Grid (Multiple Regions per Sim)
Physics EngineBulletSim
Script Engine
EnvironmentMono / OSX
Mono VersionOther
Attached Files? file icon PGSQLUserProfilesData.cs [^] (47,631 bytes) 2015-06-23 11:00

- Relationships
related to 0007503patch included Estate ban request raise exception - banned user data not written to database 
related to 0007398closedorenh PGSQL module - typecasting issues 
related to 0007606closedorenh Group handler exception - PGSQL 

-  Notes
Gavin Hird (reporter)
2015-06-06 12:40

Added 3 related as these are all bugs in the PGSQL adapter.
Gavin Hird (reporter)
2015-06-23 11:01
edited on: 2015-06-23 11:02

Line 222 had ClassifiedID misspelled. With the enclosed file the code now works and correctly deletes a classified from the database.

dahlia (administrator)
2015-06-24 04:10

Thanks for the fix. Applied via commit r3aa9e786de10. PGSQL users please test and comment.
Gavin Hird (reporter)
2015-06-24 23:23

Thanks Dahlia. Perhaps you would be good to take 7456 also. This is a non-destructive database migration for os_group_notices to be able to send group notes without attachments.
Gavin Hird (reporter)
2015-06-25 08:04
edited on: 2015-06-25 08:05

@Dahlia, could you please test this for me because both creating a user Pick or a Classified number 2 will overwrite the first one, meaning each avatar can just create one of each.

So is this a general feature, or a feature of the PGSQL code only? :-))

- Issue History
Date Modified Username Field Change
2015-06-06 12:01 Gavin Hird New Issue
2015-06-06 12:26 Gavin Hird Relationship added related to 0007503
2015-06-06 12:28 Gavin Hird Relationship added related to 0007398
2015-06-06 12:39 Gavin Hird Relationship added related to 0007606
2015-06-06 12:40 Gavin Hird Note Added: 0028629
2015-06-23 11:00 Gavin Hird File Added: PGSQLUserProfilesData.cs
2015-06-23 11:01 Gavin Hird Note Added: 0028784
2015-06-23 11:02 Gavin Hird Status new => patch included
2015-06-23 11:02 Gavin Hird Note Edited: 0028784 View Revisions
2015-06-24 04:10 dahlia Note Added: 0028799
2015-06-24 23:23 Gavin Hird Note Added: 0028801
2015-06-25 08:04 Gavin Hird Note Added: 0028806
2015-06-25 08:04 Gavin Hird Note Edited: 0028806 View Revisions
2015-06-25 08:05 Gavin Hird Note Edited: 0028806 View Revisions

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker