Title: ypp's Replies | WordPress.org --- # ypp [ ](https://wordpress.org/support/users/ypp/) * [Profile](https://wordpress.org/support/users/ypp/) * [Topics Started](https://wordpress.org/support/users/ypp/topics/) * [Replies Created](https://wordpress.org/support/users/ypp/replies/) * [Reviews Written](https://wordpress.org/support/users/ypp/reviews/) * [Topics Replied To](https://wordpress.org/support/users/ypp/replied-to/) * [Engagements](https://wordpress.org/support/users/ypp/engagements/) * [Favorites](https://wordpress.org/support/users/ypp/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 15 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 8 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10620020) * Will do … * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 8 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10619842) * Hi Jean, * Yes, I think this has got it. * At first I got an error message when I tried to add the auto-increment attribute to umeta_id; MySQL didn’t like the row with a primary key value of 0 … * [https://stackoverflow.com/questions/5402949/mysql-cant-make-column-auto-increment#6469632](https://stackoverflow.com/questions/5402949/mysql-cant-make-column-auto-increment#6469632) * That was overcome by following the advice in entry #29 of that article, so the resulting code that did it was as follows: * SET SESSION sql_mode=’NO_AUTO_VALUE_ON_ZERO’; ALTER TABLE `wp_usermeta` CHANGE` umeta_id` `umeta_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; SET SESSION sql_mode=”; * As it turns out (I noted this when I inspected the tables earlier), the ID field for wp_users was also not set to auto-increment, whereas the WordPress spec above says that it should be. So I set that field to auto-increment too. * At first glance it looks like I have succeeded in adding my user, which was my original mission. We’ll see how that works out but for now it looks promising that we’ve got this one solved. * Thanks very much for your patient and expert help! * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 8 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10619251) * Correction: * phpMyAdmin does not show umeta_id in wp_usermeta as being autoincremented. * The WordPress table description at [https://codex.wordpress.org/Database_Description](https://codex.wordpress.org/Database_Description), however, does. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 8 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10618545) * Hi Jean, * Thanks again. * 1. umeta_id is not set to auto-increment * 2. Yes, values of umeta_id are sequential. Two largest values (other than the row I renumbered manually to 999) are 322 and 407. Presumably the large gap comes from my numerous unsuccessful attempts to add a new administrator before the login loop occurred. * 3. I have been able successfully to log out and in several times. * Other interesting facts: — the renumbered row with a value of “wp_statistics” for the key_name property is a singleton – no other users have a value of “wp_statistics” for that property –the new row that was created after my first successful login, with a u_meta value of 0 and value of “session_tokens”, remains in the database after I sign out * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 8 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10616465) * Hi Jean, * Thanks again. * > I suppose you’ve tried clearing your browser cache or connecting from another computer ? -Yes. Just tried again from my mobile phone for good measure. * > Have you turned on debugging ? Does it capture any error when you log in ? [https://codex.wordpress.org/Debugging_in_WordPress](https://codex.wordpress.org/Debugging_in_WordPress)- Tried this by following the article. No debug message. * > Have you asked your server manager if there’s any error showing in the web server logs ? -Just asked him, and he relayed the following error message to me: * [Thu Aug 23 05:39:41.857617 2018] [proxy_fcgi:error] [pid 90131] [client 174.6.144.140: 41082] AH01071: Got error ‘PHP message: WordPress database error Duplicate entry‘ 0’ for key ‘PRIMARY’ for query INSERT INTO `wp_usermeta` (`user_id`, `meta_key`,` meta_value`) VALUES (1, ‘session_tokens’, ‘a:1:{s:64:\\”015ca64018e47031fc69c3994052a2163122a4b93ddab68185b7ff70f992f507\\”; a:4:{s:10:\\”expiration\\”;i:1535175581;s:2:\\”ip\\”;s:13:\\”174.6.144.140\\”; s:2:\\”ua\\”;s:68:\\”Mozilla/5.0 (Android 8.0.0; Mobile; rv:61.0) Gecko/61.0 Firefox/61.0\\”;s:5:\\”login\\”;i:1535002781;}}’) made by wp_signon, wp_set_auth_cookie, WP_Session_Tokens->create, WP_Session_Tokens->update, WP_User_Meta_Session_Tokens- >update_session, WP_User_Meta_Session_Tokens->update_sessions, update_user_meta, update_metadata, add_metadata\n’, referer: [http://pendarpagi.org/wp-login.php?redirect_to=http%3A%2F%2Fpendarpagi.org%2Fwp-admin%2F&reauth=1](http://pendarpagi.org/wp-login.php?redirect_to=http%3A%2F%2Fpendarpagi.org%2Fwp-admin%2F&reauth=1) * Now it looks like we’re getting somewhere. The above matches my mobile phone login. * On inspection, an existing record in wp_usermeta contained the following properties and values: * umeta_id 0 user_id 1 meta_key wp_statistics meta_value a:1:{s:13:”dashboard_set”; s:6:”12.3.5″;} * The user with user_id = 1 is me as site admin. * I reassigned the value for umeta_id to 999 and was able to sign in. * The newly created record in wp_usermeta is as follows: * umeta_id 0 user_id 1 meta_key session_tokens meta_value [date from the login just completed, on my laptop] * What do I do with the record with the previous umeta_id value of 0, now reassigned to 999. Can I safely delete it? * Is it possible that there are other errors in the database? How would I know? * Thanks for getting me this far! * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 9 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10581935) * Hi Jean, * Confirmed from our server manager that neither Istallatron nor Softaculous were used to install WP. * Any more ideas? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 9 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10576742) * Thanks Jean. * I don’t know whether WordPress was installed with Installatron or Softaculous. We are borrowing space on another company’s server. * I will ask your question of the person who manages the server. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Cannot sign in to WordPress admin](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [7 years, 9 months ago](https://wordpress.org/support/topic/cannot-sign-in-to-wordpress-admin/#post-10576272) * Hi Jean, * Thanks very much for your reply. * > Does it display any error message at all ? –No error message; just a refresh and return to the login screen * > When you edited the users tables, are you sure you selected MD5 in the functions list before changing the password ? –Yes * > When you disabled all plugins, did you move everything out of the /wp-content/ plugins folder ? –No, I just renamed the folder to plugins.disabled * > Is there a folder called /wp-content/mu-plugins ? If yes, you could move the content out too. –No, no folder by that name * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[MC4WP: Mailchimp for WordPress] Opt-in checkbox label does not align correctly](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [8 years, 10 months ago](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/#post-9317798) * Great, thank you very much! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[MC4WP: Mailchimp for WordPress] Opt-in checkbox label does not align correctly](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [8 years, 10 months ago](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/#post-9315184) * Hi Lap, * I added that code to my child styles.css but no change in the way the label displays. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[MC4WP: Mailchimp for WordPress] Opt-in checkbox label does not align correctly](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [8 years, 10 months ago](https://wordpress.org/support/topic/opt-in-checkbox-label-does-not-align-correctly/#post-9314843) * Hi Lap, * Thanks for your reply. I saw that the screenshots weren’t loading but couldn’t figure out why. * Sample form is at [http://pendarpagi.org/en/partner/](http://pendarpagi.org/en/partner/) * For you to view this I have intentionally set the opt-in label position to ‘right of element.’ In my browser (Safari) the label text appears in two lines, on the opposite side of the form. * When I tested a normal Ninja Forms checkbox the label appears in the correct position. * Thanks! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Polylang] Catch Everest homepage not translating](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [11 years, 6 months ago](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/#post-5428979) * Thank you very much, Chrystl! * Changing to ‘The language is set from the directory name in pretty permalinks’ in URL modifications has got the homepage translating correctly. Much appreciated! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Polylang] Catch Everest homepage not translating](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [11 years, 6 months ago](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/#post-5428771) * One more try: * [https://wordpress.org/support/topic/polylang-and-catch-everest-theme?replies=2](https://wordpress.org/support/topic/polylang-and-catch-everest-theme?replies=2) * [http://www.coffee-imports.com/de/frontpage/](http://www.coffee-imports.com/de/frontpage/) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Polylang] Catch Everest homepage not translating](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/) * Thread Starter [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [11 years, 6 months ago](https://wordpress.org/support/topic/catch-everest-homepage-not-translating/#post-5428769) * Apologies, the links above didn’t come out right. * The post I referenced is [.](https://wordpress.org/support/topic/polylang-and-catch-everest-theme?replies=2) * The website referred to in that post is [.](http://www.coffee-imports.com/de/frontpage/) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[MiniMax - Page Layout Builder] after last update(1.7.3) nothing works](https://wordpress.org/support/topic/after-last-update173-nothing-works/) * [ypp](https://wordpress.org/support/users/ypp/) * (@ypp) * [11 years, 8 months ago](https://wordpress.org/support/topic/after-last-update173-nothing-works/#post-5245420) * In the backend view of your website at the bottom of the menu on the left hand side should be the MiniMax icon and name. Click it. * In MiniMax Modules, Available Modules tab, activate the modules you need, e.g. Rich Text and Image. * Modules of those types should reappear. Viewing 15 replies - 1 through 15 (of 15 total)