Page MenuHomePhabricator

Database Error
Closed, ResolvedPublic

Description

Author: jlp09550

Description:
This error is occuring when I attempt to edit/create a page:

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 "LinksUpdate::getExistingInterlangs". MySQL returned error "1146:
Table 'chibipaws2.mw_langlinks' doesn't exist (chibipaws2.chibipaws.com)".

I have recently upgraded and the database is updated to.


Version: 1.7.x
Severity: major
URL: http://wiki.chibipaws.com/

Details

Reference
bz6712

Event Timeline

bzimport raised the priority of this task from to High.Nov 21 2014, 9:16 PM
bzimport set Reference to bz6712.
bzimport added a subscriber: Unknown Object (MLST).

Most likely you didn't run the database updater. Can you
confirm it ran successfully? Provide output from the script.

jlp09550 wrote:

Wow, that was very fast. :)

The update.php script returned this:

[cupcake]$ ./wiki.chibipaws.com/maintenance/update.php
X-Powered-By: PHP/4.4.2
Content-type: text/html

<br />
<b>Parse error</b>: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION
or T_VAR or '}' in <b>/home/.goddard/chibipaws/wiki.chibipaws.com/includes/Exception.php</b> on
line <b>114</b><br />

you have to use php5 with mediawiki 1.7

jlp09550 wrote:

(In reply to comment #3)

you have to use php5 with mediawiki 1.7

I do. I have PHP5 with it, escept shell is on php 4.

jlp09550 wrote:

(In reply to comment #5)

then use php5 in shell ;-)

Ugh, I can't. See, you know DreamHost? Well, I used the uprade feature to upgrade it, but it
seems to have messed up the DB.

I cannot edit the PHp used in shell. I am not the server owner.

jlp09550 wrote:

(In reply to comment #3)

you have to use php5 with mediawiki 1.7

Proof I'm using PHP5: http://wiki.chibipaws.com/Special:Version

proof you're not using php5:

[cupcake]$ ./wiki.chibipaws.com/maintenance/update.php
X-Powered-By: PHP/4.4.2

achuggard wrote:

If your apache is php5 and you can't get the shell to be php5 then read
http://www.mediawiki.org/wiki/Manual:Upgrading_to_1.7 and use the "Re-run the
installer" method.

jlp09550 wrote:

(In reply to comment #8)

proof you're not using php5: [cupcake]$ ./wiki.chibipaws.com/maintenance/update.phpX-Powered-

By: PHP/4.4.2

Just so you know, I used the install script within the HTTP server. It told me I had PHP 5, and
the version information says I have PHP5. I will attempt to run the update.php script within my
broswer. I will post the results.

jlp09550 wrote:

Unforutantly, I cannot run the update.php within my broswer, and I know why.

But, that's not important. The fact is that I'm running PHP5, except shell is not PHP5, but it
is PHP4. I RAN the install script as the Manual says before I posted this, and it still does not
work.

achuggard wrote:

Did you make sure to enter the proper table prefix when running the installer
script? otherwise the installer wouldn't have found your old tables, made a
duplicate installation, and when you put your old configuration back in it would
have looked at the old unupgraded tables.

jlp09550 wrote:

(In reply to comment #12)

Did you make sure to enter the proper table prefix when running the installerscript? otherwise

the installer wouldn't have found your old tables, made aduplicate installation, and when you
put your old configuration back in it wouldhave looked at the old unupgraded tables.

Aha, let me check that, one second.

jlp09550 wrote:

(In reply to comment #12)

Did you make sure to enter the proper table prefix when running the installerscript? otherwise

the installer wouldn't have found your old tables, made aduplicate installation, and when you
put your old configuration back in it wouldhave looked at the old unupgraded tables.

Thanks. I've resolved my issue. :)