Forum Activity for @soaringeagle

soaringeagle
@soaringeagle
09/19/17 09:06:22AM
3,304 posts

Error: Query Error: The table 'jr_jrcore_cache' is full


Installation and Configuration

installed it but lil confused (theres no documentation)
whats the servers?
do i just set 1 up somehow on an ip on my server?
is there a redis specifiuc server list/ do they cost much?
soaringeagle
@soaringeagle
09/18/17 07:39:21PM
3,304 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction


Installation and Configuration

heres 1 thats original mp4 and again sam,e behavior only plays after clicking that name
Video shows Indian man with a 62FT-LONG dreadlock Daily Mail Online.zip - 2.2MB

updated by @soaringeagle: 09/18/17 07:42:16PM
soaringeagle
@soaringeagle
09/18/17 07:31:03PM
3,304 posts

Page/Widget Header Text and Fonts


Using Jamroom

id recommend you learn some css its really not hard, that combined with simple template edits and you can even alow your members to set the colors of their names on their profile pages.

you can use the form designer to add stuff like profile_name_color and use the color picker tool to select a color
then tame that colr value and add it to inline css

i had posdted a tip somewhere in the ning forum i think (if that still exists) expolaining how to add a profile header cover image change the name color and the heading background color , for starters.
from there you can build in even more control if you want.

css can be edited in the skin styles thing but i find that extremely limiting so actually never used it
instead in templates if i wanted to targed a certain .item like the 1st .item in a forum post i can in that template add a second class or a id (when you learn css basics (again pretty simple) you'll know which to use. now in the skins css files you just use that new class or id to apply custyom styling to that item that through the skin style editor is innaccessible

between css template editing and the form editoir you have pretty much complete control and can give users controlk over the look of their own content
it would be ugly and silly but youi could even let users have custom background colors (ort even imagtes) for their forum posts.


learn to usefirefiox's plugin firebug!
if you want toi change the color of an item, simply right click it view element in firebug then you can play with the colors live (you see what you change others don't0 then when happy right click copy the code and paste into the end of your css file
firebug can teach you many css basics by simply using it
thats how i taught myself everything but css animation

as fotr fonts css uses font families. since not everyone hasd every font installed on their system you choose a font family and if a fonts not installed another from the same family gets used.
you can specify both a font and font family i believe and then if the 1 you specify is not inbstaled anopther from the samne family gets used.

if a specific font is essential i believe they can be downloaded and loasded with the page with link statementrs that load the font files before page rendering
soaringeagle
@soaringeagle
09/18/17 07:09:24PM
3,304 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction


Installation and Configuration

geez thats inconsistent too.. its the exact same file i used for multiple tests some work ()as described..incorrectly) others do not, despite the original file being the same in each case
soaringeagle
@soaringeagle
09/18/17 07:03:29PM
3,304 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction


Installation and Configuration

this video
https://www.dreadlockssite.com/soaring-eagle/uploaded_video/369/testing-small-2

i click view from datastore takesme topo
https://www.dreadlockssite.com/soaring-eagle/uploaded_video/369/testing-small-2
i get the error
i click play
i get the error
i click the name here
(see screenshot)
it plays
and then clicking play againm now works
such is not the casde for others that had mkv original
only this 1 that had mov

very confusing
weird.jpg weird.jpg - 81KB
soaringeagle
@soaringeagle
09/18/17 06:55:16PM
3,304 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction


Installation and Configuration

i think i made a discovery
it seems mov vids (original) might work mkv oriiginals dont seem to
\
at least thats what im finding so far (and anything u see that should be changed in the my.cnf?)

i am going through my datastoire and so far found 1 that plays

give me 20 minutes to investigate further plz
i want to try a couple things
soaringeagle
@soaringeagle
09/18/17 06:40:47PM
3,304 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction


Installation and Configuration

michael:
It will be stored in /data/media

why am i getting error loading media url for every uploaded video
soaringeagle
@soaringeagle
09/18/17 06:04:55PM
3,304 posts

Error: Query Error: The table 'jr_jrcore_cache' is full


Installation and Configuration

think to be safe i'll post mine see if you spot the issues
##
[mysqld]
#bind-address = 127.0.0.1
skip_name_resolve
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

key-buffer-size                = 1024M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
max_allowed_packet             = 128M
wait_timeout                   = 300
max-connect-errors             = 1000000
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M

# DATA STORAGE #
datadir                        = /var/lib/mysql/

# BINARY LOGGING #
#log-bin                        = /var/lib/mysql/mysql-bin
#expire-logs-days               = 1
#sync-binlog                    = 1

# CACHES AND LIMITS #
tmp-table-size                 = 128M
max-heap-table-size            = 128M
query_cache_size               = 128M
query_cache_limit              = 2M
query_cache_type               = 0
join_buffer_size               = 4M
max-connections                = 160
thread-cache-size              = 160
open-files-limit               = 65535
table-definition-cache         = 8096
table-open-cache               = 8096
optimizer_search_depth         = 1


# INNODB #
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 2G
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 10G
innodb_buffer_pool_instances   = 10
innodb_lock_wait_timeout=120
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

soaringeagle
@soaringeagle
09/18/17 05:50:18PM
3,304 posts

Error: Query Error: The table 'jr_jrcore_cache' is full


Installation and Configuration

i would assume that if i have 32 gigs i should take the 1 gig tunings and multiplty by 32?
or are some based more on the total number of tables iin all databases
soaringeagle
@soaringeagle
09/18/17 05:38:51PM
3,304 posts

Error: Query Error: The table 'jr_jrcore_cache' is full


Installation and Configuration

thats what i asssumed cause with the update werent a whole lot of tables converted to innodb and thats when the issues started
  52