Ultimate SEO v3 (and v2.200) [Support Thread]

Yikes, the plugin's initialization script is setting those datetime fields to an invalid date. You'll need to edit the file /admin/includes/classes/usu_plugin.php, finding the following code-fragment starting at line 123:

Code:

---

        public function handleDatabaseChanges($install = true) {
                global $db, $messageStack;

                $success = true;
                if($install) {
                        if(!$this->dbTableExists(TABLE_USU_CACHE)) {
                                $db->Execute(
                                        'CREATE TABLE `' . TABLE_USU_CACHE . '` ( ' .
                                                '`cache_id` VARCHAR(32) NOT NULL default \'\', ' .
                                                '`cache_language_id` TINYINT(1) NOT NULL default \'0\', ' .
                                                '`cache_name` VARCHAR(255) NOT NULL default \'\', ' .
                                                '`cache_data` MEDIUMBLOB NOT NULL, ' .
                                                '`cache_global` TINYINT(1) NOT NULL default \'1\', ' .
                                                '`cache_gzip` TINYINT(1) NOT NULL default \'1\', ' .
                                                '`cache_method` VARCHAR(20) NOT NULL default \'RETURN\', ' .
                                                '`cache_date` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' .
                                                '`cache_expires` DATETIME NOT NULL default \'0000-00-00 00:00:00\', ' .
                                                'PRIMARY KEY (`cache_id`,`cache_language_id`), ' .
                                                'KEY `cache_id` (`cache_id`), ' .
                                                'KEY `cache_language_id` (`cache_language_id`), ' .
                                                'KEY `cache_global` (`cache_global`) ' .
                                        ')'
                                );
                        }

---

and changing the highlighted sections as shown below:

Code:

---

        public function handleDatabaseChanges($install = true) {
                global $db, $messageStack;

                $success = true;
                if($install) {
                        if(!$this->dbTableExists(TABLE_USU_CACHE)) {
                                $db->Execute(
                                        'CREATE TABLE `' . TABLE_USU_CACHE . '` ( ' .
                                                '`cache_id` VARCHAR(32) NOT NULL default \'\', ' .
                                                '`cache_language_id` TINYINT(1) NOT NULL default \'0\', ' .
                                                '`cache_name` VARCHAR(255) NOT NULL default \'\', ' .
                                                '`cache_data` MEDIUMBLOB NOT NULL, ' .
                                                '`cache_global` TINYINT(1) NOT NULL default \'1\', ' .
                                                '`cache_gzip` TINYINT(1) NOT NULL default \'1\', ' .
                                                '`cache_method` VARCHAR(20) NOT NULL default \'RETURN\', ' .
                                                '`cache_date` DATETIME NOT NULL default \'0001-01-01 00:00:00\', ' .
                                                '`cache_expires` DATETIME NOT NULL default \'0001-01-01 00:00:00\', ' .
                                                'PRIMARY KEY (`cache_id`,`cache_language_id`), ' .
                                                'KEY `cache_id` (`cache_id`), ' .
                                                'KEY `cache_language_id` (`cache_language_id`), ' .
                                                'KEY `cache_global` (`cache_global`) ' .
                                        ')'
                                );
                        }

---

I'll get an update going ...

Hi, lat 9

Perfect, now the admin has returned, but I do not see "Ultimate SEO" in "Configuration".

What could I have done wrong? How to make it appear to configure it?

Thank you very much for your help, I really need it :blush:

Thank you

I'd follow the steps in the USU readme to 'uninstall' (backing up files and database first) and then re-install. That MySQL error on the database table-addition has "confused" USU's installation procedure.

Hi, lat 9

I have uninstalled the module and reinstalled it.

It does not give me any errors, but nothing is shown in "Configuration" of the administration panel.

I have checked the logs and none has been created.

Any ideas?

Thank you very much, really, I am totally lost.

Are you familiar with how to use your webhost's phpMyAdmin database tool? If so, I'll post some instructions through which you can "gather" some information to help identify the source of the issue.

Hi, lat 9

I have worked something, very little, but I can access without problems.

I am very thankfull for your help.

OK, let's see what's in the configuration by running a couple of queries.

Log into your site's phpMyAdmin, click the SQL tab, enter the following query and press Go. Note that this assumes that your DB_PREFIX (defined in the configure.php files) is set to ''; if it's set to something else, e.g. 'zen_', then enter zen_configuration:

Code:

---

SELECT * FROM configuration WHERE configuration_key LIKE 'USU_%' OR configuration_key LIKE 'SEO_%';

---

Post-back those results. Then click the SQL tab again, enter the following query and press Go. Same assumption as above; if your DB_PREFIX is not an empty string, e.g. 'zen_', use zen_admin_pages:

Code:

---

SELECT * FROM admin_pages WHERE page_key = 'configUltimateSEO';

---

Post-back those results, too.

I'm, essentially, trying to determine where your site is in the USU installation process so that I can get you back on-track.

Hi, lat 9

Let's see if I'm doing it right ... I've made the query:

Code:

---

SELECT * FROM prefix_configuration WHERE configuration_key LIKE 'USU_%' OR configuration_key LIKE 'SEO_%';

---

And the consultation:

Code:

---

SELECT * FROM prefix_admin_pages WHERE page_key = 'configUltimateSEO';

---

Understanding that "prefix" is the prefix of my BBDD.

I do not know if I've done it well, but both times it shows me 0 values ...

:-(

Did you replace USU's installation files after you uninstalled?

The plugin currently (:censored:) uses an installation method that removes its installation files after completion. That's something I'll be changing in any future update.

Hi, lat 9

In Admin> includes> auto_loaders The file "config.usu_onetime.php" is missing
In Admin> includes> init_includes The file "init_usu_install.php" is not there

Should be?

;-(