Just did the upgrade to 5.1.9 from 4.23. Looks like everything is working except we cannot change the subscription dates for our subscribers. We get the following database error:
Database error in vBulletin 5.1.9:
Invalid SQL:
INSERT INTO forum2access (`userid`,`forumid`,`accessmask`) VALUES (5195,6,1),(5195,32,1),(5195,27,1),(5195,31,1),(5195,5,1),(5195,29,1),(5195,30,1),(5195,3, 1),(5195,13,1),(5195,7,1),(5195,8,1),(5195,28,1),(5195,25,1),(5195,21,1),(5195,24,1),(5195 ,34,1),(5195,9,1),(5195,11,1),(5195,10,1),(5195,12,1),(5195,14,1),(5195,4,1),(5195,26,1),( 5195,15,1),(5195,17,1),(5195,16,1),(5195,22,1),(5195,19,1),(5195,18,1),(5195,20,1)
/**access**/;
MySQL Error : Duplicate entry '5195-6' for key 'PRIMARY'
Error Number : 1062
Can someone PLEASE help me, we have people that have paid and we can not make the changes to their subscription.
Database error in vBulletin 5.1.9:
Invalid SQL:
INSERT INTO forum2access (`userid`,`forumid`,`accessmask`) VALUES (5195,6,1),(5195,32,1),(5195,27,1),(5195,31,1),(5195,5,1),(5195,29,1),(5195,30,1),(5195,3, 1),(5195,13,1),(5195,7,1),(5195,8,1),(5195,28,1),(5195,25,1),(5195,21,1),(5195,24,1),(5195 ,34,1),(5195,9,1),(5195,11,1),(5195,10,1),(5195,12,1),(5195,14,1),(5195,4,1),(5195,26,1),( 5195,15,1),(5195,17,1),(5195,16,1),(5195,22,1),(5195,19,1),(5195,18,1),(5195,20,1)
/**access**/;
MySQL Error : Duplicate entry '5195-6' for key 'PRIMARY'
Error Number : 1062
Can someone PLEASE help me, we have people that have paid and we can not make the changes to their subscription.
Comment