Repairing Albums table Repairing Albums table
 

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

Repairing Albums table

Started by tonyl09, May 16, 2005, 02:49:49 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

tonyl09

May 16, 2005, 02:49:49 PM
We had an albums table get corrupted, and when repaired I can see that a half dozen albums are missing. I can get the aid's by doing a SELECT DISTINCT on the pictures table to add the records back into the albums table, but am wondering what the "pos" column is for. It appears to be the numerical order of albums within the parent category starting at 100. Is that correct?

Thank you -- Tony
Print
Go Up Pages1
User actions