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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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