Photoalbum photo order problem.
Asked Modified Viewed 1,560 times
asked
Dunno if anyone else has had this happen.
I did the upgrade from 4 to 6. I had a few existing photo albums in there before the upgrade.
Since then, when I add new albums or photos, the existing albums get messed up.
The way they are affected is that when you use the "next" link on the photo viewing page, the link liks back to the photo album as opposed to the next pic. (as if it were the last pic in the album, how it goes back to the album's "homepage" listing the thumbnails.)
I took a look in my database and found that the photo_order field gets messed up with "1"s being written over them. Odd.
Anything obvious that I'm missing? Here's a dump of my fusion_photos table.
I'm debating just deleteing all of the albums, and re-uploading them all to see if that helps unless anybody might see whats up.
My current fusion install is updated with the latest patches.
thanks for looking.
Scott
I did the upgrade from 4 to 6. I had a few existing photo albums in there before the upgrade.
Since then, when I add new albums or photos, the existing albums get messed up.
The way they are affected is that when you use the "next" link on the photo viewing page, the link liks back to the photo album as opposed to the next pic. (as if it were the last pic in the album, how it goes back to the album's "homepage" listing the thumbnails.)
I took a look in my database and found that the photo_order field gets messed up with "1"s being written over them. Odd.
Anything obvious that I'm missing? Here's a dump of my fusion_photos table.
Code Download source
Table structure for table fusion_photos
--
CREATE TABLE fusion_photos (
photo_id smallint(5) unsigned NOT NULL auto_increment,
album_id smallint(5) unsigned NOT NULL default '0',
photo_title varchar(50) NOT NULL default '',
photo_date int(10) unsigned NOT NULL default '0',
user_id smallint(5) unsigned NOT NULL default '0',
photo_views smallint(5) unsigned NOT NULL default '0',
photo_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (photo_id)
) TYPE=MyISAM AUTO_INCREMENT=207 ;
--
-- Dumping data for table fusion_photos
--
INSERT INTO fusion_photos VALUES (36, 5, '1', 1092002297, 1, 138, 1);
INSERT INTO fusion_photos VALUES (37, 5, '2', 1092002306, 1, 225, 1);
INSERT INTO fusion_photos VALUES (38, 5, '3', 1092002314, 1, 151, 1);
INSERT INTO fusion_photos VALUES (39, 5, '4', 1092002321, 1, 159, 1);
INSERT INTO fusion_photos VALUES (40, 5, '5', 1092002333, 1, 153, 1);
INSERT INTO fusion_photos VALUES (41, 5, '6', 1092002344, 1, 171, 1);
INSERT INTO fusion_photos VALUES (42, 5, '7', 1092002355, 1, 138, 2);
INSERT INTO fusion_photos VALUES (43, 5, '8', 1092002363, 1, 169, 3);
INSERT INTO fusion_photos VALUES (44, 5, '9', 1092002413, 1, 164, 5);
INSERT INTO fusion_photos VALUES (55, 5, '10', 1092620334, 1, 143, 6);
INSERT INTO fusion_photos VALUES (56, 5, '11', 1092620376, 1, 219, 7);
INSERT INTO fusion_photos VALUES (57, 5, '12', 1092620436, 1, 196, 8);
INSERT INTO fusion_photos VALUES (58, 5, '13', 1092620483, 1, 123, 9);
INSERT INTO fusion_photos VALUES (59, 5, '14', 1092620561, 1, 161, 1);
INSERT INTO fusion_photos VALUES (60, 5, '15', 1092620640, 1, 155, 1);
INSERT INTO fusion_photos VALUES (61, 5, '16', 1092620707, 1, 143, 1);
INSERT INTO fusion_photos VALUES (62, 5, '17', 1092620767, 1, 143, 1);
INSERT INTO fusion_photos VALUES (63, 5, '18', 1092620828, 1, 146, 1);
INSERT INTO fusion_photos VALUES (64, 5, '19', 1092620890, 1, 170, 1);
INSERT INTO fusion_photos VALUES (65, 5, '20', 1092621221, 1, 129, 1);
INSERT INTO fusion_photos VALUES (83, 7, 'red haze', 1118436697, 66, 28, 1);
INSERT INTO fusion_photos VALUES (84, 7, 'hi', 1118436921, 66, 32, 1);
INSERT INTO fusion_photos VALUES (86, 8, '1', 1118609876, 1, 10, 1);
INSERT INTO fusion_photos VALUES (87, 8, '2', 1118609914, 1, 9, 1);
INSERT INTO fusion_photos VALUES (88, 8, '3', 1118609981, 1, 8, 1);
INSERT INTO fusion_photos VALUES (89, 8, '4', 1118609999, 1, 9, 1);
INSERT INTO fusion_photos VALUES (90, 8, '5', 1118610011, 1, 12, 1);
INSERT INTO fusion_photos VALUES (91, 8, '6', 1118610022, 1, 10, 1);
INSERT INTO fusion_photos VALUES (92, 8, '7', 1118610031, 1, 5, 2);
INSERT INTO fusion_photos VALUES (93, 8, '8', 1118610051, 1, 12, 3);
INSERT INTO fusion_photos VALUES (94, 8, '9', 1118610080, 1, 12, 4);
INSERT INTO fusion_photos VALUES (95, 8, '10', 1118610091, 1, 11, 5);
INSERT INTO fusion_photos VALUES (98, 8, '12', 1118610176, 1, 14, 6);
INSERT INTO fusion_photos VALUES (99, 8, '13', 1118610191, 1, 8, 7);
INSERT INTO fusion_photos VALUES (100, 8, '14', 1118610203, 1, 8, 8);
INSERT INTO fusion_photos VALUES (101, 8, '15', 1118610219, 1, 8, 9);
INSERT INTO fusion_photos VALUES (102, 8, '16', 1118610243, 1, 11, 10);
INSERT INTO fusion_photos VALUES (103, 8, '17', 1118610259, 1, 14, 11);
INSERT INTO fusion_photos VALUES (104, 8, '18', 1118610276, 1, 15, 12);
INSERT INTO fusion_photos VALUES (105, 8, '19', 1118610286, 1, 13, 13);
INSERT INTO fusion_photos VALUES (106, 8, '20', 1118610295, 1, 13, 14);
INSERT INTO fusion_photos VALUES (107, 8, '21', 1118610302, 1, 18, 15);
INSERT INTO fusion_photos VALUES (108, 8, '22', 1118610312, 1, 11, 16);
INSERT INTO fusion_photos VALUES (110, 9, '2', 1118612283, 1, 8, 1);
INSERT INTO fusion_photos VALUES (109, 9, '1', 1118612274, 1, 7, 1);
INSERT INTO fusion_photos VALUES (111, 9, '3', 1118612291, 1, 13, 1);
INSERT INTO fusion_photos VALUES (112, 9, '4', 1118612299, 1, 17, 1);
INSERT INTO fusion_photos VALUES (113, 9, '5', 1118612308, 1, 11, 1);
INSERT INTO fusion_photos VALUES (114, 9, '6', 1118612316, 1, 15, 1);
INSERT INTO fusion_photos VALUES (115, 9, '7', 1118612327, 1, 9, 2);
INSERT INTO fusion_photos VALUES (116, 9, '8', 1118612334, 1, 11, 3);
INSERT INTO fusion_photos VALUES (117, 9, '9', 1118612346, 1, 8, 4);
INSERT INTO fusion_photos VALUES (118, 10, '1', 1118614574, 1, 12, 1);
INSERT INTO fusion_photos VALUES (119, 10, '2', 1118614580, 1, 14, 1);
INSERT INTO fusion_photos VALUES (120, 10, '3', 1118614586, 1, 18, 1);
INSERT INTO fusion_photos VALUES (121, 10, '4', 1118614593, 1, 16, 1);
INSERT INTO fusion_photos VALUES (122, 10, '5', 1118614599, 1, 16, 1);
INSERT INTO fusion_photos VALUES (124, 10, '6', 1118614616, 1, 13, 1);
INSERT INTO fusion_photos VALUES (125, 10, '7', 1118614622, 1, 12, 3);
INSERT INTO fusion_photos VALUES (126, 10, '8', 1118614630, 1, 15, 4);
INSERT INTO fusion_photos VALUES (127, 10, '9', 1118614639, 1, 14, 5);
INSERT INTO fusion_photos VALUES (128, 10, '10', 1118614655, 1, 13, 6);
INSERT INTO fusion_photos VALUES (129, 10, '11', 1118614661, 1, 11, 7);
INSERT INTO fusion_photos VALUES (130, 10, '12', 1118614666, 1, 13, 8);
INSERT INTO fusion_photos VALUES (131, 10, '13', 1118614676, 1, 14, 9);
INSERT INTO fusion_photos VALUES (132, 10, '14', 1118614687, 1, 12, 10);
INSERT INTO fusion_photos VALUES (133, 10, '15', 1118614694, 1, 10, 11);
INSERT INTO fusion_photos VALUES (134, 10, '16', 1118614700, 1, 11, 2);
INSERT INTO fusion_photos VALUES (135, 10, '17', 1118614708, 1, 10, 12);
INSERT INTO fusion_photos VALUES (136, 10, '18', 1118614717, 1, 10, 13);
INSERT INTO fusion_photos VALUES (137, 10, '19', 1118614737, 1, 7, 14);
INSERT INTO fusion_photos VALUES (138, 10, '20', 1118614744, 1, 15, 15);
INSERT INTO fusion_photos VALUES (139, 10, '21', 1118614749, 1, 9, 16);
INSERT INTO fusion_photos VALUES (140, 10, '22', 1118614755, 1, 9, 17);
INSERT INTO fusion_photos VALUES (141, 10, '23', 1118614762, 1, 10, 18);
INSERT INTO fusion_photos VALUES (142, 10, '24', 1118614801, 1, 7, 19);
INSERT INTO fusion_photos VALUES (144, 10, '26', 1118614828, 1, 10, 20);
INSERT INTO fusion_photos VALUES (146, 10, '25', 1118615004, 1, 6, 21);
INSERT INTO fusion_photos VALUES (147, 10, '27', 1118615204, 1, 14, 22);
INSERT INTO fusion_photos VALUES (196, 11, 'raw13', 1120427580, 1, 3, 8);
INSERT INTO fusion_photos VALUES (200, 11, 'raw16', 1120427631, 1, 5, 11);
INSERT INTO fusion_photos VALUES (199, 11, 'raw15', 1120427616, 1, 3, 10);
INSERT INTO fusion_photos VALUES (198, 11, 'raw14', 1120427608, 1, 5, 9);
INSERT INTO fusion_photos VALUES (185, 11, 'raw2', 1120427474, 1, 9, 16);
INSERT INTO fusion_photos VALUES (184, 11, 'raw1', 1120427464, 1, 14, 1);
INSERT INTO fusion_photos VALUES (195, 11, 'raw12', 1120427571, 1, 4, 7);
INSERT INTO fusion_photos VALUES (194, 11, 'raw11', 1120427560, 1, 4, 6);
INSERT INTO fusion_photos VALUES (193, 11, 'raw10', 1120427549, 1, 5, 5);
INSERT INTO fusion_photos VALUES (192, 11, 'raw9', 1120427537, 1, 4, 4);
INSERT INTO fusion_photos VALUES (191, 11, 'raw8', 1120427527, 1, 5, 3);
INSERT INTO fusion_photos VALUES (190, 11, 'raw7', 1120427518, 1, 5, 2);
INSERT INTO fusion_photos VALUES (189, 11, 'raw6', 1120427509, 1, 5, 14);
INSERT INTO fusion_photos VALUES (205, 11, 'raw4', 1120441023, 1, 3, 13);
INSERT INTO fusion_photos VALUES (186, 11, 'raw3', 1120427483, 1, 6, 15);
INSERT INTO fusion_photos VALUES (201, 11, 'raw17', 1120427656, 1, 4, 12);
INSERT INTO fusion_photos VALUES (206, 11, 'raw5', 1120441538, 1, 1, 17);
INSERT INTO fusion_photos VALUES (166, 12, '2', 1120426701, 1, 3, 1);
INSERT INTO fusion_photos VALUES (165, 12, '1', 1120426692, 1, 2, 1);
INSERT INTO fusion_photos VALUES (167, 12, '3', 1120426709, 1, 2, 1);
INSERT INTO fusion_photos VALUES (169, 12, '5', 1120426727, 1, 4, 2);
INSERT INTO fusion_photos VALUES (168, 12, '4', 1120426718, 1, 2, 3);
INSERT INTO fusion_photos VALUES (170, 12, '6', 1120426737, 1, 3, 1);
INSERT INTO fusion_photos VALUES (171, 12, '7', 1120426746, 1, 4, 1);
INSERT INTO fusion_photos VALUES (172, 12, '8', 1120426755, 1, 2, 1);
INSERT INTO fusion_photos VALUES (175, 13, '3', 1120426958, 1, 1, 1);
INSERT INTO fusion_photos VALUES (174, 13, '2', 1120426951, 1, 2, 1);
INSERT INTO fusion_photos VALUES (178, 13, '6', 1120426988, 1, 1, 1);
INSERT INTO fusion_photos VALUES (180, 13, '8', 1120427008, 1, 4, 1);
INSERT INTO fusion_photos VALUES (179, 13, '7', 1120426998, 1, 2, 1);
INSERT INTO fusion_photos VALUES (177, 13, '5', 1120426980, 1, 2, 1);
INSERT INTO fusion_photos VALUES (176, 13, '4', 1120426971, 1, 2, 2);
INSERT INTO fusion_photos VALUES (173, 13, '1', 1120426943, 1, 1, 3);
INSERT INTO fusion_photos VALUES (181, 13, '9', 1120427019, 1, 1, 1);
INSERT INTO fusion_photos VALUES (182, 13, '10', 1120427033, 1, 2, 1);
INSERT INTO fusion_photos VALUES (183, 13, '11', 1120427044, 1, 4, 1);
I'm debating just deleteing all of the albums, and re-uploading them all to see if that helps unless anybody might see whats up.
My current fusion install is updated with the latest patches.
thanks for looking.
Scott
Category Forum
Bugs and Errors - 6Labels
None yet
Statistics
- Views 0 views
- Posts 1 post
- Votes 0 votes
- Topic users 2 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions