2 unnecessary fields are added to the tables 2 unnecessary fields are added to the tables
 

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

Main Menu

2 unnecessary fields are added to the tables

Started by Andi, August 22, 2004, 03:38:23 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Andi

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 ?
hope, I could help you... :)

lamama

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?


Nibbler

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