Ticket #79 (closed Bug report: fixed)

Opened 7 years ago

Last modified 6 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

Attachments

Change History

Changed 7 years ago by kaouete@…

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

Changed 7 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 7 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 7 years ago by max-horvath

  • status changed from assigned to closed
  • resolution set to fixed

Add/Change #79 (error when uploading a picture and editing it.)

Author


E-mail address and user name can be saved in the Preferences.


Action
as closed
The resolution will be deleted. Next status will be 'reopened'
 
Note: See TracTickets for help on using tickets.