Since the latest update to 3.2.3 I cannot update any articles
Clicking the 'edit' link from the article OR trying the 'edit' option from the admin section throws an SQL error:
phpMyFAQ Fatal error
Uncaught exception: 'mysqli_sql_exception'
Message: 'Unknown column 'updated' in 'field list''
#0 [...]FAQs/src/phpMyFAQ/Database/Mysqli.php(308): mysqli->query('SELECT \n ...')
#1 [...]FAQs/src/phpMyFAQ/Revision.php(84): phpMyFAQ\Database\Mysqli->query('SELECT \n ...')
#2 [...]FAQs/admin/record.edit.php(338): phpMyFAQ\Revision->get(539, 'en', '[username]')
#3 [...]FAQs/admin/index.php(352): require('[...]')
#4 {main}
Thrown in '[...]FAQs/src/phpMyFAQ/Database/Mysqli.php' on line 308
the [...] are removed and the [username] is the user name I'm using
Cannot edit any articles
Moderator: Thorsten
Re: Cannot edit any articles
Hi,
which version did you have before the upgrade?
bye
Thorsten
which version did you have before the upgrade?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Cannot edit any articles
Can't say with 100% certainty but I think it was a 3.1 version.
Just noticed that 'Add a FAQ' also shows the same error...
Just noticed that 'Add a FAQ' also shows the same error...
Re: Cannot edit any articles
Hi,
this code hasn't changed since 3.1.0, do you have a column "updated" in the table faqdata_revisions?
bye
Thorsten
this code hasn't changed since 3.1.0, do you have a column "updated" in the table faqdata_revisions?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Cannot edit any articles
Nope - I have:
New
active
author
commecnt
content
created
date_end
date_start
datum
email
[id]
keywords
[lang]
notes
[revision_id]
[solution_id]
sticky
thema
the [ ] denotes 'keys'
New
active
author
commecnt
content
created
date_end
date_start
datum
[id]
keywords
[lang]
notes
[revision_id]
[solution_id]
sticky
thema
the [ ] denotes 'keys'
Re: Cannot edit any articles
Hi,
this is strange as we renamed the column with phpMyFAQ 2.9.0, please run this query:
bye
Thorsten
this is strange as we renamed the column with phpMyFAQ 2.9.0, please run this query:
Code: Select all
ALTER TABLE faqdata_revisions CHANGE datum updated VARCHAR(15) NOT NULL
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Cannot edit any articles
That seems to have fixed it ![Smile :)](./images/smilies/icon/smile.gif)
I can now edit things and it's not throwing an error when I create a new FAQ.
Thanks for the fix!
![Smile :)](./images/smilies/icon/smile.gif)
I can now edit things and it's not throwing an error when I create a new FAQ.
Thanks for the fix!