Ticket #79 (closed Bug report: fixed)

Opened 13 years ago

Last modified 12 years ago

error when uploading a picture and editing it.

Reported by: kaouete@… Owned by: max-horvath
Priority: normal Milestone: WifiDog Auth Server 1.0
Component: Auth server, Content Management Version: Auth Server SVN
Keywords: Cc:

Description

i get this error when i upload a content picture.

Warning: pg_query() [function.pg-query]: Query failed: ERROR: column "remote_size" of relation "files" does not exist in /var/www/wifidog/classes/AbstractDbPostgres.php on line 306

execSqlUpdate(): An error occured while executing the following SQL query :

UPDATE files SET remote_size = 0 WHERE files_id='77d4c770ec0abd52ec96aa598cb88aca'

Error message : ERROR: column "remote_size" of relation "files" does not exist

Change History

Changed 13 years ago by kaouete@…

looks like my schema was not updated like it should have been, i will investigate it more.

Changed 13 years ago by kaouete@…

this column wath just missing, looks like it was created with the TABLE in schema rev 9, so i dont know why i didnt had it, but when it was added it was int8 and not bigint. (bigint is the type in the dump in the sql dir)

Changed 13 years ago by max-horvath

  • owner set to max-horvath
  • status changed from new to assigned
  • milestone set to WifiDog Auth Server 1.0

Fixed schema_validate.php (to create it with bigint) ... will be in SVN on my next commit ... anyway, nobody should be out there with a db schema < 9 ;) ...

Changed 13 years ago by max-horvath

  • status changed from assigned to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.