Forum Activity for @michael

michael
@michael
09/24/18 08:18:29PM
7,823 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

JR4 is only going to run on php up to php 5.2. Anything newer than that and it wont run properly. It MIGHT be an issue with the mysql version on the server. Just a guess, but if the mysql() set of functions are not on the server because its too new, that might be the cause of the issue.

At some point after JR4 phps 'mysql' set of functions got replaced with 'mysqli' set of functions. If your server does not have the older set of mysql functions that may be the issue.
michael
@michael
09/23/18 03:47:53AM
7,823 posts

"select all" option for Integrity Check ?


Suggestions

For a quick way to check checkboxes without the mouse, click on the top one, then go SPACE, TAB, SPACE, TAB, SPACE, TAB, SPACE, TAB, SPACE, ENTER

and the integrity check will show the "do you want to...?" and that last ENTER will confirm "yes".
updated by @michael: 09/23/18 03:48:34AM
michael
@michael
09/21/18 10:03:36PM
7,823 posts

Elastic 2 Reduce Header


Design and Skin Customization

The css class .index controls the outer box.

There are development tools built into the browsers now that help locate that kind of stuff, for me its F12 to open them in Firefox, they used to be a plugin called 'firebug' but now they are included.
Development Tools the Jamroom Team uses
Using firebug with the STYLE tab
height.jpg height.jpg - 236KB
michael
@michael
09/21/18 07:02:11PM
7,823 posts

Combining some Lucid and Elastic2 features


Design and Skin Customization

They are different skins, they have different features just throwing them all together is not going to get you the result you want.

think: "I like the body of the Camario, but I want the engine of the Corvette in it" You need to get rid of some things, add others, move others then re-wire it.

Start by getting the HTML in place, then see what classes it has, maybe those classes exist in your current site, mabye they don't.

Jamroom is designed as an extensible platform for developers, but its not a sectional clip-together system.

I think you'd be better gaining an understanding of how it works then building the thing you need rather than trying to merge stuff.
michael
@michael
09/21/18 06:52:13PM
7,823 posts

Database Size almost 20GB!


Using Jamroom

Both of those are just temp tables, you can truncate them.
michael
@michael
09/20/18 06:11:48PM
7,823 posts

Database Size almost 20GB!


Using Jamroom

Delete your activity log. If it doesnt go away with that one, truncate the table.
ACP -> DASHBOARD -> ACTIVITY LOG -> EMPTY ACTIVITY LOG
michael
@michael
09/20/18 06:01:06PM
7,823 posts

gravatar change


Design and Skin Customization

gravitar will only show if you havent uploaded a profile image. Its the backup image.
michael
@michael
09/19/18 04:27:42PM
7,823 posts

Database Size almost 20GB!


Using Jamroom

jr_jrcore_log_debug This is the ? on the right side of the ACTIVITY LOG. Deleting the activity log clears this out.

jr_jrcharts_history This is your charts history. If you have any charts on your site "most popular for the last 7 days" type thing, deleting this will remove that data and charts will no longer work until the data is built up again.

jr_jruser_item_key This is the main datastore for your users. Deleting this will cause all your users to be deleted.

jr_jruser_session This is the user session. Deleting this will cause any users logged in to be logged out and they will have to log back in again.

Dont DELETE them, use TRUNCATE instead to just empty those you want to empty.
michael
@michael
09/19/18 04:19:47PM
7,823 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

If it was working and you did nothing, contact your hosting provider.

If it was working and you changed something in the database, may need to check that database still exists and possibly restore from a backup.

If it was working and you changed something in the file system check that you have the correct details in your config file found at /data/config/config.php
  109