next »

[Will3]

Hi again, having more issues. When some of the folks, myself included when I tested it, keep getting this error:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "SpoofUser::getConflicts". Database returned error "1146: Table 'usnwwiki_wiki.spoofuser' doesn't exist (localhost)".

Anyone have any suggestions?

Thank You

[Sove]

"Table 'usnwwiki_wiki.spoofuser' doesn't exist (localhost)"

It says the reason quite clearly. You need to make that table first.

[Sasha Ehrenstein]

If you're installing an extension, you need to copy the text of all the files that end in .sql into the database.  You might be able to use a cron job to run update.php.

[Fanra]

You might be able to use a cron job to run update.php.

If, like myself, you have Advanced Hosting and no idea how to create a cron job, you can install https://www.mediawiki.org/wiki/Extension:MaintenanceShell in order to run update.php.

[Sasha Ehrenstein]

The only trouble is that sometimes the wiki doesn't even work if you don't have the tables added.  LiquidThreads is like that.

[Twibbles]

You can update the tables through the installer.

[Sasha Ehrenstein]

Is it difficult to use the cron job?  I think the main complicated part is making sure you look at the server time for setting the time to run the script.

[Twibbles]

Cron Jobs are fairly easy to use, You just have to be careful in setting it up and the command to execute. For example FlaggedRev updates the Stats every Hour on the Hour on my wiki. For this the Time is set like so:
Min:0
Hr:*
Day:*
Mnt:*
WkDay:*

And it runs this:
php /public_html/wiki/extensions/FlaggedRevs/maintenance/updateStats.php

That just initiates the Php file UpdateStats;

I find it easiest to navigate to URLTOWIKI/mw-config/ and run that, it updates the tables correctly for most of the extensions.

Or I directly add the SQL Generation code to the database.