Jump to content

Topic on Extension talk:ArticleFeedback/Archive 2

update.php does not create the proper tables

5
99.109.40.187 (talkcontribs)

Hi, when I enable the ArticleFeedback extension in my LocalSettings.php file and then run update.php, it borks at:

A database query syntax error has occurred. The last attempted database query was: "SHOW INDEX FROM `article_feedback`" from within function "ArticleFeedbackHooks::loadExtensionSchemaUpdates". Database returned error "1146: Table 'courses_wiki.article_feedback' doesn't exist (localhost)"


What exactly is the proper sequence for installing this extension?

Retrothe80sninja (talkcontribs)

Had a similar issue. Initially happened when viewing Special:ArticleFeedback (I enabled the dashboard in the extension settings first.) Checked the MySQL database, the specified table did not exist although 6 others did. Running update.php again produced the error reported above. Better installation instructions would be appreciated.

Mediawiki 1.18.1 PHP:5.3.8 (Apache2handler) MySQL: 5.5.16

92.37.86.195 (talkcontribs)

Same issue here. Anyone happens to have fixed the problem? This is the output of update.php (I've ran it more than once)

php maintenance/update.php MediaWiki 1.19.0 Updater

Going to run database updates for mw794-u3c_ Depending on the size of your database this may take a while! Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0 A database query syntax error has occurred. The last attempted database query was: "SHOW INDEX FROM `u3c_article_feedback`" from within function "ArticleFeedbackHooks::loadExtensionSchemaUpdates". Database returned error "1146: Table 'mw794.u3c_article_feedback' doesn't exist (localhost)"

Peculiar Investor (talkcontribs)

I found a workaround that seems to work

cd /path/to/your/wiki/
cd extensions/ArticleFeedback/sql
mysql -Dwiki_db < ArticleFeedback.sql

Then run update.php per the installation instructions.

Retrothe80sninja (talkcontribs)

This seemed to fix any SQL errors. The dashboard seems to work properly now as well (although it has no data yet). Still can't get the ratings widget to appear on pages but I suspect it's an issue with JavaScript rather than the extension itself.

Reply to "update.php does not create the proper tables"