Forum Activity for @white-agency

Group Members problem

Using Jamroom

Thanks Paul - Great service as usual

Potential Video approval bug and pending items problem

Using Jamroom

Still an issue Paul.

Jpg attached to show.

Cheers

Dave

Group Members problem

Using Jamroom

All our Groups have lost the Members list down the right hand side of the page.

Have reset the cache

Found this is debug log but don't think it is related :-

[query] => INSERT INTO jr_jrgroup_member (member_created,member_user_id,member_group_id,member_status) VALUES ('1456776017','15061','45','0') ) (2016-02-29T20:00:27+00:00.0.21053100 : 0)-(mem: 1572864)-(pid: 28913)-(ip: ******)-(user: 88888)-(uri: POST /group/button/join/45/__ajax=1) Array ( [error] => Query Error: Duplicate entry '15061-45' for key 'member_unique' [_post] => Array ( [_uri] => /group/button/join/45/__ajax=1 [module_url] => group [module] => jrGroup [option] => button [_1] => join [_2] => 45 [__ajax] => 1 )



updated by @white-agency: 06/02/16 09:41:00AM

Potential Video approval bug and pending items problem

Using Jamroom

Sorry Paul,

The Video Tab is not there. It was when I originally looked cos they was a video waiting to be approved !

No other info for you other than the items in the DB table refer to videos that have been approved.

Potential Video approval bug and pending items problem

Using Jamroom

Was asked exactly the same thing by one of the programmers in the office who was looking over my shoulder !

Nothing in the video tab.

Potential Video approval bug and pending items problem

Using Jamroom

Thanks for the fast response Paul.

We can wait. I've set the admins to require approval for the time being.


Any ideas on the Pending view problem?

Potential Video approval bug and pending items problem

Using Jamroom

We currently have videos posted by normal users requiring approval and Admin users not requiring approval.

Videos posted by an Admin we're not appearing to normal users so we had a look in the datastore for videos and noticed that they where missing a 'video_pending' field when compared to videos that had required approval. Manually adding that field to the admin videos and setting it to 0 fixed the problem.


When viewing the Dashboard in the ACP it is currently showing there are 6 pending items but when you view the pending page there is nothing to approve.

Having a look at the jr_jrcore_pending database table there are 6 items in there all relating to creation or updating of videos.?

Cheers

Dave






updated by @white-agency: 05/31/16 12:12:28AM

Sql error whilst performing integrity check

Using Jamroom

Managed to work my way round this.

I ran the integrity check in the following order :-

1: Repair Tables
2: Optimize Tables
3: Repair Modules

This time no errors when the Repair Modules ran.
Same result on the test and live servers.

Sql error whilst performing integrity check

Using Jamroom

Checked all the logs I can find.

Same error is in the activity and debug logs but nothing in the error log.

Had a look at the apache, php and mysql logs on the server and can't find anything in there

Sql error whilst performing integrity check

Using Jamroom

Generated this when I ran the integrity check ( Repair Modules )

Replicated this on our test system.