grantcause

Same problem with my site.

@ultimatemembersupport way beyond that, have already done this. Check out my previous “UM2.0 Broken Menus” item on the UM2.0 tag to see what I have already tried. It is definitely a redirect being caused by UM2.0 conditional menus. Non UM2.0 links work just fine on my site. I can see the correct page briefly flash up and then be redirected really quickly. It only happens for logged in users. I only tried this permalinks test as I was clutching at straws. Waiting for the UM2.1 update. The 404 issue described here seems to be unique to @kimthurlow.

I thought this might resolve my earlier broken conditional menu items issue for logged in users. However changing the permalinks didn’t help as the logged in users still cant access their pages. Conditional menu items only work for logged out users. Interestingly the Administrator account cannot access these pages via the UM2.0 menu links either. The pages themselves can be accessed via the administrator panel though.

@samanthawpaladinpos, I am running Divi and Ultimate Member.

I did have to add the following CSS to get it to work correctly.

Go into Divi, Theme Options, General, Custom CSS at the bottom and enter:

.um { opacity: 1 !important; }

This put the CSS code at the top of every page.

@ultimatemembersupport Samantha appears to be running version 1.3.88 of ultimate member.

@ultimatemembersupport any updates on this issue?

Here’s what I used for my site:

.avatar {
border-radius: 50%;
-moz-border-radius: 50%;
-webkit-border-radius: 50%;
}

I didnt use the advanced settings though, that seems to have disappeared in UM2.0.

Instead I placed this in my Theme’s custom CSS area so it appears at the top of every page on the site.

@ultimatemembersupport any chance of an update?

My menus for logged in users are still broken despite having tried all of the above.

I followed the same tutorial and it is working just fine on my site.

You need to add the CSS to the top of every page. Your theme may have an option in its customisation section that will allow you to put custom CSS in it.

Cheers,

Grant

Ok tried playing with the page level setting access settings for UM and nothing I tried made any difference.

There is an option to show an error message if someone who doesn’t have access to the page tries to access it and this is not showing either.

Began to suspect a Plugin / Javascript conflict, but disabled them all and still had the same issues.

• This reply was modified 7 years ago by grantcause.

Hi Alex,

That worked just fine.

I had to DROP the second table as it was already there the first time I ran it so it complained about that. I then dropped both tables and ran the SQL again and all was good.

Thank you for your assistance in resolving this it is greatly appreciated.

Cheers,

Grant

Here is how XCode formatted the SQL as:

CREATE TABLE?ccmd_wallets_txs?(
                               id?int(10) UNSIGNED NOT NULL,
                               blog_id?bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘blog_id for multisite installs’,
                               category?enum(‘deposit’,’move’,’withdraw’) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT ‘type of transaction’,
                               tags?varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ” COMMENT ‘space separated list of tags, slugs, etc that further describe the type of transaction’,
                               account?bigint(20) UNSIGNED NOT NULL COMMENT ‘ccmd_users.ID’,
                               other_account?bigint(20) UNSIGNED DEFAULT NULL COMMENT ‘ccmd_users.ID when category==move’,
                               address?varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ” COMMENT ‘blockchain address when category==deposit or category==withdraw’,
                               txid?varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL COMMENT ‘blockchain transaction id’,
                               symbol?varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT ‘coin symbol (e.g. BTC for Bitcoin)’,
                               amount?decimal(20,10) NOT NULL COMMENT ‘amount plus any fees deducted from account’,
                               fee?decimal(20,10) NOT NULL DEFAULT ‘0.0000000000’ COMMENT ‘fees deducted from account’,
                               comment?text COLLATE utf8mb4_unicode_520_ci COMMENT ‘transaction comment’,
                               created_time?datetime NOT NULL COMMENT ‘when transaction was entered into the system in GMT’,
                               updated_time?datetime NOT NULL COMMENT ‘when transaction was last updated in GMT (e.g. for update to confirmations count)’,
                               confirmations?mediumint(8) UNSIGNED DEFAULT ‘0’ COMMENT ‘amount of confirmations received from blockchain, or null for category==move’,
                               status?enum(‘unconfirmed’,’pending’,’done’,’failed’,’cancelled’) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ‘unconfirmed’ COMMENT ‘state of transaction’,
                               retries?tinyint(3) UNSIGNED NOT NULL DEFAULT ‘1’ COMMENT ‘retries left before a pending transaction status becomes failed’,
                               admin_confirm?tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if an admin has confirmed this transaction’,
                               user_confirm?tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if the user has confirmed this transaction over email’,
                               nonce?char(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT ‘nonce for user to confirm via emailed link’,
                               extra?varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL COMMENT ‘extra info required by some coins such as XMR’
                               ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
ALTER TABLE?ccmd_wallets_txs
ADD PRIMARY KEY (id),
ADD UNIQUE KEY?uq_tx_idx?(txid,symbol),
ADD KEY?account_idx?(account),
ADD KEY?blogid_idx?(blog_id);
CREATE TABLE?ccmd_wallets_adds?(
                                id?int(10) UNSIGNED NOT NULL,
                                blog_id?bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘blog_id for multisite installs’,
                                account?bigint(20) UNSIGNED NOT NULL COMMENT ‘ccmd_users.ID’,
                                symbol?varchar(5) COLLATE latin1_bin NOT NULL COMMENT ‘coin symbol (e.g. BTC for Bitcoin)’,
                                address?varchar(255) COLLATE latin1_bin NOT NULL,
                                created_time?datetime NOT NULL COMMENT ‘when address was requested in GMT’,
                                extra?varchar(255) COLLATE latin1_bin NOT NULL DEFAULT ” COMMENT ‘extra info required by some coins such as XMR’
                                ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
ALTER TABLE?ccmd_wallets_adds
ADD PRIMARY KEY (id),
ADD UNIQUE KEY?uq_ad_idx?(address,symbol,extra),
ADD KEY?retrieve_idx?(account,symbol),
ADD KEY?lookup_idx?(address);

Ok Alex, I thought it might be a case of bad copy/paste due to HTML on this forum, so I loaded up XCode and put the SQL statement into the file editor there. This time it formatted it correctly and I got a different error:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘TABLE? ccmd_wallets_txs? (
id? int(10) UNSIGNED ‘ at line 1

Cheers,

Grant

Hi Alex,

Here is what MySQL responded with:
SQL query:

CREATE TABLE ccmd_wallets_txs ( id int(10) UNSIGNED NOT NULL, blog_id bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘blog_id for multisite installs’, category enum(‘deposit’,’move’,’withdraw’) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT ‘type of transaction’, tags varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ” COMMENT ‘space separated list of tags, slugs, etc that further describe the type of transaction’, account bigint(20) UNSIGNED NOT NULL COMMENT ‘ccmd_users.ID’, other_account bigint(20) UNSIGNED DEFAULT NULL COMMENT ‘ccmd_users.ID when category==move’, address varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ” COMMENT ‘blockchain address when category==deposit or category==withdraw’, txid varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL COMMENT ‘blockchain transaction id’, symbol varchar(5) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT ‘coin symbol (e.g. BTC for Bitcoin[…]

MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘a€?1a€? COMMENT a€?blog_id for multisite installsa€?,
category enum(a€?deposit’ at line 3

I will see if I can do some more digging around this and let you know.

Thank you for your assistance with this it is greatly appreciated.

Cheers,
Grant

Got the front end working ?? Still need to get the wallets table created.

Have hooked it all up to CoinPayments API using the adaptor, testing with LitecoinTestnet at the moment.

Cheers,

Grant