• Print

Author Topic: Database error  (Read 15 times)

0 Members and 1 Guest are viewing this topic.

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Database error
« on: November 11, 2015, 04:08:33 pm »
So Bytewave says I hate "everything" joking in another thread.
I try to come back with proof that I don't.
I go to advanced search (I know, only we can at the moment).
I type in "hate" and by user JamminR.

9 pages?????
Oh, wait. it's finding the word "whatever"

So, I try again, only using "hate" and "-what"
I get this error.


Database Error
Not unique table/alias: 'm'
File: /home/nayruden/forums.ulyssesmod.net/Sources/Search.php
Line: 1338

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.11, while your database is at version 2.0.6. The above error might possibly go away if you execute the latest version of upgrade.php.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Database error
« Reply #1 on: November 11, 2015, 06:13:13 pm »
Huh, well, upgrade.php is supposed to execute automatically with the way we've upgraded. Worth downloading it and trying manually, though.
Experiencing God's grace one day at a time.

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Database error
« Reply #2 on: November 11, 2015, 06:19:50 pm »
Well, yeah, but, it's a database.
I'll take blame for upgrading forum files, but, the heart of the forum...I'll leave that to you. :P
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Database error
« Reply #3 on: November 12, 2015, 03:33:00 am »
Tried and did not fix it. :(
Experiencing God's grace one day at a time.

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2727
  • Karma: 430
    • |G4P| Gman4President
Re: Database error
« Reply #4 on: November 12, 2015, 09:06:32 am »
At some point it may be worth taking a backup of the forums and then doing a clean install and restoring from the backup.
The forums have been patched and upgraded for a lot of years now, a clean install might make things run smoother. (and maybe bring back the search feature)

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Database error
« Reply #5 on: November 12, 2015, 02:56:06 pm »
At one time I thought 'we' (speaking as though Megiddo has collective speech here) were going to try that anyway.
:P
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

  • Print