Scribuntu Error

[Anonymous]

G:/XOWA/bin/any/xowa/xtns/Scribunto/engines/Luaj/MWServer.lua:59 vm error: gplx.Err: 0 New_stmt_prep.fail; sql=SELECT orig_repo,orig_status,orig_ttl,orig_ext,orig_w,orig_h,orig_redirect FROM wiki_orig WHERE orig_ttl = ? err=class java.sql.SQLException [SQLITE_ERROR] SQL error or missing database (no such column: orig_status):class java.sql.SQLException [SQLITE_ERROR] SQL error or missing database (no such column: orig_status)

after updating the with the latest en wilipedia and using 2.2.2.1 i get the above error.

[gnosygnu]

Thanks for the report!

This is a defect due to a recent Scribunto change. I'll fix this for this Monday's release, but in the meantime, you can do the following to work around it:

• Download a database of file metadata: https://archive.org/download/Xowa_enwiki_latest/Xowa_enwiki_2015-01-12_orig_regy.7z
• Unzip it wherever you installed xowa. If xowa is at C:\xowa, then unzip it there. It will unzip one file to C:\xowa\file\en.wikipedia.org\wiki.orig#00.sqlite3

Scribunto will then use this database to retrieve the file metadata.

This Monday's release (v2.2.4) will make the error "prettier" if the database isn't present.

Let me know if this still doesn't work.

[Anonymous]

Nope still getting an error

Script error @G:/XOWA/bin/any/xowa/xtns/Scribunto/engines/Luaj/MWServer.lua:59 vm error: gplx.Err: 0 New_stmt_prep.fail; sql=SELECT orig_repo,orig_status,orig_ttl,orig_ext,orig_w,orig_h,orig_redirect FROM wiki_orig WHERE orig_ttl = ? err=class java.sql.SQLException [SQLITE_ERROR] SQL error or missing database (no such column: orig_status):class java.sql.SQLException [SQLITE_ERROR] SQL error or missing database (no such column: orig_status)

[gnosygnu]

Sorry about that. I made a change and uploaded a new version now. Try it again: https://archive.org/download/Xowa_enwiki_latest/Xowa_enwiki_2015-01-12_orig_regy.7z

You can also wait for v2.2.4 which will fix this on its own.

Thanks.

---

ALTER TABLE wiki_orig ADD orig_status tinyint DEFAULT 1;

[Anonymous]

Cool will wait for 2.2.4

[gnosygnu]

Thanks for the follow-up.

I released the fix tonight. You can download it here: https://sourceforge.net/projects/xowa/files/v2.2.4/

[Anonymous]

Thanks...now new issue after update to 2.2.4.1 - Site not found. Check address please, or see console log.
null

Where previously it did work on 2.2.2.1?

This is in the session log:
arguments: [0] = '--app_mode' [1] = 'http_server' [2] = '--http_server_port' [3] = '8282' 20150223_074926.099 app.init 20150223_074927.081 gfs.done: G:\XOWA\bin\windows_64\xowa\cfg\xowa_cfg_os.gfs 20150223_074927.174 gfs.done: G:\XOWA\user\anonymous\app\data\cfg\xowa_user_cfg.gfs 20150223_074927.177 gfs.done: G:\XOWA\user\anonymous\app\data\cfg\user_custom_cfg.gfs 20150223_074927.181 gfs.done: G:\XOWA\xowa.gfs 20150223_074927.185 app.upgrade.done 20150223_074927.187 wiki.init.bgn: home 20150223_074927.332 wiki.init.end 20150223_074927.337 HTTP Server started: Navigate to http://localhost:8282 20150223_074935.362 wiki.init.bgn: en.wikipedia.org 20150223_074935.525 wiki.init.end 20150223_075102.348 wiki.init.bgn: favicon.ico 20150223_075102.363 wiki.init.end

[gnosygnu]

Ugh.... Thanks for the report. I'll make a release tonight to fix this issue and post again to this thread.

[Anonymous]

thanks

[gnosygnu]

No problem. I posted v2.2.4.2 tonight: https://sourceforge.net/projects/xowa/files/v2.2.4.2/

Also, I like to give credit to users for reporting defects. Let me know if you want to be cited in the change log. You'd get a line like "HttpServer: Fix HTTP Server failing with null ref {detected by your_nickname}"

Thanks again for the catch.

[Anonymous]

all working. thanks again. you really respond quickly :)

[Anonymous]

in cmd I have noticed this error

Request: GET /en.wikipedia.org/ HTTP/1.1
failed to evaluate function: page=Main Page defn=#invoke src={{#invoke:In the ne
ws/image|main}} err=class java.lang.NullPointerException null [java.lang.NullPoi
nterException]

[gnosygnu]

Damn. It looks like 2.2.4.2 also had issues.

I made yet another release today and posted it here: https://sourceforge.net/projects/xowa/files/v2.2.4.3/ Hopefully the third time is the charm.

Thanks.

[Anonymous]

So the news article on the main page gives a error. is this because the image was not loaded on your image dump or is it that it's not downloading correctly.

Request: GET /en.wikipedia.org/ HTTP/1.1
java.io.FileNotFoundException: G:\XOWA\file\commons.wikimedia.org\orig\4\1\d\2\T
ransAsia_Airways_ATR_72-212A_B-22816.jpg (The system cannot find the path specif
ied)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at gplx.xowa.servers.http.HttpRequest.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

[Anonymous]

have updated to 2.2.4.3 btw

[gnosygnu]

Thanks for trying again.

As you guessed, it's because it's not in the image dump.

Here's the commons page for the image. Note that it was uploaded on 2015-02-04: https://commons.wikimedia.org/wiki/File:TransAsia_Airways_ATR_72-212A_B-22816.jpg

The XOWA image dump is only as good as the latest commons dump. The last commons dump was 2015-01-10: http://dumps.wikimedia.org/commonswiki/

In theory I can probably check the offline dump first and then the online version if it's not found. I'll try to add that for a future version. Let me know if you run across this a more often.

[Anonymous]

Cool. Adding that feature will be great. Obviously one would still download the image database you create but would be a "nice to have" if the database dumps are older.

[gnosygnu]

Ok. Thanks for the feedback. I've added it to the to-do list, but it may be a while. Let me know if there's anything else.