Mysidia Adoptables Support Forum - Columns after upgrade

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - Columns after upgrade (http://www.mysidiaadoptables.com/forum/showthread.php?t=3850)

Columns after upgrade

Hi together :smile:

I've upgraded from MA 1.2.4 to 1.3.1 (with upgrade to MA 1.3.0 of course) but I've a strange problem.
I've got the error message, that there're missing a column.

Isn't it so, that the upgrade automatically add the new column in my database ?
because ... I don't know, which columns are new :catfish:

please help :Q:

Well how did you upgrade from Mys v1.2.4 to v1.3.1? An official upgraded is not available yet for upgrade between version 1.2 to 1.3. Did you upgrade manually then? If so, please check the structure of mys 1.2 tables and mys1.3 tables and see if you can make any changes to get it to work. Anyway upgrading from mys 1.2 to 1.3 is a risky move, I hope for the best of your site.

ohh, I only follow the installation guide...

and that's what I got:

Code:

Fatal error: Uncaught exception 'Exception' with message 'Database error 1054 - Unknown column 'linkparent' in 'where clause'' in /data/multiserv/users/201262/projects/237104/www/adopties/classes/class_database.php:161 Stack trace: #0 /data/multiserv/users/201262/projects/237104/www/adopties/classes/class_database.php(81): Database->_query('links', Array, 'select', 'linkparent < 1 ...') #1 /data/multiserv/users/201262/projects/237104/www/adopties/functions/functions.php(222): Database->select('links', Array, 'linkparent < 1 ...') #2 /data/multiserv/users/201262/projects/237104/www/adopties/functions/functions.php(458): getlinks() #3 /data/multiserv/users/201262/projects/237104/www/adopties/index.php(23): showpage('Startseite', 'Willkommen bei ...', '03-22-2011') #4 {main} thrown in /data/multiserv/users/201262/projects/237104/www/adopties/classes/class_database.php on line 161

I've no idea, how I shall solve this :catfish:

If I use a blank database, I've no problem, it works. I
But if I use a my old database (with all existing adoptables, users and so on) I got this error message.

I've all needed colums too. I've took a look.

Well yeah, this is because the database in Mys v1.2.x and v1.3.x are not compatible. Before a megaupgrader is made(not sure if it ever will), I'd recommend you not to upgrade from Mys v1.2.x to v1.3.x unless you are fully aware of what you are doing. Again like I said before, you may want to take a look at the database table structures and see what changes you can make.

oooookaaayy.... so'll try to export the important parts of the existing database and import it to the newer version...

Its sooo good, that I can try it at another database *hrrhrr*