DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • September 02, 2010, 09:45:48 AM
Home Forums News Links Downloads Login Register Advanced Search
* * *
DragonPrime Menu
» Home
» Forums
» Downloads
» DragonPedia
» Installation Help
» Play LoGD
» Links
» Bugtracker
» FAQ
Login
 
 
Resource Pages
Installing the Game
Creating Your First Module (Tutorial)
Specialties 4 Dummies
Skins Made Easy
Mount Editor FAQ
Race Creation FAQ
Core Module List
External Sites:
Theme Colour Tester
IRC Channels
DragonPrime Coding Chat
Player's and Social Chat
Search
DragonPrime - LoGD Resource Community > Coding Support > Coding Support Desk (Moderator: GenmaC) > Topic: Upgrade from .9.7
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Upgrade from .9.7  (Read 1182 times)
0 Members and 1 Guest are viewing this topic.
dvd871
Guest
« on: January 04, 2005, 08:40:52 PM »
Has anyone got this to work?  I installed 9.8-pr8 and ran the sql updates from 9.7 to 9.8 and that went fine, ran modules.sql, again fine.  Then I ran the pr12 installer and updated from pr8 to pr12 with no errors but afterwards I can not login.  Its always wrong username/password.  All I really need to do is convert my user accounts from .9.7 to .9.8 as I already have .9.8pr11 installed and working fine.  Any ideas?
Logged
Talisman
Administrator
Mod God
*****
Offline Offline

Posts: 5223



View Profile WWW
« Reply #1 on: January 04, 2005, 08:45:13 PM »
Were you using the encrypted passwords mod for .97?
Logged
Play the latest beta version here on DragonPrime
dvd871
Guest
« Reply #2 on: January 04, 2005, 09:10:45 PM »
No it was a the regular non-emcrypted passwords.
Logged
Kendaer
Global Moderator
Mod God
*****
Offline Offline

Posts: 1806


Once a dragon, always a dragon


View Profile WWW
« Reply #3 on: January 04, 2005, 09:17:04 PM »
When you ran the update from PR8 to PR12, did you MAKE SURE to select PR8 from the dropdown where you choose upgrade or fresh install?  If you did not do this then your passwords got encrytped an extra time in the database and there isn't any way to recover  them unless you have a backup.
Logged
Ex co-developer of LotGD
dvd871
Guest
« Reply #4 on: January 04, 2005, 09:26:00 PM »
I'm sure that I did.  I'm going to run through the process again from the beginning and see what happens.
Logged
dvd871
Guest
« Reply #5 on: January 04, 2005, 10:00:22 PM »
I've run the upgrade from .9.7 to .9.8pr8 and am able to login fine except I had some problems with newday and the weather semaphore, but that is really not important as that works on my .9.8 server already.  At this point I am able to login and things for the most part are fine.  I am going to run the update from pr8 to pr12 now making 100% sure that I select "I should update from 0.9.8 pre8.

-EDIT
The install went much better this time.  The only error I am getting is:

Code:
INSERT INTO settings (setting,value) VALUES ("newdaySemaphore","0000-00-00 00:00:00")
Duplicate entry 'newdaySemaphore' for key 1

But that is not important at this point as my .9.8 install is working already so this won't be an issue.  All I have left to do is export my accounts and import into the live database.
« Last Edit: January 04, 2005, 10:10:07 PM by dvd871 » Logged
enderwiggin
Guest
« Reply #6 on: January 08, 2005, 04:50:40 AM »
We should sticky a topic called installer issues for the current prerelease so we don't have twenty new topics.

Also as a general rule of advice, is you have a failed install, you may need to delete some SQL tables before reinstalling.  Let's say for instance that you did a fresh install with Prerelease 12 and it failed to import data for the creatures.  If you decide to reinstall, when it issues the Create Table `creates` command, that command will actually delete the table rather than create it.  Create Table on an existing table will actually delete it.

Is there any way to have the installer check for this sort of thing, or ask if the previous installation failed?
Logged
Kendaer
Global Moderator
Mod God
*****
Offline Offline

Posts: 1806


Once a dragon, always a dragon


View Profile WWW
« Reply #7 on: January 10, 2005, 01:08:57 PM »
Quote from: enderwiggin on January 08, 2005, 04:50:40 AM
We should sticky a topic called installer issues for the current prerelease so we don't have twenty new topics.

Also as a general rule of advice, is you have a failed install, you may need to delete some SQL tables before reinstalling.  Let's say for instance that you did a fresh install with Prerelease 12 and it failed to import data for the creatures.  If you decide to reinstall, when it issues the Create Table `creates` command, that command will actually delete the table rather than create it.  Create Table on an existing table will actually delete it.

Is there any way to have the installer check for this sort of thing, or ask if the previous installation failed?

The table creation code works correctly if a table already exists Ender.
The only time it will blow away a table is if you tell it 'fresh install'.
Create table on top of a table which already exists is an error, it will NOT create an empty table (at least on any sane/functioning install of mysql)
Logged
Ex co-developer of LotGD
enderwiggin
Guest
« Reply #8 on: January 10, 2005, 01:42:47 PM »
I wasn't trying to knock your code.

I was installing an upgrade to some forum software, and accidentally blew away half my datbase.  Luckily I had a backup.  I was told by the author of the forum software that in SQL, a CREATE TABLE command will wipe out a table if it already exists.
Logged
Kendaer
Global Moderator
Mod God
*****
Offline Offline

Posts: 1806


Once a dragon, always a dragon


View Profile WWW
« Reply #9 on: January 10, 2005, 02:35:07 PM »
Quote from: enderwiggin on January 10, 2005, 01:42:47 PM
I wasn't trying to knock your code.

I was installing an upgrade to some forum software, and accidentally blew away half my datbase.  Luckily I had a backup.  I was told by the author of the forum software that in SQL, a CREATE TABLE command will wipe out a table if it already exists.

The author of the forum software was wrong.  I wasn't offended btw, nor did I think you were knocking my code. I was just trying to correct your wrong statements.   People have a ... tendancy ... to believe anything they see on a web page and I wanted to head off the spread of wrong information Smiley
Logged
Ex co-developer of LotGD
Pages: [1]   Go Up
  Print  
DragonPrime - LoGD Resource Community > Coding Support > Coding Support Desk (Moderator: GenmaC) > Topic: Upgrade from .9.7
 « previous next »
 
Jump to:  


*
DragonPrime Notices
Version 1.1.2 is the current supported version and is available for download.
Support Us
No funds raised yet this year
Your help is greatly appreciated!
Who's Online
30 Guests, 0 Users
DragonPrime LoGD
Play
Legend of the Green Dragon
on Dragon Prime

LoGD Player's Forum

Recent Topics
Home Forums News Links Downloads Login Register Advanced Search