These are chat archives for collectiveaccess/support

7th
Jun 2018
Kehan Harman
@kehh
Jun 07 2018 04:34
The install time depends on a number of things: cpu speed, database speed/ memory, network latency between server and db. However I have seen installs with large profiles take quite a while. Travis installs take about 6 minutes using the testing profile: https://travis-ci.org/collectiveaccess/providence/jobs/382787163
TBthegr81
@TBthegr81
Jun 07 2018 08:17
@collectiveaccess I re-checked the owner/group and permissions of the symlink, the media-folder and compared it between my pawtucket and providence.
I even copied my setup.php to a new providence folder straight from the release ZIP and set it all up again, still can't preview stuff...
Thing is, thumbnails are loaded correctly, but full-size isn't.

And now I found another problem that still only occurs in this DB and not the other two:
When in object details view in providence and I try to ad a relationship the search-results box doesn't show.
I write a name of a person or object in the "add new relationship" box and I can see in the console and network tab that the search-results is returned, but no result-box is shown.
This also happens in my clean-copy of Providence.

Since both these problems seem to occur in clean providences I am starting to wonder if there is something in the database that trigger this... But that doesn't make any sense

TBthegr81
@TBthegr81
Jun 07 2018 08:41
Could I do some type of export of all the objects and stuff into a clean DB, without dumping the whole DB with MySQLDump like I usually do, and that would fix some of these things?
I see the "replicate-data" option in caUtils, could that be something?
Kehan Harman
@kehh
Jun 07 2018 09:05
have you tried caUtils reprocess-media @TBthegr81? I've not used replicate-data but you will have to at least use an exact copy of the installation profile of the system that you're using (caUtils export-profile). Also you'll probably have to dig into replication.conf.
TBthegr81
@TBthegr81
Jun 07 2018 11:12
I tried running reprocess-media but it seemed to take too long. Each image took along the lines of a minute and the estimate by the script guessed at 37 days.
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:13
You should look into why it's taking so long. Check the process list and see what processes (if any) are hanging.
runengine
@runengine
Jun 07 2018 11:14
What is normal time it takes to run ? Now Im finding it doesn always create the same amount of tables.. just now it stopped at 41 tables ?!?
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:15
@runengine On a really slow machine it might take 4 or 5 minutes. On most machines I've seen ~ 90 seconds.
runengine
@runengine
Jun 07 2018 11:15
And now it created 215 tables... How many tables is in a successful install ?
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:15
A successful install is one that works.
runengine
@runengine
Jun 07 2018 11:15
well yeah.. but in trying to troubleshoot.. how many tables ?
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:15
The number of tables varies by version. What version are you running
runengine
@runengine
Jun 07 2018 11:16
1.7.6
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:16
223
runengine
@runengine
Jun 07 2018 11:16
ok.. so this time it got close then
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:16
Does the installer just hang or do you get an error?
runengine
@runengine
Jun 07 2018 11:16
just hangs.. no error
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:16
Even in the logs?
runengine
@runengine
Jun 07 2018 11:17
Should I use InnoDB or MyIsam ?
yep. no logs
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:17
Innodb is required for all tables.
runengine
@runengine
Jun 07 2018 11:17
ok.. that is what they are
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:17
It's not an option you choose
runengine
@runengine
Jun 07 2018 11:17
any collation required ?
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:17
What sort of machine are you doing this on?
runengine
@runengine
Jun 07 2018 11:18
webserver, 24 core
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:18
What operating system
runengine
@runengine
Jun 07 2018 11:18
Centos WHM/Cpanel;
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:18
Ok
runengine
@runengine
Jun 07 2018 11:18
Centos
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:18
What version of Linux
number I mean
I get that it's CentOS
runengine
@runengine
Jun 07 2018 11:19
Sorry, im not sure.. its Centos 7.5
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:19
Ok Centos 7
We run it on CentOS 7 all the time without an issue
What version of PHP is installed?
runengine
@runengine
Jun 07 2018 11:19
right now 5.6 - but will be upgraded to multiphp (7) soon
could it be the php processor ?
CollectiveAccess
@collectiveaccess
Jun 07 2018 11:20
Maybe
runengine
@runengine
Jun 07 2018 11:21
right now its EasyApache 4 with PHP/SuExec
can the installer run from shell ?
I wonder if that would run better
runengine
@runengine
Jun 07 2018 11:36
ok Maybe I have news..
the failed again.. this was one of the last queries run
INSERT INTO ca_guids (table_num,row_id,guid) VALUES (32,57,'fc042654-d834-4d13-984a-ebf05c00473f')
but there still is only 215 tables...
but there is actually data now.. never was before
im not sure what is failing.. max execution time is 10000
should be plenty
CollectiveAccess
@collectiveaccess
Jun 07 2018 14:18
It's not the execution time. The install is throwing an error. Look for the error.
Danielle Nowak
@nowak369_twitter
Jun 07 2018 19:46
Can Collective Access link chatbots to pages?