blog documentation FAQ followers forum marketplace services youtube

Forum category transfer shows error

The Jamroom Network » Forum » Using Jamroom » Page » Forum category transfer shows error
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
On my jamroom.net profile, I tried to transfer a post from Test1 into General and got the following error:
Quote: Query Error: Duplicate entry '6-0-general' for key 'view_unique'

Then when tying to submit this new topic I got:
Invalid forum category - please try again


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
updated by @ultrajam: 12/14/13 12:52:13PM
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
It kept doing this, so I emptied a category (Test2), deleted it and then tried to transfer out of Test1 again, and it worked, the posts transferred without error.


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
So I tried again, Made a category called Test2, created a post in it, and then tried to transfer to Test1
Quote: Query Error: Duplicate entry '6-0-test1' for key 'view_unique'



--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
I just transferred without getting the error, the success message showed, but the topic wasn't transferred. It is still in Test2.

Quote: The topics have been successfully transferred to the new category



--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
updated by @ultrajam: 11/03/13 03:12:10AM
brian
@brian
12 years ago
10,149 posts
Thanks Steve - I'm checking this out.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
12 years ago
10,149 posts
Weird - I can't replicate it here on our forum - I just moved a post from the Using Jamroom into the Suggestions forum and it worked. Are you going into Modify on the post and then selecting a different category from the drop down?

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
No, using the Transfer button under the categories tab to move everything in the category
/ultrajam/forum/categories


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
brian
@brian
12 years ago
10,149 posts
Found it - this should be fixed now. Let me know if you see any issues.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
Just tried the transfer again and got this error:
Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE view_time = UNIX_TIMESTAMP()' at line 4


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
SteveX
SteveX
@ultrajam
12 years ago
2,589 posts
Tried a few more times, received a success message, and posts are moved around. But all counts are thrown out in both the category being transferred from, and to:
http://www.jamroom.net/ultrajam/forum


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
brian
@brian
12 years ago
10,149 posts
OK let me check this out sorry for the hassle.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
12 years ago
10,149 posts
The Query error is what was causing the counts to not transfer - that should be fixed now. Let me know if you see any more issues.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

Tags