Upgrade from 3.0.9 to 3.2 Problems

[ZagorianBeatle]

Hello there,

I am trying to upgrade phpMyFAQ but there a two problems:

1.
[core:alert] /var/www/vhosts/faq-dev.xxx.de/httpdocs/.htaccess: Option FollowSymlinks not allowed here

This option is disabled by default in Plesk and for security reasons it should remain disabled.

Will the update still work if I disable the specific line in .htaccess?


2. A table is missing in the database:

Message: 'Table 'faq-dev.faqcategory_order' doesn't exist'

Is there a way to rebuild the table (V 3.0.9)?

Greetings,

Ralph

[Thorsten]

Hi,

I think you don't need the Option FollowSymlinks, I will remove it.

Is "faqcategory_order" missing for 3.0 or 3.2? I think we introduced this table with 3.1.

bye
Thorsten

[ZagorianBeatle]

Hi Thorsten,

I get this message while updating from 3.0.9 to 3.2.

----
phpMyFAQ Fatal error
Uncaught exception: 'mysqli_sql_exception'
Message: 'Table 'faq-dev.faqcategory_order' doesn't exist'

Stack trace:
#0 /var/www/vhosts/faq-dev.xyz.de/httpdocs/src/phpMyFAQ/Database/Mysqli.php(308): mysqli->query()
#1 /var/www/vhosts/faq-dev.xyz.de/httpdocs/src/phpMyFAQ/Category.php(216): phpMyFAQ\Database\Mysqli->query()
#2 /var/www/vhosts/faq-dev.xyz.de/httpdocs/src/phpMyFAQ/Category.php(108): phpMyFAQ\Category->getOrderedCategories()
#3 /var/www/vhosts/faq-dev.xyz.de/httpdocs/index.php(319): phpMyFAQ\Category->__construct()
#4 {main}
Thrown in '/var/www/vhosts/faq-dev.xyz.de/httpdocs/src/phpMyFAQ/Database/Mysqli.php' on line 308

Regards,

Ralph

[Thorsten]

Hi,

you can create this table manually:

Code: Select all

CREATE TABLE faqcategory_order (
            category_id int(11) NOT NULL,
            parent_id int(11) DEFAULT NULL,
            position int(11) NOT NULL,
            PRIMARY KEY (category_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB

bye
Thorsten