Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: 2 unnecessary fields are added to the tables  (Read 4791 times)

0 Members and 1 Guest are viewing this topic.

Andi

  • VIP
  • Coppermine regular visitor
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 85
  • Join the Future
    • www.pragmamx.org
2 unnecessary fields are added to the tables
« on: August 22, 2004, 03:38:23 pm »

Hello :)

Version 1.3.2

In update.sql 2 (apparent) unnecessary fields are added to the tables.
Not surely perhaps already for version 1.4?

line # 209
ALTER TABLE `CPG_pictures` ADD `lasthit_ip` TINYTEXT ;
line # 215
ALTER TABLE `CPG_users` ADD `user_favpics` TEXT ;

I think this 2 fields are not used in v1.3.2 ?
Logged
hope, I could help you... :)

lamama

  • Contributor
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 404
Re: 2 unnecessary fields are added to the tables
« Reply #1 on: December 02, 2004, 10:27:46 am »

No answer since August?

I have a question that goes the same direction:
- is the field lasthit_ip already used for something inside 1.3.2 (or probalby 1.4),
- can it be used it for some 1.3.2-hack (actually: write the users ip here) or will this crash with some future use?

Logged

Nibbler

  • Guest
Re: 2 unnecessary fields are added to the tables
« Reply #2 on: December 02, 2004, 12:11:29 pm »

lasthit_ip is used to store the last ip to see that picture, that's why it is full of ip addresses. You can see them in the lasthits meta album. user_favpics shouldn't be there, and has its own table as of 1.4
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.